SQLSaturday #480 - Nashville 2016

Event Date: 01/16/2016 00:00:00

Event Location:

Middle Tennessee State University (MTSU)
1301 East Main Street, Murfreesboro
Nashville, Tennessee

This event has completed. All data shown below is from the historical XML public data available.

Sessions
Speakers
Sponsors

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: Data Pages, Allocation Units, IAM chains… Oh My!

Abstract: Understanding how SQL Server stores your data can seem like a daunting task. In this session You’ll learn how objects such as tables and indexes are stored in a data file. We’ll also look at how these concepts tie in to your work as a DBA or developer. We’ll see these concepts in action using demos and see how we can use this knowledge to better design solutions.

We’ll start off by looking at the structure of a row and then move on the concept of a data page. From there we’ll cover a few special page types like the index allocation map and GAM and SGAM pages. Then we’ll look at index structures and talk about the differences between heaps and clustered indexes.

Speaker(s):

Brandon Leach

Track and Room: Database Administration - S279

Title: Execution Plans for Mere Mortals

Abstract: As a beginner database professional, execution plans are intimidating. In this session, I will take you through the basics of reading graphical execution plans and drill into key operators, warnings and properties.

You will understand how, why and when the execution plan will be created and saved to plan cache.

Reading the execution plan will be much less intimidating as we walk through the flow and process of a graphical execution plan.

After looking at the key operators, you will be able to analyze the operators of your execution plans, view the operator properties, and identify common performance tuning opportunities.

Finally, you will be able to capture the execution plan, save it for analysis and comparison after modifications have occurred.

Speaker(s):

Mike Lawell

Track and Room: Database Application Development - S276

Title: Flying Through the Clouds–Performance Tuning in Azure

Abstract: So between your management and Microsoft, it’s been decided that you are moving your SQL Server workloads to the cloud. Whether it’s Microsoft Azure SQL Database or running SQL Server in a VM, there are unique performance tuning challenges that are different in a cloud environment. Just like when you moved your SQL Servers from physical to virtual environments, you will learn new techniques for tuning workloads. In this session you will learn about:

• Optimizing TempDB in an Azure VM • Reducing latency between application VMs and database VMs • Right sizing Azure VMs for performance and cost • Striping I/O across devices in Azure VMs • Performance Tuning in Azure DB

You will learn about techniques that will not just improve your system performance, but save you company money, which can be easily quantified just in time for your performance review.

Speaker(s):

Joseph D’Antoni

Track and Room: Cloud Database/Application Development Deployment - S208

Title: SSAS Metadata Reporting for Cube Consumers and Developers

Abstract: You’ve made that big investment in developing several (or hundreds) of SSAS cubes. Now, how do you provide your users with information regarding cube structures, hierarchies and attributes, measures, etc.? And what if your cube developers want to know things like which attributes in a model have specific properties set (or not set)? During this session, we’ll explore a reporting solution developed to provide SSAS metadata information to cube consumers and developers alike. By using SSIS, the AMO object model, and SSRS, we’ll build a system that gathers SSAS metadata and makes that available via a set of reports to create a catalog of cubes, drill-down reports showing dimension/hierarchy/attribute information, etc.

Speaker(s):

Dave Fackler

Track and Room: BI Architecture Management - S314

Title: Mastering and Enhancing Company Data

Abstract: Getting a good 360 degree view of organizations (customers or vendors) or doing customer centric analysis is often complicated as a result of bad data/ duplicate data / inconsistent data coming from multiple systems. In addition, there are external factors like mergers and acquisitions, inter-company relationships and other nuances that may not be captured in source systems. Getting a clear picture of customer and vendor data can not only provide a clear picture for analysis of information, but also aid in critical risk management functions. In this session, you will learn about some techniques and data services from DB that you can use to clean and enhance your data.

Speaker(s):

Rushabh Mehta

Track and Room: BI Analytics Visualization - S334

Title: PowerShell for the Reluctant Administrator

Abstract: You’ve heard many people claim that PowerShell is fabulous, but you’ve never really felt the need for it. What’s all the fuss? What is PowerShell and why should you even care, much less learn it? How will this new toy make your work easier?

This session will help you understand what PowerShell is, how it integrates into the tools you know and love, and how it can help make your everyday work go faster and more smoothly. Along with the background on PowerShell, you’ll see some simple but useful tools and ideas for how you can use those tools and make your own tools too.

This session was designed for the non-PowerShell user and the new PowerShell user. It is intended to help people start to use PowerShell, and it will touch on advanced ideas but only assumes only basic scripting/coding experience like understanding a variable, a loop, etc.

Speaker(s):

Pat Phelan

Track and Room: PowerShell - S276

Title: XML Without Xanax: How to Handle XML in SQL Server

Abstract: Do you cringe whenever you have to look at an XML document? Does the very thought of XML data living in your database make you scream? Do you have a panic attack any time you have to parse XML? If you answered yes to any of these questions, then this session is for you!

We’ll start with reasons why having XML in SQL Server might be a good thing, then we’ll face our fears and turn tabular data into XML, and finally we’ll confront the true source of our anxiety by parsing XML back into tabular data using xQuery.

If you survive this session, you’ll have faced your fears about XML in SQL Server, you’ll have a solid understanding of creating XML from tabular data, and you’ll know how to use xQuery to parse XML.

Speaker(s):

Adam Belebczuk

Track and Room: Database Application Development - S213

Title: Don’t Rely on Magic - Tabular Performance Troubleshooting

Abstract: Many times you’ll hear that one of the major advantages of using the tabular model is ease of use and implementation. So that must mean that it will run like a super fast dream all the time out of the box, forever and ever right? Not exactly. There are many things to consider at the time of modeling and implementation for performance. And later if you run into trouble with reports and queries, what do you do then? In this session we’ll go through the process to troubleshoot performance of your tabular models and queries to keep things running as fast as possible. Just because tabular is easy to use doesn’t mean you have a magical black box that you can’t tune when it doesn’t run as fast as you want. In this session, we will focus on building a methodology for troubleshooting tabular performance so you can get that super fast dream machine.

Speaker(s):

Hope Foley

Track and Room: BI Architecture Management - S277

Title: Turning Requirements into a BI Prototype

Abstract: Your SQL Server system can support two types of Analysis Services models: multidimensional or tabular. But what if you’ve never implemented them and your company wants to start using BI? Are you wondering how to get started? Regardless of which type of SSAS model you want to use, the best first step is to determine what types of questions your BI solution should answer. Next, determine how to structure your data. Before you begin the physical restructuring of your data, though, you should validate your proposed design by creating a prototype that users can review with you. In this session you’ll learn how to translate the business questions to be answered by your solution into a functional prototype that can steer your development efforts in the right direction.

Speaker(s):

Stacia Varga

Track and Room: BI Architecture Management - S275

Title: Version control with GIT for the DBA

Abstract: In 2005, Linus Torvalds developed the version control system (VCS) git. Since then, it has become as platform agnostic and ubiquitous as the internet. In that same note, github, the most popular service for hosting git repositories has become so ubiquitous that Microsoft chose to host the source code for its OSS fork of the .NET framework there instead of its own codeplex.

What does this mean to a DBA? Whether or not you use SSDT, you should be storing your database schema in version control. In addition, your utility scripts certainly belong in VCS.

In my session. We’ll cover:

What is version control? How does a distributed version control system differ from traditional version control like Visual Sourcesafe, TFS, and SVN? How do I setup git for internal use in my company? How do I host public and private repositories on github. How do pull requests work? How do I fork a SVN repo to github?

We will be covering using git from both the command line and Visual Studio.

Speaker(s):

Justin Dearing

Track and Room: Other - S272

Title: Parameter Sniffing and the Query Store in SQL Server 2016

Abstract: Troubleshooting performance problem (particularly related to parameter sniffing) is one of the most challenging and most often faced situation in a DBA’s life. In SQL Server 2016, Microsoft has come up with an Interesting tool called the “Query Store”. The Query Store records everything about query compilations and execution statistics. It collects and presents detailed historic information about all queries in a simplified way and reduces the time required to diagnose and resolve issues faster, even allowing you to observe changes in query performance over time. In this presentation, I will provide an overview of the Query Store and discuss its features, benefits, and implementation

