SQLSaturday #285 - Atlanta 2014

Event Date: 05/03/2014 00:00:00

Event Location:

  • Georgia State University - Alpharetta location
  • 3775 Brookside Pkwy
  • Alpharetta, Georgia

PDF of Schedule

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: Everything You Ever Knew About SSIS Is Null and Void

Abstract: With the release SQL Server Integration Services 2012, Microsoft did a massive overhaul to the deployment platform for SSIS. Gone is the old file based deployment system and MSDB. New to SSIS is the Integration Services Catalog.

Along with the catalog came many new improvements, such as package and project parameters. No longer do you have to mess around with ugly configuration files, or the mess of passing data between packages. Also included are new reports which you can use to examine your packages as they run, or see the status of past runs.

In this session we’ll look at how the new project based deployment model simplifies your SSIS coding. We’ll also take a dive into the catalog, uncovering the wealth of information it can provide.

Speaker(s):

  • Robert Cain

Track and Room: 11 Express Toll Lane ETL - N/A


Title: Manageable SSAS Deployment Strategies

Abstract: When it comes to making changes to your production Analysis Services databases, do you simply open the SSAS DB in SQL Server Data Tools (or BIDS) and click through creating the changes? Does this method lead to problems keeping everything in sync and the right changes deployed to the right environment at the right time? Have you, the BI developer, had to fight to get Production access to do your own deployments?

If you’ve answered “yes” to any of these questions, and are in search of a better way, I have the solution! In this demo-heavy session, we will look at five steps to more robust, controllable, and flexible Tabular and Multidimensional SSAS deployments.

Speaker(s):

  • Kerry Tyler

Track and Room: 08 BI Traffic Analysis - N/A


Title: Peace of Mind: Making DBCC CHECKDB Go Faster

Abstract: Along with backups, consistency checks are arguably the two most important tasks that DBAs need to perform regularly. Our databases are getting bigger every day, and CHECKDB run times, along with its performance impact to Production systems, keep increasing. In this session we discuss how to improve your system so that you can reduce the time that it takes to run CHECKDB or the individual DBCC CHECK* commands. We will cover topics like Transaction log and VLF management, tempdb configuration, trace flags, Resource Governor, and many more. In one of many the demos we will explore a real life example where SurveyMonkey’s consistency checks were taken from 7 days down to 6 hours.

Speaker(s):

  • Argenis Fernandez

Track and Room: 10 DBA Radar Detectors - N/A


Title: Statistics and Query Optimization

Abstract: There are any number of tricks and traps around getting the query optimizer to provide you with an optimal execution plan that gets you your data quickly and efficiently. But, at the end of the day, the principal driving factor of the optimizer, and therefore of your queries, are the statistics that define your data. This session teaches you how those statistics are put together and maintained by SQL Server. Different types of maintenance results in different levels of accuracy within statistics so we detail what the structures and information looks like after this maintenance. Your understanding of how the optimizer works with statistics will better enable you to understand why you’re getting the performance and types of execution plans that you are getting. Understanding enables you to write better t-sql statements and deal with performance problems such as bad parameter sniffing.

Speaker(s):

  • Grant Fritchey

Track and Room: 07 High Performance - N/A


Title: SQL 2012 Table Compression

Abstract: SQL Server 2008 has introduced Table compression to the DBA toolkit. We all know there are different kinds of compression available in SQL Server. What some may not know is the subtleties of compression. Such subtleties include that not all Page Compressed tables are entirely page compressed. This session will show you how to reach into the database and discover compression states at the page level. At the lower level, this session will also show how to determine compression settings of objects in the database. Participants will be able to use undocumented commands as well as commands such as PIVOT to derive some interesting information from the database engine.

Speaker(s):

  • Jason Brimhall

Track and Room: 03 Admin Highway - N/A


Title: Geekin’ Out on Extended Events -Deconstructing the system_health session to solve performance issues

Abstract: Extended Events are used to gather a wide range of performance information to help troubleshoot performance problems in SQL Server. The system_health session is an Extended Events session that is included by default with SQL Server. This session starts automatically when the SQL Server database engine starts, and runs without any noticeable performance effects. This presentations will take you on an in-depth tour of the data provided in the system_health event session and how to use it to troubleshoot performance issues. Cases studies from real-life examples will be used to demonstrate tips and tricks.

Speaker(s):

  • Janis Griffin

Track and Room: 07 High Performance - N/A


Title: Entity Framework: Or How I Learned to Stop Worrying and Learned to Love Developers

Abstract: Do you have applications in your environment that don’t use SQL written by a person but by the application itself? No, the system isn’t self-aware. Chances are the system is utilizing Microsoft’s Entity Framework.

Entity Framework (EF) and other object relational mapping technologies have been a boon for developers. But is Entity Framework a technology that developers should even be using? In this session, we’ll review what Entity Framework is and how it’s changed over time. We’ll also dive into how Entity Framework works and what to look for when inspecting a database generated by Entity Framework. Finally, we’ll review T-SQL generated by Entity Framework and give some tips on how to improve performance. If you’re a data professional that manages databases that are accessed through Entity Framework or would like a basic knowledge of how Entity Framework works this session is for you.

Speaker(s):

  • Richie Rump

Track and Room: 04 Code Paths - N/A


Title: Database Development Comes out of the Dark Ages

Abstract: Database development has traditionally been done using SQL Server Management Studio query window as the primary tool, when far more powerful tools are available in your toolset. This is the equivalent of writing a document using Notepad, when MS Word is available on your desktop. This session will take you through some of the basics of using SSDT, show you how to use VS2012 database projects effectively, how to utilize TFS build, test and deploy your code. I’ve had my share of bumps on the road to deploying these toolsets. At the end of this session you will have a good introduction into how to use the tools and how to avoid some common issues with legacy code you are already have in your environments.

Speaker(s):

  • miguel Cebollero

Track and Room: 04 Code Paths - N/A


Title: Best Interview Ever

Abstract: Are you looking for a career change? Good News! Technology is back on the move and companies are again hiring. I’ll cover key strategies you can use to make your face-2-face interview the best ever increasing chances for a new job and new adventure. Presented by Chris Skorlinski with a collection of tips from 20 years of interviewing new hire candidates at Microsoft. He’ll cover techniques for building your résumé and key strategies during interviews, whether via phone, Skype, or in-person, to increase your chances for a new job and a new adventure.

Speaker(s):

  • Chris Skorlinski

Track and Room: 06 Pro Racing - N/A


Title: Lightning Talks!

Abstract: System.Xml.XmlElement

Speaker(s):

  • Rob Volk

Track and Room: 06 Pro Racing - N/A


Title: Create and Load a Staging Environment from Scratch in an Hour with Biml

Abstract: Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this hour long presentation, Scott Currie (the creator of Biml) will use the free BIDSHelper add-in for BIDS and SSDT to introduce Biml and use to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Scott will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of hundreds of target table creation scripts, data load packages, data scrubbing rules, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns.

Speaker(s):

  • Scott Currie

Track and Room: 11 Express Toll Lane ETL - N/A


Title: Automate Your ETL Infrastructure with SSIS and PowerShell

Abstract: Much of your ETL process flow consists of packages that are very similar in structure, capturing data from a single source and transferring that to a single destination. Creating the individual packages can be tedious and it’s easy to miss something in the process of generating the same basic package over and again. BI Markup Language makes it easy to build new packages, and PowerShell makes creating the BIML scripts easy. In this session we’ll show you how to use PowerShell to generate dozens of SSIS packages doing similar tasks from a defined set of ETL sources.

Speaker(s):

  • Allen White

Track and Room: 11 Express Toll Lane ETL - N/A


