sqlsathistory

Nr: 719

SQLSaturday #719 - Chicago 2018

Start Time (24h)	Speaker	Track	Title
08:30:00	Anthony Nocentino	Enterprise Database Administration Deployment	I Needed to Install 80 SQL Servers…Fast. Here’s How I Did It!
08:30:00	David Maxwell	Enterprise Database Administration Deployment	Targeting Wait Statistics with Extended Events and DMVs
08:30:00	Ross LoForte	Enterprise Database Administration Deployment	Azure SQL Database Administration and Management
08:30:00	John Sterrett	Enterprise Database Administration Deployment	Automate the Pain Away with Query Store and Automatic Tuning
08:30:00	Karlyn LeBlanc	Professional Development	Creating your Vision
08:30:00	Thomas Norman	Enterprise Database Administration Deployment	Database Project Makes Deployment Consistent
08:30:00	Aaron Nelson	BI Platform Architecture, Development Administration	PowerShell for BI Professionals: Automating SSIS, SSRS SSAS
08:30:00	Chirag Shah	Enterprise Database Administration Deployment	SQL Server 2017 Database Engine Enhancements
08:30:00	Doug Lane	Cloud Application Development Deployment	How to Survive Migrating to SQL Server on AWS
09:50:00	Phil Ekins	Professional Development	SQL Testing - How to Build a SQL Lab
09:50:00	William Wolf	Application Database Development	Stop Doing That! Common T-SQL Anti-Patterns
09:50:00	Janis Griffin	Enterprise Database Administration Deployment	HiHo! HiHo! SQL Server on Linux, We Go!
09:50:00	Andy Leonard	BI Platform Architecture, Development Administration	Faster SSIS
09:50:00	Michael Fal	Enterprise Database Administration Deployment	Exploring the new SqlServer PowerShell module
09:50:00	Derik Hammer	Cloud Application Development Deployment	Introduction to Azure SQL Data Warehouse
09:50:00	Brent Ozar	Application Database Development	How to Build Fast Multi-Parameter Stored Procedures
09:50:00	Allan Hirt	Professional Development	10 Years of Highs and Lows as an Independent Consultant
09:50:00	John Eisbrener	Application Database Development	Columnstore 101: The Five Ws of Columnstore Indexes
09:50:00	Kerry Tyler	BI Platform Architecture, Development Administration	45 Minutes to Your First SSAS Tabular Model
11:10:00	David Maxwell	Enterprise Database Administration Deployment	Understanding and Handling Database Corruption
11:10:00	Tracy Boggiano	Enterprise Database Administration Deployment	Monitoring Availability Groups
11:10:00	Dave Bland	Enterprise Database Administration Deployment	Extended Events: What are they and How do I use them
11:10:00	Joe Obbish	Application Database Development	Decoding the Cardinality Estimator to Speed Up Queries
11:10:00	Igor Chmil	Cloud Application Development Deployment	Migrate multi-terabyte DB from OnPrem to Azure SQL (ASD) with minimal downtime.
11:10:00	Cathrine Wilhelmsen	BI Platform Architecture, Development Administration	Biml for Beginners: Script and Automate SSIS Development
11:10:00	Arthur Daniels III	Enterprise Database Administration Deployment	Plan Cache performance tuning and pruning
11:10:00	Allan Hirt	Enterprise Database Administration Deployment	Infrastructure 101 for SQL Server Deployments
11:10:00	Seth Bauer	BI Platform Architecture, Development Administration	Administering and Deploying Power BI Solutions
12:40:00	Rick Bielawski	Application Database Development	Difficult Queries
12:40:00	Tracy Boggiano	Enterprise Database Administration Deployment	Collecting Performance Metrics
12:40:00	Rob Volk	Application Database Development	Tame Your Unruly Data With Constraints
12:40:00	Wylie Blanchard	Professional Development	Become a SQL Pro who’s in High Demand
12:40:00	David Klee	Enterprise Database Administration Deployment	Level Up Your Cloud Infrastructure Skills
12:40:00	Adam Kerr	Application Database Development	Strong Architecture and Entity Framework Code First - It's Possible!
12:40:00	Tamera Clark	BI Platform Architecture, Development Administration	SSRS; Not everything is a dashboard
12:40:00	Argenis Fernandez	Enterprise Database Administration Deployment	SQL Server and Pure Storage: Redefining Database Engineering
12:40:00	Michael Fal	Enterprise Database Administration Deployment	Simplifying SQL Data Protection (with Rubrik)
14:00:00	William Wolf	Application Database Development	Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry
14:00:00	H. Ross Reed	Enterprise Database Administration Deployment	Limiting SQL Server Exposure
14:00:00	Eric Flamm	Enterprise Database Administration Deployment	Intro to SQL Operations Studio
14:00:00	Marsha Pierce	Enterprise Database Administration Deployment	How To Talk To Your Storage Admin
14:00:00	David Bermingham	Enterprise Database Administration Deployment	SQL Server in "The Cloud": High Availability and Disaster Recovery in Azure, AWS and Google
14:00:00	Henry Treftz	Application Database Development	Why Third Party Vendors Do The Things They Do
14:00:00	Brian Hansen	Enterprise Database Administration Deployment	Get Your Optimizer to Give up All Its Secrets
14:00:00	Lynn Ballard	Professional Development	Disaster Recovery Planning for Your Career and Your Life...There's No Certification For This
14:00:00	Diane Schuster	BI Platform Architecture, Development Administration	Dynamic Data Flows in SSIS without Programming
14:00:00	David Klee	Enterprise Database Administration Deployment	Advanced SQL Server on VMware Features
15:15:00	Tim Gorman	Enterprise Database Administration Deployment	Reducing The Surface Area Of Risk in Data Security
15:15:00	Vazi Okhandiar	Analytics and Visualization	Building a Dashboard in an Hour using PowerPivot Power BI
15:15:00	Ben Davis	Enterprise Database Administration Deployment	Linked Servers – Purpose, Pitfalls and Performance Implications
15:15:00	Dan Mallott	Application Database Development	ORMs and the DBA: How to Make Both Happy
15:15:00	Pat Phelan	Application Database Development	Relational Data Architecture 101
15:15:00	Daniel Janik	Enterprise Database Administration Deployment	A DBA's guide to whole stack performance troubleshooting
15:15:00	Eddie Wuerch	Professional Development	Be the Next Great Speaker: The Complete Speaker Starter Kit
15:15:00	Ed Leighton-Dick	Enterprise Database Administration Deployment	How to Keep Your Databases Secure in Just Minutes a Day
15:15:00	David Bermingham	Cloud Application Development Deployment	Azure Site Recovery and other Disaster Recovery Options for SQL S
15:15:00	David Klee	Professional Development	My Brain Has Blue Screened - Let's Laugh