Speaker(s):

Sreeni Julakanti

Track and Room: Database Administration - S208

Title: Understanding Windows Azure High Availability Options for SQL Server

Abstract: Windows Azure provides an excellent IaaS platform for deploying SQL Server. Although Microsoft is managing the infrastructure, you still need to plan for high availability and disaster recovery. In this session, learn how to leverage Azure Fault Domains, Upgrade Domains, and Internal Load Balancers to ensure the high availability of SQL Server deployments within the Azure cloud. Learn the difference between Azure Classic and Azure Resource Manager and how both affect your SQL Server availability.

While Microsoft Azure offers SLA’s of 99.95%, you have to know what to do to make sure your SQL Server deployment qualifies. Don’t miss this session if you are moving or have moved your SQL Servers instances to Azure. This session assumes you have a basic knowledge of SQL Server AlwaysOn Failover Clustering as well as Availability Groups.

Speaker(s):

David Bermingham

Track and Room: Cloud Database/Application Development Deployment - S128

Title: Table Vars and Temp Tables – What you NEED to Know!

Abstract: Almost every SQL Developer is familiar with Table Variables and Temporary Tables. While each of these objects represents temporary storage, there are also substantial differences between them. Understanding the differences between Table Variables and Temporary Tables, and the ramifications that those differences cause, is essential to being able to properly select the appropriate object for use in your development tasks. In this code filled session, we’ll discover the differences and similarities of Temporary Tables and Table Variables, dispel some widespread myths about each, and answer the most important questions of them all, “When do I use one or the other and what are the various impacts of doing so?”

Speaker(s):

Wayne Sheffield

Track and Room: Database Application Development - S279

Title: Tame Your Unruly Data…With Constraints!

Abstract: Never given time or care, never forming good relationships, becoming bloated, corrupt and rife with indistinguishable copies, and all so horrifyingly pervasive in society. But enough about the Kardashians, what about YOUR DATA? If you want to straighten it out and prevent it from going too far in the first place, this session is for you. We will cover constraint basics (not null, check, primary key/unique, foreign keys), provide standard use cases, and address misconceptions about constraint use and performance. We will also look at triggers and application logic and why these are NOT substitutes for (but can effectively complement) good constraint usage. Attendees will enjoy learning how to keep THEIR data off the tabloid page!

Speaker(s):

Rob Volk

Track and Room: Database Application Development - S274

Title: Maintain SQL Server Performance Baseline w/PowerShell

Abstract: Maintaining a solid set of information about our servers and their performance is critical when issues arise, and often help us see a problem before it occurs. Building a baseline of performance metrics allows us to know when something is wrong and help us to track it down and fix the problem. This session will walk you through a series of PowerShell scripts you can schedule which will capture the most important data and a set of reports to show you how to use that data to keep your server running smoothly.

Speaker(s):

Allen White

Track and Room: PowerShell - S334

Title: Ten Query Tuning Techniques Every SQL Programmer Should Know

Abstract: SELECT statements have a reputation for being very easy to write, but hard to write very well. This session will take you through ten of the most problematic patterns and anti-patterns when writing queries and how to deal with them all. Loaded with live demonstrations and useful techniques, this session will teach you how to take your SQL Server queries mundane to masterful.

Goal 1: Implement a reusable Transact-SQL test harness for reliable query results. Goal 2: Learn ten patterns that kill the performance of SELECT statements and how to avoid them. Goal 3: Discover the high-impact metadata that shows how a SELECT statement behaves … or misbehaves.

Speaker(s):

Kevin Kline

Track and Room: Database Application Development - S279

Title: The Art and the Science of Designing a Mission Critical SQL Server Solution

Abstract: When asked to design a critical database system, too many people pick an HA feature and then design the solution around it. This usually results in a costly and disappointing design. This session will show you the five basic archetypes for mission critical database systems and how to select the right features from SQL Server to implement each design. Along the way you’ll hear best practices, tips, and real world advice for features like Availability Groups, clustered instances of SQL Server, as well as the history of some of the more interesting and less often used availability features. While you may not be able to revisit your current designs right away, what you learn will make you the hero of your next mission critical deployment.

Speaker(s):

Maxwell Myrick

Track and Room: Database Application Development - S334

Title: Introduction to the Power BI Desktop

Abstract: Most of us are overwhelmed with data from all the different applications that we use on a daily basis. Bringing all the data together is often a very time-consuming and sometimes a challenging process. Even further, attempting to analyze and visualize the data poses new challenges that is sometime difficult or impossible to overcome. Now with Power BI this can all be made very simple. Individuals, ranging from novice information workers to advanced IT professionals can quickly and easily transform, analyze and visualize data using a single tool, Power BI Desktop. In this course we will work through four main topics: Shaping Data, Building a Data Model, Visualizing Data and Using the Power BI Server.

Speaker(s):

Patrick LeBlanc

Track and Room: BI Analytics Visualization - S332

Title: A Quick Peek into the 4th Dimension with T-SQL

Abstract: Time. We are all cursed and blessed with it. We run out of it, often need more of it, sometimes forget it but are always keeping track of it. In this session, we will delve into the functions provided in T-SQL and Excel to demonstrate how to solve both simple and complex problems with time and dates for your reports and dashboards. Ever wondered what is so special about 01/01/1900 and what will happen on January 1, 10,000? Do you want to know how to find gaps in time between systems or forecast the future? Are you interested to know how to accurately tally hours from minutes (it may not be as easy as you thought), then this session will not be a waste of your time.

Speaker(s):

Rodney Landrum

Track and Room: Database Application Development - S274

Title: Ensure optimal database performance with Foglight Performance Investigator

Abstract: This session will provide an introduction to one of Dell Software’s Performance Monitoring and Diagnostics Solutions - Foglight Performance Investigator. You will learn about: Multidimensional SQL workload drilldowns. View dimensions of your data, including users, programs, SQL, and sessions. Historical lock analysis – Resolve SQL Server concurrency issues with historical reviews of blocking-lock scenarios built into the dimensional drilldown. Automated change tracking – Find out when changes to server, instance, database and schema environments occur. Compare utility – Efficiently identify root causes and symptoms of performance deviations in application environments. Find and analyze statement-level wait events.

Speaker(s):

David Orlandi

Track and Room: Database Administration - S126

Abstract: Social Networking and Media is all over the news today. Did you see that on Facebook? Johnny 5 said what on Twitter? Can you believe Susie moved to that company? Do any of those sound familiar? No? Never heard of Twitter or LinkedIn? Have no fear, this is the session for you! Social networking can be a very confusing and intimidating place. What makes it even worse, is when you have no clue even where to start. In this session, we will go over different facets of Social Networking and Media and how you can use them to enhance not only your personal lives but just as importantly, your professional one. For example, did you know you can get help from some of the top minds in the SQL Server profession by using the #SQLHELP hash tag for free? We will show you how! We’ll be covering that and more using Facebook, LinkedIn and Twitter.

Speaker(s):

John Morehouse

Track and Room: Professional Development - S332

Title: Perceptual Intelligence with Cortana Analytics

Abstract: Cortana Analytics is a fully managed big data and advanced analytics suite that enables you to transform your data into intelligent action. Come learn more around how you can take action by going beyond looking in the rear-view mirror to predicting what’s next. Enhance your business applications with machine intelligence to evolve from simple descriptive analytics to prescriptive recommendations. See some of the new ways to infer intent with vision, face, speech, text and sentiment analysis to customize responses and drive appropriate actions in a secure, compliant and scalable way leveraging SQL Server, Azure and Power BI. Expect to leave the discussion understanding new trends in analytics and how you can apply value to your organization.

Speaker(s):

Dan Evans

Track and Room: BI Analytics Visualization - S213

Title: Get Near Realtime ETL with Service Broker

Abstract: Most of the time you’ll see ETL being done with a tool such as SSIS, but what if you need near-realtime reporting? You need to get the updates in your OLTP database to the Data Warehouse quickly, but with minimal impact on your application. Asynchronous messaging with Service Broker makes this simple and painless. This session will walk through the basic transformations to build a Kimbal-style data warehouse from an OLTP database and demonstrate how to keep your data warehouse updated using Service Broker messages from your OLTP database.

Speaker(s):

Allen White

Track and Room: BI Architecture Management - S334

Title: Building Your Yellow Brick Road: Directing Your Path to a Successful Career

Abstract: For most of us, our career in technology was and is the result of our combined education, experience, opportunities, and luck. In this presentation we will explore approaches to creating the career we want instead of the one we stumble into.

Speaker(s):

Justin Randall

Track and Room: Professional Development - S332

Title: Top 10 Wait Types Everyone Should Know

Abstract: There are over 800 wait types in SQL Server 2014, but there are only 10 (in my experience) that are seen very often. If you can learn these 10 wait types, what causes them and their solutions, you will be ahead of the performance analysis game. The list of 10 wait types to be discussed came from over 100 consulting engagements with customers, so come find out what they are and improve your performance troubleshooting skills.

Speaker(s):

Janis Griffin

Track and Room: Database Administration - S275

Title: Overview of Security Investments in SQL Server 2016 and Azure SQL Database

Abstract: Join me for an overview of the most recent security investments for SQL Server 2016 and Azure SQL Database in the areas of encryption, data filtering and data masking. I will showcase a real-life user scenario with examples and demos of Always Encrypted, Row Level Security and Dynamic Data Masking. The demos include a real working .NET application with source code for testing. This is based on the session and demos I co-presented with Microsoft at SQL Summit 2015 so if you missed Summit or the presentation and are interested in learning what Microsoft is doing in the area of security in SQL Server 2016 and Azure SQL DB then this is the session for you.

Speaker(s):

Jamey Johnston

Track and Room: Database Application Development - S309

Title: 16 Enhancements for SQL Server 2016

Abstract: Microsoft announced SQL Server 2016 on April 1, 2015 and it is no joke! In this session we’ll examine 16 of the new enhancements that are coming in the latest version of SQL Server that is currently available in a technology preview. there are so many enhancements that I can’t cover them all in one session! So we will examine some in high level reviews and more in-depth previews such as row level security, query store, and always encrypted.

Speaker(s):

Robert Verell

Track and Room: Database Administration - S309

Title: The Benefits of Implementing SQL Server on Cisco Unified Computing System

Abstract: Join this session to learn the benefits of implementing SQL Server on Cisco Unified Compute System (UCS) for various workloads in both bare-metal and virtualized environments. We’ll begin with an overview of Cisco UCS, then discuss deployment scenarios that follow Cisco UCS best practices and recommendations to help ensure your systems are highly available and scalable and can be efficiently consolidated and centrally managed. We’ll cover benchmarks for both Cisco UCS blade and rack-mount servers as well. You’ll walk away from the session with a fundamental understanding of the hardware and software components and the configurations required for a successful SQL Server implementation on Cisco UCS.

Speaker(s):

Frank Cicalese

Track and Room: Database Administration - S272

Title: Powershell Jumpstart for SQL Server DBAs

Abstract: Powershell can be hard. As a language, it is fairly complex and provides a large array of functionality. Fortunately, you can teach yourself how to use Powershell with tools that are built right into the language. This session will cover some Powershell fundamentals, how you can use Powershell itself to learn about concepts and syntax, and techniques for using Powershell with SQL Server. We will focus on core language patterns that you can use immediately, taking the mystery out of the code and helping you start writing your own Powershell scripts. The key to learning Powershell is using it and this session will give you a launchpad to start building your own tools.

Speaker(s):

Michael Fal

Track and Room: PowerShell - S276

Title: Understanding SQL Server Backup and Restore

Abstract: Everyone knows that it’s critical to have backups but it’s amazing how few people make sure those backups can be restored properly! Too many times to count, lt;name removedgt; has been brought in by organizations to help recover failed systems where administrators simply didn’t know how to properly restore SQL Server backups when they have to. In this session, lt;name removedgt; will explain the various types of backups that can be taken and demonstrate how to restore each of them. Apart from covering the common full, differential and log backups, lt;name removedgt; will also cover partial, filegroup, and COPY_ONLY backups, backing up to and restoring from a URL, backup encryption, and how to perform a hack attach for the ultimate tail log restore. There’s something here for everyone to learn!

Speaker(s):

Tim Radney

Track and Room: Database Administration - S213

Title: Surviving Your Peak Database Load

Abstract: Each application and system is different, but all have a similar quality: there will be times where the systems are used more, and other times where they may appear to be sleeping. Good examples are monthly, quarterly, and yearly for financial systems and the holiday season for retail. The last thing you want to have in these timeframes is your CxO standing at your desk wondering why things are slow or possibly down. Ensuring that your SQL Servers are optimally configured for those heavy usage periods cannot be done with a wing and a prayer – you need an actionable, realistic plan. This session will discuss how to guarantee that your SQL Server instances and the configurations they use are as scalable and reliable as possible.

Speaker(s):

Ben DeBow

Track and Room: Database Administration - S208

Title: Using SQL Servers AlwaysOn Availability Groups

Abstract: In this session we will look at the features which are provided with Microsoft SQL Server 2012 as part of the “AlwaysOn” features including site to site configurations to allow of a large scale high availability solution without the need for any high end SAN storage solution.Additionally we will be looking at the ability to have redundant servers which can be used for reporting or for taking your backups reducing the load from the production database.

Speaker(s):

Denny Cherry

Track and Room: Database Administration - S213

Title: WIT-Diversity Panel: Parenting Daughters in an IT world Why Its Important

Abstract: Join Justin Dearing, Patrick LeBlanc, Arlene Rose and Rie Irish to discuss raising daughters as a parent involved in IT. Parenting is hard. We all know that. Parenting girls is really hard. Adding to an already complicated job, is our technology based way of thinking problem solving. The IT field isn’t very diverse, but we have the opportunity to change that in a generation: encouraging young females, calling out other biases in the field and coming up with positive solutions. Are we raising tech savvy daughters? Should we be?

Speaker(s):

Rie Irish

Track and Room: Other - S334

Title: Top Free Tools for Tuning SQL Statements

Abstract: In this demo-packed session, you’ll learn practical tips and tricks for SQL code tuning to help you with some of the most problematic and troublesome SQL coding issues. Using a variety of free community tools, you’ll learn tips and tricks you can take home and immediately apply to your SQL code. You’ll learn things like:

A little-known technique to create a tiny version of large production databases, yet deliver query execution behaviors as you would see in production.
Sneaky DBCC commands which help you replicate a full production server on your workstation, as well as how to turn on and off specific query engine optimizations.
Best practices in reading execution plans using the free tool, Plan Explorer.
A variety of T-SQL techniques, including the best way to write a cursor, a quick trick that can save you 20-30% processing times on your big stored procedures, and some weird situations where SQL Server doesn’t use cached plans when it should.

Speaker(s):

Kevin Kline

Track and Room: Database Application Development - S332

Title: Let Me Finish… Isolating Write Operations

Abstract: OLTP databases can be constantly written to and reporting databases are written to at least periodically. In order to ensure consistent results, connections must be isolated from one another while executing, ideally with the lowest possible cost to concurrency. How this isolation is handled is based on the isolation level, whether the classic lock based or the newer optimistic scheme of the in-memory OLTP engine is used, or even if both engines are enlisted in the same transaction. In this session we will look at examples of how SQL Server isolates reading and writing operations from other writing operations to explore how this may affect your application through error messages and performance hits.

Speaker(s):

Louis Davidson

Track and Room: Database Application Development - S272

Title: Data Architecture 101

Abstract: This presentation is a quick introduction for the DBA or developer who was just told that their boss promised a major new customer a scalable, well designed database. The customer will pay a lot of cash and years of ongoing business using this database… If you deliver it this week!

You’ll get a big bonus if you build this right, but you also remember what your co-workers did to the person who bungled the last database design… and wonder if that designer ever recovered! This session will introduce you to the fundamentals of Datatypes, Relational Algebra, and Normalization to help you avoid the major pitfalls and maybe get some sleep too!

NOTE: Database Architecture 101 is like Calculus 101 or Bio-Chemistry 101. This is a very basic introduction to Database Architecture, but it is not intended for the inexperienced Database Administrator.

Speaker(s):

Pat Phelan

Track and Room: Database Application Development - S276

Title: SQL Server’s In Memory Database Objects

Abstract: SQL Server 2014 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: Database Application Development - S213

Title: Show me whatcha workin’ with: Big Data Edition

Abstract: Congratulations. You’ve setup your Big Data environment with all the fun toys. You have Pig, Sqoop, and Hive all on your Hadoop cluster. You even got your data flowing in there properly. Now what? In this session we’re gonna go over Data Mining tools to help you gain some insight from your data. Then, to bring it all together, we’ll go over some easy ways to use common tools to show off all of this Big Data of yours, using tools that most have access to.

Speaker(s):

Josh Luedeman

Track and Room: Cloud Database/Application Development Deployment - S277

Title: Use Biml to Automate SSIS Design Patterns

Abstract: Perhaps you’ve heard the buzz about Business Intelligence Markup Language (Biml) and wondered, “Why is everyone so excited about Biml?” Occasionally, a new technology emerges that changes everything. For SSIS developers, Biml is one such technology. Business Intelligence Markup Language (Biml) is a powerful solution for rapidly creating SSIS packages and solutions. SSIS Design Patterns support various load profiles. Combined, Biml and SSIS Design Patterns offer a compelling solution for automating enterprise data integration.

In this session, you will learn:

How to rapidly build multiple SSIS packages using Biml
How to apply different SSIS Design Patterns using Biml
How to automate SSIS Design Patterns using Biml

Speaker(s):

Andy Leonard

Track and Room: BI Architecture Management - S309

Title: Automating Database Restores

Abstract: Beginning DBA’s think of a RESTORE as something that gets done when something goes wrong. In practice we restore all the time, perhaps most often to refresh our QA and Development environments. Doing one restore isn’t hard, but what about when you get five or ten requests a day? It’s not just the restore either, you have to alter permissions, change the recovery model, set the database owner, perhaps update synonyms or mask out sensitive data. Restores are a pattern and if we see the pattern, we can do things to make it faster and repeatable.

This presentation will show you the latest version of the system I use, one consisting of a couple of tables and a couple of Powershell scripts. I’ll start with my design goals, show you some of the compromises I made to get to a solution that handles 90% or so of the requests, and some of the options I thought about but decided against. I used Powershell, but it’s a pattern you could solve using another language, even perhaps TSQL!

Speaker(s):

Andy Warren

Track and Room: Database Application Development - S334

Title: Batches, Transactions, and Errors

Abstract: This session is an introduction into the PROCESS of queries and how this effects Batches, Transactions, and Error Handling. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses.

Speaker(s):

John Deardurff

Track and Room: Database Application Development - S275

Title: Transforming Data using the T-SQL PIVOT / UNPIVOT operators

Abstract: Ever wish your horizontal data were vertical for easier data storage, or vice-versa for reporting purposes? Are you writing elaborate routines to transform between them for one-time usage? Are your queries repeating “OUTER JOIN” or “UNION” so often that you wind up back in Kansas when your read them aloud? Join Jeff Foushee as he explains SQL Server’s lesser-known PIVOT and UNPIVOT operators using SQL 2014. After this session, you will no longer need to rotate your monitor!

Speaker(s):

Jeff Foushee

Track and Room: Database Application Development - S314

Title: Beginners SQL Server Security the Low Hanging Fruit

Abstract: Security is not for the faint of heart and this session is just the tip of the iceberg. Those new to the DBA role and of course the Accidental DBA’s can take away a few nuggets to get them started securing their SQL Servers and raising awareness to the importance of securing the data we have been sworn to protect. Let this session jump start your journey to learning why DBA’s are called the gatekeepers and increase your value in the office while getting noticed for caring enough to stop intrusions to your SQL Servers.

Speaker(s):

Lindsay Clark

Track and Room: Database Administration - S276

Title: Power BI: Data Refresh ad SSAS On-Premises Connectivity

Abstract: Join me to go under the hood with a Power BI deep dive. Where I will discuss two Hybrid Scenarios for Power BI. I will explore the data refresh capabilities, allowing reports published to Power BI to connect to varying data sources for data refresh. I will also discuss exciting new capabilities that allows Power BI to connect directly to SQL Server Analysis Services on-premises and interactively query. Allowing customers to keep and manage data on-premises without the need to move their data to the cloud.

Speaker(s):

Patrick LeBlanc

Track and Room: BI Analytics Visualization - S332

Title: Keys to Successful SharePoint Administration for the DBA

Abstract: Inherited SharePoint or being tasked to implement it? In this session we will start with the fundamentals of SharePoint and work our way to understanding what it looks like to be a successful SharePoint administrator. We will cover common SharePoint misconceptions use live demos to show frequently performed tasks - all to set you up for success day one. Lastly we will cover the training options and other resources available to make your job easier and more automated.

Speaker(s):

Daniel Glenn

Track and Room: Other - S274

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: Database Administration - S314

Title: Getting Started with MDX

Abstract: In this session, led by Microsoft BI Architect, SSAS Maestro and SQL Server MVP Bill Pearson, we will concentrate largely upon crafting simple MDX expressions and queries whose purposes, for the most part, are to return a set of data. We will overview the structure of a cube, using as a basis the sample Adventure Works cube that is available to anyone installing SQL Server Analysis Services 2012 and most previous versions. We will then outline the components of simple MDX syntax, and get started writing basic expressions and queries. We will expose basic member functions, introduce filters (or “slicers”), and begin exploring core MDX functionality, including calculated members, and named sets.

Speaker(s):

William E Pearson III

Track and Room: BI Architecture Management - S314

Title: TempDB Done Right

Abstract: Every SQL Server instance relies on the tempdb database. Whether through explicit use with #temp tables or @table variables, or implicit use through working space for many other operations, most tempdb databases get quite a workout. There are additional concerns when using Always On Availability Groups. This session will dig into many of the otherwise-hidden issues that can kill server performance. Attend this session and you will be able to spot tempdb performance issues, drill into the causes, and take the steps necessary to solve them.

Speaker(s):

Eddie Wuerch

Track and Room: Database Administration - S279

Title: Balancing Work and Home to Create a Better You

Abstract: If you are a working professional there is a chance that your career has interrupted your life and you’ve forgotten about you and/or your family. How do you create a healthy balance between the two so that you are happy and everyone else is to? In the session, you will learn how to properly manage time, erase stress, advance at work, address common marriage and family Issues, and ultimately create a better you.

Speaker(s):

Karlyn LeBlanc

Track and Room: Professional Development - S274

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: Cloud Database/Application Development Deployment - S309

Title: Database Continuous Delivery Your Salvation!

Abstract: Continuous Integration Delivery isn’t a new concept. Application Developers have been doing it for quite a while and now it’s time for Database Professionals to catch up. Whether you are a database administrator, database developer, or even an application developer, database continuous delivery can help you find your salvation. I’ll show you how to apply these concepts to areas of security, collaboration, testing, support and deployments. We will look at what continuous delivery means, demonstrate some tools that can help you easily get it into place, and dive into why it’s important.

Speaker(s):

John Morehouse

Track and Room: Database Application Development - S272

Title: Hadoop for SQL Server Pros

Abstract: What is Hadoop? Why is it getting so much attention? How will it impact my career? For many data professionals Hadoop remains a new technology that is often talked about, but rarely encountered. This demo-heavy session will demystify this high profile data platform by reviewing it’s architecture, ecosystem of open source projects, and seeing it in action.

Speaker(s):

Jon Boulineau

Track and Room: BI Architecture Management - S272

Title: Cleaning House: The Indexing Edition

Abstract: Do you design your database’s indexes? Well, have you ever analyzed how those indexes are being used, if at all? And do you know if SQL Server needs other indexes to improve performance? Attend this session and discover how SQL Server tracks actual index usage. We will use this data to identify wasteful, unused, redundant indexes. Finally, we will dive into the Missing Index DMV and learn how to make proper use of its recommendations. We will spend the second half of this session interactively working through a demo exercise, to reinforce the entire process.

Speaker(s):

Andy Yun

Track and Room: Database Administration - S274

Title: A Real, Live PowerShell Beginner’s Tutorial

Abstract: This is for the PowerShell precon. The problem I’ve seen with most PowerShell “beginner’s tutorials” is that they almost always go way beyond the basics. In this session, in which participants are expected to be utterly brand-new to the technology, we cover the true basics, focusing on only three commands: Get-Command, Get-Help, and Get-Member. I can do this in 60 or 90 minutes, although I’d prefer the latter.

Speaker(s):

Tim Warner

Track and Room: Other - S277

Title: Case Study: Improving High Availability and Disaster Recovery

Abstract: Kevin will present at the SIOS sponsored lunch session at 12:30pm. You can also enter to win a $25 Amazon gift card.

Speaker(s):

SQLSaturday Nashville

Track and Room: Other - S128

Title: Row-level Security in SSRS and SSAS

Abstract: It is relatively straight-forward to grant a user access to a particular SSRS report, multi-dimensional cube, or tabular model table, but what happens when the user needs access to the object but should be denied access to view certain rows of data? In this session we’ll investigate a real-world solution to this common BI problem.

Speaker(s):

Chris Hyde

Track and Room: BI Architecture Management - S309

Title: Looking for the Power BI on-prem alternative?

Abstract: Do you like Power BI – but your company is not ready to move to the CLOUD? In this session we will be covering the On-Prem Power BI alternative that Microsoft has endorsed: Pyramid Analytics BI Office. Do you want to allow your business users to build Tabular models on the fly, or connect to your multi-dimensional cubes - and visualize them immediately? You can do all of this and more with Pyramid Analytics’ BI Office suite. Come and hear about the recent Strategic Alliance between Microsoft and Pyramid Analytics – that brought you the Power BI on-prem alternative.

Speaker(s):

Jason Picker

Track and Room: BI Analytics Visualization - S208

Title: Encrypting Data within Sql Server

Abstract: Data breaches abound! Sql Server has several options to encrypt the data, Transparent Data Encryption, Cell Level Encryption and Sql Server 2016 Always Encrypted. Let’s review each option to hide the encrypt the data. Let’s also look at new options to hide data with Always Encrypted.

Speaker(s):

Thomas Norman

Track and Room: Database Application Development - S275

Title: Turbo-Charged Transaction Logs

Abstract: The transaction log is one of the most critical, yet often misunderstood components of SQL Server. From out of control log growth to very long start-up times, problems with the transaction log can cause a lot of pain. In this session, we’ll look at how the transaction log works and how to optimize its performance. You’ll learn how to determine the right settings for maximum throughput, and what to do when things get out of control.

Speaker(s):

David Maxwell

Track and Room: Database Administration - S279

Title: R with AzureML

Abstract: R is a free software environment for statistical computing and graphics. By far the most popular programming language for data science projects, R is used to solve problems in fields such as biology, physics, finance and marketing. With the recent acquisition of Revolution R and the increasing capabilities of AzureML, Microsoft’s attention to deliver an enterprise-ready version of the R platform has increased exponentially. Please join me to learn the foundations of R, how to begin plotting data using ggplot2 and how R is integrated in AzureML.

Speaker(s):

Jake Switzer

Track and Room: BI Analytics Visualization - S272

Title: Beginning Azure

Abstract: The cloud is here! Are you ready? Microsoft, Amazon and others are all vying for your cloud attention. In this session, we will review the different types of cloud platforms available and what they mean to you. We will pay close attention to Microsoft’s Azure platform that offers two hosting solutions. What are these hosting options and what are the differences between them? Most importantly, how do I get started with all of this cloud business? Let’s put SQL Server into the cloud!

Speaker(s):

Thomas Norman

Track and Room: Cloud Database/Application Development Deployment - S277

Title: Looking for the Power BI on-prem alternative?

Speaker(s):

Mark Scott

Track and Room: BI Analytics Visualization - S208

Title: Tame the sibling rivalry of the Lock, Block, Deadlock sisters

Abstract: Deadlocks present a problem to many DBAs. Deadlocks can be minor occurrences or major issues making SQL Server continually choose a victim like constantly quarreling siblings.

We will review locking, blocking and deadlocking. We will review isolation levels. When would be an appropriate time to use each. We will also review how to identify locks and deadlocks and how to lessen the family fighting.

Speaker(s):

William Wolf

Track and Room: Database Application Development - S277

Title: Extended Time Slot

Abstract: Extended time slot for Spotlight Sessions (90-min) listed above

Speaker(s):

SQLSaturday Nashville

Track and Room: Other - S279

Title: The Next Dimension of Data

Abstract: Send your data on a journey through space and time, while engaging your audience’s senses to tell its story. SQL Server’s geospatial datatype offers pinpoint accuracy and many advanced location-aware capabilities, such as shapes, overlaps, distances, and direction. The Power Map feature can turn your addresses and supporting figures into a movie. Turn your facts and figures into a compelling story by entering geospace: the final frontier.

Speaker(s):

Dave Mattingly

Track and Room: BI Analytics Visualization - S314

Title: Introduction to SQL Server Integration Services

Abstract: Take an introductory journey into the world of SSIS through the eyes of a SQL Server DBA as he navigates the Business Intelligence waters. This is an introductory course for beginners or users without any SSIS experience. Come learn how to SSIS with me!

Speaker(s):

Ed Watson

Track and Room: BI Architecture Management - S332

Speakers

This is a list of speakers from the XML Guidebook records. The details and URLs were valid at the time of the event.

Thomas Norman

Twitter: - ArmorDba

LinkedIn: Thomas Norman

Contact: https://armordba.com/

Tom Norman is a Database Architect at KPA with a strong fervor to protect data. He works daily to review and improve data protection methodologies while reviewing governing laws affecting finance, healthcare, and personal data. His areas of expertise include encryption, auditing, data identification, and database object deployment. He is the current leader of the PASS Virtualization Group and Vice President of the TRIPASS user group. You can read his blog at https://armordba.com/ and reach him on twitter at @armordba. Tom speaks at a number of SQLSaturday events and SQL Server user groups.

Dan Evans

Twitter: - @danthebiman

LinkedIn: Dan Evans

Dan Evans is a Data and Analytics evangelist with over 25 years’ experience deploying strategic and innovative analytic solutions. He’s focused on Microsoft technologies including Data Platform, Advanced Analytics and Business Applications. Current focuses include SQL Server, Power Suite, Cognitive Services, Artifical Inteligence and other Data Platform related topics in Azure. Dan presents at many local, regional and national events including SQL PASS, DAMA, TDWI, TechEd and Ignite and supports best practices in Microsoft data and analytics across North America.

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.

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Kevin Kline is a database and industry expert serving as Principal Program Manager at SentryOne, the industry leading SQL Server database tools vendor. A Microsoft SQL Server MVP since 2003, he is a founder and former president of PASS. Kevin is an author of many books, blogger, columnist, and popular international speaker. Kevin’s best known book is the best-selling SQL in a Nutshell and contributes monthly to Database Trends Applications magazine. He tweets at @kekline and blogs at http://Blogs.SQLSentry.com/Author/KevinKline.

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.

Thomas Norman

Twitter: - ArmorDba

LinkedIn: Thomas Norman

Contact: https://armordba.com/

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.

Justin Randall

Twitter: - jh_randall

LinkedIn: Justin Randall

Contact: http://blogs.sqlsentry.com/justinrandall

Justin Randall is a Senior Consultant at SQL Sentry, LLC. He has over 30 years of data management experience in a variety of roles from Enterprise Data Modeler to DBA, supporting development in DB2, Sybase, and SQL Server. Justin frequently speaks at SQL Server User Group meetings and SQLSaturdays, and has presented at several SQLintersection conferences. His current professional interests are SQL Server performance monitoring and tuning, and career development.

Allen White

Twitter: - SQLRunr

LinkedIn: Allen White

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

Kevin Kline

Twitter: - kekline

LinkedIn: Kevin Kline

Contact: http://blogs.sentryone.com/author/kevinkline

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Joseph D’Antoni is a Senior Consultant and Microsoft Data Platform MVP with over 20 years of experience working in both Fortune 500 and smaller firms. He is a Principal Consultant for Denny Cherry Associates and lives in Malvern, PA. He is a frequent speaker at major tech events like Microsoft Ignite, PASS Summit, and Enterprise Data World. He blogs about all topics technology at joeydantoni.com. He believes that no single platform is the answer to all technology problems. Joseph holds a BS in Computer Information Systems from Louisiana Tech University and an MBA from North Carolina State University, and is the co-author of the Microsoft book “Introducing SQL Server 2016”.

Jake Switzer

LinkedIn: Jake Switzer

Jake Switzer is a SQL/BI consultant for Microsoft. He works to deliver data analytics solutions to customers using a variety of Microsoft and Open Source software. He is interested in topics such as data science, business intelligence, and sports analytics.

Hope Foley

Twitter: - hope_foley

LinkedIn: Hope Foley

Contact: http://www.hopefoley.com

Hope Foley, a former Data Platform MVP, has worked across many industries as a DBA and Business Intelligence consultant. She joined team at Microsoft and is a Data AI Technology Solutions Professional. She has worked with enterprise customers but now focuses on education. Hope is an active member in the SQL Server and PASS communities speaking at events and organizing the SQLSaturday event in Indianapolis.

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.

Justin Dearing

Twitter: - zippy1981

LinkedIn: Justin Dearing

Contact: http://www.justaprogrammer.net

Justin Dearing has been working in IT in 2002. He started as a night shift AS/400 operator and rose through the ranks at a series of companies. He currently works as a developer in the capital markets industry.

Justin has served in both the development and production side of the house on Windows, Unix and Midrange Platforms. His database experience includes MongoDB, MySQL, Postgres and Microsoft SQL server. These days he programs in C#, PowerShell and PHP.

Jason Picker

LinkedIn: Jason Picker

Jason has over 20 years of BI experience developing datawarehouses, SSAS cubes, and end-user solutions using SQL Server Reporting Services, PerformancePoint, ProClarity and now Pyramid Analytics#39; BI Office. He has spent time as the BI Architect and Lead Developer for a major computer hardware manufacturer, a national home builder, and a regional hospital system. Jason also worked as an independent consultant and trainer on the Microsoft SQL stack. He loves to read and write MDX! Ask him to show you how to parameterize your MDX statements and queries.

Andy Leonard

Twitter: - AndyLeonard

LinkedIn: Andy Leonard

Contact: https://andyleonard.blog

Andy Leonard is founder and Chief Data Engineer at Enterprise Data Analytics, Microsoft Data Platform MVP, creator of the DILM (Data Integration Lifecycle Management) Suite, an SSIS trainer, consultant, developer, Business Intelligence Markup Language (Biml) developer and BimlHero, SQL Server database and data warehouse developer, community mentor, engineer, and farmer. He is a co-author of “The Biml Book and SQL Server Integration Services Design Patterns” and author of “Managing Geeks - A Journey of Leading by Doing”, “Data Integration Lifecycle Management with SSIS”, “Building Custom Tasks for SSIS”, and the “Stairway to Integration Services”. Andy blogs at andyleonard.blog where you can learn more on the About Andy page.

Maxwell Myrick

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

LinkedIn: Maxwell Myrick

Contact: http://sqlha.com/blog

Max Myrick is a SQL Server consultant whose experience includes 15 years at Microsoft with 5 years on the SQL Server development team where he ran the SQL Customer Lab and then the Sustained Engineering team. He was an founding member of Microsoft#39;s Mission Critical team where he worked with the largest SQL Server applications worldwide for almost a decade. Max was a regular speaker for Microsoft and has continued to speak at various PASS and other SQL Conferences since becoming a managing partner of SQLHA LLC.

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.

Dave Mattingly

Twitter: - @dave_mattingly

LinkedIn: Dave Mattingly

Contact: http://www.davemattingly.net

Dave Mattingly has spent thirty years of designing, developing, databasing, documenting, and directing a variety of projects in many industries. In the past, he’s worked on space travel, fraud prevention, data accuracy, and virtual reality for industries such as games, ecology, health, religion, and money. He also writes, publishes, orates, teaches, and preaches.

David Orlandi

David Orlandi brings over 15 years of experience in software consulting to his position as Systems Consultant with Dell Software. Dave is responsible for supporting the sales division by communicating and demonstrating the value of the Performance Monitoring suite of solutions. Prior to Dell, Dave held similar positions at Embarcadero Technologies, Toshiba, and Thomson. Dave graduated from the Whitman School of Management at Syracuse University with a bachelor’s degree in Marketing.

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

Andy Warren

Twitter: - @sqlandy

Contact: https://sqlandy.com

Andy Warren is a SQL Server consultant and trainer based in Orlando, FL. Focusing on administration, performance tuning, and SQL Server patterns and practices, he’s been a SQL Server MVP since 2008. Andy served two terms on the PASS Board of Directors, was a founding principal in SQLServerCentral, and created both the SQLSaturday and SQLRally event models.

Joseph D’Antoni

Twitter: - jdanton

LinkedIn: Joseph D’Antoni

Contact: http://joeydantoni.com

John Morehouse

Twitter: - SQLrUs

LinkedIn: John Morehouse

Contact: http://www.sqlrus.com

John Morehouse is currently a Consultant with Denny Cherry Associates living in Louisville, Kentucky. With over 2 decades of technical experience in various industries, John now focuses on the Microsoft Data platform and specializes in Microsoft SQL Server. He is honored to be a Microsoft Data Platform MVP, VMWare vExpert, Friend of Red Gate, Sentry One PAC member Community Ambassador, and 2016 Idera Ace. John has a passion around speaking, teaching technical topics, and giving back to the technical community as much as possible. He is a user group leader, SQLSaturday organizer, and former PASS regional mentor. He is also a blogger, avid tweeter, and a frequent speaker at SQLSaturday’s as well as other conferences.

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.

Sreeni Julakanti

Sreeni Julakanti is an Enterprise DBA at Humana, Inc., currently working in an Architect role while supporting over 16,000 databases on 1,500 different SQL Servers. He primarily works on troubleshooting performance Issues and fine tuning various database designs and processes. Sreeni holds an MCITP certification in SQL Server and is an active member of the Louisville SQL Users Group, participating in monthly meetings and also participates and presents topic in SQLSaturday.

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.

Frank Cicalese

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

LinkedIn: Frank Cicalese

Contact: http://www.digitalmusicproductions.com

Frank Cicalese - Technical Solutions Architect with Cisco Systems, Inc., assists customers with their design of SQL Server solutions on Cisco Unified Compute System. Before joining Cisco, Frank was with Microsoft Corporation for 10 years, excelling in several positions, including Database TSP. Frank has in-depth technical knowledge and proficiency with database design, optimization, replication, and clustering and has extensive virtualization, identity and access management and application development skills. He has established himself as an architect who can tie core infrastructure, collaboration, and application development solutions together in a way that can help companies to effectively address their business initiatives.

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.

Jamey Johnston

Twitter: - STATCowboy

LinkedIn: Jamey Johnston

Contact: http://STATCowboy.com

Jamey Johnston is a Senior Data Scientist/Engineer for a large independent OG company. For over 25 years, he has worked for Fortune 500 companies architecting successful platforms in the cloud, on the edge, and on-premises for BI reporting, statistical analysis, ML, and AI. Lately, he spends his time in Azure, Python, R, Power BI, MS SQL, and SAS JMP. He holds a BS in Spatial Analysis from LSU and a Masters of Science in Analytics from Texas AM. He is a professor at the Mays Business School at Texas AM in the MS Analytics program. He is active in his PASS Local Group in Houston, co-leader of the local Power BI users group and data analytics group. He regularly speaks and volunteers at PASS events. He is also a Microsoft Data Platform MVP.

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

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.

Dave Fackler

Twitter: - @sqlbiguru

LinkedIn: Dave Fackler

Contact: http://davefackler.blogspot.com/

Dave Fackler is a business intelligence architect, focusing on enterprise data warehouse and business intelligence solutions using Microsoft technologies. Dave has helped organizations design and implement large-scale data warehouses, exploiting SQL Server enterprise database features using dimensional modeling design principles and best practices. He has also architected and developed several enterprise ETL processes using SSIS and its robust set of high-performance tasks and transformations. Dave has delivered various end-user reporting solutions using SSAS and SSRS, often coupled with SharePoint and Office components. Dave speaks about business intelligence at numerous technical conferences, user groups and professional groups each year.

Janis Griffin

Twitter: - DoBoutAnything

LinkedIn: Janis Griffin

Pat Phelan

Twitter: - @YetAnotherSQL

LinkedIn: Pat Phelan

Pat Phelan first joined a computer user group (DECUS) in High School, and has joined many more since then. Pat worked many jobs in high school and college, and over twenty years for a major accounting firm. Pat started working for Involta in 2007 and is now the database mentor and a member of the Engineering team. Involta builds, owns and operates world class colocation datacenters and also provides managed services and support staff to clients.

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.

Tim Warner

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

LinkedIn: Tim Warner

Contact: https://techtrainertim.com

I am a full-time author with Pluralsight, specializing in Microsoft Azure. In addition, I consult as an Azure solutions architect and do a great deal of technical writing.

SQLSaturday Nashville

Twitter: - @SQLSatNash

Contact: http://www.sqlsatnash.com

SQLSaturday Nashville

Adam Belebczuk

Twitter: - @SQLDiablo

LinkedIn: Adam Belebczuk

Contact: http://www.sqldiablo.com/

Adam Belebczuk is the Owner amp; Principal Consultant at Belebczuk Consulting Services, LLC and has more than 10 years of experience in IT, ranging from customer service to server/network administration to software and database development and administration. Adam is the Chapter Leader for the Ohio North SQL Server Users Group, a frequent speaker and volunteer at PASS events, and specializes in SQL Server development, performance tuning, high availability, and disaster recovery.

Pat Phelan

Twitter: - @YetAnotherSQL

LinkedIn: Pat Phelan

John Morehouse

Twitter: - SQLrUs

LinkedIn: John Morehouse

Contact: http://www.sqlrus.com

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.

Stacia Varga

Twitter: - @StaciaV

LinkedIn: Stacia Varga

Contact: http://blog.datainspirations.com

Stacia Varga is a Microsoft Data Platform MVP and SSAS Maestro with a Bachelor’s Degree in Social Sciences. A consultant, educator, author, and principal of Data Inspirations, her career spans more than 30 years, with a focus on improving business practices through technology.

Since 2000, Stacia has provided consulting and education services for Microsoft’s Business Intelligence technologies. As Stacia Misner, she also authored several books covering the Microsoft BI stack.

Mike Lawell

Twitter: - @sqldiver

LinkedIn: Mike Lawell

Contact: http://sqlserverassociates.com/Blog

Mike Lawell is an 19 year veteran of SQL Server, working with all versions since 6.5. He specializes in performance tuning and high availability as an independent consultant.

He is a Linchpin People Teammate, he also consults with SolidQ, Intellinet and Microsoft Consulting Services.

He is also a certified Scuba instructor with a long bucket list of dive sites.

He resides in Atlanta, GA and you can catch him at many of the SQLSaturdays in the SE region of the United States.

Andy Yun

Twitter: - SQLBek

LinkedIn: Andy Yun

Contact: http://sqlbek.wordpress.com

Andy Yun is a SentryOne Principal Solutions Engineer and a former Microsoft MVP. He has been working with SQL Server for nearly 20 years as both a Database Developer and Administrator. Leveraging knowledge of SQL Server Internals and extensive experience in highly transactional environments, he strives to make T-SQL leaner and meaner. Andy is extremely passionate about passing knowledge onto others, regularly speaking at User Groups, SQLSaturdays, and PASS Summit. Andy is a co-founder of the Chicago SQL Association, co-Chapter Leader of the Chicago Suburban User Group, and part of the Chicago SQLSaturday Organizing Committee.

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.

Rie Irish

Twitter: - IrishSQL

LinkedIn: Rie Irish

Rie lives with her family just north of Atlanta, Georgia. She worked as a SQL Server DBA, manager director for over 20 years. She’s worked in many industries including the non-profit sector, education, big pharma, and e-commerce. She was awarded the MVP in the Data Platform 3 times beginning in 2017 and gave that up to accept her role as a Senior Program Manager with Microsoft in 2019. She is very involved with the Atlanta MDF User Group, SQLSaturday Atlanta and is co-leader of the PASS Women in Tech virtual group.

Denny Cherry

Twitter: - mrdenny

LinkedIn: Denny Cherry

Contact: https://www.dcac.com

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.

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.

Wendy Pastrick

Twitter: - @wendy_dance

Contact: http://wendyverse.blogspot.com

William E Pearson III

Twitter: - @Bill_Pearson

LinkedIn: William E Pearson III

Contact: https://mvp.support.microsoft.com/profile=02C5CD07-7511-4151-A678-3A4A3451F85E

Bill Pearson created Island Technologies Inc. in 1997, and has developed a large and diverse customer base since. Bill#39;s background as a CPA, Internal Auditor, Management Accountant, and SQL Server MVP (BI) enables him to provide value to clients as a liaison between Accounting / Finance and Information Services. Bill has implemented enterprise business intelligence systems over the years for many Fortune 500 companies and focuses his practice upon the integrated Microsoft Business Intelligence

Eddie Wuerch

Twitter: - @EddieW

LinkedIn: Eddie Wuerch

Contact: http://www.indydba.com

Eddie Wuerch has 20 years of experience as a SQL Server specialist in a much-longer IT career. A Microsoft Certified Master, Eddie spends his days in the Salesforce Marketing Cloud, focusing on performance, scale, and uptime for the massive SQL Server backend. These SQL Servers churn billions of transactions daily against trillions of rows of data in a 24x7 continuously-available online system accessed by millions worldwide every day.

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

Lindsay Clark

Twitter: - @LindsayOClark

LinkedIn: Lindsay Clark

Lindsay started out in network administration with a BA in Computer Science from South University prior to finding her true love in database administration. Whether it#39;s mentoring in the office or presenting sessions at SQLSaturday, Lindsay loves to find new ways to collaborate and share information. In addition to her role as DBA at American Credit Acceptance, she actively recruits speakers for her user group and chairs her local SQLSaturday event.

Karlyn LeBlanc

Karlyn LeBlanc is a native of Chicago, Illinois. She currently resides in the Atlanta, Georgia area. Karlyn obtained her Bachelors degree from Louisiana State University in Baton Rouge and her Masters from Tulane University in New Orleans. Her career began as licensed master social worker where she spent twelve years counseling patients, supervising master level social workers, and facilitating support groups. In addition, she’s a bestselling author of two books and motivational speaker.

Patrick LeBlanc

Twitter: - patrickdba

LinkedIn: Patrick LeBlanc

Contact: http://patrickdleblanc.com

John Deardurff

Twitter: - SQLMCT

LinkedIn: John Deardurff

Contact: https://www.sqlmct.com

John has been a Microsoft Certified Trainer (MCT) for over 20 years teaching Azure, SQL Server, Exchange Server, and Windows Server networking courses. He is currently a SQL Premier Field Engineer for Microsoft. He is an MCT Regional Lead for the Eastern United States and a former Data Platform MVP.

Jeff Foushee

Jeff Foushee has his MCITP certification in both SQL Server and Windows Server. He is also an Enterprise DBA at Louisville-based Humana, Inc., where he supports almost 20,000 databases on 1,800 SQL Servers. His latest endeavor has been around building a warehouse/website in C#/MVC to automate many database-related processes.

Rushabh Mehta

Twitter: - @rushabhmehta

LinkedIn: Rushabh Mehta

Contact: http://blogs.solidq.com/RushabhMehta

Rushabh Mehta is a Business Intelligence Mentor with SolidQ and the Managing Director for Solid Quality India Pvt. Ltd. He served as PASS President for 2010/2011 term.

Rushabh has worked with MS Data Platform since 1998 and has designed and developed BI systems since 2001. He has been the lead architect for many large-scale and complex BI solutions for clients such as Publix, Raymond James, Jackson Hewitt, US Dept. of Defense, and Microsoft. He is an MVP with Microsoft, Damp;B amp; Melissa Data

Dan Evans

Twitter: - @danthebiman

LinkedIn: Dan Evans

Jon Boulineau

Twitter: - @jboulineau

LinkedIn: Jon Boulineau

Contact: http://jonboulineau.me

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

SQLSaturday Nashville

Twitter: - @SQLSatNash

Contact: http://www.sqlsatnash.com

SQLSaturday Nashville

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.

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

William Wolf

Twitter: - sqlwarewolf

LinkedIn: William Wolf

Contact: http://www.sqlwarewolf.com

Bill is the Manager of SQL Server Performance Tuning for RDX. He works with over 400 customers on solutions within the SQL Server environment and specialized in code tuning and mentoring the team within RDX. He has become a SQLSaturday veteran speaking at nearly 40 SQLSaturdays in the last 3 years. He has also spoken at Summit and is an Idera Ace class of 2018. Bill is active in the Pittsburgh SQL Server User Group. He is also the chapter lead for the DevOps Virtual User Group. He is passionate about educating users on SQL Server and mentoring others.

Daniel Glenn

Twitter: - DanielGlenn

LinkedIn: Daniel Glenn

Contact: https://DanielGlenn.com

Daniel is a Microsoft MVP with 15 years’ experience building technology solutions, intranets and extranets. As Practice Leader for the Nashville-based InfoWorks Inc., Daniel helps organizations of all sizes solve complex data challenges by implementing Office 365 and SharePoint without the need of customization and costly investments.

Daniel is passionate about giving back and building the Microsoft technical community. Daniel holds leadership roles in various local user groups, serves as an organizer for Microsoft 365 Nashville, and is a co-host for the popular podcast 365 Message Center Show on https://MessageCenter.Show. You can follow Daniel online at https://DanielGlenn.com and @DanielGlenn on Twitter.

Josh Luedeman

Twitter: - http://www.twitter.com/joshluedeman

LinkedIn: Josh Luedeman

Contact: http://www.joshluedeman.com

David Maxwell

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

LinkedIn: David Maxwell

Contact: https://dmmaxwell.wordpress.com/

David Maxwell has almost 20 years of experience with SQL Server, with a keen interest in performance tuning, monitoring, and troubleshooting. He has experience in environments as diverse as health care institutions, auto manufacturers, and insurance companies. David has been a frequent presenter at SQLSaturday events around the United States since 2012, as well as a presenter for the DBA Fundamentals Virtual Group, the Performance Virtual Group, 24 Hours of PASS, and the annual PASS Summit. David participates in his local Columbus Ohio PASS Local Group, where he serves on the board of directors as SQLSaturday coordinator.

Ben DeBow

Twitter: - bbqsql

LinkedIn: Ben DeBow

Contact: http://www.fortifieddata.com

Ben DeBow is an active member of the technology community. With his strong belief in creating relationships and supporting others, he has actively worked on providing results to clients in order to provide them with the end result that the client may have not even had known they needed. Over the year, Ben has presented at several industry thought leadership events and aspires to educate others on data in order to expand the technological community and provide knowledge to those seeking to discover hidden talents within the field.

As founder and Chief Executive Officer of Fortified Data, Ben DeBow guides the team of Fortified Data under the core values of giving back, maintaining curiosity, driving towards results, being respectful, and

Mark Scott

Twitter: - @usamjscott

LinkedIn: Mark Scott

Contact: http://www.pyramidanalytics.com/Pages/blog/Authors/mark-scott.aspx

Mark has over 20 years of consulting, managing, delivering, and selling in both private and public companies all over the US. Prior to joining Pyramid, he held consulting and sales leadership positions at Microsoft delivering and selling BI and Data Warehousing solutions to large enterprise accounts. In his spare time - Mark enjoys traveling and spending time with his wife, and two sons age 4 and 6!

SQLSaturday #480 - Nashville 2016

Sessions

Title: Data Pages, Allocation Units, IAM chains… Oh My!

Title: Execution Plans for Mere Mortals

Title: Flying Through the Clouds–Performance Tuning in Azure

Title: SSAS Metadata Reporting for Cube Consumers and Developers

Title: Mastering and Enhancing Company Data

Title: PowerShell for the Reluctant Administrator

Title: XML Without Xanax: How to Handle XML in SQL Server

Title: Don’t Rely on Magic - Tabular Performance Troubleshooting

Title: Turning Requirements into a BI Prototype

Title: Version control with GIT for the DBA

Title: Parameter Sniffing and the Query Store in SQL Server 2016

Title: Understanding Windows Azure High Availability Options for SQL Server

Title: Table Vars and Temp Tables – What you NEED to Know!

Title: Tame Your Unruly Data…With Constraints!

Title: Maintain SQL Server Performance Baseline w/PowerShell

Title: Ten Query Tuning Techniques Every SQL Programmer Should Know

Title: The Art and the Science of Designing a Mission Critical SQL Server Solution

Title: Introduction to the Power BI Desktop

Title: A Quick Peek into the 4th Dimension with T-SQL

Title: Ensure optimal database performance with Foglight Performance Investigator

Title: Social Networking Is Alive!!!

Title: Perceptual Intelligence with Cortana Analytics

Title: Get Near Realtime ETL with Service Broker

Title: Building Your Yellow Brick Road: Directing Your Path to a Successful Career

Title: Top 10 Wait Types Everyone Should Know

Title: Overview of Security Investments in SQL Server 2016 and Azure SQL Database

Title: 16 Enhancements for SQL Server 2016

Title: The Benefits of Implementing SQL Server on Cisco Unified Computing System

Title: Powershell Jumpstart for SQL Server DBAs

Title: Understanding SQL Server Backup and Restore

Title: Surviving Your Peak Database Load

Title: Using SQL Servers AlwaysOn Availability Groups

Title: WIT-Diversity Panel: Parenting Daughters in an IT world Why Its Important

Title: Top Free Tools for Tuning SQL Statements

Title: Let Me Finish… Isolating Write Operations

Title: Data Architecture 101

Title: SQL Server’s In Memory Database Objects

Title: Show me whatcha workin’ with: Big Data Edition

Title: Use Biml to Automate SSIS Design Patterns

Title: Automating Database Restores

Title: Batches, Transactions, and Errors

Title: Transforming Data using the T-SQL PIVOT / UNPIVOT operators

Title: Beginners SQL Server Security the Low Hanging Fruit

Title: Power BI: Data Refresh ad SSAS On-Premises Connectivity

Title: Keys to Successful SharePoint Administration for the DBA

Title: Navigating the Options for Data Redundancy

Title: Getting Started with MDX

Title: TempDB Done Right

Title: Balancing Work and Home to Create a Better You

Title: Data Factory: Data Integration in the Cloud

Title: Database Continuous Delivery Your Salvation!

Title: Hadoop for SQL Server Pros

Title: Cleaning House: The Indexing Edition

Title: A Real, Live PowerShell Beginner’s Tutorial

Title: Case Study: Improving High Availability and Disaster Recovery

Title: Row-level Security in SSRS and SSAS

Title: Looking for the Power BI on-prem alternative?

Title: Encrypting Data within Sql Server

Title: Turbo-Charged Transaction Logs

Title: R with AzureML

Title: Beginning Azure

Title: Looking for the Power BI on-prem alternative?

Title: Tame the sibling rivalry of the Lock, Block, Deadlock sisters

Title: Extended Time Slot

Title: The Next Dimension of Data

Title: Introduction to SQL Server Integration Services

Speakers

Sponsors