Title: Windows Server 2012 R2 High Availability for SQL Server

Abstract: With the increasing adoption rate of virtualization, creating SQL Server clusters is now within reach of many more DBAs. What do you need to know about Windows Server 2012 (R2) virtualization and high availability to set up your first cluster? What’s needed for geo-clustering? Come learn from a Windows Server admin and (accidental) DBA who’s been building SQL Server clusters since 2000 (the year and the version!). We’ll discuss initial planning, the process and the maintenance best practices. There will be demos too, so if you want to see a multi-node SQL cluster run on a Lenovo X230 tablet, come see (it’s pretty cool!).

Speaker(s):

  • Sven Aelterman

Track and Room: 05 Availability Horsepower - N/A


Title: T-SQL: Beyond the Basics

Abstract: If you’ve been writing T-SQL code for a while, but have never delved into what happens after you submit your queries there is a whole world that you are missing. Taking the next step as a T-SQL developer requires understanding the basics of the SQL Server architecture and what it means to use a declarative language. Have you ever wondered why cursors are so slow, why query performance can be unpredictable, or how you can begin to analyze your queries more deeply? In this session we will cover what SQL Server has to do to turn your T-SQL code into the results you expect and how you can use this knowledge to make your code better.

Speaker(s):

  • Jon Boulineau

Track and Room: 04 Code Paths - N/A


Title: Data Analytics and the DBA – Using PowerView to Uncover Interesting Facts About Your SQL Servers

Abstract: DBAs do not always have time to work with some of the amazing visual data tools that are becoming common place now for analysts. In this presentation I will show how in just a few very easy steps you can learn more than the basics of PowerView, PowerPivot and Data Mining using data you are already familiar with as a DBA, your SQL Server installation data. We will analyze growth patterns in databases, witness job failures interactively across hundreds of servers, discover elevated permissions in a flash and watch a movie of your infrastructure growing and changing before your eyes.

Speaker(s):

  • Rodney Landrum

Track and Room: 01 BI Roadshow - N/A


Title: Wrangling performance with Resource Governor

Abstract: In this introductory session we’ll delve into the basics of the resource governor feature in SQL Server. We’ll look at the types of issues this feature can help resolve. We’ll then delve into various components of the feature, such as a classifier function, workload groups and resource pools. Finally we’ll bring all this together with an example implementation. From there, if time allows, we’ll look at best practices and questions to answer to ensure a successful implementation.

Speaker(s):

  • Brandon Leach

Track and Room: 10 DBA Radar Detectors - N/A


Title: DAX 101

Abstract: In this session, we will look at the new BI query language for PowerPivot and Tabular - DAX. This session will give you an introduction to Data Analysis eXpressions (DAX) and will provide you the necessary understanding to start using in your environment for data analysis. No prior experience with DAX is needed to attend this session.

Speaker(s):

  • Damu Venkatesan

Track and Room: 08 BI Traffic Analysis - N/A


Title: Squeezing Top Performance from Your Virtualized SQL Server

Abstract: Just about anyone can click through a SQL Server installation and get it working, but more than a little tuning is required to get the most performance out of your servers. Once virtualized, additional tuning can help get even more performance out of that virtual machine. David Klee (@kleegeek) will discuss valuable details for both VMware vSphere and Microsoft Hyper-V on how to tweak and tune your virtual infrastructure for business-critical virtualized SQL Servers. Tips on configuring your SQL Server installations for maximum performance when virtualized will be covered in detail.

Speaker(s):

  • David Klee

Track and Room: 03 Admin Highway - N/A


Title: The 20-Minute Tabular Model

Abstract: The Tabular model is the new kid on the block in Analysis Services 2012. Based on xVelocity, a new highly compressed in-memory technology, Tabular models promise considerable performance improvements over Multidimensional models in many scenarios. But, as is the case with any new technology, there are certain limitations of which to be aware. Join me in this introductory-level session focusing on how Tabular fits into the Microsoft BI stack, the major factors to consider when choosing between Tabular and Multidimensional technologies, and finally a live demo where we’ll build a basic Tabular model in visual studio.

Speaker(s):

  • Bill Anton

Track and Room: 02 BI HorsePower - N/A


Title: Administering Managing the Power BI Environment

Abstract: Power BI for Office 365 is Microsoft’s new self-service BI offering. Just because it emphasizes self-service doesn’t mean a system administrator isn’t an important role! In this session we will discuss the overall system components and how a Power BI site in SharePoint Online differs from an on-premises SharePoint BI site. We will walk through how to best handle setting up connectivity to data sources, when a gateway is needed, and what data refresh capabilities exist. We will also consider how and when to create OData feeds from your corporate on-premises data sources, and how those OData feeds affect Enterprise Data Search functionality.

Speaker(s):

  • Melissa Coates

Track and Room: 02 BI HorsePower - N/A


Title: Predictive Analytics for the Data Scientist and BI Pro

Abstract: The time for predictive analytics to go mainstream has finally come! Business users and BI Pros can use the Microsoft SQL Server and Microsoft Office to unleash predictive analytics and unlock hidden patterns. Join this session to learn how a data scientist can use the Excel Data Mining add-ins to perform predictive analytics with Excel data. I’ll provide also the necessary fundamentals for understanding and implementing organizational predictive models with Analysis Services.

Speaker(s):

  • Teo Lachev

Track and Room: 08 BI Traffic Analysis - N/A


Title: Automating Execution Plan Analysis

Abstract: Many SQL Server performance issues can be solved with the information from the DMVs, even if it is collected only after the occurrence. But why was it fine yesterday and a problem today? On modern server systems, problems may be infrequent, but they do still occur. And so we may have neglected to collect data on a routine basis. It is important to collect sufficient information to diagnose and a resolve a problem. Too many third party tools to stop after identifying a problem on the presumption that the DBA’s responsibility ends with passing this information to someone else. I have automated the collection and partial analysis of index usage, query execution statistics and executions plans in my tool ExecStats.

Speaker(s):

  • Joe Chang

Track and Room: 07 High Performance - N/A


Title: Microsoft Azure SQL Database

Abstract: SQL Database is part of the Microsoft Azure platform. The SQL Database component provides the relational database functionality of SQL Server, but it also provides functionality as a cloud-computing service, hosted in Microsoft data-centers around the globe. We will go over how it works and what it has to offer, as well as some of the differences and limitations.

***It is assumed that you have familiarity with SQL Server.

Speaker(s):

  • Ryan Duclos

Track and Room: 09 Spaghetti Junction - N/A


Title: Database Design Fundamentals

Abstract: In this session I will give an overview of how to design a database, including the common normal forms and why they should matter to you if you are creating or modifying SQL Server databases. Data should be easy to work with in SQL Server if the database has been organized as close as possible to the standards of normalization that have been proven for many years. Many common T-SQL programming “difficulties” are the result of struggling against the way data should be structured and can be avoided by applying the basic normalization techniques and are obvious things that you find yourself struggling with time and again (i.e. using the SUBSTRING function in a WHERE clause meaning you can’t use an index efficiently).

Speaker(s):

  • Louis Davidson

Track and Room: 06 Pro Racing - N/A


Title: T-SQL Window Function Performance

Abstract: Window functions were first introduced with SQL Server 2005 and enhanced with SQL Server 2012. They enable easy development and great performance…well, sometimes. Learn what you need to know to take full advantage of these features. What you don’t know can hurt you when you are using window functions.

Speaker(s):

  • Kathi Kellenberger

Track and Room: 09 Spaghetti Junction - N/A


Title: SSIS 2012: More Than Just a Pretty UI