SessionID: 70877

I Needed to Install 80 SQL Servers…Fast. Here’s How I Did It!

Back to calendar

Event Date: 17-03-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Anthony Nocentino

Title: I Needed to Install 80 SQL Servers…Fast. Here’s How I Did It!

Abstract:

In this session we’ll learn:

DSC Fundamentals DSC Resources and where to get them Configuration Data Best practice SQL Server configurations implemented in DSC Leveraging this configuration for Disaster Recovery

SessionID: 70954

Targeting Wait Statistics with Extended Events and DMVs

Back to calendar

Event Date: 17-03-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Targeting Wait Statistics with Extended Events and DMVs

Abstract:

When troubleshooting overall server performance, wait statistics are a great place to start. But when your SQL Server hosts a complex set of workloads, it can be difficult to narrow down which queries are causing the most wait, and what types of wait they are causing. Fortunately, SQL Server provides easy ways for targeting which queries are causing you the most wait time. In this session, we’ll learn how to use both Extended Events, and Dynamic Management Views new to SQL Server 2016 for examining wait statistics at a query level, rather than at the server level. We’ll analyze poorly performing queries using a combination of methods and show how to quickly narrow down what SQL Server is waiting for, and why.

SessionID: 71001

Azure SQL Database Administration and Management

Back to calendar

Event Date: 17-03-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Ross LoForte

Title: Azure SQL Database Administration and Management

Abstract:

Azure SQL Database is a Platform as a Service that provides DBAs with lower maintenance, on-demand scalability and performance with the latest SQL Server advanced features like adaptive query tuning. How to do maintenance and management tasks in Azure SQL Database, what you can and cannot do. Come to this session to explore the capability and differences between a traditional SQL Server and Azure SQL Database, to give the DBAs the understanding they need to make the right decision to run on Azure platform while reducing cost, maintenance, improving query tuning, administration and agility.

SessionID: 71296

Automate the Pain Away with Query Store and Automatic Tuning

Back to calendar

Event Date: 17-03-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: John Sterrett

Title: Automate the Pain Away with Query Store and Automatic Tuning

Abstract:

Join John Sterrett, Principal Consultant at Procure SQL LLC to learn how execution plans get invalidated and why data skew could be the root cause of seeing different execution plans for the same query. We will look at the options for forcing a query to use a particular execution plan. Finally, you will learn how this complex problem can be identified and resolved simply using new features in SQL Server 2016 and SQL Server 2017 called Query Store and Automatic Tuning.

SessionID: 71576

Creating your Vision

Back to calendar

Event Date: 17-03-2018 - Session time: 08:30:00 - Track: Professional Development

Speaker: Karlyn LeBlanc

Title: Creating your Vision

Abstract:

Dreams become reality and it's time for you to create the life you want. What's your vision? Where do you see yourself in 5 years? What's the next step in your professional career? Are you living life to the fullest and doing what really makes you happy? Discover a new you and learn to succeed and live without regrets in this very interactive seminar.

SessionID: 72173

Database Project Makes Deployment Consistent

Back to calendar

Event Date: 17-03-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Norman

Title: Database Project Makes Deployment Consistent

Abstract:

SessionID: 72840

PowerShell for BI Professionals: Automating SSIS, SSRS SSAS

Back to calendar

Event Date: 17-03-2018 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: Aaron Nelson

Title: PowerShell for BI Professionals: Automating SSIS, SSRS SSAS

Abstract:

PowerShell has allowed DBAs to manage huge numbers of SQL servers, all automatically. Now BI practitioners can reap the same benefits of scale and automation. Scenarios that are normally extremely time consuming can be done quickly, all with a few lines of PowerShell.

This session will be filled with demos based on real-life scenarios and use-cases. We will demonstrate how to scale and automate your BI solutions, with a minimum of effort. In particular, we will be covering PowerShell cmdlets their integrations with SSRS, SSIS, SSAS.

By the end of the session, you'll be able to accomplish in minutes what would normally take hours or days. You’ll know ways to quickly deploy hundreds of SSRS objects to multiple servers; or instantly identify and process stale SSAS dimensions. Additionally, you will also be able to take care of some pesky ETL tasks, some by automating SSIS, and others using just plain old PowerShell.

SessionID: 73712

SQL Server 2017 Database Engine Enhancements

Back to calendar

Event Date: 17-03-2018 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Chirag Shah

Title: SQL Server 2017 Database Engine Enhancements

Abstract:

With an advent of SQL 2017 we at Microsoft bringing a new level of enhancements into core relational SQL engine. Even if you are a seasoned database professional worked with SQL product for many years, come join this session to find out how and what has changed in SQL Server 2017 from improved query processing to new and improved features to further enhance scalability of the product.

SessionID: 73791

How to Survive Migrating to SQL Server on AWS

Back to calendar

Event Date: 17-03-2018 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Doug Lane

Title: How to Survive Migrating to SQL Server on AWS

Abstract:

10 terabytes of SQL Server data migrated to AWS in two months? I am serious, and don't call me Shirley. In this session we'll cover some of the lessons learned from migrating a $100 million company from ancient on-premises hardware to glistening new EC2 instances in a seriously compressed timeline.

We'll cover key decisions and considerations on architecture, hardware, high availability and disaster recovery, and how to execute the cut-over with minimal downtime. It wasn't always pretty, but we survived, and you can too.

SessionID: 70875

SQL Testing - How to Build a SQL Lab

Back to calendar

Event Date: 17-03-2018 - Session time: 09:50:00 - Track: Professional Development

Speaker: Phil Ekins

Title: SQL Testing - How to Build a SQL Lab

Abstract:

This session will cover that various tips and tricks on what you can do on a single laptop to make a robust lab.

How to create fake external storage, solutions for networking (need subnets) and other creative solutions to allow for the creation and testing of various SQL features.

SessionID: 71215

Stop Doing That! Common T-SQL Anti-Patterns

Back to calendar

Event Date: 17-03-2018 - Session time: 09:50:00 - Track: Application Database Development

Speaker: William Wolf

Title: Stop Doing That! Common T-SQL Anti-Patterns

Abstract:

There are several programming design patterns that work great in object oriented code but do not scale inside SQL Server. Things like Scalar-Value functions, Unions, CTEs, and row by row processing can make for more work than you would expect.

In this session, we will focus on several anti-patterns like these and show how to rework them to improve scale in the database engine.

By the end of the session, you will be able to quickly identify these common anti-patterns and analyze their sometimes unclear cost to the engine. Heading back to the office, you’ll be able to identify pain points in your longest running queries from a T-SQL perspective and become a code tuning rock star!

SessionID: 71524

HiHo! HiHo! SQL Server on Linux, We Go!

Back to calendar

Event Date: 17-03-2018 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: HiHo! HiHo! SQL Server on Linux, We Go!

Abstract:

SQL Server has been running on Windows for years. Now Microsoft is making it available on Linux in order to provide a consistent database platform across Window and Linux servers, as well as on-premises and in the cloud. In this presentation, Janis Griffin, database performance evangelist at SolarWinds, will discuss the advantages of using SQL Server on Linux, comparing architecture, cost and performance. Several demonstrations on installing and maintaining SQL Server on Linux will be shown along with an introduction of several useful Linux commands.

The participant will learn:

The advantages of using SQL Server on Linux, comparing architecture, cost and performance to Window servers.
How to install, maintain and backup SQL Server on Ubuntu Linux systems
Several useful Linux commands to monitor/manage SQL Server

SessionID: 72049

Faster SSIS

Back to calendar

Event Date: 17-03-2018 - Session time: 09:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Andy Leonard

Title: Faster SSIS

Abstract:

Ever wonder why SSIS runs so slow? Watch SSIS author Andy Leonard as he runs test loads using sample and real-world data and shows you how to tune SQL Server 2016 Integration Services (SSIS 2016) packages.

We'll start by experimenting with SSIS design patterns to improve performance loading AdventureWorks data. We will implement different change detection patterns and compare execution performance for each. Then, we'll explain a Data Flow Task's bottleneck when loading binary large objects - or Blobs.

Finally, we'll demonstrate a design pattern that uses a Script Component in a Data Flow to boost load performance to MySql, whether on-premises or in the cloud.

SessionID: 72190

Exploring the new SqlServer PowerShell module

Back to calendar

Event Date: 17-03-2018 - Session time: 09:50:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Fal

Title: Exploring the new SqlServer PowerShell module

Abstract:

If you’ve dabbled in PowerShell, you probably know that there are many ways to use it in conjunction with SQL Server. While using the provided tool set has been a challenge for many data professionals, recent upgrades and improvements to the PowerShell module for SQL server provide a solid tool set for new and experienced users. This session will cover the SqlServer module in detail, exploring the various commands and demonstrating various use cases for the tool set. Attendees will get a solid overview of the module and real world examples of how users can get the most out of their code.

SessionID: 72532

Introduction to Azure SQL Data Warehouse

Back to calendar

Event Date: 17-03-2018 - Session time: 09:50:00 - Track: Cloud Application Development Deployment

Speaker: Derik Hammer

Title: Introduction to Azure SQL Data Warehouse

Abstract:

On-premises data warehouse solutions are typically a large up-front capital expense which expensive boundaries to expansion. This led my organization to look to the cloud. In this session, I cover the basics of Azure SQL Data Warehouse, its architecture, and why you should be interested in combining the flexibility and scalability of the cloud with a massively parallel processing data warehouse.

SessionID: 73278

How to Build Fast Multi-Parameter Stored Procedures

Back to calendar

Event Date: 17-03-2018 - Session time: 09:50:00 - Track: Application Database Development

Speaker: Brent Ozar

Title: How to Build Fast Multi-Parameter Stored Procedures

Abstract:

You're comfortable writing T-SQL, and you've built a lot of stored procedures that have a bunch of parameters. For example, you have that "product search" stored proc with parameters for product category, name, price range, sort order, etc, and you have to accept any of 'em.

So how do we make those go fast? And how can we get 'em to use indexes?

In one all-demo hour, performance tuner Brent Ozar will show you several ways that fail in comically bad ways. You'll learn how to write dynamic SQL that's easy to tune, manage, and troubleshoot.

SessionID: 73578

10 Years of Highs and Lows as an Independent Consultant

Back to calendar

Event Date: 17-03-2018 - Session time: 09:50:00 - Track: Professional Development

Speaker: Allan Hirt

Title: 10 Years of Highs and Lows as an Independent Consultant

Abstract:

2017 marked the 10th anniversary of when I left the world of being a full time employee to being an independent consultant. Back then I was just trying to make it to year two. Ten years later, I've learned a lot and I'm still standing with a few battle scars to prove it. Join me as I discuss what it takes to be (and survive as) a consultant, lessons learned - both good and bad, and how you can apply the principles of consulting even if you are a full time employee to step up your game.

SessionID: 73796

Columnstore 101: The Five Ws of Columnstore Indexes

Back to calendar

Event Date: 17-03-2018 - Session time: 09:50:00 - Track: Application Database Development

Speaker: John Eisbrener

Title: Columnstore 101: The Five Ws of Columnstore Indexes

Abstract:

While Columnstore Indexes were introduced with SQL Server 2012, their popularity and general use haven't increased nearly as much as their functionality since then. If you're someone that's not had much experience with Columnstore Indexes and want to learn more about them, this session is perfect for you as I plan to cover the Five Ws of Columnstore Indexes: what they are, when to use them, where they are best utilized, and most importantly why they work so well. You'll be the "who" and after the session, I expect you'll feel more confident and excited to use this great feature.

SessionID: 73797

45 Minutes to Your First SSAS Tabular Model

Back to calendar

Event Date: 17-03-2018 - Session time: 09:50:00 - Track: BI Platform Architecture, Development Administration

Speaker: Kerry Tyler

Title: 45 Minutes to Your First SSAS Tabular Model

Abstract:

Have you been watching SSAS Tabular develop? What about the new Azure Analysis Services product? Or you've looked at these and like what they can add in Power BI or classic BI scenarios, but haven't had a chance to dive in and figure all of this out? Now is the time!

SSAS Tabular is a new-ish form of business intelligence model released with SQL Server 2012, intended as an alternative to more traditional Multidimensional cubes. In this session, we will talk briefly about what Tabular is and what it does, in addition to the various options for deployment, before exploring the development process of creating a tabular model ready for ad-hoc querying through Excel or Power BI.

SessionID: 70956

Understanding and Handling Database Corruption

Back to calendar

Event Date: 17-03-2018 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Understanding and Handling Database Corruption

Abstract:

SessionID: 71042

Monitoring Availability Groups

Back to calendar

Event Date: 17-03-2018 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Monitoring Availability Groups

Abstract:

Once you have successfully configured Availability Groups, what comes next? In this session, we will go beyond setup and look at how to monitor your Availability Groups. We will define and cover important metrics and alerts you need to manage a database in an Availability Group.

You will walk away from this session with tools you need to monitor your environment and know how to respond to alerts.

SessionID: 71058

Extended Events: What are they and How do I use them

Back to calendar

Event Date: 17-03-2018 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: Extended Events: What are they and How do I use them

Abstract:

Extended Events are an essential part of properly monitoring and every DBA should know what they are and how to use them. This session will cover the basics of Extended events as well as an introduction to the system_health session. This session will give someone who has never used Extended events before the skills to start using them!

SessionID: 71358

Decoding the Cardinality Estimator to Speed Up Queries

Back to calendar

Event Date: 17-03-2018 - Session time: 11:10:00 - Track: Application Database Development

Speaker: Joe Obbish

Title: Decoding the Cardinality Estimator to Speed Up Queries

Abstract:

The cardinality estimator in SQL Server is a massively complex piece of software that is responsible for calculating the estimated number of rows for query plans. We will derive some of the simplest and most important rules for cardinality estimation. Armed with that knowledge, we will address errors in cardinality estimates which can cause poor query performance. Demos include filtering on multiple columns, using local variables, dealing with ascending keys, and more.

SessionID: 72415

Migrate multi-terabyte DB from OnPrem to Azure SQL (ASD) with minimal downtime.

Back to calendar

Event Date: 17-03-2018 - Session time: 11:10:00 - Track: Cloud Application Development Deployment

Speaker: Igor Chmil

Title: Migrate multi-terabyte DB from OnPrem to Azure SQL (ASD) with minimal downtime.

Abstract:

With Azure PaaS database offering gaining more popularity due to its ultimate flexibility and minimized support overhead, more companies are considering it as superior alternative not just to on-site, but also to IaaS hosting options.

Migrating an existing database from on-prem SQL may prove to be a challenging effort for applications with critical availability requirements and large size databases. The default migration method offered by Microsoft uses the Data Migration Assistant (DMA). Designed with simplicity in mind, DMA migration is an offline operation. Migrating a database with the maximal Azure SQL supported size (4TB) using DMA will require hours and hours of downtime. With transaction log replay operations not supported in Azure SQL, transactional replication remains as our only option for transitioning large databases into Azure SQL and avoiding long downtime. In this presentation we will demonstrate how to migrate a database to ASD using SQL Server replication technology.

