SQLSaturday #370 - Phoenix 2015
Event Date: 02/28/2015 00:00:00
Event Location:
- The Black Canyon Conference Center
- 9440 N 25th Ave
- Phoenix, Arizona
This event has completed. All data shown below is from the historical XML public data available.
If there are any data quality issues or corrections needed, please contact the webmaster for this site or submit a pull request for the appropriate file(s).
Sessions
This is a list of sessions from the event, based on the schedule in the XML files.
Title: The Leader in Server-Side Storage Intelligence
Abstract: Storage bottlenecks are consistently the root cause of application performance issues in virtualized data centers. Solving this problem via traditional storage architectures can be costly, inefficient, and provide lackluster results. PernixData software puts storage intelligence into high speed server media, enabling a decoupled storage architecture that optimizes VM performance while leveraging any shared storage for capacity. Benefits of PernixData software include: • Fast VM performance: Fault tolerant read and write acceleration using server flash and RAM.• Flexible data center design: Decouple storage performance from capacity to minimize hardware costs.• Seamless deployment and operations: 100% software – No changes to VMs, hosts, or storage; No rip and replace of existing hardware.
Speaker(s):
- Jared Lutgen
Track and Room: DBA/Prof Dev - N/A
Title: RC, SI, and RCSI, Oh My! –We’re off to see the Wizard -to understand how it all works
Abstract: I’m just going to say it straight out. I’m pessimistically optimistic that most really understand transaction concurrency in SQL Server. There is often significant confusion about transaction concurrency and contention options available to Developers -is it ‘pessimistic’, or ‘optimistic’, or in between? Everyone ‘sort of’ understands READ COMMITTED (RC). But do you sometimes feel ‘dirty’ as you attempt to ‘repeatedly’ read that phantasma? In order to reduce locking and blocking conflicts, some folks adopt SNAPSHOT ISOLATION (SI). And a few hardy stalwarts have ventured into the new world of READ COMMITTED SNAPSHOT ISOLATION (RCSI). In this session, we will explore the differences between the three, including a discussion about the positives and negatives of each option. We will discuss the effects of ‘Dirty’, ‘Repeatable’ and ‘Phantom’ reads, and why you may want to know which may be buried in your code. There will be code examples demonstrating the benefits and traps of each option.
Speaker(s):
- Arnie Rowland
Track and Room: SSIS/DBA/Misc - N/A
Title: Standalone to High-Availability Clusters over Lunch—with Time to Spare
Abstract: Don’t miss this demonstration of the hot new container technology that will change your assumptions about what it takes to implement high-availability clusters–on physical and/or virtual machines. Join DH2i’s Carl Berglund as he transforms standalone SQL Server instances of different versions and editions into an automated HA cluster failing over between systems—in just a few minutes. In fact, he’ll have plenty of time left over to show you some other cool tricks with his new cluster, such as: QoS controls at the instance level, SQL and OS updates as fast as an application stop/start, and multi-subnet geo-clustering capabilities. And you’ll still have time to grab dessert.
Speaker(s):
- Carl Berglund
Track and Room: DBA - N/A
Title: Achieving Peak Performance from your Virtual SQL Servers
Abstract: Your SQL Servers are probably virtualized by now, but are they running at their absolute peak performance? How can you tell? When properly configured and maintained, a virtualized SQL Server will be at least as fast as the system that it came from, if not better. If not properly configured, silent performance killers can wreck your virtualization experience. This session will give you tips and tricks to maximize performance while giving you talking points so you can convince your infrastructure engineers to design the virtualization stack your way. This session goes deep into the architecture and methodology for squeezing the best possible performance from your virtualized SQL Server, and includes valuable tips on topics such as host-level over-commitment, storage performance, In-memory OLTP, and more!
Speaker(s):
- David Klee
Track and Room: DBA - N/A
Title: Extending Your Availability Group for Disaster Recovery
Abstract: Did you know that SQL Server Availability Groups can be a great solution for disaster recovery? Availability groups have become well known for their high availability capabilities, and for good reason: they work well, they remove some of clustering’s limitations, and they are fairly straightforward to setup. Extending an availability group to multiple sites for disaster recovery becomes more complicated. A lot of moving parts have to come together for it to work properly - SQL Server, Windows, Active Directory, and DNS all get involved in this advanced configuration. In this session, we’ll discuss some of the factors that complicate a multi-site availability group deployment, and we’ll walk through a multi-site deployment so you can see how it’s done.
Speaker(s):
- Ed Leighton-Dick
Track and Room: DBA - N/A
Title: Guerilla MDM via MDS/SSIS Implementation
Abstract: I have implemented at several client. In implementing MDS I have extensive experience in creating data quality, data governance and MDM/MDS accelerators I published many articles.
Accelerators can take many forms generally there either software products that accelerate development and/or techniques that embody data aware and code generation capabilities.
In developing the MDS application extracting data, applying data quality, loading MDS entities, and extracting data from MDS, we have applied these techniques, that I have published articles on.
Specifically we’ve created an SSIS/MDS application architecture is highly reusable and can easily be used to Quickstart other MDS projects requiring minimal change and leaving the best practices for MDS architecture, as I understand them. The basic principle we applied this to be a data aware (data profiling)and create SSIS code that will self generate loan pr
Speaker(s):
- Ira Warren
Track and Room: SSIS - N/A
Title: SSAS Multidimensional vs. SSAS Tabular – Which one do I use?
Abstract: With the release of SQL Server 2012, we were introduced to two possible options when it came to Analysis Services. This ultimately presented a question…”Which one do I use SSAS multidimensional or SSAS tabular”?
Determining whether multidimensional or tabular is the optimum solution for your organization is a key step when working with SQL Server Analysis Services 2012/2014. This session will introduce you to some of the common pitfalls with each solution and how you can avoid them. By the end of this session, you’ll have a clearer understanding of the strengths and weakness of each model and how your organization can optimally leverage the strengths of SSAS 2012/2014.
Speaker(s):
- Alan Faulkner
Track and Room: BIA - N/A
Title: Enterprise-grade MDM On SQL Server - the Keys to Success
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
Track and Room: DBA - N/A
Title: SQL Server Backups and Restores A to Z
Abstract: Have you become the de facto DBA? Have you been tasked with the responsibility of backing up your databases? Do you feel that your database maintenance plan is adequate, but may be lacking in what it can do? If these scenarios sound familiar, you’ll want to join this session, where Microsoft Certified Master (MCM) Keith Tate will walk you through the basics of backup and restore options. The session will begin with the reasons why databases must be backed up (hint: to restore them). Then, discuss the different recovery models and how they affect your backup strategy. Next, explore ways to automate backup and restore strategies, and review ways to improve the speed of your backups and restores. Finally, put it all together and you’ll be on your way to a disaster proof backup and restore strategy.
Speaker(s):
- Keith Tate
Track and Room: DBA - N/A
Title: Dynamically Increase your Data Awareness
Abstract: Data Profiling is a vital step that is often overlooked in the development process. Integration Services (SSIS) built-in support for data profiling is limited and takes manual user intervention. Learn a new approach to automate data profiling and increase your data awareness. In this session we will walk through a framework that dynamically develops a group of packages that can profile data based on the existing metadata within your current environment. By dynamically tracking the metadata within your environment, you can easily maintain your data monitoring solution. This will enable a more thorough view of your ETL environment that will allow you to spot issues faster and create a more scaled infrastructure based on your current performance needs.
Speaker(s):
- Reeves Smith
Track and Room: SSIS - N/A
Title: SQL Server Statistics – What Are The Chances?
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. We’ll also go over the cardinality estimator changes in 2014. At the end of this session, you should have a better idea of how the query optimizer within SQL Server makes decisions on how to gather data.
Speaker(s):
- Lori Edwards
Track and Room: DBA - N/A
Title: Introduction to Microsoft Azure DocumentDB
Abstract: Developers are interested in consuming and processing very large amounts of data as quickly as possible. Microsoft Azure DocumentDB is a NoSQL document database service designed for modern mobile and web applications which require fast reads and writes of unstructured data feeds. Azure DocumentDB natively supports JSON documents which is a key performance feature. In this session I will demonstrate how to create a DocumentDB instance in Azure, how to work with JSON documents, create Ad hoc queries with familiar SQL syntax, create application logic as stored procedures, triggers and user defined functions (UDFs) using standard JavaScript.
Speaker(s):
- Jeff Renz
Track and Room: BIA - N/A
Title: SQL Server Filesystem
Abstract: As part of the SQL Server OS, SQL Server has its own file system built on top of the Windows NTFS. Understanding how the SQL Server filesystem works and how it interacts with NTFS and storage is critical to SQL Server performance. This presentation will start with a brief review of NTFS and then go into depth on the SQL Server filesystem. It should help you understand: • Why is fragmentation bad for performance? • Why should I allocate more than one file in a filegroup? • Why should I not rely on autogrow to size my SQL files? • Why is autoshrink a very bad thing? • What should my NTFS allocation unit size be set to? • How many files should tempdb have?
All this and more!
Speaker(s):
- Roger Wolter
Track and Room: SSIS/DBA/Misc - N/A
Title: WIT Panel
Abstract: The definition of confidence is “belief in oneself and one’s powers or abilities” but the authors of the new book “The Confidence Code” define confidence as “the quality that turns thoughts into actions.” Traditionally men have been found to have much more confidence in themselves than do women. For example, in a study at Hewlett-Packard, men applied for a promotion when they thought they could meet 60% of the qualifications while women applied only when they thought they could meet 100%. Attend this WIT session to learn more about confidence and how it impacts your career and life. To prepare for the session, it is recommended that you complete The Confidence Quiz (http://theconfidencecode.com/confidence-quiz/)
Speaker(s):
- Kathi Kellenberger
Track and Room: DBA - N/A
Title: Power BI Hands-On Micro-Workshop
Abstract: Bring your laptop and let’s build a BI solution using the components of Power BI! You’ll need Office 2013 ProPlus (you can install the trial) and the Power Query add-in. I’ll provide everything else. This 95% demo and uber-fast hands-on lab session will show you how to cleanse and transform data from multiple sources with Power Query, model data for reporting with Power Pivot and then explore the model and build interactive dashboards with Power View. You’ll leave with a working BI solution. Office ProPlus 60 day trial: http://www.microsoft.com/en-us/evalcenter/evaluate-office-professional-plus-2013 Power Query add-in: http://www.microsoft.com/en-us/download/details.aspx?id=39379
Speaker(s):
- Paul Turley
Track and Room: BIA - N/A
Title: Getting started with Big Data and BI
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
Track and Room: BIA - N/A
Title: Setting the stage…
Abstract: Making successful deployments consistently is something your executive team wishes could happen. Sometimes they wish it so hard, that you end up becoming that cowboy that tests everything in production (you know who you are). Procuring equipment and configuring an environment so that you can have some confidence in your solutions, while not destroying customer data, can be a challenge…especially if you have no plan of attack to hand the people that sign the checks.
In this session we will discuss the need for, the design of, and the way to get a staging environment that can boost your deployment success rate, allow developers to fearlessly code creative solutions, and allow you the DBA to get some sleep knowing they aren’t testing in production.
Speaker(s):
- Tim Hidalgo
Track and Room: App Dev - N/A
Title: Change Data Capture (CDC) with SSIS
Abstract: Whether you are trying to setup a new data warehouse, keep it updated, audit changes to your databases or quickly load changes to another database Change Data Capture (CDC) is a solution for all of these and can now be setup and supported easily with SQL Server SSIS 2012! Change Data Capture (CDC) has been around since SQL Server 2008, but has been underused because it was difficult to fully implement. SSIS 2012 now provides support for CDC with new components that make consuming the captured data very easy to apply. This session will define what CDC is and with live demos show how it is setup on your databases. Once it has been setup then you need to consume and apply those changes, this will be demonstrated with live demos using SSIS 2012 to create packages that apply the changes.
Speaker(s):
- Steve Wake
Track and Room: SSIS/DBA/Misc - N/A
Title: On-Demand Compute and Analytics with Powershell, Hadoop and Azure
Abstract: This session will take the beginner in big data and show them how to use powershell, HDinsight and Microsoft’s Azure platform to enable on demand analytic and compute. These capabilities are critical in the modern data warehouse environment and can only be delivered by technologies working together to create an analytic fabric that the organization can use. From developers the analysts and operations folks, this session will have something for all of you.
Speaker(s):
- Adam Jorgensen
Track and Room: BIA - N/A
Title: The Significance of Choosing the Right Data Types
Abstract: It’s an all too common occurrence to have table columns or variables that have been assigned less than ideal data types. Join this session and learn the importance of choosing the proper data type, the guidelines in determining what an appropriate data type would be, and, once chosen, some tools for its usage and management. There will be several demonstrations on performance and accuracy issues, along with their possible solutions, caused by either the assignment of inappropriate data types or improper usage of them. In addition, we will cover several data type related functions, and the caveats in their usage. Even advanced T-SQL developers and DBAs will walk away with a useful nugget or two.
Speaker(s):
- Vern Rabe
Track and Room: App Dev - N/A
Title: Optimize Your SQL Server 2014 Workloads with Cisco UCS
Abstract: Learn about Cisco Unified Computing System (UCS) and why it is an optimal platform for Microsoft SQL Server. During this session we’ll discuss key differentiators that place Cisco well ahead of the competition. Learn about UCS’ management model, Service Profiles, Virtual Interface Adapters, and how they help to simplify and standardize SQL Server deployments. We will also discuss how these differentiators drastically reduce deployment and recovery times, and how UCS provides the best of class hardware platform that can help to achieve the highest levels of consolidation and performance for both virtual and bare metal SQL Server implementations.
Speaker(s):
- Gary Serda
Track and Room: SSIS - N/A
Title: The Life Cycle of a Query in 3D
Abstract: Have you ever wondered what really happens behind the scenes when you execute a query? In this unique demonstration, Todd will use a video game engine (Unreal Engine 4) and will dramatically show The Life Cycle of a Query in 3D. We will follow a query from beginning to end and “runthrough” the various SQL Server components all queries must use including the Protocol Layer, Relational Engine, Storage Engine, Buffer Pool and then back out to the client. A volunteer at the end will then don an Oculus Rift DK2 Virtual Reality headset and then race through the sections in under a minute to win a prize. Participants will leave with a better understanding of the major components and with a conceptual framework to explore the components more in-depth.
Speaker(s):
- Todd Kleinhans
Track and Room: DBA/Prof Dev - N/A
Title: Powershell - Automating build and deployment in a datawarehouse environment
Abstract: There are many components which are developed and integrated as part of the large database solution – databases, ETL packages, reports, roles/security, SharePoint presentment, dashboards, etc. But the solution also needs to be managed in the context of a robust ALM, many physical environments with varying configurations, and many developers contending for resources. Automated builds are critical to such a solution. In this session we will examine the techniques used at one company to leverage PowerShell to drive automated processes to build, deploy, and test a solution in their development, testing, and QA environments. We will see live demos of the tools involved.
Speaker(s):
- Richard Kemp
Track and Room: BIA - N/A
Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
Abstract: While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.
Speaker(s):
- Amy Herold
Track and Room: DBA - N/A
Title: Fun with the File System Task
Abstract: The SSIS File System task allows for create, copy, move and delete of files and folders. In this session I will demonstrate some creative ways I have seen these tasks used to perform seemingly magical functions. You may be thinking what could possibly be so magical about using the File System task? Well, you will just have to attend to find out.
Speaker(s):
- Paul Graham
Track and Room: SSIS - N/A
Title: Microsoft Keynote - Advancing the Cloud Data Platform
Abstract: Join Kevin Cox Matt Smith from Microsoft as they display the engineering and innovation in the Microsoft Cloud Data Platform. Listen to them as the talk about and showcase some of the largest, fastest, and most complex customer projects in addition to how Microsoft is enabling customers to leverage the cloud to address previously unattainable business objectives.
Keynote Themes: 1) Pay attention to Azure SQL DB because most of the new features will appear there first 2) Large projects on SQL 2014 3) SQL on premises + Cloud scenarios/use cases 4) Demos: Power BI, On-Premises + Cloud
Speaker(s):
- Kevin Cox
Track and Room: DBA - N/A
Title: Understanding Parameter Sniffing
Abstract: Parameter sniffing is a good thing: it is used by the Query Optimizer to produce an execution plan tailored to the current parameters of a query. However, due to the way that the plan cache stores these plans in memory, sometimes can also be a performance problem. This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well. The session will also include details on how the Query Optimizer uses the histogram and density components of the statistics object and some other advanced topics.
Speaker(s):
- Benjamin Nevarez
Track and Room: DBA - N/A
Title: Introduction to Excel pivot tables
Abstract: When people have a pile of data on which they need to do some basic analysis, most still turn to Excel as an easy-to-use data analysis tool. While there are many advanced BI tools you can use to help data tell the story, one of the easiest to use is built-in functionality, the Excel pivot table. In this session, we’ll review what a pivot table is, how to put your data together to leverage the power behind it, and do some demonstrations. We’ll also, time permitting, get into some of the more advanced features of pivot tables and show how they can be used to do some pretty advanced data analysis and aggregation.
Speaker(s):
- Ryan McCauley
Track and Room: SSIS - N/A
Title: In Memory OLTP: One programmer’s experience
Abstract: New for SQL Server 2014, In Memory OLTP, aka Hekaton, improves performance of many OLTP operations by maintaining tables in memory in lock latch free data structures and compiling T-SQL stored procedures to native code. This is one programmer’s experience porting an application to SQL Server 2014’s In-Memory OLTP feature to improve application concurrency, performance and scalability. I will discuss lessons learned and what changes are necessary to partially migrate an existing application to exploit SQL Server In Memory OLTP without having to rewrite a large application.
Speaker(s):
- Paul Combellick
Track and Room: App Dev - N/A
Title: Tools in Your Toolbox You’re Not using! Why Not?
Abstract: Policy Based Management (PBM) and Central Management Server (CMS) are tools you already have if you have at least one SQL 2008 instance. These powerful but often overlooked tools are simple to use, and together they give you a central point from which to manage all your SQL instances. You can even manage your SQL 2000 and 2005 servers as well. This live demo session will show you how easy it is to use these ‘hidden gems’ that have been lying about in your SSMS toolbox. Real world solutions for real world problems in just minutes.
Speaker(s):
- Mike Tutor
Track and Room: DBA - N/A
Title: Data Factory: Data Integration in the Cloud
Abstract: The Azure platform is ever changing. Today is no different. Azure has released a new tool called Data Factory. It is a cloud PaaS that is SSIS in the cloud. Are you curious what all it entails and if you can use it? In this session, we’ll go over the basics of Data Factory like structure, billing, and building blocks. We’ll go over a couple instances on how you can use Data Factory in current processes that you have in your data warehouse ETL.
Speaker(s):
- Josh Luedeman
Track and Room: BIA - N/A
Title: Introduction to Wait Types and Response Time Analysis
Abstract: Using Response Time Analysis and Wait Types is a newer method for tuning SQL Server instances. As a result, there is often confusion on exactly what the data means. The issue typically centers around the fact the wait time data is analyzed at the wrong level or the collected wait time data is not detailed enough. This presentation will focus on these problems and review several real-life case studies of using SQL Server Wait Type data coupled with Response time performance analysis to solve the most difficult performance related issues.
Speaker(s):
- Janis Griffin
Track and Room: DBA - N/A
Title: SMO Internals for High Performance Automation
Abstract: Ever wanted to know what happens behind the scenes in SQL Server when automating your maintenance work? How fast can your automation really go? I will take you through a few common objects in SMO and the internals of what happens when you use those objects. We will examine the TSQL that is generated, and learn techniques that lead to high efficiency. Combining the flexibility of PowerShell and SMO Internals is a recipe for awesome sauce. Come to learn about the knobs available to tune your SMO automations. PowerShell will be used as the vehicle that leverages SMO. Come see this demo-heavy session, you’ll be glad you did.
Speaker(s):
- Ben Miller
Track and Room: DBA/Prof Dev - N/A
Title: How “quirky” is your update?
Abstract: Running totals are a lot easier with the SQL Server 2012 T-SQL syntax, but making it perform over large data sets still remain a challenge. This demo-heavy session will explore the good, the bad and the ugly when it comes to calculating running totals.
Our main focus however, will be a method coined by Jeff Moden as the “quirky update”. This method produces lightning-fast results when calculating running totals, and sometimes the only option if you’re dealing with large volumes and high performance requirements.
Speaker(s):
- Martin Schoombee
Track and Room: App Dev - N/A
Title: Introduction to Microsoft Power Query
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
Track and Room: BIA - N/A
Title: Pyramid Ananytics Govern Data Discovery
Abstract: The integrated Pyramid office suite offers a number of features that enables users to make the most of the suite’s BI capabilities. Designed to smoothly integrate with corporate business flows,
Speaker(s):
- Mike Teel
Track and Room: BIA - N/A
Title: Writing Better T-SQL Queries with Window Functions
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
Track and Room: App Dev - N/A
Title: Geospatial Data Types in SQL Server 2012
Abstract: The geospatial capabilities in SQL Server are not only powerful, but easy and fun to use! In this session, Lenni shows you how to integrate location-awareness into your own applications with the geometry and geography data types. We’ll explore the planar and geodetic spatial models, spatial markup languages such as WKT and GML, and then put these concepts to use as we build several useful demos, (e.g., Bing Maps integration). Demos show how to use the geospatial methods to easily calculate area, length, and distance, and project new shapes based on intersection and overlap. Attend this session and embrace spatial programming today!
Speaker(s):
- Leonard Lobel
Track and Room: App Dev - N/A
Title: Setting up an Azure Test Lab
Abstract: Azure is a fun new world, but many developers don’t have access to an Azure subscription to start playing with it. In this session, you will learn how to setup an Azure Test environment, find free training resources, and learn tips and tricks to get the most out of the Azure Free Trial.
Speaker(s):
- Marie Roqueni
Track and Room: BIA - N/A
Title: Introduction to Tableau
Abstract: In this introductory Step-by-step you’ll learn how to visually analyze data with Tableau by connecting to data, creating views and more.
- Introducing the Tableau Desktop application
- Connecting to SQL/OLAP data
- Creating worksheets and dashboards
- Demonstrating query and design best practices
Speaker(s):
- Michael Perillo
Track and Room: BIA - N/A
Title: Using Extended Events in SQL Server
Abstract: Extended Events were introduced in SQL Server 2008. With SQL 2014, we have seen a significant upgrade to this feature. Join me for a little adventure into the realm of extended events. 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. This is a fast paced session and will be a lot of fun. Attendees will be able to take back several sample XE sessions to help troubleshoot different issues and get to more intimately know their data/environment.
Speaker(s):
- Jason Brimhall
Track and Room: DBA - N/A
Title: Making the Leap from Developer to DBA
Abstract: You are a Developer (.NET, SQL or otherwise) but you have been doing some DBA work and have now decided that is all you want to do - how do you make the transition? What do you need to know? This session will cover this topic from first-hand experience.
Speaker(s):
- Amy Herold
Track and Room: DBA/Prof Dev - N/A
Title: Database Replication Strategies for Improved Productivity
Abstract: Strategies for Database Replication that can be used to reduce downtime during migrations, distribute database workload and improve database productivity and availability.
Speaker(s):
- Clay Jackson
Track and Room: DBA/Prof Dev - N/A
Title: BI DBA Performance Tuning
Abstract: Data Warehouses and OLTP systems are different! But there are some core concepts that we need to understand for managing and maintaining both. Do you want to know how you can load data faster, just by setting up your database correctly? Are your queries running slow? Want to understand how you can reduce locking and blocking in reporting queries? Do you have a system with views, that reference views, which reference more views? Let’s discuss some core concepts and techniques that will get you out of the slow lane and on your way to a faster Data Warehouse!
Speaker(s):
- Bradley Ball
Track and Room: SSIS/DBA/Misc - N/A
Title: Dimensional Modeling Design Patterns: Beyond Basics
Abstract: This session will provide a deeper dive into the art of dimensional modeling. We will look at the different types of fact tables and dimension tables, how and when to use them. We will also some approaches to creating rich hierarchies that make reporting a snap. This session promises to be very interactive and engaging, bring your toughest Dimensional Modeling quandaries.
Speaker(s):
- Jason Horner
Track and Room: BIA - N/A
Title: Creating Dashboards in SSRS
Abstract: Introduction on how to use SSRS to present relevant data in a format that is easy for the business user to use.
Speaker(s):
- Joshua Buttles
Track and Room: BIA - N/A
Title: Virtualizing our Environment
Abstract: This session will describe our journey to convert our cluttered, underutilized, power draining physical hosts to a sleek virtualized environment. This session will also provide some VMware high level architecture, terms and concepts, and a look at vSphere (VMware admin console). I’ll discuss the differences between virtual and physical host metrics and issues surrounding them. We’ll discuss some virtualization shortcomings and then show a little about Solarwinds’ DPA and how it can help DBAs achieve virtualization and not lose visibility of their physical layer.
Speaker(s):
- Rob Mandeville
Track and Room: DBA - N/A
Title: Make Your DBA Happy: 5 Habits Developers Can Implement Today
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
Track and Room: App Dev - N/A
Title: Tune a star schema for High Performance Data Warehouse Reporting
Abstract: A data warehouse built using star schema dimensional models can be tuned to handle a demanding workload put on it by its users who require fast reports, dashboards, data extracts, and ad-hoc analysis. In this session Carlos Bossy will discuss the unique problems associated with star schema query performance and present strategies that will allow you to handle large query volumes in a dimensional environment. Topics covered will include clustering, indexing and partitioning, and how to treat fact tables different from dimension tables.
Speaker(s):
- Carlos Bossy
Track and Room: BIA - N/A
Title: Event Notification in SQL Server 2012
Abstract: This session will cover an introduction to Event Notification usage in SQL Server 2012.
Speaker(s):
- Robert Miller
Track and Room: DBA - N/A
Title: Understanding the SQL Server Transaction Log
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
Track and Room: DBA - N/A
Title: Application of Hadoop on-demand for BI Integration and ETL Automation Using Azure HDInsight
Abstract: This session is designed to demonstrate the practical application of the Hyper Scale on-demand approach to Hadoop on Azure HDInsight, to process massive amounts of data on the cloud, for business intelligence applications. A hybrid architecture for ETL Integration will be discussed with practical demonstrations.
Speaker(s):
- Orion Gebremedhin
Track and Room: BIA - N/A
Title: Predicting the future with Machine Learning
Abstract: Machine Learning is Microsoft’s big entry in to the predictive analytics arena. Instead of staring into crystal balls, Machine Learning analyzes the data to determine if past performance is indicative of the future. In this introductory session we will discuss the growing new field of data predictive analytics and now Machine Learning is used to analyze cloud data.
Speaker(s):
- Ginger Grant
Track and Room: DBA - N/A
Title: Powershell Tips and Tricks for SQL Server Administration
Abstract: Have you dipped your toe into the Powershell pool, but are still lost on how you can make it work for you? Maybe you’re just looking for a few more tools to help you better manage SQL Server administration? In this session, we will cover a handful of useful scripts and patterns in Powershell that will ease your management of SQL Server. Backups, file management, instance configuration, and several other areas will be covered. By attending this session, you will learn more about how you can use Powershell effectively in your environment.
Speaker(s):
- Michael Fal
Track and Room: DBA/Prof Dev - N/A
Title: The Ins and Outs of SQL Indexes
Abstract: This course will focus on the fundamentals of strategic SQL Server index design and creation. Terms that will be covered and clarified: clustered index, non-clustered index, uniqueness, covering index, fill-factor, scan, seek, key lookup, and fragmentation. This is a beginning level course for those who have always found indexes confusing and somewhat elusive. Lots of valuable information will be provided in a short amount of time.
Speaker(s):
- Mindy Curnutt
Track and Room: App Dev - N/A
Title: TSQL Bullet-Dodging and Spoon-bending
Abstract: Did you think you could dodge bullets with SQL Server? Well, with some of these techniques, you won’t have to. Learn some of the newer language elements in SQL server: Recursive CTE’s, Composable DML, the MERGE statement, Row numbering and table-valued parameters. This fast-paced session that is almost exclusively demos is sure to leave you with a few ideas to make your TSQL development life easier.
Speaker(s):
- Michael DeFehr
Track and Room: App Dev - N/A
Title: Data wizardry with the next generation of Power BI!
Abstract: This will be an action-packed culmination of entertainment, story telling, jokes, and data wizardry using the next generation of Power BI!
Speaker(s):
- Matt Smith
Track and Room: BIA - N/A
Title: Diary of a Wimpy SSIS Developer
Abstract: 5 Glorious chapters that have
1- To lookup or Not to Lookup 2- Stored Procedure or Crazy CTE’s 3- Excel’s just don’t do it! 4- Problems in container Town. 5- Show down at the Error Corral.
Prelude to devine intervention of SSIS supremacy(With the rest of the time, show you examples of cool stuff you can do with SSIS)
Speaker(s):
- Joseph Barth
Track and Room: SSIS - N/A
Title: Ten T-SQL Techniques with Tally Tables
Abstract: Chris Hyde has been working with the Microsoft SQL Server stack for over thirteen 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
Track and Room: App Dev - N/A
Title: Protecting Your Data with Encryption
Abstract: We’ve all seen the recent news stories about companies whose data has been stolen by hackers. What was once a rare event has become all too common, and companies large and small are at risk. While it isn’t always possible to prevent intrusions, you can reduce the risk by encrypting your data. In this presentation, I’ll show you the four ways that SQL Server provides to encrypt data: hashes, cell-level encryption, database-level encryption (also known as transparent data encryption), and backup encryption. We’ll also discuss the keys required for each type of encryption and discuss how to protect the keys themselves.
Speaker(s):
- Ed Leighton-Dick
Track and Room: SSIS/DBA/Misc - N/A
Title: SQL Server 2014 Column Store Index vNEXT
Abstract: The Column Store Index functionality released in SQL 2012 did allow for stunning performance gains for OLAP-style queries, but as a v1.0 release it suffered from a number of caveats, limitations, provisos, etc. The one BIGGIE was that it made it’s underlying table NON-UPDATABLE. Well, that often implementation-killing restriction has been addressed, along with a huge number of other fixes and enhancements. We will cover what those are and also see actual usage with some nice demos.
Speaker(s):
- Kevin Boles
Track and Room: DBA - N/A
Speakers
This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.
Kevin Cox
Twitter: - @kevincoxsql
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.
Rob Mandeville
Twitter: - https://twitter.com/rob_mandeville
LinkedIn: Rob Mandeville
Rob Mandeville is a Senior DBA with over 20 years of broad experience in database technologies.
He’s served in many roles including production DBA, development DBA, and architect/data modeler on a variety of platforms.
Before coming to Solarwinds, Rob worked in the aerospace, global technology, and geospatial industries.
Rob also had the honor of teaching database related master level courses at Regis University.
Keith Tate
Twitter: - https://twitter.com/keith_tate
LinkedIn: Keith Tate
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.
Mindy Curnutt
Twitter: - @sqlgirl
LinkedIn: Mindy Curnutt
Contact: http://www.mindycurnutt.com
Mindy Curnutt is a 5X Microsoft Data Platform MVP, Business Owner and Entrepreneur. Her specialties include SQL Server hardware, configuration, migrations, scalability, performance tuning. She has been actively involved in the SQL Server Community for over two decades and has become a well known speaker within the SQL and Transportation Management communities. She is a two-time PASS Volunteer of the Month, has presented at 6 SQLPASS Summits, Live360, DevConnections, MVPMix and too many SQLSaturdays to count. She is currently the President of the North Texas SQL Server User Group out of Dallas/Fort Worth, TX.
Carl Berglund
Contact: http://dh2i.com/
Carl Berglund has 20+ years of experience helping businesses source and implement sophisticated datacenter infrastructures. Carl has held senior business development roles at HP and PolyServe, where he helped drive enterprise organizations’ SQL Server consolidation, virtualization and optimization projects. As a technology evangelist, Carl helps organizations reduce spend on overall SQL Server lifecycle costs while reducing risk. He is a regular speaker and author on Windows datacenter issues.
Steve Wake
Twitter: - stevewake
LinkedIn: Steve Wake
Contact: http://blog.wakebi.com
Steve Wake is currently the Principal BI Developer at Brown and Caldwell and has experience in consulting, advertising, media, manufacturing, retail, charities, telecommunications and financial services organizations using the full on-premises Microsoft BI stack. Recent experience with the Azure services: Analysis Services, Logic Apps, Data Factory, Databricks, Snowflake and Power BI. Steve is also very involved in the SQL community, speaking at events around the world.
Roger Wolter
Contact: http://rwolter50.blogspot.com/
Roger Wolter has over 25 years of experience in databases and distributed systems. He has extensive experience developing and delivering large complex applications on Windows environments with emphasis on databases, transaction processing, client server, reliable messaging, communications interfaces, and Master Data Management. During Roger’s 12 years with Microsoft he served as a program manager for SQL Server and as architect for a variety of product teams.
Ginger Grant
Twitter: - desertislesql
LinkedIn: Ginger Grant
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.
Michael Fal
Twitter: - @Mike_Fal
LinkedIn: Michael Fal
Contact: http://mikefal.net
Mike is a specialist in data management technologies. As a community advocate, public speaker, and blogger, Mike is a practicing thought leader for data and automation. He is passionate about DevOps and data, building platforms to optimize, protect, and use data efficiently.
Since 1999, Mike has been working in the database field, focusing primarily on SQL Server and specializes in automating data solutions to improve the reliability and efficiency of his environments. He has been caught playing trombone in public on more than one occasion.
Ryan McCauley
Twitter: - @SQLRyan
LinkedIn: Ryan McCauley
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.
Joshua Buttles
Contact: https://www.linkedin.com/profile/public-profile-settings?trk=prof-edit-edit-public_profile
SQL Professional certifed in SQL Server 2012 for both Data Platform and BI.
Mike Teel
Twitter: - michael teel@teel_pyramid michael teel@teelmi2000
LinkedIn: Mike Teel
Contact: http://www.pyramidanalytics.com/Pages/blog/Authors/mike-teel.aspx
Mike Teel- Pyramid Analytics- Sales Director – Western Region
Mike is a high energy and peak-performing sales professional with over 25 + years’ experience in diverse, high volume, complex solution oriented technology markets including; PC#39;s, Servers, Data Warehouse, CRM, Business Intelligence and Big Data.
Mike has a deep industry knowledge of the Retail, CPG, and Transportation Industry. Prior to joining Pyramid, Mike’s sales career spanned working at some of the big br
Clay Jackson
Contact: http://software.dell.com
Clay Jackson has been in the IT field since 1972; has a Masters in Software Engineering from Seattle University and is a CISM. Prior to joining Dell Software in 2012, he was a Database Administrator and DBA Manager for US West, Starbucks, Washington Mutual and Darigold; managing both SQLServer and Oracle databases. He has extensive experience managing heterogeneous database environments and making sure that decision makers have access to correct and complete data at all times.
Robert Miller
Twitter: - https://twitter.com/RobertMiller
LinkedIn: Robert Miller
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.
Jason Horner
Twitter: - jasonhorner
LinkedIn: Jason Horner
Contact: http://blog.jasonhorner.com
Hi, my name is Jason I’m a practice lead at Redapt. I spend most of my day helping clients solve business problems mostly in the Data and Advanced Analytics spaces. Sometimes this involves various and sundry cloud technologies including Azure Data Factory, Azure SQL Data Warehouse, Azure Data Lake Store, Azure Databricks, HDInsight and Azure SQL Database. I’m fluent in several languages including: SQL, C#, Python, and PowerShell.
I’m a Microsoft Certified Master of SQL Server (MCM) and have been recognized for my technical excellence and evangelism efforts by Microsoft by being awarded the Most Valuable Professional (MVP) for the last 5+ years.
In my off hours I like to snowboard, karaoke, ride roller coasters, and play arcade games
Ed Leighton-Dick
Twitter: - eleightondick
LinkedIn: Ed Leighton-Dick
Contact: http://www.edleightondick.com
Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.
Martin Schoombee
Twitter: - sqlmartin
LinkedIn: Martin Schoombee
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.
Paul Turley
Twitter: - paul_turley
LinkedIn: Paul Turley
Contact: http://www.sqlserverbiblog.com
Paul is a Principal Consultant for Pragmatic Works, a Mentor and Microsoft Data Platform MVP. He consults, writes, speaks, teaches blogs about business intelligence and reporting solutions. He works with companies around the world to model data, visualize and deliver critical information to make informed business decisions; using the Microsoft data platform and business analytics tools. He is a Director of the Oregon Data Community PASS chapter user group, the author and lead author of Professional SQL Server 2016 Reporting Services and 14 other titles from Wrox Microsoft Press. He holds several certifications including MCSE for the Data Platform and BI.
Randy Knight
Twitter: - randy_knight
LinkedIn: Randy Knight
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.
Ed Leighton-Dick
Twitter: - eleightondick
LinkedIn: Ed Leighton-Dick
Contact: http://www.edleightondick.com
Ed Leighton-Dick is a Microsoft MVP, SQL Server performance and architecture specialist, and Founder/Principal Consultant of Kingfisher Technologies. He is a frequent volunteer with PASS, including current roles as a Regional Mentor, co-leader of I-380 PASS local group, and co-leader of the HA/DR virtual group. He can often be found teaching sessions at local, regional, and national events, including user groups, SQLSaturday, and PASS Summit.
John McAllister
Twitter: - @jmcallis64
LinkedIn: John McAllister
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.
Jason Brimhall
Twitter: - sqlrnnr
LinkedIn: Jason Brimhall
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.
Chris Hyde
Twitter: - ChrisHyde325
LinkedIn: Chris Hyde
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.
Matt Smith
Twitter: - @SmithMattC
LinkedIn: Matt Smith
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.
Eric Oszakiewski
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.
Michael DeFehr
Twitter: - @mdefehr
LinkedIn: Michael DeFehr
Contact: http://mikedefehr.com
Michael DeFehr is an independent SQL Server consultant based in Winnipeg, Canada. He is focused on database administration and development using Microsoft SQL Server. A SQL Server MVP, Professional Engineer and MCITP in both Database Development and Administration, Mike has spent the past 15 years producing and maintaining database solutions. Mike specializes in the relational and storage engines and his solutions emphasize performance and simplicity.
Paul Combellick
Paul earned a BS in Petroleum Engineering, an MCSD certification, and has over 30 years experience in IT, with the last 20 years focused on SQL Server application development. He has programmed in BASIC, Fortran IV, dBaseIII+, Clipper, C/C++, VB6, C#, and T-SQL. He is now focused on designing and developing applications for Azure DB.
Bradley Ball
Twitter: - @SQLBalls
LinkedIn: Bradley Ball
Contact: http://www.sqlballs.com
Bradley Ball is a Sr. Azure Engineer for Microsoft, and former Data Platform MVP. During his IT career Bradley has spent 8 years working as a Defense contractor for clients such as the U.S. Army and The Executive Office of the President of the United States, and the former Data Platform Practice Manager for Pragmatic Works Consulting. He has presented at SQLSaturdays, SSUG’s, SQL Rally, DevConnections, SQLBits, SQL Live 360, and the PASS Summit. Bradley can be found blogging on http://www.SQLBalls.com
Michael Perillo
Twitter: - @michaelperillo
LinkedIn: Michael Perillo
Michael has 15 years of experience with business intelligence products, SQL Server, and SharePoint development. Michael focuses on on-boarding, training, community involvement, and product evangelism across many BI platforms.
David Klee
Twitter: - kleegeek
LinkedIn: David Klee
Contact: http://davidklee.net
David Klee is a Microsoft Data Platform MVP and VMware vExpert with a lifelong passion for technology. David spends his days focusing on the convergence of data and infrastructure as the Founder of Heraflux Technologies. His areas of expertise include cloud, virtualization, performance, and business continuity. David speaks at a number of national and regional technology related events, including PASS Summit, VMware VMworld, SQLBits, SQLSaturday events, and many SQL Server User Groups.
Carlos Bossy
Twitter: - @carlosbossy
LinkedIn: Carlos Bossy
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.
Carlos Bossy
Twitter: - @carlosbossy
LinkedIn: Carlos Bossy
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.
Lori Edwards
Twitter: - www.twitter.com/loriaedwards
LinkedIn: Lori Edwards
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.
Kathi Kellenberger
Twitter: - auntkathi
LinkedIn: Kathi Kellenberger
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.
Richard Kemp
Richard Kemp is a consultant with more than 25 years experience in the fields of information technology, software engineering, and data warehousing.
Leonard Lobel
Twitter: - @lennilobel
LinkedIn: Leonard Lobel
Contact: http://lennilobel.wordpress.com
Leonard Lobel (Microsoft MVP, Data Platform) is CTO and co-founder of Sleek Technologies, Inc., a New York-based development shop with an early adopter philosophy toward new technologies. He is also a principal consultant at Tallan, Inc., a Microsoft National Systems Integrator and Gold Competency Partner.
Programming since 1979, Lenni specializes in Microsoft-based solutions, with experience that spans a variety of business domains, including publishing, financial, wholesale/retail, health care, and e-commerce. Lenni has served as chief architect and lead developer for various organizations, ranging from small shops to high-profile clients. He is also a consultant, trainer, and frequent speaker at local usergroup meetings, VSLive, SQL PASS, and other industry conferences.
Lenni has also authored several MS Press books and Pluralsight courses on SQL Server programming.
Kathi Kellenberger
Twitter: - auntkathi
LinkedIn: Kathi Kellenberger
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.
Arnie Rowland
Twitter: - @ArnieRowland
LinkedIn: Arnie Rowland
Contact: http://sqlblog.com/blogs/arnie_rowland/
Arnie long ago realized that most issues between Developer and DBA comes from incomplete communication and a misunderstanding of each other’s objectives. He is a frequent Trainer and Mentor for Developers and DBAs, bringing both sets of skills to better communicate with teams to create a working solution. For over a decade, Arnie has been a SQL Server MVP, Certified Trainer, technical editor for several publishers, including MOC, and has served as University and Community College adjunct faculty. Clients include Fortune 500 and Multi-Nationals, Federal and State agencies, Foreign governments, and local enterprises –both public and private.
Mike Tutor
Twitter: - @SQLTutor
LinkedIn: Mike Tutor
Contact: http://www.sqlsolutionsgroup.com/category/sql-group/
Mike Tutor has been in the IT industry for over 30 years. He has worn many hats, including developer, systems admin, and project manager, but he has worked almost exclusively as a SQL Server DBA since the late 90s. He has worked as a development DBA in the medical research industry for many years, but is currently working as a Sr. consultant at SQL Solutions Group in Lehi UT.
Amy Herold
Twitter: - @texasamy
LinkedIn: Amy Herold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
Josh Sivey
Twitter: - @joshsivey
LinkedIn: Josh Sivey
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.
Vern Rabe
Twitter: - @VernRabe
LinkedIn: Vern Rabe
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.
Reeves Smith
Twitter: - SQLReeves
LinkedIn: Reeves Smith
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.
Orion Gebremedhin
Twitter: - oriongm
LinkedIn: Orion Gebremedhin
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.
Gary Serda
John Rice is a Data Center Consulting Systems Engineer for State amp; Local Government and Higher Education for Cisco in the Southwest States. He has been at Cisco for 4 1/2 years and has over 30 years of experience in computing, storage, networking, applications and systems management. He has certifications in Sun Microsystems Solaris, VMware VCP, Hitachi Data Systems Modular and Enterprise Storage, and Netapp.
Paul Graham
BI is my passion and working for Neudesic is my ideal job. I have had the opportunity to work in several different industries developing Business Intelligence solutions for our client. I find that extremely challenging and rewarding. I also enjoy sharing what I have seen and learned with others as well as continuously learning new things myself. SQLSaturday is an excellent opportunity for me to do both (to share and to learn). I hope to see you there.
Marie Roqueni
Marie Roqueni has 30+ years of DBA experience including design, development and implementation of mission critical database applications as well as business intelligence solutions. Before coming to Statera, Marie was a SQL Server Technology Specialist at Microsoft for 10 years, and prior to that was a Microsoft Certified Instructor. Marie’s passion is working with DBAs and developers helping develop solutions utilizing the Microsoft platform to deliver high business value.
Ben Miller
Twitter: - DBAduck
LinkedIn: Ben Miller
Contact: https://dbaduck.com
Ben has been a member of the SQL Server Community since 2000. He loves a challenge and has fixed many SQL Servers and helped hundreds of people get more out of their DBA jobs. He is a Data Platform MVP a SQL Server Certified Master (MCM). He has worked at various companies throughout the USA, as well as at Microsoft for 7 years. He is passionate about SQL Server Infrastructure, High Availability, Automation and Integration using SMO and PowerShell. He teaches DBAs how to use PowerShell to do their job and teaches SQL Server Internals. He is @DBAduck all around the web (Twitter, LinkedIn, Facebook, Blog) so let’s catch up.
Todd Kleinhans
Twitter: - @toddkleinhans
LinkedIn: Todd Kleinhans
Contact: https://toddkleinhans.wordpress.com/
Todd Kleinhans has been using SQL Server since the last millennium. He has served in different roles across many industries but he’s mainly been a DBA. When not in virtual reality, he likes to speak at PASS sponsored events and volunteers in various groups like PASS, DSSUG, Colorado Virtual Reality and is the President of Denver/Boulder Unreal Engine group. He is on Twitter: @toddkleinhans and blogs at https://toddkleinhans.wordpress.com/
Ira Warren
Over 35 years experiences in Software Sevelopemt, IT Management and BI Architecture.
Adam Jorgensen
Twitter: - wadamj
LinkedIn: Adam Jorgensen
Contact: http://www.pragmaticworks.com
As President of Pragmatic Works Consulting Adam drives market strategy, sales, partnerships, implementation and thought leadership. He has over 15 years of experience helping companies use their data to fuel their growth. Adam has been wowing audiences around the world for over a decade. He has delivered hundreds of sessions, published over a dozen books and hundreds of online videos and webinars on data and cloud topics. His passion is growing companies and mentoring leaders and companies to help them achieve their dreams.
Tim Hidalgo
Twitter: - digitalohm
i like computers and synthesizers and cats
Joseph Barth
Twitter: - @sql_da
LinkedIn: Joseph Barth
Contact: http://sqlda.com
An eight year Microsoft SQL Server Specialist in SQL Server 2005-2016, Azure SQL DB, he has held many development positions, including SQL query tuner, SSIS and SSRS . Joseph’s early focus as an SQL tuning professional, fixing long running queries by techniques; join order,use of temporary object, also implementing Index optimization, maintenance and design to fix slowness. Joseph has focused on ETL solutions using SSIS for the last 4 years, data warehousing and cloud architecture using Azure. Currently working on a Modern Data Warehouse project involving Azure Data Lake and Azure SQL DW using external tables. MCSE Data Management and Analytics 2016 MCSA: SQL Server 2012 Co-found CASSUG Albany NY 2 yrs AZSSUG Chapter Leader 3 yrs
Alan Faulkner
Twitter: - #FalconTekNik
LinkedIn: Alan Faulkner
Contact: http://falconteksolutionscentral.com/
I am an IT professional with over 20+ years of progressive technical experience with managing, consulting, software development, data integration architecture, data warehousing, and business intelligence development projects. The focus of my work is to work closely with stakeholders to develop architecture frameworks that align with organizational strategy, processes, and IT assets. Specializing in Business Intelligence (BI), Data Warehousing, database architecture, design and implementation.
Kevin Boles
Twitter: - @TheSQLGuru
LinkedIn: Kevin Boles
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.
Josh Luedeman
Twitter: - http://www.twitter.com/joshluedeman
LinkedIn: Josh Luedeman
Contact: http://www.joshluedeman.com
Josh is a Sr FastTrack Engineer with the FastTrack team in the Azure Engineering Group at Microsoft. Josh focuses on Microsoft’s Cloud Scale Analytics Solutions in Azure using products like HDInsight, Data Lake, Data Factory, and DataBricks. He has worked in IT for over 10 years holding positions in Application Support, Database Administration, and Business Intelligence, in industries like Higher Education, Consulting, Manufacturing, and Software Development.
Jared Lutgen
PernixData is leading a new era of server side storage intelligence. Break free from the trap of buying capacity to get storage performance, and enable your virtualized envi
Jeff Renz
Twitter: - jeff_renz
LinkedIn: Jeff Renz
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.
Benjamin Nevarez
Contact: http://www.benjaminnevarez.com/
Benjamin Nevarez is a SQL Server MVP and independent consultant based in Los Angeles, California who specializes in SQL Server query tuning and optimization. He is the author of “SQL Server 2014 Query Tuning Optimization”, “Inside the SQL Server Query Optimizer” and has contributed to other SQL Server books including “SQL Server 2012 Internals”. Benjamin has also been a speaker at many SQL Server conferences, including the PASS Summit, SQL Server Connections and SQLBits.
Janis Griffin
Twitter: - DoBoutAnything
LinkedIn: Janis Griffin
Janis Griffin has over 30 years of DBA/database experience including design, development and implementation of many critical database applications. Before coming to Quest Software, Janis primarily worked in the Telecom/Network Industry, working with both real-time network routing databases and OLTP business to business applications. Janis also held positions as a Principal Architect and Senior Manager, mentoring other DBAs on best practices in database performance tuning.
Amy Herold
Twitter: - @texasamy
LinkedIn: Amy Herold
Contact: http://www.sqlkitten.com/
Amy Herold is currently a Premier Field Engineer with Microsoft, specializing in APS. Prior to this, she was a Sr. Database Administrator, focusing on PowerShell and automation. She is also currently the Director of Programs for the North Texas SQL Server User Group (NTSSUG). She frequently speaks at SQLSaturday and user group events across the United States and has also participated in numerous Women in Technology sessions as a panelist. Amy currently blogs at sqlkitten.com.
Sponsors
The following is a list of sponsors that helped fund the event: