Event Location:
Chandler-Gilbert Community College Pecos Campus
2626 East Pecos Road
Chandler, Arizona
Abstract:
Knowing the vast majority of the content accessed via SharePoint is stored in SQL Server, and also knowing an incorrect configuration of SQL Server can have a detrimental impact on the performance of SharePoint it is important to understand the integration of these two products. Regardless of whether you have a dedicated DBA, or the SharePoint administrator is also the DBA, there are critical SQL Server configurations that can be made that will improve the performance of SharePoint. Often DBA’s are familiar with how to manage SQL Server, but may not be familiar with some nuances that SQL Server has when integrated with SharePoint. In this session we will demonstrate how some default SQL Server settings negatively impact SharePoint and what changes can be made to improve the performance of SharePoint. These changes include database file settings and SQL Server instance settings. We'll also examine how to properly install SQL Server and SharePoint so they work together efficiently.
Speaker(s): Brian Alderman,
Abstract:
Everywhere you turn in the technological literature people are talking and writing about Big Data. In this presentation you will learn about the origins of Hadoop, and how it is implemented today. In addition to the most infamous way of retrieving data from Hadoop, Map Reduce, there another way to manipulate the Hadoop data. It is possible to query the data from Hadoop in SQL Server through the use of Sqoop. In order to better understand the logic behind Sqoop, I will present information on the Hadoop components. Having this information will help you determine how the tools all fit together so that you will know which tools are the best choice for getting the desired answers from your data sources.
Speaker(s): Ginger Grant,
Abstract:
This session discusses a proven organizational approach and important technical considerations that lead to the successful adoption of Master Data Management (MDM) on SQL Server. Organizational considerations include building buy-in, team capability expertise, and selling MDM to the rest of the organization while building a subject-area center of excellence. We also discuss approaches to improved time-to-value and to ensure that the technology and staff investment is matched to the expected outcome. Great technology choices will help ensure that your best laid plans succeed and the second half of this session goes over some important technology considerations. In this part of the session we discuss User Experience, Integration Patterns, Matching, Programmability, and Data Quality.
Speaker(s): John McAllister,
Abstract:
With IT budgets shrinking and demand for data continuously growing, you face the challenge of increasing database scale to meet demand with minimal increase in costs. Join us and learn how SQL Server 2014 provides breakthrough performance and scalability with in-memory technologies across all workloads including OLTP, Data Warehousing and Business Intelligence. You will also learn about the rich capabilities included in SQL Server 2014 that deliver mission critical performance, faster insights on any data through comprehensive business intelligence tools, and a platform for hybrid cloud that offers new scenarios, like simplified database backup and disaster recovery in the cloud.
Speaker(s): Kevin Cox,
Abstract:
Tired of seeing your name spelled 27 different ways... all from the same company? Tired of making the same corrections over and over and over again? Would it be better if business users could directly correct data and have the corrections recorded and consistently applied? Surely someone has come up with a solution to these problems? Come check out how software you likely already own can solve these problems. This session was originally presented at SQLSaturday 158 in NYC, but has been enhanced with additional content and all filler has been mercilessly cut, folded, spindled and mutilated. http://www.sqlsaturday.com/viewsession.aspx?sat=158sessionid=9892
Speaker(s): Marc Jellinek,
Abstract:
There are times when you are able to be proactive and tune existing queries. Sometimes, you will receive a phone call from your manager telling you that a certain web page or report is timing out and your users are furious. You need to quickly diagnose what the problem is. Where do you turn to first? When a query is underperforming, hogging resources or timing out, one of the first things you want to examine is the query execution plan. An execution plan provides a wealth of information that can help you quickly diagnose what is wrong. In this beginner level session you will learn what an execution plan is, how to find it, and how to interpret it to see what the query optimizer is doing and find the major pain points.
Speaker(s): Jason Kassay,
Abstract:
While many in the BI realm are comfortable performing SSIS tasks using Microsoft Business Intelligence Studio, there is that other world of exploration that utilizes the SSIS programming interface API. Why use it? In this session we will go over some basic approaches as to how to take advantage of the SSIS API model to perform package configuration and property changes in an automated manner. This is especially advantageous in enterprise systems that maintain numerous dtsx packages. Automating changes to SSIS packages reduces the amount of development time that otherwise would be spent if one were to go in and manually apply these changes using the graphical interface.
Speaker(s): Mark Paszli,
Abstract:
The Hadoop ecosystem has emerged as the most viable means of working on huge amount of data which is now commonly referred to as “BigData”. The piping- and parallelism approach of breaking heavy tasks in to smaller manageable tasks and executing them in parallel on readily available commodity hardware, relies on the MapReduce programing framework. One of the challenges facing the enterprise BI team is the learning curve in moving from existing solutions built on traditional databases to Hadoop clusters which are primarly designed to be queries using MapReduce programing constructs . Initially developed by Facebook, and used and enhanced by other companies like Netflix and Amazon; the Hive Query Language (HQL), bridges the gap between MapReduce and Traditional SQL. In this presentation I will be discussing the basic commands required to interact with Hadoop File System (HDFS), as well as the fundamental query constructs of Hive. Demos will done on a Hortonworks , Apache Hadoop SandBox.
Speaker(s): Orion Gebremedhin,
Abstract:
Business Intelligence Markup Language (Biml) is an XML language for Microsoft Business Intelligence that can take your Integration Services package development to the next level. Creating template packages added productivity to your Integration Services development effort. If the template design changes after development begins, a fair amount of rework to packages could be needed. See how Biml can help create template packages that can better adapt to changing business needs and allow for more comprehensive design or redesign. This session will be a demo based session that will inspire you to make Biml your number one integration services development tool. Learn how to use Biml scripts to create staging tables and integration services packages. Add metadata to your Biml scripts and really watch the possibilities expand.
Speaker(s): Reeves Smith,
Abstract:
In this session we will revisit some of the fundamental design principals of relational databases: normalization rules, key selection, and the controversies associated with these issues from a practical perspective. We will consider the benefits and challenges of using different types of keys - natural, surrogates, artificial (and others?) from multiple aspects: data consistency, application development, maintenance, portability and performance.
Speaker(s): Ami Levin,
Abstract:
Even in the most reliable ETL system, it's eventually going to happen: A package will fail, an output row count won't match what is expected, a data anomaly will force a forensic search of the package infrastructure... In this session, we'll talk about some of the things that can go wrong during package execution - and some of the defenses that can be built into SSIS to help head off those errors (or at least make the errors easier to troubleshoot). From error handlers to package restartability, and from logging methods to row count validation and remediation, we'll cover various ways to keep your ETL flowing when problems arise.
Speaker(s): Tim Mitchell,
Abstract:
In this session, led by Microsoft BI Architect and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2008 R2. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets. This session applies equally to Analysis Services 2008, 2008R2 and 2012.
Speaker(s): William E Pearson III,
Abstract:
Data types are the basic building blocks of table design. Using the correct data type can affect data integrity and performance. Redesign after a table is in production is very difficult, so getting it right when building the table is crucial. We begin with discussion on best practices for choosing data types and why the right data type is important for performance and data integrity. We will then run scripts to spotlight inconsistent field lengths and data types as examples of secrets that will be revealed. This session will help you design better tables so your data is more stable and reliable. It is also a good review if you will be taking exam 70-461.
Speaker(s): Andre DuBois,
Abstract:
SQL Server 2012 adds to the Master Data Services (MDS) platform by expanding table-level integration (staging), improving the web UI, providing an Excel add-in, and adding to the services layer. But many organizations have not yet begun to leverage the full potential. This session helps you better understand the Master Data Management (MDM) and MDS by exploring 4 key features in depth. While diving deeply into the new Excel add-in, MDM Hierarchies, MDM Business Rules, and Staging you will gain a much deeper understanding of MDS. The talk will be interspersed with tips and best practices for how start an MDM project in your organization.
Speaker(s): John McAllister,
Abstract:
Windows Azure gives you a choice in where to host your SQL data, with both SQL Server running in a VM and Windows Azure SQL database. Ongoing innovations in SQL/VM and SQL DB enable both low overall TCO for management of existing applications/services and an efficient platform for the new breed of cloud applications/services. Additionally the ability to mix and match existing and new applications in the same hosted service, and to integrate with on-premises applications and networks in hybrid models provides tremendous flexibility. This session will take a deep look at the best practices when provisioning and deploying a SQL Server in a Windows Azure Virtual Machine
Speaker(s): Kevin Cox,
Abstract:
Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive, demo focused presentation you’ll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use Biml Script to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.
Speaker(s): David Stein,
Abstract:
What are FileTables? How do they work? What are their limitations? These questions and more will be answered in this demo filled presentation. We will walkthrough the configuration and implementation of this feature. We will show you some use cases on how this functionality can help you manage your data in whatever forms it exists.
Speaker(s): Warren Sifre,
Abstract:
Top 10 methods to kill your database performance. The attendee will leave this session with some ideas on what to look for and what to tune in order to improve performance. Joint Session with Wayne Sheffield
Speaker(s): Jason Brimhall,
Abstract:
HDInsight is the latest evolution of Hadoop on the Windows platform. It allows you to manage big and unstructured data while using the rich Business Intelligence tools provided by SQL Server. This session will cover big data architecture and demonstrate map/reduce, the nucleus of big data technology. You will also see how you to get maximum value out of big data by incorporating it into your BI architecture with tools such as Hive, Excel, PowerQuery, and Tabular models.
Speaker(s): Carlos Bossy,
Abstract:
Windows Failover Clustering has been a common solution to providing failover and high-availability in SQL Server environments, and can be used to cluster an instance of sql server, as well as serve as the supporting infrastructure for AlwaysOn. But for a new server deployment, which should you use - traditional clustered instances or AlwaysOn, and what's the difference? While not delving into advanced implementation, this session will describe what clustering is, the components involved, how it's used (both historically and with AlwaysOn), clear up some common terminology around clustering, and help set the stage for your next deployment.
Speaker(s): Ryan McCauley,
Abstract:
The SQL Server transaction log is one of the most misunderstood components of the database engine. What makes it grow? How does it get truncated? Should I shrink it? What is a VLF? In this session we will answer these questions and more.
Speaker(s): Randy Knight,
Abstract:
Extended Events were introduced in SQL Server 2008. With SQL 2012, we have seen a significant upgrade to this feature. Join me for a little adventure into what extended events are. We will discuss how to use extended events to aid in performance tuning and in day to day administration. We will also explore some background and the architecture of extended events.
Speaker(s): Jason Brimhall,
Abstract:
Managing concurrency is one of the most challenging aspects of working with any enterprise DBMS. There is much confusion out there about locking, blocking, and deadlocks. In this demo heavy session we will clear up the confusion.
Speaker(s): Randy Knight,
Abstract:
We will discuss some of the most important things that you as a Data Professional can document to make your job much easier, ensure information consistency between groups, and better prepare your organizations for raising the bar on your day to day business. Think of this as a sort of Database Library that allows you to finally detail the processes you follow currently to perform repetitive tasks. This Library will also allow you to simply document your systems for your and others knowledge.
Speaker(s): TJay Belt,
Abstract:
The very nature of a database system is to be dynamic; rarely static. The applications that use databases tend to change, requiring changes to occur within our databases. The totality of pieces and parts that comprise this ‘change’ will be combined into a ‘Release’ that will be applied to your systems. Controlling this change is not rocket science, but it is not without its complexities. We will discuss various terms, define processes, share ideas, and suggest tools to assist you in performing this necessary function, while minimizing risk, and impacting your systems in a graceful fashion.
Speaker(s): TJay Belt,
Abstract:
Is the list of servers you manage growing and growing? Are you starting to wonder if there is a more efficient way to manage your SQL Server instances than T-SQL and SSMS? In this session we will give you an introduction to PowerShell with a focus on SQL Server. In this session, we will cover the basics towards configuring and using PowerShell. We will also cover the basic syntax of PowerShell that will help you get started in the right direction. Finally, we will conclude the session with some examples that could make your SQL Admin life a lot easier.
Speaker(s): John Sterrett,
Abstract:
Many data professionals understand the basics of Data Warehouse design, including Dimension and Fact Tables, slowly changing Dimensions, and the use of meaningless surrogate keys. However, it isn’t until you’ve created a dimensional model and put it into production, that you realize just how much of an impact seemingly trivial mistakes can make. They can hobble performance, allow inaccuracy, and perhaps worst of all, inhibit adoption and usage of the new system. Learn how to avoid many common mistakes, from someone who’s made them and then found ways to correct them.
Speaker(s): David Stein,
Abstract:
Reporting has moved to the cloud with the introduction of Power BI. Get the Power with Power Query, Power Map, Power Pivot and Power View which you will learn about while finding out how they all work together with Microsoft Excel and Office 365 to create a Self-Service Business Intelligence application in the cloud.
Speaker(s): Ginger Grant,
Abstract:
Tabular models in SQL Server 2012 give us a powerful analytic engine that is faster and easier to implement than traditional multi-dimensional cubes using Analysis Services. In this session, you'll see how to develop analytic models using your existing data sources and learn best practices for preparing data so that it can be effectively used as a Tabular database. In addition to creating the model, you'll see how to quickly add measures, hierarchies, and calculated columns to provide a rich user experience and how the model works with Excel, SSRS and other reporting tools.
Speaker(s): Carlos Bossy,
Abstract:
Don't make your DBA groan each time you need to start a project! There are best practices and good habits developers can be using when developing databases that not only make your DBA happy, but keep the application and entire database server healthy. Learn about 5 good habits developers can be using right now to show your database admin you really care, including but not limited to T-SQL query construction and database design.
Speaker(s): Eric Oszakiewski,
Abstract:
DBAs understand their bottlenecks, managers understand business issues, this presentation will help both sides understand each other and how to put a dollar figure in business terms on your performance problems. Putting actual costs to problems allows the business to determine if it worth fixing and allows the DBA to obtain budget to move their environment forward.
Speaker(s): Shawn Meyers,
Abstract:
Slowly Changing Dimensions form an integral part of any Data Warehouse environment, and there are many different factors that will determine the flexibility, scalability and effectiveness of the dimensional structure. The first part of this session takes a look at all the different design elements and considerations of SCD's. We'll look at whether it is feasible to create a snowflake, how to deal with relationships between dimensions as well as 1:1 and many:many relationships with fact tables. Afterwards, we will walk-through a practical and effective method (with code) to load SCD's with T-SQL.
Speaker(s): Martin Schoombee,
Abstract:
Robots, SQL, Twitter and games! In an ongoing battle across SQLSaturdays, our two Finch bots RGPDEV (represents developers) and RGPDBA (represents DBAs) will compete against each other. You the audience will help determine the winner of the finch bot race by voting real time on twitter for your favorite robot. After all games are over we will use the data collected by the finch bots to select 4 participants to advance to a cyber boxing tournament to win a finch bot.
Speaker(s): Jeff Renz,
Abstract:
For far too long, I thought that statistics only contained information on table row counts. While they do contain that information, there is more to it than that. In this beginner session, we’ll go over statistics – how they are created, the different types of statistics that exist, how they’re maintained and how the Query Optimizer uses them. We will also touch on system tables and DMVs that will provide additional information on your statistics. At the end of this session, you should have a better idea of how SQL Server makes decisions on how to gather data.
Speaker(s): Lori Edwards,
Abstract:
SQL Server 2005 and later versions introduced several T-SQL features that are like power tools in the hands of T-SQL developers. If you aren’t using these features, you’re probably writing code that doesn’t perform as well as it could. This session will teach you how to get great performance, avoid cursor solutions, and create simpler code by using the window functions that have been introduced between 2005 and 2012. You'll learn how to use the new functions and how to apply them to several design patterns that are commonly found in the real world.
Speaker(s): Kathi Kellenberger,
Abstract:
This session will cover key ideas for organizing the hardware and software environment into appropriate logical and physical tiers in order to best support data warehouse extraction, staging, and data mart processes. Additionally the session will cover key differences in leading data warehouse architectures and will finish with a primer on dimensional modeling.
Speaker(s): Joe Salvatore,
Abstract:
Whether we inherit our Analysis Services environments from predecessors or create them - learning as we go - ourselves, we often conclude that performance (processing and / or querying) and functionality can be enhanced. In this session, Microsoft BI Architect and SQL Server MVP Bill Pearson overviews ways to launch new capabilities and to propel performance beyond its current plateau, using design best practices to better meet consumer performance and functional needs. This Best Practices session applies equally to Analysis Services 2008, 2008R2 and 2012.
Speaker(s): William E Pearson III,
Abstract:
SQL Server implements three different physical operators to perform joins. In this session we will examine how each of these operators work, its advantages and challenges. We will try to understand the logic behind the optimizer's decisions on which operator to use for various joins using (semi) real life examples and we will see how to avoid common join related pitfalls.
Speaker(s): Ami Levin,
Abstract:
Microsoft Power Query is an Excel plugin that enhances self-service business intelligence by allowing for discovering, merging, and enriching data from a variety of data sources including relational, structured and semi-structured, OData, Web, Hadoop, Azure Marketplace, and more. Power Query also provides you with the ability to search for public data from sources such as Wikipedia. In this session we’ll explore the basics of Power Query including how to use the plugin to source, merge, and enrich data to support self-service analytics.
Speaker(s): Josh Sivey,
Abstract:
Class will cover the basics of AlwaysOn and it is terminology. It will also cover basic setup and configuration using asynchronous commit mode.
Speaker(s): Gene Stout,
Abstract:
There is MUCH more to SQL Server 2014 than just Hekaton and Updatable Column Store Indexes!! This session will be a medium-to-high-level overview of many of the new features and enhancements coming in SQL Server 2014. We will take a look at some of the new functionality via demos as well.
Speaker(s): Kevin Boles,
Abstract:
This session, modeled after the popular PASS WIT Luncheons, will be a lively discussion about issues affecting women -- and men -- in tech. Everyone welcome to this very interactive session.
Speaker(s): Kathi Kellenberger,
Abstract:
This session will cover an introduction to Event Notification usage in SQL Server 2012.
Speaker(s): Robert Miller,
Abstract:
Well, we have all heard about the horror stories of data loss due to SQL Injection and how costly (in many ways) they can be. This in-depth discussion covers various forms of SQL Injection attacks and offers some guidelines on how to avoid them. Lots of code examples in both .NET and TSQL. Watch me hack a website and retrieve user data in just 3 hits on an unprotected html page!
Speaker(s): Kevin Boles,
Abstract:
Have you ever seen or used “WITH (NOLOCK)” in T-SQL? Do you know what it does and its side effects? Is SQL Server optimistic or pessimistic when it comes to locking? Can it be both? In this session we will cover these questions and discuss how and why SQL Server takes locks and how that affects other users. We will go over alternatives for using NOLOCK and discuss when it is appropriate to use. In addition, we will discuss what are the ACID properties and how to monitor locks and blocks.
Speaker(s): Keith Tate,
Abstract:
In this presentation you will learn about a real life big data use case to increase web and directly mail marketing ROI, using different components - R, Hadoop, Mahout, data warehouse, Powerpivot and Powerview. Those different technologies are implemented to work together to deliver a smart auto-learning system to produce prediction models, such as lead to buyer conversion prediction, search engine marketing optimization and spending allocation optimization. This data architecture solution will help you to determine how big data solution can help your organization to full utilize your existing data.
Speaker(s): John Yang,
Abstract:
Chris Hyde has been working with the Microsoft SQL Server stack for over twelve years and has completed certification exams in SQL versions 2012, 2008, 2005, and 2000. He is a Senior Consultant with Leidos Health specializing in the healthcare market, which he particularly enjoys as he gets to tackle different types of data problems at each client. He is currently on the board of the Albuquerque chapter of SQL PASS.
Speaker(s): Chris Hyde,
Abstract:
In this session we will discuss recommended practices around the preparation of SQL for SharePoint 2013.
Speaker(s): Eric Stoltze,
Abstract:
Presenting BI in a sophisticated look that is both user friendly and easy to use can be challenging. In this session I will review the three major types of dashboards (Operational, Strategic, and Analytical). Using Visio, SSRS, SharePoint and Pyramid Analytics I will demonstrate examples of each of the dashboard types.
Speaker(s): Jeff Renz,
Abstract:
Maintaining SQL Server performance is a constant task. Whether you are a developer or a database administrator, there are many things that you can do to avoid those poorly performing queries. In this session we’ll discuss some common guidelines and offer some tidbits for developing fast queries; and if you already have some poorly performing queries, we’ll discuss some ways to identify the source of the poor performance.
Speaker(s): Vern Rabe,
Abstract:
Power BI is Microsoft's latest cloud self service BI offering. Join me as we peel back the layers and features of Power BI. What's available? When, How, and Why do I use Power BI? See how Power BI can truly enable business users to lead the way and build justification for critical business decisions without needing IT data gurus.
Speaker(s): Matt Smith,
Abstract:
When reviewing your ETL processes, the No. 1 question is always, "Does it work as expected?" Closely following that question is the ubiquitous, "How fast does it run?" This session’s tips are targeted at improve the latter. In this session, we’ll focus on SSIS package performance, quickly reviewing 15 common hotspots for performance issues as well as recommended methods for maximizing throughput. You’ll walk away with some key design patterns and recommendations that you can use today to improve SSIS package performance.
Speaker(s): Tim Mitchell,
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
LinkedIn: https://www.linkedin.com/in/ryanmccauley
Contact: http://www.TryCatchFinally.net
Ryan McCauley has been in IT for 15 years, and has filled roles from .NET developer to MSSQL DBA, but is currently an IT Manager at a mid-size Cable/HSD company. In each role, Ryan is always looking for ways to solve new and unique challenges. In additional to solving technical problems and managing a team of DBAs and Report Developers, Ryan likes to get to the bottom of problems and help everybody clearly define a shared solution. Ryan is an MCP and frequently helps out others on StackOverflow, Experts-Exchange, and under the #sqlhelp tag on Twitter.
LinkedIn: http://www.linkedin/in/carlosbossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
LinkedIn: http://linkedin.com/in/jasonkassay
Contact: http://www.JasonKassay.com
Jason Kassay is a database administrator, software engineer amp; speaker from Colorado with over 12 years of experience. He is passionate about SQL Server, programming, release process, automation amp; performance tuning. Jason is an active member of the SQL Server community amp; volunteers/presents at events such as Colorado User Groups, SQLSaturday amp; Colorado GiveCamp. When not tuning databases or coding, Jason will most likely be found spending time with his family, playing hockey or running.
LinkedIn: https://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
LinkedIn: https://www.linkedin.com/in/ginger-grant-3a177b157/
Contact: http://www.DesertIsleSQL.com
Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
LinkedIn: https://www.linkedin.com/in/ginger-grant-3a177b157/
Contact: http://www.DesertIsleSQL.com
Ginger Grant manages the consultancy Desert Isle Group and shares what she has learned while working with data technology to people around the world. As a Microsoft MVP in Data Platform, Microsoft Certified Trainer and an instructor on DataCamp, she focuses on guiding clients to create solutions using the entire Microsoft Data Stack, which includes SQL Server, Power BI, and Azure Data Cloud components. When not working, she protypes the latest pre-release data technologies, maintains her blog http://www.desertislesql.com, and spends time on twitter @desertislesql.
Mark Paszli is a senior consultant at Neudesic with over 10 years experience in Microsoft BI Solutions. His background originates in Engineering, who then crossed over to the realm of .Net application development and is now actively involved in helping clients achieve their goals using data driven methodologies within the Microsoft BI practice.
LinkedIn: http://www.linkedin.com/in/thesqlguru
Kevin Boles is a SQL Server expert, working exclusively with the product since v6.5. With over 25 years of database experience and over 45,000 man hours of SQL Server engine experience, he holds many related certifications, is an MCT and was a SQL Server MVP from 2007 to 2012. Kevin has been a very successful independent consultant for over 20 years. His passion is the relational engine, especially designing, building, analyzing and tuning high-performance database applications.
LinkedIn: https://www.linkedin.com/in/chris-hyde-3803706
Chris Hyde is a Microsoft Data Platform MVP and Microsoft Certified Trainer based in Albuquerque, New Mexico. He works as an independent SQL Server BI and DBA consultant, and is the leader of the Albuquerque PASS local user group. He is also part of the Friends of Redgate program and was a member of the Idera ACE class of 2018. He loves loud music and cricket, but usually not at the same time.
Contact: http://marcjellinek.wordpress.com
Marc Jellinek is a Senior Lead Consultant with Catapult Systems, a Microsoft National Systems Integrator based in Austin, TX. Marc's been working with SQL Server since version 4.21 for employers such as Microsoft, Ernst Young and Major League Baseball.
LinkedIn: https://www.linkedin.com/in/timmitchell/
Contact: http://www.TimMitchell.net
Tim Mitchell is a business intelligence architect, author, and trainer. He has worked with SQL Server for over a decade, specializing in data warehousing, ETL/SSIS, and reporting. He holds a Bachelor’s Degree in Computer Science from Texas AM at Commerce, and is recognized as a Microsoft Data Platform MVP. Tim is a business intelligence consultant and principal at Tyleris Data Solutions. Tim is an active community speaker and volunteer, having spoken at over 100 events including the PASS Summit, SQLBits, Dev Connections, SQL Intersection, and scores of SQLSaturdays. He blogs at TimMitchell.net, and tweets at @Tim_Mitchell.
LinkedIn: https://www.linkedin.com/in/joshuasivey/
Josh Sivey is a Microsoft Certified Professional with over fifteen years of experience delivering solutions using Microsoft technologies. He enjoys helping empower users to unlock the power of corporate data using the Microsoft BI stack. Josh is a Technology Solutions Professional with Microsoft. In his free time, he enjoys saving Hyrule from the clutches of Ganon with his son and playing My Little Ponies with his daughter.
LinkedIn: https://www.linkedin.com/in/dbajbrimhall/
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
I have working with SQL and Informix Database engines for over 13 years
LinkedIn: https://www.linkedin.com/in/millerrobert
Contact: http://sqlhuman.com
Robert Miller has managed Microsoft SQL Server implementations for the past twenty years. Additional, he is an accomplished architect, application developer, SAN and Systems administrator. In addition to Microsoft SQL Server, he has experience with Oracle and VMS/Rdb database environments. Robert#39;s specialty is working in and architecting high-performance, high-availability environments.
Contact: http://oszakiewski.net/erics_blog
Eric has been a developer for 32 years, working with SQL since 2006, managing SQL development, performance tuning optimization, SSIS package development auditing, and SSRS design development. Currently developing .Net SharePoint solutions for General Motors.
LinkedIn: https://www.linkedin.com/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
John Yang is currently the co-founder and chief architect for Data and Decision. His areas of expertise include big data, data mining, data warehouse architecture, business Intelligence and predictive analysis, he is also the part time research associate with ASU Biomedical Informatics Department, working towards promoting clinical research data warehouse to research community.
LinkedIn: http://www.linkedin/in/carlosbossy
Contact: http://www.carlosbossy.com
Carlos Bossy (MCTS, MCP BI, CBIP) is a data and cloud analytics architect with 25 years of experience in software and database development. As a principal of Datalere, Carlos focuses on developing BI, Data Science, and Advanced Analytics solutions, including modeling data warehouses and delivering predictive models, integration, and visualization. He has developed warehouses and BI solutions for a variety of industries and state agencies, including health insurance, solar energy, foster care, telecom, and manufacturing.
Contact: http://sharepointdavinci.blogspot.com/
Based in Phoenix, Arizona, Eric is a Senior Consultant within the Portals and Collaboration Group at Neudesic LLC. With 13 years of experience in multiple facets of IT, Eric enjoys the SharePoint platform because “it is an evolving product line that constantly brings new and exciting solutions to market”. Eric has a deep theoretical and practical understanding of SharePoint and Windows infrastructure. Eric holds multiple Microsoft certifications.
LinkedIn: https://www.linkedin.com/in/johnbmcallister/
Contact: http://www.profisee.com
John McAllister co-founded Stratature, an Independent MDM software vendor, in 2001. Following Microsoft’s acquisition of Stratature in 2007 John served as Group Program Manager for MDS and oversaw the incorporation of MDM into SQL Server. John now serves as the Regional Sales Director for Profisee, Inc. which provides enterprise-class MDM Solutions built on top of Microsoft’s MDS offering. John has worked with 100’s of organizations around the world in all phases of MDM projects.
LinkedIn: http://www.linkedin.com/in/reevessmithiii/
Contact: http://reevessmith.wordpress.com
Reeves Smith, owner and principal architect of Macer Consulting, is passionate about applying data technologies that empower organizations. Reeves wields his knowledge and experience to lead, design, architect, and teach, working with both data center and business project teams. He approaches every project by first understanding the organization’s business challenges, and then developing a unique approach that targets those business needs accurately and effectively. Reeves Smith has more than 20 years of experience working on the SQL Server stack. He is a Microsoft Data Platform MVP and Microsoft Certified Master, and regularly delivers technical presentations at international, regional, and local conferences and user groups.
LinkedIn: http://www.linkedin.com/pub/jeff-renz/29/82a/aa4
Contact: http://www.revgen.com
Jeff Renz is a Senior Architect at RevGen Partners, currently working as the design architect and implementation lead on several projects for a Fortune Top 50 company. Jeff has worked with SQL Server and BI for 15+ years and has 10 years’ experience with data warehouse design and implementation. In addition to consulting, he is joining the University of Denver adjunct faculty and is expected to begin teaching in the ICT program starting in June. He received his bachelor’s degree in Computer Science, his master’s degree in Operations Research from Colorado School of Mines, and will be graduating from the Harvard Business Analytics Program in December.
LinkedIn: http://www.linkedin.com/in/smithmatthewc/
Matt is currently a Data Platform Business Intelligence Technology Solution Professional and works heavily with Enterprise level architectural, analytical, and operational solutions. His technical and leadership experience spans across numerous industries. He has a strong interest in remaining tactical in while working at the strategic level. His goal is to assist clients in analyzing, cleansing, and presenting their data so they can make more educated decisions about their business.
Contact: http://www.microtechpoint.com
Brian has been focused on helping IT Pros and Database Administrators (DBAs) better understand core Microsoft technologies for over 25 years. As an industry-recognized consultant, author, and conference speaker, Brian’s expertise ranges across Microsoft operating systems; SharePoint, SQL Server, and Active Directory. A frequent presenter at SharePoint Conferences around the world, he has authored or contributed to several SharePoint, SQL Server, and other technical books, and is an MCSE and MCT.
LinkedIn: http://www.linkedin.com/in/randyknight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
LinkedIn: http://www.linkedin.com/in/wsifre
Contact: http://www.broadstrokeconsulting.com/blog/, http://www.allegient.com
Warren Sifre has been in the IT community since 1998 and has worked in a variety of industries deploying solutions utilizing MS SQL Server in one capacity or another. In 2003, he decided to make SQL Server his mastery and has since developed skills in most defined disciplines of MS SQL. Currently he is a Principal Consultant and Technology Leader with Moser Consulting. He is responsible for BI Solution Architecture and the mentorship of team members. He has been a SQLSaturday Speaker since 2012, Azure Global Bootcamp, and many user groups in 2015 alone. He has a passion for knowledge transfer and solutions architecture, with a keen interested in Info Security.
LinkedIn: http://www.linkedin.com/pub/jeff-renz/29/82a/aa4
Contact: http://www.revgen.com
Jeff Renz is a Senior Architect at RevGen Partners, currently working as the design architect and implementation lead on several projects for a Fortune Top 50 company. Jeff has worked with SQL Server and BI for 15+ years and has 10 years’ experience with data warehouse design and implementation. In addition to consulting, he is joining the University of Denver adjunct faculty and is expected to begin teaching in the ICT program starting in June. He received his bachelor’s degree in Computer Science, his master’s degree in Operations Research from Colorado School of Mines, and will be graduating from the Harvard Business Analytics Program in December.
LinkedIn: http://www.linkedin.com/in/loriedwards/
Contact: http://www.sqlservertimes2.com
Lori Edwards currently holds the position of Solutions Engineer for SentryOne. Prior to working with SQLSentry, she spent 11 years working as a production DBA. She also has volunteered for PASS since 2009 on the Program Committee, ERC, Nomination Committee and speaking at SQLSaturdays.
LinkedIn: http://www.linkedin.com/in/tjaybelt/
Contact: http://tjaybelt.blogspot.com
TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can't be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.
LinkedIn: http://www.linkedin.com/in/tjaybelt/
Contact: http://tjaybelt.blogspot.com
TJay Belt is an outdoorsman at heart who enjoys riding dirtbikes, waterskiing, boating, playing racquetball and spending time with his family. When he can't be out playing, TJay loves to tinker with databases. TJay has been an IT professional for over a decade and a half. Currently serving as a Senior Database Administrator with Imagine Learning. TJay has progressed through several roles in his database career including developer, data guy, database developer, database analyst and DBA.
LinkedIn: http://www.linkedin.com/in/randyknight
Contact: http://www.sqlsolutionsgroup.com/blog
Randy Knight is a data professional who has worked with Microsoft technology for over 25 years, focusing on SQL Server since 1997. He has worked in a variety of settings, including 6 years as a database architect for match.com. In 2010, he founded SQL Server Solutions Group LLC, a boutique SQL Server consultancy. A Microsoft Certified Master (MCM) in SQL Server, he speaks often at events all over the country including the PASS Summit, SQLIntersections, and numerous SQLSaturday and User Groups.
LinkedIn: http://www.linkedin.com/in/johnbmcallister
Contact: http://www.profisee.com
John McAllister co-founded Stratature, an Independent MDM software vendor, in 2001. Following Microsoft’s acquisition of Stratature in 2007 John served as Group Program Manager for MDS and oversaw the incorporation of MDM into SQL Server. John now serves as the Regional Sales Director for Profisee, Inc. which provides enterprise-class MDM Solutions built on top of Microsoft’s MDS offering. John has worked with 100’s of organizations around the world in all phases of MDM projects.
Kevin Cox has been working with databases for over 35 years and with SQL Server for more than 25 years. He is an author, lecturer, and mentor in database subjects. Kevin is currently with the Microsoft Azure Engineering product group in the Customer Advisory Team and feels fortunate to be able to work on the largest projects around the world.
LinkedIn: http://www.linkedin.com/in/martinschoombee
Contact: http://www.martinschoombee.com
Martin is an independent Business Intelligence Analytics consultant, helping customers make sense of their data for more than 15 years.
Contact: http://MtnDBA.wordpress.com
Andre has been in the IT industry for over 25 years in various positions with the majority working as database administrator, designer and programmer. His experience has been in the financial, travel and education industries.
LinkedIn: http://www.linkedin.com/pub/vern-rabe/a/ba3/980
Contact: http://www.rabedata.com
Vern Rabe is an independent SQL Server consultant and contract trainer in Portland, OR, and leader of the Oregon Data Community user group, formerly OregonSQL. He has attained MCSE, MCITP (both Administration and Development), and MCT certifications, among others. Vern has been passionate about databases since 1992 and has worked with SQL Server since version 4.21a. He provides broad technical SQL Server knowledge gained from the mixture of academic and practical experiences acquired from his classroom instructing and varied consulting contracts. Vern regularly presents technical sessions at SQL Server user group meetings, SQLSaturdays, and PASS Summit.
LinkedIn: http://www.linkedin.com/in/kathikellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
LinkedIn: http://www.linkedin.com/pub/david-stein/8/ba8/705
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
LinkedIn: http://www.linkedin.com/in/kathikellenberger
Contact: http://auntkathisql.com
Kathi Kellenberger is the editor of Simple Talk at Redgate and a Data Platform MVP. She has worked with SQL Server for over 20 years and has authored, co-authored, or tech edited over a dozen technical books. Kathi is the co-leader of the PASS Women in Technology Virtual Group and a volunteer at LaunchCode. When Kathi isn’t working, she enjoys spending time with family and friends, cycling, singing, and climbing the stairs of tall buildings. Be sure to check out her courses on Pluralsight.
LinkedIn: http://www.linkedin.com/in/shawnmeyers42
Shawn Meyers is a Field CTO working at Tintri. Shawn has worked in IT for 25+ years and specifically with SQL Server for 20+ years, beginning with version 6.5. A frequent speaker at many events including PASS Summit, VMworld, VMUGs, Virtual Chapter sessions, and many SQLSaturday events. Current focus is on improving DBAs lives with better infrastructure.
LinkedIn: http://www.linkedin.com/pub/david-stein/8/ba8/705
Contact: http://www.Made2Mentor.com
David Stein - Agile Data Warehouse Architect and Independent Consultant - has more than a decade of experience working in SQL Server Business Intelligence. He’s designed multi-terabyte, multi-tenant Data Warehouses from scratch as well as saved projects in serious jeopardy.
LinkedIn: http://www.linkedin.com/in/levinami/
Contact: http://www.amilevin.com
Ami is a data nerd that has been designing, consulting, training, writing, and speaking about SQL, relational modeling, and data platform architecture for more than 20 years. Currently works as a freelance consultant, senior SQL instructor at O'Reilly Media, as an author for PluralSight and LinkedIn Learning.
LinkedIn: http://www.linkedin.com/in/levinami/
Contact: http://www.amilevin.com
Ami is a data nerd that has been designing, consulting, training, writing, and speaking about SQL, relational modeling, and data platform architecture for more than 20 years. Currently works as a freelance consultant, senior SQL instructor at O'Reilly Media, as an author for PluralSight and LinkedIn Learning.
Contact: http://datadesignpro.com/
Joe is an accomplished Business Intelligence Architect with Pragmatic Works. For over 15 years, Joe, has designed complex business intelligence solutions for customers throughout all of North America. His focus on architecting the right hardware and software solution along with implementing best practice dimensional models has earned him high praise from customers.
LinkedIn: https://www.linkedin.com/in/dbajbrimhall/
Contact: http://jasonbrimhall.info
Jason Brimhall has more than 20 years of experience and has worked with SQL Server 6.5 through SQL Server 2019. He has experience in performance tuning, high transaction environments, and large environments. He is currently a consultant specializing in performance tuning, server analysis, and problem resolution. Jason is a Microsoft Certified Master (MCM) and a Data Platform MVP.
LinkedIn: https://www.linkedin.com/e/fpf/252170891
Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E
Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence
Contact: http://johnsterrett.com
John Sterrett is a Group Principal and Sr. Consultant at Linchpin People. Previously, he was a Sr. Database Admin Advisor for Dell, directly responsible for several mission-critical databases behind dell.com. John has presented at many community events, including PASS Member Summit, SQLRally, 24 Hours of PASS, SQLSaturday’s, PASS Chapters and Virtual Chapter meetings. John is a PASS Regional Mentor and founded WVPASS user group and the HADR Virtual Chapter.
LinkedIn: https://www.linkedin.com/pub/keith-tate/34/a40/a46
Contact: http://thesqlchef.com
Keith Tate is a Senior Database Administrator with over 17 years of experience as a data professional. During Keith#39;s professional career he has been a developer, DBA and data architect. Keith is also active in the SQL Server community and is currently the chapter leader of the Albuquerque SQL Server User Group.
LinkedIn: https://www.linkedin.com/in/oriongm
Contact: http://www.bi-insights.com/
Orion Gebremedhin, is the Director of Technology for Data and Analytics Platform at Neudesic . He is also a Data Platform (vTSP) for Microsoft Corporation focusing on Big Data technologies. Orion brings extensive experience in implementing advanced analytics and big data technology solutions in various industries. He is a frequent speaker in various technology events; and currently leads the Big Data and Advanced Analytics roadshow sponsored by Neudesic and Microsoft. Neudesic has been providing innovative technologies, services and software products for more than a decade to help organizations gain a competitive advantage and position them for success.
Kevin Cox has been working with databases for over 35 years and with SQL Server for more than 25 years. He is an author, lecturer, and mentor in database subjects. Kevin is currently with the Microsoft Azure Engineering product group in the Customer Advisory Team and feels fortunate to be able to work on the largest projects around the world.
The following is a list of sponsors that helped fund the event.