SessionID: 73019

Biml for Beginners: Script and Automate SSIS Development

Back to calendar

Event Date: 17-03-2018 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Cathrine Wilhelmsen

Title: Biml for Beginners: Script and Automate SSIS Development

Abstract:

Are you tired of creating and updating the same SSIS packages again and again? Is your wrist hurting from all that clicking, dragging, dropping, connecting and aligning? Do you want to take the next step and really speed up your SSIS development?

Say goodbye to repetitive work and hello to Biml, the markup language for Business Intelligence projects.

In this session we will look at the basics of Biml. First learn how to use Biml to generate SSIS packages from database metadata. Then see how you can reuse code to implement changes in multiple SSIS packages and projects with just a few clicks. Finally, we will create an example project that you can download and start with to speed up your SSIS development from day one.

Stop wasting your valuable time on doing the same things over and over and over again, and see how you can complete in a day what once took more than a week!

SessionID: 73564

Plan Cache performance tuning and pruning

Back to calendar

Event Date: 17-03-2018 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Arthur Daniels III

Title: Plan Cache performance tuning and pruning

Abstract:

In this session, we'll discuss ways to manage execution plans inside the plan cache of busy and unpredictable SQL Servers. The plan cache keeps SQL Server healthy, but all it takes is one bad execution plan to decrease server performance.

Just like gardening, keeping a database healthy requires pruning. Techniques to manage, remove, and improve execution plans will be shown. The Query Store gives us power tools for this work, but it's not the entire solution.

SessionID: 73582

Infrastructure 101 for SQL Server Deployments

Back to calendar

Event Date: 17-03-2018 - Session time: 11:10:00 - Track: Enterprise Database Administration Deployment

Speaker: Allan Hirt

Title: Infrastructure 101 for SQL Server Deployments

Abstract:

In a cloudy, virtualized world where we have less physical deployments of SQL Server, those responsible for SQL Server still need to understand basic infrastructure concepts whether you are deploying on Windows Server or Linux. Without them, your VMs and IaaS deployments will not scale, will underperform, and most likely will have poor availability. This session will cover the basics of what you need to know whether you are deploying SQL Server on premises or in the public cloud to go from SQL Server zero to SQL Server hero and be able to have better working relationships with the other administrators in your organization.

SessionID: 73749

Administering and Deploying Power BI Solutions

Back to calendar

Event Date: 17-03-2018 - Session time: 11:10:00 - Track: BI Platform Architecture, Development Administration

Speaker: Seth Bauer

Title: Administering and Deploying Power BI Solutions

Abstract:

SessionID: 72149

Difficult Queries

Back to calendar

Event Date: 17-03-2018 - Session time: 12:40:00 - Track: Application Database Development

Speaker: Rick Bielawski

Title: Difficult Queries

Abstract:

Take your T-SQL skills to the next level. Regardless of your current level there will be something here you'll be glad you didn't miss. Basics like avoiding cursors in iterative tasks and multi-database executions are the tip of the iceberg. If queries are basic arithmetic then this is basic algebra. First we see how coding style affects maintainability then dive into several types of encapsulation, parameterization and tricks with values, cross apply, pivot and more .

SessionID: 72659

Collecting Performance Metrics

Back to calendar

Event Date: 17-03-2018 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Tracy Boggiano

Title: Collecting Performance Metrics

Abstract:

Only if you have baseline performance information can you answer these questions and form a plan to address the issues at hand. In this session, we will be discussing several open source tools you can combine into an inexpensive baselining system you can use to troubleshoot issues and answer important questions.

Attendees in this session will learn how to collect important metric data, what data to collect, and how to interpret that data and develop a plan of action to address any issues.

SessionID: 72746

Tame Your Unruly Data With Constraints

Back to calendar

Event Date: 17-03-2018 - Session time: 12:40:00 - Track: Application Database Development

Speaker: Rob Volk

Title: Tame Your Unruly Data With Constraints

Abstract:

Bad data comes in many forms: duplicate rows, wrong data type, invalid values, and orphaned or missing foreign keys. Time is wasted cleansing, reviewing and correcting data, not to mention the potential hazards bad data can cause. This introductory presentation will explain the data types and constraints available in SQL Server, and how they can replace or augment business rules that would otherwise be written in application or procedure code. Performance benefits provided by constraints will be demonstrated. We will examine the various system views and procedures that describe constraints and how to use them to document your databases. You will be able to apply this knowledge to your database environments and see significant improvements in data quality, performance, and reliability.

SessionID: 73434

Become a SQL Pro who’s in High Demand

Back to calendar

Event Date: 17-03-2018 - Session time: 12:40:00 - Track: Professional Development

Speaker: Wylie Blanchard

Title: Become a SQL Pro who’s in High Demand

Abstract:

Expertise in SQL is an in-demand IT skill. As demand continues to grow, so does the increase of SQL professionals entering your specific industry. Learn what's needed to ensure that you become a stronger technology authority in your industry and a SQL Pro who’s always in High Demand. You'll learn how to invest in growing your expertise, improve your social/people skills, how to effectively sell and market your talent, what is a “source of truth” and why is it extremely important and more.

SessionID: 73495

Level Up Your Cloud Infrastructure Skills

Back to calendar