Abstract: SQL Server Integration Services (SSIS) 2012 added rounded corners and Undo/Redo to the designer, but what else was added to make this worth the upgrade? In this session there will be as many demos of the new features as we can get through! Along with the rounded corners, you will also see the changes to deployment, SSIS catalog database, metadata/XML updates, Parameters, logging updates, Data Taps, ODBC support, script debugging, PowerShell interface and many others. If you haven’t seen what has been updated in SSIS 2012, this will be the session to cover the most!

Speaker(s):

  • Steve Wake

Track and Room: 11 Express Toll Lane ETL - N/A


Title: Merging Excel files from SharePoint for Analysis in Tableau with the BI Stack

Abstract: Leveraging the Microsoft BI stack to grab multiple Excel files from SharePoint folders, merge them together, and ultimately bring them into Tableau Desktop for additional analysis. The solution will help with the common problem when different regions of a company are submitting different versions of the same Excel document/report which need to be combined and analyzed as a whole. Rather than downloading and manually merging dozens of documents, this solution will detail the automated process for making this happen.

Speaker(s):

  • Nelson Davis

Track and Room: 08 BI Traffic Analysis - N/A


Title: SQL Server’s In Memory Database Objects

Abstract: SQL Server 14 is continuing to expand on the in memory database features that were first introduced in SQL Server 2012. During this session we will explore the new in memory database tables which were developed under the code name project hekaton. During this presentation the scope of the feature will be discussed as well as reviewing the use cases and best practices for using in memory database tables and when the in memory database tables shouldn’t be used.

Speaker(s):

  • Denny Cherry

Track and Room: 09 Spaghetti Junction - N/A


Title: Ask The Experts!

Abstract: Ask The Experts is an open clinic/lounge area, where you can ask questions of our participating Experts and get answers to your most vexing problems. The clinic will be open throughout the day, and we will be awarding prizes for your toughest questions, so bring ‘em on!

Speaker(s):

  • Rob Volk

Track and Room: Ask The Experts! - N/A


Title: Column Level Encryption

Abstract: This session will introduce column level encryption using t-sql. We will discuss the introduction of cryptographic services in SQL Server and how this enables native encryption as well as real life scenarios and uses of column level encryption.

Speaker(s):

  • David Dye

Track and Room: 03 Admin Highway - N/A


Title: Independent Contracting 101

Abstract: WARNING: Do not quit your job after this presentation. Have you ever thought about becoming an Independent Contractor? Would you like to transition from Full Time Employment to Consulting? Do you want to know how to get started? If so, then this lively session is for you. The session will cover the basics of running a consulting business and a selling yourself as a Technical Resource. We will conclude with an open discussion about the business side of technology.

Speaker(s):

  • Michael French

Track and Room: 06 Pro Racing - N/A


Title: AlwaysOn Availability Groups Troubleshooting and Common Issues

Abstract: Do Availability Groups sound like a perfect fit for your High Availability and Disaster Recovery needs, but there is the initial fear of a new technology? As the primary support of your organization’s databases and surrounding technology, you need to have the troubleshooting knowledge for those reactive scenarios when data availability is on the line. Join a Microsoft SQL Server Premier Field Engineer as he dives into his troubleshooting methodology, as well as showing you common pitfalls that he has dealt with out in the wild. Walk out of this session with the tools and confidence to support AlwaysOn Availability Groups.

Speaker(s):

  • Thomas Stringer

Track and Room: 05 Availability Horsepower - N/A


Title: Managing a Technical Team: Lessons Learned

Abstract: I got promoted to management a couple of years ago, and despite what I previously believed, there were no fluffy pillows and bottles of champagne awaiting me. My team liked me, but they didn’t exactly stoop and bow when I entered the room. I’ve spent the last year relearning everything I thought I knew about management, and what it means to be a manager of a technical team. This session is intended for new managers, especially if you’ve come from a database (or other technical) background.

Speaker(s):

  • Stuart Ainsworth

Track and Room: 06 Pro Racing - N/A


Title: Using recursive Common Table Expressions (CTE)

Abstract: In this session we will look at real world experiences using recursive CTEs. Starting with the basics of putting together CTEs, adding recursion, using more complex queries and then using the queries to calculate n-level of financial balances. Additionally we will look at going from parent-child and child-parent

Speaker(s):

  • Ken Colson

Track and Room: 04 Code Paths - N/A


Title: DataViz You Thought You Couldn’t Do with SSRS

Abstract: Despite SQL Server Reporting Services (SSRS) being a very flexible and adaptable tool when it comes to visualization techniques, very few venture beyond its ready-made charts. Most of the time, all it takes to build a chart considered “outside the scope” of SSRS is a bit of lateral thinking. Sometimes, we need to go a little further and use custom code. Join this session as we bust popular myths around “impossible in SSRS” visualizations and construct them live in SSRS!

Speaker(s):

  • Jason Thomas

Track and Room: 02 BI HorsePower - N/A


Title: Implementing Auditing in SQL Server 2012

Abstract: SQL Audit provides the ability to track and log activities and changes at the instance or database level built upon Extended Events SQL Audit provides both synchronous and asynchronous capabilities. The granularity of events that can be monitored and tracked with SQL Audit can only be matched by means of using a SQL Profiler trace, but provides reduced overhead. This presentation will provide insight into the internals of SQL Audit, along with how to plan, create, and monitor instance and database level audits.

Speaker(s):

  • David Dye

Track and Room: 03 Admin Highway - N/A


Title: 45 min to build your first SSRS report

Abstract: Does this sound like you? You were just given access to SSRS and you want to make a report. Or, you’re a DBA and could use a daily report. Either way, I’ve got your back! You will learn everything you need to know to get that first report out the door quickly and how to tweak it once it’s deployed. We’ll even look at the differences between building a report in BIDS (Business Intelligence Development Studio) and Report Builder 3.0. We’ll use SSRS (SQL Server Reporting Services) 2012. The query makes no difference, this time it’s all about the output.

Speaker(s):

  • Tamera Clark

Track and Room: 01 BI Roadshow - N/A


Title: Using SSDT (SQL Server Data Tools) to Manage Database Lifecycle

Abstract: This session will concentrate on features of SSDT as it pertains to creating and updating data structure while incorporating your databases into source control management as well as full application lifecycle management. Discussion will include structure management, seeded data management and deployment. Build integration features will also be part of the talk.

Learning objectives

  1. Core features of SSDT
  2. Source control and artifacts creation
  3. Refactoring and build integration

Speaker(s):

  • Sergey Barskiy

Track and Room: 04 Code Paths - N/A


Title: It is TEMPDB, Why Should You Care?

Abstract: TEMPDB is just for temporary data right? It is installed by default and gets recreated it time SQL is restarted so what does it matter right? WRONG. This session will give you great insight into what uses TEMPDB, why TEMPDB is important, what are some best practices for configuring TEMPDB, and how to determine if you have contention. If you have systems where TEMPDB hasn’t been touched since the install, you need to attend this session.

Speaker(s):

  • Tim Radney

Track and Room: 10 DBA Radar Detectors - N/A


Title: READY FOR PROD

Abstract: As a DBA, my personal least favorite part of the development lifecycle is pushing changes to production. It means adding something unknown (no matter how well tested) to an environment that is considered stable and reliable. Plus there are other things that myself (and I’m sure developers as well) would rather be doing.

In READY FOR PROD (caps for emphasis), we will explore how I believe pushing T-SQL script, SSRS reports, and SSIS packages to production should go, and I encourage those in the audience to participate so we can get an idea of how other environments push code as easily or painfully as possible.

Speaker(s):

  • Robert Verell

Track and Room: 10 DBA Radar Detectors - N/A


Title: What’s Simple About SIMPLE Recovery?

Abstract: There is a common misconception that SIMPLE Recovery means no logging, and this is a very dangerous myth to propagate. SQL Server does log database changes in SIMPLE Recovery, but some (not all) operations are minimally logged. In this presentation, I’ll tell you what minimal logging means in conjunction with each of the three different recovery models. In addition, I’ll describe the benefits and dangers of the SIMPLE Recovery Model.

Speaker(s):

  • Kalen Delaney

Track and Room: 10 DBA Radar Detectors - N/A


Title: Maintenance and Backups: Intro to Ola Hallengren

Abstract: This session will provide an overview of the critically acclaimed SQL Server Maintenance Solution written and maintained by Ola Hallengren. If you’re using Maintenance plans, you’re started in the right direction, but Ola’s solution is the Gold Standard for Maintenance scripts. We will review the options and show you how these scripts can leave you more at ease with your backup, database and index maintenance duties.

Speaker(s):

  • Jason Carter

Track and Room: 03 Admin Highway - N/A


Title: Data Visualization Using Excel

Abstract: In this session, we will explore how powerful Excel has become as a Data Visualization tool. Using Analysis Services as a data source, we will create dashboards, report books, and some slick custom reports that you may have never imagined possible in Excel.

Speaker(s):

  • Justin Stephens

Track and Room: 02 BI HorsePower - N/A


Title: Troubleshooting SQL Server with SysInternals Tools

Abstract: In this demo-packed session we will explore the use of SysInternals tools like Process Monitor, Process Explorer, and many others to troubleshoot various problem scenarios with SQL Server. This session is not for the faint of heart and is tailored toward those adventurous DBAs who often like to step out of their comfort zone. A fair knowledge of Windows OS internals is recommended.

Speaker(s):

  • Argenis Fernandez

Track and Room: 09 Spaghetti Junction - N/A


Title: Tips Tricks for dynamic SSRS Reports

Abstract: In this session we will explore the multitude of ways that you can make your reports adapt to the needs of your users. This will include defining formats based on the data contents. We will explore how to refine layouts based on the data to be delivered. We will demonstrate how to create a parameter driven data source. We will take a look at how creating templates can give your catalog of reports a more professional look. All of this together will empower you to have more control over the reports you create.

Speaker(s):

  • Pam Shaw

Track and Room: 01 BI Roadshow - N/A


Title: High Availability with Windows Server 2012 R2 and SQL Server 2014

Abstract: This lecture (20% slides, 80% demonstrations) takes a close look at the new features of Windows Server 2012 R2 clustering and how it affects your SQL Server availability. In addition, the new availability features of SQL Server 2014 will be reviewed. This session is geared for those new to Windows Server clustering and SQL Server AlwaysOn but will also be beneficial to those with experience looking to learn about the new high availability features in both Windows Server 2012 R2 and SQL Server 2014.

Speaker(s):

  • David Bermingham

Track and Room: 05 Availability Horsepower - N/A


Title: Crazy Things That Developers Do

Abstract: Throughout my career, I’ve seen developers do some pretty crazy things to databases (and truth be told, I’ve done some of these myself!). Come to this session to learn what we do (from opening up the database to SQL Injection attacks, how SQL can use Referential Integrity to optimze queries, and the pitfalls of using NOLOCK), why it’s bad to the database server (or your career)… and alternatives that can be used instead. Trust me… your DBA will love you for making these changes.

Speaker(s):

  • Wayne Sheffield

Track and Room: 10 DBA Radar Detectors - N/A


Title: SQL 2012 AlwaysOn Quickstart

Abstract: In this presentation I’ll explain what the new SQL 2012 AlwaysOn high availability and disaster recovery solution is all about. I’ll talk about the different levels of protection it provides through Windows Clustering, SQL Clustering, and Availability Groups. We’ll discuss how these three things come together to protect your databases. We’ll finish with a dive into availability group configuration and the new capabilities it gives us.

Speaker(s):

  • Ryan Adams

Track and Room: 05 Availability Horsepower - N/A


Title: BIML–Step by Step

Abstract: BIML–Business Intelligence Markup Language is your key to faster development of SSIS Packages. This session will guide you through an introduction to BIML. We’ll explore the capabilities of BIML and BIMLScript, available through the free Codeplex BIDSHelper download. We’ll move through basic syntax of plain BIML, and progress to BIMLScript, which enables exponentially faster development of SSIS packages.

Speaker(s):

  • Julie Smith

Track and Room: 01 BI Roadshow - N/A


Title: Quiz Bowl! - Room 223

Abstract: Think you know SQL Server? Test your knowledge with (and against) our Experts! Quiz Bowl will consist of several 2 person teams, one attendee and one Expert. Teams will compete for a very nice prize. Please visit our Ask The Experts clinic before lunch and ask a challenging question! You can receive one of a limited number of tickets to participate in Quiz Bowl. Please note that Quiz Bowl is being held in Room 223 during the lunch break. Additional prizes may be awarded at the end of the day for ticket holders who were not selected to compete.

Speaker(s):

  • Rob Volk

Track and Room: Ask The Experts! - N/A


Title: 15 Quick Tips for SSIS Performance

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

Track and Room: 11 Express Toll Lane ETL - N/A


Title: ETL Architecture Chekup: Avoiding Costly Mistakes

Abstract: In this session, we will review a list of costly mistakes we make when designing and building ETL and data integration processes, and provide with actionable recommendations to avoid them. You will get a check-list you can use in your projects to ensure the ETL processes include the capabilities a solid data integration sub-system should have and you will be better prepared to assess the robustness and reliability of ETL solutions.

Speaker(s):

  • Rafael Salas

Track and Room: 11 Express Toll Lane ETL - N/A


Title: Fundamentals of MDX

Abstract: Cubes and Excel go together like peanut butter and jelly. However, some questions cannot be answered by browsing a cube. Multidimensional Expressions, or MDX, unlock the full potential of your multidimensional data. Learning MDX requires a clear understanding of some fundamental concepts. Change your mental model, and advance past the MDX learning curve.

Speaker(s):

  • Lance England

Track and Room: 08 BI Traffic Analysis - N/A


Title: The Spy Who Loathed Me - An Intro to SQL Security

Abstract: You have lots of data you have painstakingly collected over the years. How do you ensure that data is protected from hackers, spies and other ne’er-do-wells? Understanding the vast array of security features available in SQL Server is the first step in helping you determine what actions you need to take now to protect your data.

Speaker(s):

  • Chris Bell

Track and Room: 03 Admin Highway - N/A


Title: Indexing strategies and good physical designs for performance tuning

Abstract: Multiple index strategies to help improve database performance, Part of the topics covered in this session are:

  • Noncluster Coverage
  • Page Split
  • Heaps
  • Filtered Indexes
  • Clustered Indexes

Speaker(s):

  • Kenneth Urena

Track and Room: 07 High Performance - N/A


Title: Judge, Jury, and Executioner–A First Look At Execution Plans

Abstract: When a query is run against a database, a plan is formed to do the work. This session will serve as an introduction on how to read and interpret execution plans. We will also take a look at the execution plan that won the ‘Hairy’ Execution Plan contest on SQLCruise Miami in 2013! Take a peek at http://sqlcruise.com/winner-of-the-2013-caribbean-landlubber-sql-sentry-hairy-execution-plan/

Speaker(s):

  • Carlos L Chacon

Track and Room: 07 High Performance - N/A


Title: BI Expert Panel - Part 2