Event Date: 17-03-2018 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Level Up Your Cloud Infrastructure Skills

Abstract:

SessionID: 73722

Strong Architecture and Entity Framework Code First - It's Possible!

Back to calendar

Event Date: 17-03-2018 - Session time: 12:40:00 - Track: Application Database Development

Speaker: Adam Kerr

Title: Strong Architecture and Entity Framework Code First - It's Possible!

Abstract:

Code-first database generation has a reputation as a dirty word. In this session, we'll explore ways to integrate Entity Framework Code First with a well-architected application. Topics covered will include unit testing, (Yes, you can unit test a database!) dependency injection, transaction scoping, separation of concerns, and repeatable patterns for model generation.

SessionID: 73766

SSRS; Not everything is a dashboard

Back to calendar

Event Date: 17-03-2018 - Session time: 12:40:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tamera Clark

Title: SSRS; Not everything is a dashboard

Abstract:

OH “SSRS is so 2005, why are we even talking about it?” Join me and find out why we should be talking about it, even in 2018. We’ll explore the differences between MS Business Intelligence offerings and help you see why SSRS is still relevant. We’ll review example scenarios and help you see what SSRS can do for you.

SessionID: 77316

SQL Server and Pure Storage: Redefining Database Engineering

Back to calendar

Event Date: 17-03-2018 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Argenis Fernandez

Title: SQL Server and Pure Storage: Redefining Database Engineering

Abstract:

Please join SQL Server MCM Argenis Fernandez for an eye-opening session on how the innovative, industry-disruptive tech in the Pure Storage FlashArray helps your business do everything faster, easier. Faster transactional workloads, analytics, backups and maintenance, all without the pain of having to tweak a thousand knobs to get things to work. Finally a storage array you can love to use, and be proud to own! Come see what the fuss is all about.

SessionID: 77478

Simplifying SQL Data Protection (with Rubrik)

Back to calendar

Event Date: 17-03-2018 - Session time: 12:40:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Fal

Title: Simplifying SQL Data Protection (with Rubrik)

Abstract:

When you think about backups in your environment, how many servers scripts do you have to manage? Or have you ever needed to get a table back from a large database and didn't want to argue with the storage admins about space for the restore? With Rubrik, we empower you to backup and restore your databases quickly and with ease. Come see how you can quickly protect hundreds of databases with just a few clicks or bring back a database in minutes to satisfy your most demanding executives. With Rubrik, it's not about backing up, it's about going forward!

SessionID: 71214

Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Back to calendar

Event Date: 17-03-2018 - Session time: 14:00:00 - Track: Application Database Development

Speaker: William Wolf

Title: Locks, Blocks, and Deadlocks; Tame the Sibling Rivalry

Abstract:

Like parents having to break up a fight between battling siblings, SQL Server must do the same for conflicting transactions. We call these Deadlocks and they can present a problem to many DBAs. Deadlocks can be minor fights or major issues making SQL Server continually choose a side like constantly quarreling siblings.

To understand how Deadlocking occurs, we must understand what caused the fight . Learning about basic locking and blocking of SQL Server is a great place to start.

By the end of this session you will walk away with the knowledge of how the locking/blocking mechanism works, the basics of deadlocking, and what Isolation Levels are . You will know how these can help or hurt your situation. Finally you will have the power to capture, report, and stop the family fighting.

SessionID: 71314

Limiting SQL Server Exposure

Back to calendar

Event Date: 17-03-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: H. Ross Reed

Title: Limiting SQL Server Exposure

Abstract:

Sooner or later DBA's are tasked with securing Database Instances to meet auditing requirements whether we like it or not. The purpose of this topic is to offer some solid pointers to lock down SQL Server instances without causing a disruption to the applications. The presentation will also look at how to set up auditing to report potential hacking , as well as auditing schema changes.

SessionID: 72030

Intro to SQL Operations Studio

Back to calendar

Event Date: 17-03-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Eric Flamm

Title: Intro to SQL Operations Studio

Abstract:

"SQL Operations Studio (preview) offers a modern, keyboard-focused T-SQL coding experience that makes your everyday tasks easier with built-in features, such as multiple tab windows, a rich T-SQL editor, IntelliSense, keyword completion, code snippets, code navigation, and source control integration (Git). Run on-demand T-SQL queries, view and save results as text, JSON, or Excel. Edit data, organize your favorite database connections, and browse database objects in a familiar object browsing experience."

And, it runs on a Mac (and Linux, and Windows, too). Similar to Visual Studio Code, SQL Operations Studio (still in pre-release form) lets you connect to and manipulate your databases without spinning up Visual Studio (or SSMS). We'll walk through how to get the bits and install them, then connect to and query a database (in Azure) - we might not even use a mouse! If time permits, we'll take a look at Code Snippets - a built-in capability to make your T-SQL coding super-productive!

SessionID: 72872

How To Talk To Your Storage Admin

Back to calendar

Event Date: 17-03-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Marsha Pierce

Title: How To Talk To Your Storage Admin

Abstract:

A general discussion about storage and how it affects DBA's. We will discuss how to monitor for performance as well. We will also discuss what DBA's need to consider when talking to their storage administrators.

SessionID: 73000

SQL Server in "The Cloud": High Availability and Disaster Recovery in Azure, AWS and Google

Back to calendar

Event Date: 17-03-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Bermingham

Title: SQL Server in "The Cloud": High Availability and Disaster Recovery in Azure, AWS and Google

Abstract:

If you are considering moving your SQL Server instances to "The Cloud" you will need to have a plan in place for both high availability and disaster recovery. In this session we will examine the three top public cloud providers and what they have to offer in terms of both high availability and disaster recovery. We will discuss where the providers are the same and where the differ. Some real life customer configurations will be presented. Cloud and Datacenter Management MVP Dave Bermingham will lead this session and encourages you to bring your questions specific to your environment.

SessionID: 73171

Why Third Party Vendors Do The Things They Do

Back to calendar

Event Date: 17-03-2018 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Henry Treftz

Title: Why Third Party Vendors Do The Things They Do

Abstract:

Have you ever installed a third-party application that uses SQL Server, started to use it, and then wondered why does this feature behave this way or what the heck were they thinking when they did it this way.

I at one point was one of those people who designed, developed, and maintained databases for an ISV. This is my chance to explain and atone for my database sins and explain why some decisions seem like good ideas at the time and why some are forced upon an ISV.

This presentation has three main objectives:

Explain why vendors make the design, coding, and implementation decisions that they do;
Discuss how to make third-party applications run better in your environment;
Teach you how to work around those limitations and work with those vendors and get better support.

SessionID: 73321

Get Your Optimizer to Give up All Its Secrets

Back to calendar

Event Date: 17-03-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Get Your Optimizer to Give up All Its Secrets

Abstract:

You know that execution plans can provide you with vital information to tune a query, but just how does that plan get generated? In this session, we will examine details the query optimization process that are not very well known. We will discuss how SQL Server parses a T-SQL statement then and begins applying rules to make it more efficient. Did you know that SQL Server can be coaxed into outputting hidden structures such as parse trees and memos? We'll do just that, and then take it a step further with a unique visualization tool that I have created. With a better understanding of how SQL Server optimizes T-SQL (and sometimes doesn't do it as well as might be hoped), you can write more efficient SQL statements.

SessionID: 73686

Disaster Recovery Planning for Your Career and Your Life...There's No Certification For This

Back to calendar

Event Date: 17-03-2018 - Session time: 14:00:00 - Track: Professional Development

Speaker: Lynn Ballard

Title: Disaster Recovery Planning for Your Career and Your Life...There's No Certification For This

Abstract:

As DBAs, disaster recovery planning is one of the first things we learn. We have it planned and can execute it on a dime. But do you have a plan for when things go wrong in your life outside of databases? Some speakers might use the words resiliency and grit but those words aren't a concrete plan. Add in the fact that IT personnel have to constantly adapt and learn to keep their career current. So what do you, as a IT worker, need to do daily, weekly or monthly to build a life that can withstand or rebound from adversity? The presentation will focus on the career, financial and emotional supports that propel you during the best of times and help you survive layoffs, financial downturns or personal tragedies.

SessionID: 77321

Dynamic Data Flows in SSIS without Programming

Back to calendar

Event Date: 17-03-2018 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Diane Schuster

Title: Dynamic Data Flows in SSIS without Programming

Abstract:

This session is an introduction to the unique functionality offered by COZYROC to create integration packages that dynamically map columns at runtime.

The standard SSIS Data Flow Task can only use static metadata which is defined when the package is initially designed. The mapping of columns is configured and remains unchanged until the package is re-opened and design changes are made, thus costing maintenance time and effort.

Data Flow Task Plus extends the capabilities of the standard Microsoft Data Flow task in that it allows you to set up dynamic data flows, thus eliminating maintenance time and effort. Changes to tables and columns are automatically incorporated at runtime without the need to change and redeploy the package. Columns and fields are mapped automatically at runtime.

Furthermore, the initial design time and effort may be greatly reduced when dealing with huge amounts of data in a large number of files and/or databases.

SessionID: 77384

Advanced SQL Server on VMware Features

Back to calendar

Event Date: 17-03-2018 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Advanced SQL Server on VMware Features

Abstract:

The world's most powerful virtualization platform, VMware vSphere, contains a number of hidden gems that DBAs can use to make their SQL Servers more highly available and perform better. The demos in this session have been developed to illustrate a few key capabilities of VMware vSphere and VMware NSX that can be used to enhance the overall SQL Server implementation. Features such as vSphere vMotion, vSphere HA, Distributed Resource Scheduler and Fault Tolerance are complimentary to all the features and capabilities of SQL Server and create an unparalleled combination of the world’s top RDBMS and the world’s most complete and effective virtualization proposition. With network virtualization NSX can provide security enhancements unachievable with any other technology and can streamline SQL server deployment automation processes. Please join us for this demonstration of advanced vSphere and NSX feature functionality and an explanation as

SessionID: 70965

Reducing The Surface Area Of Risk in Data Security

Back to calendar

Event Date: 17-03-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Tim Gorman

Title: Reducing The Surface Area Of Risk in Data Security

Abstract:

Data obfuscation, also known as data masking, is soon a new legal requirement. Masking is the solution for non-production systems (i.e. DEV, TEST, etc) to greatly reduce the surface area of risk for data breach in your organization. Masking should not be confused with encryption, which is an appropriate solution for production applications. Those who believe that encryption solves all security problems are misled.

When done properly, masked data is not noticeable unless you look closely. Masking data well might still be usable for analytic reporting and aggregation, yet utterly useless for revealing confidential data. Masking is important enough that sophisticated software packages have become available.

Come learn about the right way to mask non-production data in order to allow the organization to limit possible exposure only to production. Learn what techniques can be used, why, and what factors should be considered when deciding to secure confidential data.

SessionID: 71038

Building a Dashboard in an Hour using PowerPivot Power BI

Back to calendar

Event Date: 17-03-2018 - Session time: 15:15:00 - Track: Analytics and Visualization

Speaker: Vazi Okhandiar

Title: Building a Dashboard in an Hour using PowerPivot Power BI

Abstract:

Demonstrate the steps to import raw data from text file and Excel file into Excel 2016, and then build a dashboard using PowerPivot and Power BI.

SessionID: 73197

Linked Servers – Purpose, Pitfalls and Performance Implications

Back to calendar

Event Date: 17-03-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Davis

Title: Linked Servers – Purpose, Pitfalls and Performance Implications

Abstract:

Using linked servers allows for queries across instances. While connected to Server A, you can query resources on Server B. Developers often love them. DBAs often hate them. Regardless of what side of the fence you are on, they are an important tool in the DBA toolbelt and you need to know how they can help and hurt you. Attend this session and learn linked servers' purpose, pitfalls, and performance implications.

SessionID: 73330

ORMs and the DBA: How to Make Both Happy

Back to calendar

Event Date: 17-03-2018 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Dan Mallott

Title: ORMs and the DBA: How to Make Both Happy

Abstract:

Talk to any DBA about ORMs and you'll quickly find out all the things you like about ORMs are what DBAs don't like. Interestingly enough, most developers I've talked to have issues with their ORMs, too. In this session, we'll explore why ORMs cause such trouble, some strategies for mitigating those troubles, and I'll introduce some tools (and even yet another ORM) that help solve some of the worst of the problems we see in the database when using ORMs.

SessionID: 73525

Relational Data Architecture 101

Back to calendar

Event Date: 17-03-2018 - Session time: 15:15:00 - Track: Application Database Development

Speaker: Pat Phelan

Title: Relational 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!

This presentation is a survey of Data Architecture for the Intermediate DBA, it is not intended for experienced Data Modelers.

SessionID: 73538

A DBA's guide to whole stack performance troubleshooting

Back to calendar

Event Date: 17-03-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Daniel Janik

Title: A DBA's guide to whole stack performance troubleshooting

Abstract:

Performance troubleshooting is a required skill for every DBA. Knowing the deep internals of how a query functions and why SQL Server chose to run it in a certain way is important. Knowing how to design a table or configure a database to squeeze every ounce of performance is our lifeblood.

What if I told you that you may be doing this all wrong? What if all the work and laborious effort put into design or configuration don't improve the situation because the issue was never in SQL to begin with? Truth be told, the biggest differentiator between a good DBA and a great DBA is knowing the hardware and O/S; not just SQL.

Join me as I guide you through troubleshooting SQL Server performance from tip to toe to demonstrate the common performance problems you never knew you had.

SessionID: 73725

Be the Next Great Speaker: The Complete Speaker Starter Kit

Back to calendar

Event Date: 17-03-2018 - Session time: 15:15:00 - Track: Professional Development

Speaker: Eddie Wuerch

Title: Be the Next Great Speaker: The Complete Speaker Starter Kit

Abstract:

Have you ever thought about speaking at a technical event or conference like SQLSaturday, but weren't quite sure how to get started? If so, this session was built for you! This session begins by walking you through the steps and tricks to nail down your topic and get it on the schedule at a conference. It follows with key tips for building and delivering an amazing session, all led by a veteran presenter of many regional, national, and international SQL Server conferences. Every speaker at this event started where you are now. If you’re ready to inspire, educate, and lead the discussion, then this session will provide the tools you need to start the next phase of your career!

SessionID: 74003

How to Keep Your Databases Secure in Just Minutes a Day

Back to calendar

Event Date: 17-03-2018 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Ed Leighton-Dick

Title: How to Keep Your Databases Secure in Just Minutes a Day

Abstract:

You’re busy. You don’t have time to check the security of your systems all the time, right? It’s not like anyone has added a user that you don’t know about. And no one would create a database and add all logins to the db_owner role. And of course, no one would ever think of setting the TRUSTWORTHY property on a database... right?

Things like that happen on a daily basis, poking holes in even the most well-secured database. Those holes are just waiting for someone to find them. That someone could be you, or it could be an attacker probing for a way to get data from your company.

In this session, we will explore how to create reports that are quick to review so you can find the holes before someone else does - without interfering with the rest of your day. Along the way, you'll also learn where to find security-related information in SQL Server's metadata and logs to allow you to customize and extend the reports to meet your company's unique needs.

SessionID: 77477

Azure Site Recovery and other Disaster Recovery Options for SQL S

Back to calendar

Event Date: 17-03-2018 - Session time: 15:15:00 - Track: Cloud Application Development Deployment

Speaker: David Bermingham

Title: Azure Site Recovery and other Disaster Recovery Options for SQL S

Abstract:

Microsoft Cloud and Datacenter Management MVP, David Bermingham reviews best practices for configuring cloud deployments of SQL Server for high availability and disaster recovery, including an in-depth look at Azure Site Recovery. Dave discusses a variety of configurations that companies are using to protect SQL while meeting their business requirements and provides key tips and insights on how to implement these configurations for best results.

SessionID: 77480

My Brain Has Blue Screened - Let's Laugh

Back to calendar

Event Date: 17-03-2018 - Session time: 15:15:00 - Track: Professional Development

Speaker: David Klee

Title: My Brain Has Blue Screened - Let's Laugh

Abstract:

This site is open source. Improve this page.