Abstract: In the second of this 2-part Expert Panel discussion, learn to apply best practices in design to build and deliver a successful BI solution in your organization. BI solution experts and SolidQ Mentors Rushabh Mehta, Mark Tabladillo and Paul Turley will help you define an end-to-end BI solution including data sourcing security, data quality controls, ETL, dimensional design, semantic modeling, interactive dashboards, reports and mobile BI delivery.

Speaker(s):

  • Paul Turley

Track and Room: 01 BI Roadshow - N/A


Title: “So you have a performance issue. What now?”

Abstract: You’re a new DBA, want to be a DBA or you’ve been declared an “Accidental DBA” and the phone rings. Someone tells you that they believe SQL Server is having a performance issue, what now? Their query or stored procedure took a very long time to run. Can you help them? Do you even know where to begin to help them? Most sessions I’ve attended on performance tuning seem to start in the middle. They take the approach that the audience has some understanding on how or where to start. In this session we’ll cover how to handle performance tuning from the very beginning, when the user says “The database is slow”.

Speaker(s):

  • Ed Watson

Track and Room: 07 High Performance - N/A


Title: SQL Server 2014 New Features

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

Track and Room: 09 Spaghetti Junction - N/A


Title: Power Power Query Query With Julie Smith and Rob Volk.

Abstract: Excel-erate All The Data! Power Query finishes the Microsoft Self Service (read: inside Excel) BI Stack by providing Extract-Transform-Load capabilities Come and watch Julie and Rob demonstrate this fun and useful new tool.

Speaker(s):

  • Julie Smith

Track and Room: 02 BI HorsePower - N/A


Title: Introduction to Power BI

Abstract: Power BI for Office 365 delivers a compelling set of Self-Service BI tools and services for the discovery, analysis, and visualization of on-premises and cloud-based data. In this session I will introduce Power BI, with a focus on self-service information management (SSIM) and data stewardship. You’ll leave with a solid understanding of the capabilities of the Power BI platform, how it can empower business users and data experts within an organization, and how to get started right away.

Speaker(s):

  • Patrick LeBlanc

Track and Room: 02 BI HorsePower - N/A


Title: Navigating the Options for Data Redundancy

Abstract: SQL Server has so many options for data redundancy, how do you know when you should use replication, or log shipping or AlwaysOn, etc? We will use real world examples where data redundancy is needed and discuss which is the appropriate technology and why. This is more than just a high availability vs disaster recovery discussion. If you have ever been confused or overwhelmed by all of the options, they will be broken down and made clear in this session.

Speaker(s):

  • Wendy Pastrick

Track and Room: 05 Availability Horsepower - N/A


Title: GIS Data and Solving the Shortest Path

Abstract: GIS data is used everywhere for many reasons. We are all used to digitally navigating maps on our computer or device. How can we use Sql Server and a network (map) to solve some of those same problems without leaving the server’s process? Then, once you have solved a network for one business case, what other problems can you solve with the same algorithm but in a different business domain and using a different network?

Speaker(s):

  • Dan Holmes

Track and Room: 09 Spaghetti Junction - N/A


Title: Bad, less Bad, not Bad; rewriting bad SQL Code

Abstract: This session porvodes case studied in rewritign bad SQL, with a lot of discussion on what makes sql code “bad”

Speaker(s):

  • Jeffrey Garbus

Track and Room: 04 Code Paths - N/A


Title: SQL Server 2012 Always On - The Good, the Bad and the Ugly

Abstract: Our SQL Server 2012 Always On system with 12 months in production and an 8TB data, you can learn from our experiances, the Good (yes, there are some really cool features), the Bad (not really bad, but features you need to know about) and the Ugly (outagess, causes and resolutions). The session will cover the new SQL Server 2012 Always on functionality and provide hands on examples to features along with a review of how we used SQL Server Always on in a VLDB environment.

Speaker(s):

  • Eric Peterson

Track and Room: 05 Availability Horsepower - N/A


Title: BI Expert Panel - Part 1

Abstract: Join a panel of Business Intelligence experts from SolidQ and learn the best practices for planning and delivering successful BI solutions. Join Rushabh Mehta, Mark Tabladillo and Paul Turley to discuss how to bring BI to your organization, avoid common pitfalls, apply proven design patterns and learn from deployments in companies around the world. Bring your hard questions and be prepared for an interactive discussion.In this first of two sessions, learn how to wrangle requirements from the business, plan, prototype, design your solution.

Speaker(s):

  • Paul Turley

Track and Room: 01 BI Roadshow - 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.

Patrick LeBlanc

Twitter: - patrickdba

LinkedIn: Patrick LeBlanc

Contact: http://patrickdleblanc.com

Patrick LeBlanc is a currently a Principal Program Manager at Microsoft and a contributing partner to Guy in a Cube. Along with his 15+ years’ experience in IT he holds a Masters of Science degree from Louisiana State University. He is the author and co-author of five SQL Server books. Prior to joining Microsoft he was awarded Microsoft MVP award for his contributions to the community. Patrick is a regular speaker at many SQL Server Conferences and Community events.

Kalen Delaney

Twitter: - sqlqueen

Kalen Delaney is a Data Platform MVP who has worked with SQL Server for more than 32 years. She has provided performance consulting services and taught advanced courses on SQL Server to thousands of people and organizations. In addition to her courseware development, Kalen has been writing about SQL Server for decades. She is the primary author of SQL Server Internals and the Inside SQL Server series. Kalen is also one of the primary editors for the Red Gate SQL Server Stairways tutorials.

Chris Skorlinski

Chris Skorlinski has been with Microsoft for 20 years. He is a Support Escalation Engineer at the Microsoft Charlotte NC office specializing in performance tuning and troubleshooting in Replication and Windows Azure SQL Database. His MSDN blog http://blogs.msdn.com/ReplTalk/ contain Best Practices, How To, and Inside Replication tips for configuring and turning SQL Server Replication while http://blogs.msdn.com/SQLDatabaseTalk/ covers Windows Azure SQL Database topics.

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

Justin Stephens

Justin has over 16 years of experience working with the Microsoft BI Stack. He began is BI career developing ASP/ASP.NET Custom Reports using MDX Queries against Analysis Services cubes. Over the years he has gained his MCITP in Business Intelligence for SQL Server 2008 R2, MCSA for SQL Server 2012, and MCSE in Business Intelligence for SQL Server 2012/2014 certifications. He is currently working as a Senior BI Contractor. When he is not working, you will find him on the Tennis courts.

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.

David Dye

David is a Sergeant with the Cape Coral Police Department and currently works as a database administrator and developer in the Administrative Services Division. He began his career with the police department in 1990 in the patrol division and worked various assignments until being promoted to Sergeant in 1998. Based on his education and experience David was assigned to his current position in 2002 and is responsible for database administration, software integration, and development for public sa

Robert Verell

Twitter: - @sqlcowbell

LinkedIn: Robert Verell

Contact: http://sqlcowbell.com/wordpress/

Robert Verell is a SQL Server professional working in the Nashville area and has worked in healthcare, insurance, and banking. He found his passion for databases by learning SQL Server Integration Services and writing stored procedures, and eventually became a database administrator. Robert is a chapter lead for the Nashville SQL Server User’s Group, a volunteer for SQLSaturday, and was a finalist in the 2016 PASS Summit Speaker Idol competition.

Brandon Leach

Twitter: - SQLServerNerd

LinkedIn: Brandon Leach

A Microsoft Data Platform MVP, Brandon manages the DB Operations team for financial company x. With a data estate of several petabytes, he puts a high focus on performance tuning and automation. He is a frequent speaker at events like conferences and user groups.

Allen White

Twitter: - SQLRunr

LinkedIn: Allen White

Contact: http://dataperfpro.com/blog/

Allen White is a Data Platform consultant. He has been both a developer and an administrator, so he understands both perspectives towards database technology. He loves sharing his experiences and helping people learn how to use SQL Server. Allen has spent over 40 years in IT, using SQL Server since 1992, and has been awarded Microsoft’s MVP Award for the last 13 years. Allen was a PASS Director from 2016 - 2018.

miguel Cebollero

Twitter: - SQLMiguel

LinkedIn: miguel Cebollero

Miguel is a father, husband and database professional with more than 18 years of experience. He has held positions in management, database administration, development, architect and BI development. Miguel is a regular speaker at local user groups, regional SQLSaturday and the national PASS Summit conference on various database topics. He has been an avid volunteer, chapter leader, contributor for PASS and published author of Pro TSQL Programmers Guide; ApressMedia, Published 2/27/2015

Wayne Sheffield

Twitter: - @DBAWayne

LinkedIn: Wayne Sheffield

Contact: http://blog.waynesheffield.com/wayne

Wayne Sheffield, a Microsoft Certified Master in SQL Server and Microsoft Most Valuable Professional, started working with xBase databases in the late 80’s. With over 25 years in IT, he has worked with SQL Server (since 6.5 in the late 90’s) in various dev/admin roles, with an emphasis in performance tuning. He is the author of several articles at www.sqlservercentral.com, a co-author of “SQL Server T-SQL Recipes”, and enjoys sharing his knowledge by presenting at SQL events worldwide and blogging at http://blog.waynesheffield.com/wayne

Bill Anton

Twitter: - https://twitter.com/SQLbyoBI

LinkedIn: Bill Anton

Contact: http://byobi.com/blog/

Bill Anton is an expert in Analysis Services and an experienced data warehouse practitioner. In 2013, he founded Opifex Solutions, a consulting firm with deep expertise in enterprise-scale architecture, design, and performance optimization of Analysis Services and Power BI solutions. He loves eating and spends most of his free time convincing his beloved wife to adopt more golden retrievers.

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.

Jon Boulineau

Twitter: - @jboulineau

LinkedIn: Jon Boulineau

Contact: http://jonboulineau.me

Jon Boulineau works as a Data Architect and Data Engineer in Nashville, TN.

Rodney Landrum

Twitter: - @SQLBeat

Contact: https://www.simple-talk.com/blogs/author/2133-rodney-landrum/

Rodney Landrum has been architecting solutions for SQL Server for over 12 years. He has worked with and written about many SQL Server technologies, including DTS, Integration Services, Analysis Services, and Reporting Services. He has co-authored 4 books on Reporting Services. He is been a regular contributor to SQL Server magazine, sqlservercentral.com and Simple-talk.com. Rodney is also SQL Server MVP

Tim Mitchell

Twitter: - @Tim_Mitchell

LinkedIn: Tim Mitchell

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.

Richie Rump

Twitter: - @jorriss

LinkedIn: Richie Rump

Contact: http://jorriss.net

Richie Rump is a dataveloper with Brent Ozar Unlimited, where he writes code to solve data problems. He developed statisticsparser.com and sp_DataProfile, two tools that help data professionals tune SQL Server. Richie is also the co-host of the Away From The Keyboard Podcast and founded dotNet Miami, a community focused on enterprise development with .NET. He holds the Project Management Professional (PMP) and Certified Scrum Master (CSM) certifications as well as certifications in various Microsoft development technologies. He can be found on Twitter at @Jorriss or at http://jorriss.com.

Ryan Adams

Twitter: - @ryanjadams

LinkedIn: Ryan Adams

Contact: http://www.ryanjadams.com

Ryan Adams is a Senior Premier Field Engineer for Microsoft. He works directly with customers to help them realize their business potential and accelerate their digital transformation on premises and in the cloud.

Previously, Ryan was a Microsoft Data Platform MVP and spent 19 years working for a fortune 100 company. His passion is the SQL Server Engine, High Availability, and Disaster Recovery. He also served on the Board of Directors for the North Texas SQL Server User Group, was President of the PASS Performance Virtual Chapter, was a PASS Regional Mentor, and served as a Director for the PASS organization.

Melissa Coates

Twitter: - https://twitter.com/SQLChick

LinkedIn: Melissa Coates

Contact: https://www.CoatesDataStrategies/blog

Melissa Coates is a data architect with a background in data warehousing and business intelligence. Her current professional focus is enterprise-level Power BI governance, deployment, security, and administration. As the owner of Coates Data Strategies, Melissa produces training and consults to help companies strengthen and sustain their data-driven initiatives. Melissa is big supporter of the technical community, and has been a Microsoft Data Platform MVP since 2013. You can visit Melissa’s website at CoatesDataStrategies.com, which includes community resources like diagrams, blogs, and videos.

Tamera Clark

Twitter: - https://twitter.com/tameraclark

LinkedIn: Tamera Clark

Contact: http://tameraclark.com

Tamera Clark has been involved in the IT industry for greater than ten years, with experiences ranging from systems analysis/engineering to SQL Server and SSRS administration/development. She is an active member of the SQL Server community, participating in the Women in Technology Virtual Chapter, Co-leading the Nashville BI Chapter, assisting the Nashville PASS Chapter and serving as a Regional Mentor. Tamera is also the event chair of SQLSaturday Nashville.

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.

Tim Radney

Twitter: - @tradney

LinkedIn: Tim Radney

Contact: http://www.timradney.com

Tim is a Data Platform MVP and has a whole collection of Microsoft and other industry certifications. His experience includes HA/DR, virtualization, SSIS, SSRS, and performance tuning, among everything else SQL Server-related. Tim is very active and passionate in the SQL Community. He runs the Columbus GA SQL Users Group, has been a PASS Regional Mentor for a number of years, was named a PASS Outstanding Volunteer in 2012, and is a frequent speaker at user groups, SQLSaturdays and PASS Summits. Tim is one of the top ranked in karma on ask.sqlservercentral.com, answers questions as @tradney on Twitter, and blogs at http://timradney.com and SQLskills blog at http://www.SQLskills.com/blogs/tim.

Michael French

LinkedIn: Michael French

Michael French is a Senior Consultant with Pragmatic Works. He has been working with SQL Servers for 20 years . In his spare time, he supports his community by training adult volunteers with Boy Scouts and serving with his national fraternity.

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.

Jeffrey Garbus

LinkedIn: Jeffrey Garbus

Contact: http://mssqlperformance.blogspot.com/

Jeff has been consulting on and performing technical training for MS SQL Server since 1989, Version 4, on OS/2. Since then, he has worked extensively with each release of the product, specializing in performance and tuning, from concept through legacy system, on systems of all sizes, from small start-up company applications to multi-terabyte data warehouses.

In addition to hands-on consulting, he speaks at SQLSaturdays several times/year, has a youtube channel with free training, and has written 20 books on database management systems.

His latest book is “Transact SQL the Definitive Guide.”

David Bermingham

Twitter: - https://twitter.com/daveberm

LinkedIn: David Bermingham

Contact: http://clusteringformeremortals.com/

David Bermingham is recognized within the community as a high availability expert and has been honored by his peers by being elected to be a MVP in Clustering since 2010 and most recently has been recognized as a Cloud and Datacenter MVP. David’s work as technical evangelist at SIOS has him focused on evangelizing Microsoft high availability and disaster recovery solutions for both on premise and cloud deployments. He lives in New Jersey with his wife and three kids where he a school board member, scout leader and musical director of an 8-piece jazz band, M-Town.

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.

Stuart Ainsworth

Twitter: - @codegumbo

LinkedIn: Stuart Ainsworth

Contact: http://codegumbo.com

Stuart Ainsworth (MA, MEd) manages a team of Service Reliability Engineers for the Gladiator Enterprise Information Security Services section of Profitstars, a division of Jack Henry and Associates. He’s a former DBA, developer, consultant, and public speaking professor. He’s one of the chapter leaders for AtlantaMDF, and a long-time organizer of SQLSaturday’s. He tweets infrequently (@codegumbo) and blogs even less often at http://codegumbo.com.

Rafael Salas

Twitter: - @RafSalas

Contact: http://www.rafael-salas.com

Rafael Salas is a recognized speaker and published author with more than 17 years of experience in business intelligence and information architecture. He is the recipient of multiple industry recognition, including the Microsoft MVP Award and The Data Warehouse Institute Best Practices Award. Rafael is also an active member of the SQL Server technical community and blogs regularly at www.rafael-salas.com.

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.

Ed Watson

Twitter: - http://twitter.com/SQLGator

LinkedIn: Ed Watson

Contact: http://sqlgator.com

Ed Watson is a Principal Data Platform Consultant for Improving Enterprises, a full-stack Microsoft consulting firm in Atlanta. Ed is a Microsoft Data Platform MVP since 2014 and like most children, Ed was born at an early age. Today, Ed specializes in the Business Intelligence stack and enjoys specializing in Power BI immensely. He currently lives in Atlanta and is active with the Atlanta MDF and Atlanta BI user groups and is an organizer for SQLSaturday Atlanta, Atlanta BI, and Pensacola.

Sven Aelterman

Twitter: - @svenaelterman

LinkedIn: Sven Aelterman

Contact: https://svenaelterman.wordpress.com

Sven Aelterman is the Director of IT for the Sorrell College of Business at Troy University; a role with a global scope. He is also a lecturer in Information Systems and teaches courses in data warehousing and information security. He continues consulting work through Adduxis, where he assists customers with various Microsoft technology implementations. Co-author of The Art of SQL Server FILESTREAM, published by Red Gate; and SQL Server 2017 Administration Inside Out, published by Microsoft Press. Cloud Software Architect at Sorrell Solutions, L.L.C. developing a Microsoft Azure-hosted Electronic Health Record system.

Wendy Pastrick

Twitter: - @wendy_dance

Contact: http://wendyverse.blogspot.com

Wendy Pastrick is from Chicago, IL, and for the past 15 years has served as a Database Administrator supporting both development and production environments. Her many years of involvement with PASS include WIT Virtual Chapter and the Chicago Suburban User Group, serving as Regional Mentor, and as a PASS Board member since 2013. Wendy has organized several highly successful SQLSaturday events in Chicago.

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.

Ryan Duclos

Contact: http://about.me/rduclos

Ryan Duclos is a Lead Technical Consultant for Perficient, Inc. (PRFT), where he is passionate about Microsoft development utilizing the .Net Framework, SQL Server, and Windows Azure technologies. He lives and works in LA (Lower Alabama!) and loves spending time with his family, as well as being a community influencer for Microsoft. Ryan recently became a Microsoft Azure MVP.

Lance England

Twitter: - lanceengland

LinkedIn: Lance England

Contact: http://lance-england.com

Lance England is a data professional focused on data, analysis, integration, and automation using SQL Server, Power BI, DAX, SQL Server Analysis Server, BizTalk, PowerShell, C#, and more. He has industry experience in health care, manufacturing, property rental, and non-profit sectors.

Carlos L Chacon

Twitter: - @CarlosLChacon

LinkedIn: Carlos L Chacon

Contact: http://sqldatapartners.com/blog

Carlos Chacon is the managing partner of SQL Data Partners LLC and co-host of the popular SQL Data Partners Podcast. While getting his start as a typical accidental DBA, Carlos has sat on Microsoft exam review panels, served as regional mentor and chapter leader. He enjoys traveling and has been to four continents, speaks Spanish and can eat his weight in raspberries (not yet proven). He and his family live in Richmond, Virginia.

Louis Davidson

Twitter: - drsql

LinkedIn: Louis Davidson

Contact: https://www.red-gate.com/simple-talk/author/louis-davidson/

Louis Davidson has worked in the IT industry for over 25 years as a corporate database developer and architect. He has been a Microsoft SQL Server MVP for 15 years and has written five books on database design, and contributed to many other SQL Server books as an author and tech editor. He has a bachelor’s degree in Computer Science from the University of Tennessee at Chattanooga. You can read more about Louis at http://drsql.org.

Pam Shaw

Twitter: - @PamShaw

LinkedIn: Pam Shaw

Contact: http://sqlpam.wordpress.com/

Pam Shaw has been in IT for over 30 years. Since 2001, Pam has been working with SQL Server, first 2000, then 2005, 2008, 2008 R2, 2012 and now 2014. Pam currently works as a BI Developer as an independent contractor. Pam is also the Chapter Leader of the Hillsborough SQL Users Group PASS chapter and organizer of SQLSaturday Tampa.

Chris Bell

Twitter: - @cbelldba

LinkedIn: Chris Bell

Contact: https://www.wateroxconsulting.com/

Chris Bell offers a unique view of how we live and work with data, both now and as we head into the future. Having braved many roles, lifecycles, and battles in the IT world, he has honed his DBA (Database Administration or Do ‘Bout Anything) skills in Information Systems and development, focusing on SQL Server. Currently, he serves as the lead DBA at The Motley Fool. You can keep up with Chris’ thoughts and technical community activities at WaterOxConsulting.com.

Jason Carter

Twitter: - TampaDBA

Contact: http://jason-carter.net

Jason#39;s past has included being a developer, a development manager, accidental DBA, and now a full-time DBA. Having worked with VLDBs as a developer, he found great interest in tuning, tweaking, and making things run faster. With the support of his wife, he gave up his managerial duties and jumped the Development ship and dove head first into his new career as a Database Administrator

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.

Julie Smith

Twitter: - @juliechix

LinkedIn: Julie Smith

Contact: http://datachix.com

Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer–but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.

Dan Holmes

Twitter: - @dnhlms

LinkedIn: Dan Holmes

Contact: http://sql.dnhlms.com

Dan Holmes has been developing in Microsoft technologies for 20 years using BASIC, VB, C#, c, and SQL Server from version 7 onwards.

He worked as a developer building a warehouse management system as well as custom programming. His current position at RouteMatch software is as the Director of Database Technologies.

He has spoken at SQLSaturdays in Atlanta on topics that range from dynamic object creation, GIS solutions and other out-of-the-box ideas.

He is a recent graduate of GA Tech with his Masters in Computer Science.

Teo Lachev

Twitter: - https://twitter.com/tlachev

LinkedIn: Teo Lachev

Contact: http://prologika.com/cs/blogs

Teo Lachev is an internationally-recognized authority on Data Analytics. Through his Atlanta-based company Prologika, a Microsoft Gold Partner in Data Analytics, he helps organizations make sense of their most valuable asset: their data. His strategy formulation, trusted advisory and mentoring, design and implementation services empower clients to apply effectively data analytics in order to understand, improve, and transform their business processes.

Teo has authored and co-authored several bestselling books on organizational and self-service data analytics, and he has been leading the Atlanta Microsoft BI and Power BI group since he founded it in 2010. Teo has been a Microsoft Most Valued Professional (MVP) Data Platform since 2010.

Thomas Stringer

Contact: http://blogs.msdn.com/b/sql_pfe_blog/

Thomas Stringer is a SQL Server Premier Field Engineer at Microsoft, and specializes in High Availability, Disaster Recovery, performance, administration, development (C/C++ and .NET/C#), scripting (PowerShell), and other aspects of data.

Jason Thomas

Twitter: - @SqlJason

LinkedIn: Jason Thomas

Contact: http://www.SqlJason.com

Jason Thomas is a Microsoft Certified SQL Server professional with over 10 years of Microsoft BI experience. He is a BI Consultant for BlueGranite, based in Charlotte, NC. When he#39;s not at work, Jason likes sharing his time between the MSDN forums (for which he was recognized with the Microsoft Community Contributor award), blogging about MSBI (www.SqlJason.com), speaking at SQL Server events, and watching movies with his wife (not necessarily in that order).

Argenis Fernandez

Twitter: - DBArgenis

LinkedIn: Argenis Fernandez

Contact: http://blog.purestorage.com/author/argenisfernandez/

Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.

Argenis Fernandez

Twitter: - DBArgenis

LinkedIn: Argenis Fernandez

Contact: http://blog.purestorage.com/author/argenisfernandez/

Argenis is a Principal Architect at Pure Storage. He works with customers around the world to make sure they don’t have to worry much about their infrastructure for Data. He is a former Data Platform MVP, former VMware vExpert, Microsoft Certified Master, and more recently worked in the Microsoft Azure Data/SQL Server engineering team as a Principal PM in the Tiger team.

Damu Venkatesan

Twitter: - @vdamu

LinkedIn: Damu Venkatesan

Damu Venkatesan is a Business Intelligence Consultant with over 25 years of IT experience including architecting and implementing BI/DW solutions using Microsoft SQL Server, PDW, SSIS, SSAS, SSRS, and Power BI. He has been speaking at many SQLSaturdays and user groups on data analytics and is actively involved in the Atlanta SQL community for several years. He has successfully delivered several BI/DW solutions and data migrations to various clients. He is also currently serving as President of DAMA Georgia chapter in Atlanta. He is the co-organizer of BI SQLSaturday in Atlanta.

Joe Chang

Contact: http://sqlblog.com/blogs/joe_chang/default.aspx

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.

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.

Ken Colson

Contact: https://ken-colson.squarespace.com/blog/

I am the CTO at a Nashville based start-up in the financial industry. I have worked with databases for more than 20 years, often as the database architect, chief query writer and part-time DBA. I have developed data-driven applications in various industries including finance, healthcare and higher-education.

Julie Smith

Twitter: - @juliechix

LinkedIn: Julie Smith

Contact: http://datachix.com

Julie Smith is a Microsoft Data Platform MVP and a BI consultant for Innovative Architects in Atlanta, GA. She#39;s implemented increasingly complex Business Intelligence solutions for over a decade at various organizations. She#39;s also worn many other database “hats” in her career – production DBA and database developer–but data integration and BI are her true passions. Julie holds a BA from the University of South Carolina. She and Audrey Hammonds co-created The Datachix.com blog.

Sergey Barskiy

Contact: http://DotNetSpeak.com

Sergey Barskiy is an architect with Tyler Technologies. He is a Microsoft MVP. He holds the following certifications: MCPD, MCTS, MCSD for .NET, MCAD for .NET, MCDBA, MCP. He has been working with Microsoft technologies for 15 years. He is a frequent speaker at various regional and national conferences, such as VS Live, DevLink, CodeStock, and Atlanta Code Camp as well as local user groups. He is one of the organizers of Atlanta Code Camp and Atlanta Windows Apps users group.

Scott Currie

Twitter: - @scottcurrie

LinkedIn: Scott Currie

Scott Currie is the founder and CEO of Varigence, Inc. Scott has led the development at Varigence of the Business Intelligence Markup Language (Biml) and Mist IDE. Before founding Varigence, Scott worked at Microsoft for seven years on the .NET Framework, Visual Studio, the C++ compiler, various customer connection initiatives, and internal BI/DW projects.

Robert Cain

Twitter: - https://twitter.com/arcanecode

LinkedIn: Robert Cain

Contact: http://arcanecode.com

Robert C. Cain (http://arcanecode.com) is a Microsoft MVP, MCTS Certified in BI, and is the owner of Arcane Training and Consulting, LLC. He is also a course author for Plurasight, author for Red Gate’s SImple Talk website, and co-author of 4 books. A popular speaker, Robert has presented at events such as the SQL PASS Summit, TechEd, CodeStock, and numerous SQLSaturdays. Robert has over 25 years experience in the IT industry, working in a variety of fields ranging from manufacturing to telecommunications to nuclear power.

Kenneth Urena

Twitter: - @sqlcr

LinkedIn: Kenneth Urena

Contact: http://www.sqlcr.com

Kenneth Ureña is an experienced technologist with 17 years of experience, including 14 years of experience in SQL server. He has worked on versions from SQL Server 7.0 to SQL server 2016.

Kenneth has performed the role of Database Developer, Database Architect and Database Administrator, always relying on his disaster recovery and performance tuning skills.

He co-leads the Global Spanish Virtual chapter of PASS. PASS LatAm Regional Mentor, he speaks at multiple SQL Server events in both Spanish and English. Kenneth holds multiple SQL server certifications.

Grant Fritchey

Twitter: - @gfritchey

LinkedIn: Grant Fritchey

Contact: http://scarydba.com

Grant Fritchey is a Data Platform MVP with over 20 years’ experience in IT, including time spent in support and development. He has worked with SQL Server since 6.0 back in 1995. He has also developed in VB, VB.NET, C#, and Java. Grant has written books for Apress and Simple-Talk. Grant presents at conferences and user groups, large and small, all over the world. He joined Redgate Software as a product evangelist in January 2011.

Rob Volk

Twitter: - sql_r

LinkedIn: Rob Volk

Contact: http://weblogs.sqlteam.com/robv/

Rob Volk is a SQL Server DBA in the Metro Atlanta area since 2001. He also moderates and answers the forums on SQLTeam.com. While an old-time cranky DBA, he no longer considers quot;business intelligencequot; an oxymoron or quot;the cloudquot; as merely atmospheric moisture, and is delightedly dipping his toes into both of these new oceans, and loves to do things in new and and unusual ways.

Eric Peterson

Over 30 years of Professional experiance with 25 of those in database design, SQL programming, DB implementation and DB support.

Kerry Tyler

Twitter: - AirborneGeek

LinkedIn: Kerry Tyler

Contact: http://airbornegeek.com

Kerry Tyler is a SQL Server, Business Intelligence, and Azure consultant. His initial IT experience was in network engineering and Windows system administration before moving into the data realm. This infrastructure background builds a firm foundation for performance tuning and cloud infrastructure design and implementation. Kerry has full-time DBA experience in SQL Server since version 2000 and business intelligence architecture since SQL Server 2005. In addition to consulting work, he delivers presentations and training on SQL Server administration, business intelligence, and Azure data and infrastructure components.

Nelson Davis

Contact: http://thevizioneer.blogspot.com

Nelson Davis recent joined Slalom Consulting, helping the Information Management team leverage Tableau Software and data visualization best practices.

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

Denny Cherry is the owner and principal consultant for Denny Cherry Associates Consulting and has over a decade of experience working with platforms such as Microsoft Azure, Amazon AWS, Microsoft SQL Server, Hyper-V, vSphere, and Enterprise Storage solutions. Denny’s areas of technical expertise include system architecture, performance tuning, security, replication, and troubleshooting. Denny currently holds several Microsoft Certifications related to SQL Server 2000 through 2019, including being a Microsoft Certified Master, Microsoft MVP and VMware vExpert Award.

Sponsors

The following is a list of sponsors that helped fund the event:

Back to the SQLSaturday Event List

Back to the home page