sqlsathistory

Nr: 548

Back to Main list

SQLSaturday #548 - Kansas City 2016

Start Time (24h) Speaker Track Title
08:30:00 Janis Griffin Enterprise Database Administration Deployment Top 10 Wait Types Everyone Should Know
08:30:00 Andy Galbraith Enterprise Database Administration Deployment Does it Hurt When I Do This? Performing a SQL Server Health Check
08:30:00 Chris Hyde Advanced Analysis Techniques SQL Server R Services in SQL 2016
08:30:00 Steve Wake BI Information Delivery Mobile, Paginated, KPIs and Power BI, Oh My! SSRS 2016 Reporting
08:30:00 Ben Weissman Biml Biml: Your 3D Printer for SSIS
08:30:00 George Bryant BI Platform Architecture, Development Administration So this is Power BI. What now?
08:30:00 Carlos L Chacon Enterprise Database Administration Deployment Disaster Recovery From On Premises to Azure
08:30:00 Frank Kearney BI Information Delivery Near real time analytics with Azure Stream Analytics
10:00:00 Erica Woods Professional Development Shaping Your Process to Hire Top Talent
10:00:00 Ameena Lalani Enterprise Database Administration Deployment What is new in SQL Server 2016 for DBAs?
10:00:00 William E Pearson III BI Platform Architecture, Development Administration Pragmatic Power BI: Transforming Data
10:00:00 Cher Fox Other Test Automation: Agile Enablement for DW and BI Teams
10:00:00 Melody Zacharias BI Information Delivery Introduction to Microsoft Analytics – Turning Data into Intelligent Action
10:00:00 Ben Weissman Biml Biml: I got the basics - what's next?
10:00:00 John Morehouse Enterprise Database Administration Deployment SQL Server Databaseology: A Deep Dive Into Database Internals
10:00:00 Wylie Blanchard Analytics and Visualization Analyze Visualize SQL Server Data w/ PowerPivot, PowerView Excel
12:45:00 Kevin Feasel Biml Data Migration Using BIML
12:45:00 Chase Aucoin Application Database Development Microdata For Microservices
12:45:00 Rie Irish Professional Development WIT: Identifying, Understanding and Combating Gender Bias
12:45:00 Bill Graziano Strategy and Architecture Building a Modern Transaction System on SQL Server
12:45:00 Adam Koehler Enterprise Database Administration Deployment Isolation Levels – Understanding Transaction Temper Tantrums
12:45:00 Jeremy Marx BI Platform Architecture, Development Administration Introduction to BIML and BimlScript
12:45:00 Bill Fellows Biml An Architect's Strategy for Consistent SSIS with SQL Server 2016
12:45:00 Chuck Hieber Other SQL Server Tips and Tricks from a lazy DBA
14:15:00 Monica Rathbun Professional Development I’m It – Survival Techniques for the Lone DBA
14:15:00 Kathi Kellenberger Enterprise Database Administration Deployment Kerberos Delegation Made Simple
14:15:00 David Maxwell Enterprise Database Administration Deployment Turbo Charged Transaction Logs - Internals and Performance
14:15:00 Brian Beswick BI Platform Architecture, Development Administration SSAS 2016 Tabular - Diving into the new features
14:15:00 Daniel Maenle Application Database Development Lock, Block, and Two Smoking CPUs
14:15:00 Brian Hansen Enterprise Database Administration Deployment Get Your Optimizer to Give up All Its Secrets
14:15:00 Pierre LaFromboise BI Platform Architecture, Development Administration Understanding Azure SQL Data Warehouse
14:15:00 Scott Currie Biml Incrementally Moving to the Cloud Using Biml
15:45:00 Wendy Pastrick Enterprise Database Administration Deployment Using SQL Nexus for system health
15:45:00 Ben DeBow Professional Development Troubleshooting Skills for the DBA
15:45:00 Michael Fal Enterprise Database Administration Deployment Powershell Jumpstart for SQL Server DBAs
15:45:00 Rob Volk Enterprise Database Administration Deployment Revenge: The SQL!
15:45:00 Ed Leighton-Dick Application Database Development Understanding SQL Server 2016 Always Encrypted
15:45:00 Dave Walden Enterprise Database Administration Deployment Your Data, in the Cloud
15:45:00 Reeves Smith BI Platform Architecture, Development Administration A New Approach to Unit and Integration Testing in SSIS
15:45:00 Andre DuBois Enterprise Database Administration Deployment Essential steps to ensure survivability of your SQL Server database
15:45:00 Jason Horner BI Platform Architecture, Development Administration Dimensional Modeling Design Patterns: Beyond the Basics

SessionID: 49102

Top 10 Wait Types Everyone Should Know

Back to calendar

Event Date: 24-09-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

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.

SessionID: 49229

Does it Hurt When I Do This? Performing a SQL Server Health Check

Back to calendar

Event Date: 24-09-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Andy Galbraith

Title: Does it Hurt When I Do This? Performing a SQL Server Health Check

Abstract:

How often do you review your SQL Servers for basic security, maintenance, and performance issues? Many of the servers I "inherit" as a managed services provider have quite a few gaping holes. It is not unusual to find databases that are never backed up, servers with constant login failures (is it an attack or a bad connection string?), and servers that need more RAM/CPU/etc. (or sometimes that even have too much!)

Come learn how to use freely available tools from multiple layers of the SQL Server stack to check your servers for basic issues like missing backups and CheckDB as well as for more advanced issues like page life expectancy problems and improper indexing. If you are responsible in any way for a Microsoft SQL Server (DBA, Windows Admin, even a Developer) you will see value in this session!

SessionID: 49655

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 24-09-2016 - Session time: 08:30:00 - Track: Advanced Analysis Techniques

Speaker: Chris Hyde

Title: SQL Server R Services in SQL 2016

Abstract:

One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with the brand-new SQL Server R Services. In this introductory session we'll briefly introduce the R language and then look at how to install and administer SQL Server R Services. We'll start to demonstrate the power of R by showing you how to create and run simple R scripts from within T-SQL. We'll then discuss some of the powerful open source packages that are available to aid your data analyses. Finally, we'll go through some examples of how to use R to integrate data analytical methods in real-world situations, and wow your customers with the power of statistics!

SessionID: 50076

Mobile, Paginated, KPIs and Power BI, Oh My! SSRS 2016 Reporting

Back to calendar

Event Date: 24-09-2016 - Session time: 08:30:00 - Track: BI Information Delivery

Speaker: Steve Wake

Title: Mobile, Paginated, KPIs and Power BI, Oh My! SSRS 2016 Reporting

Abstract:

SQL Server Reporting Services (SSRS) 2016 is getting the biggest update since SQL Server 2005! This session will define and demo each of the SSRS report types are and how they are developed and supported: Mobile, Paginated, KPIs and Power BI.

SessionID: 53116

Biml: Your 3D Printer for SSIS

Back to calendar

Event Date: 24-09-2016 - Session time: 08:30:00 - Track: Biml

Speaker: Ben Weissman

Title: Biml: Your 3D Printer for SSIS

Abstract:

In this demo-heavy session, you will learn about the basic concepts of increasing productivity by creating your SSIS packages using Biml.

We will look into manual Biml code to understand the general idea of Biml, then take it from there and generate a whole staging area from scratch and end with a complete manageable solution to completely maintain your staging process using SQL tables.

Have you ever spent hours fixing your SSIS due to a schema change on the source? Ever wanted to add a "load timestamp" to 370 tables in your staging area but refrained because it would have taken you weeks to do so? If so, this is the session for you!

SessionID: 53123

So this is Power BI. What now?

Back to calendar

Event Date: 24-09-2016 - Session time: 08:30:00 - Track: BI Platform Architecture, Development Administration

Speaker: George Bryant

Title: So this is Power BI. What now?

Abstract:

Everyone is talking about Power BI. People are starting to use and interact with Power BI. That is a good thing, Power BI is fun! As an organization however, what do I do now and how do I handle a periodically changing beast? Here is what to consider...

SessionID: 53232

Disaster Recovery From On Premises to Azure

Back to calendar

Event Date: 24-09-2016 - Session time: 08:30:00 - Track: Enterprise Database Administration Deployment

Speaker: Carlos L Chacon

Title: Disaster Recovery From On Premises to Azure

Abstract:

Recovery in the cloud is now easier and more convenient than ever. This session describes some common scenarios and reviews the steps needed to prepare for a disaster with a recovery in Azure. We will focus on the IAAS offerings.

SessionID: 53308

Near real time analytics with Azure Stream Analytics

Back to calendar

Event Date: 24-09-2016 - Session time: 08:30:00 - Track: BI Information Delivery

Speaker: Frank Kearney

Title: Near real time analytics with Azure Stream Analytics

Abstract:

As recently as 5 years ago, most companies could not afford the technology or did not possess the in-house skill sets needed to implement real-time analytics. At least not without involving a lot of money, a large development team and some duct tape. However, in the last few years, Microsoft has made this type of technology available at an affordable cost (and without the need of large dev team or duct tape) in the form of Azure Stream Analytics.

In this session we will review the architecture of Azure Stream Analytics, a walk through to implement this technology and a live demo with audience participation using PowerBI and Azure SQL Data Warehouse.

SessionID: 49029

Shaping Your Process to Hire Top Talent

Back to calendar

Event Date: 24-09-2016 - Session time: 10:00:00 - Track: Professional Development

Speaker: Erica Woods

Title: Shaping Your Process to Hire Top Talent

Abstract:

Hiring Managers and Employers run into various roadblocks when trying to identify, screen and attract quality candidates to join their teams. It’s frustrating when it takes considerable time to identify strong candidates, and also when you lose a quality candidate throughout the process. In this session, we’ll cover the top 5 reasons we’ve seen clients lose good candidates, provide a 6-step formula for a quality hiring process, highlight some primary motivators of technical candidates, how to write quality job descriptions, and 11 best practices for a strong interview process that both screens and attracts top talent!

SessionID: 52499

What is new in SQL Server 2016 for DBAs?

Back to calendar

Event Date: 24-09-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ameena Lalani

Title: What is new in SQL Server 2016 for DBAs?

Abstract:

This session will provide you with high level overview of several of the new features in SQL Server 2016.

It will cover Always Encrypted, PolyBase, Stretch Database and more. This is a high level session on advanced features of SQL Server 2016 so we will not be going deep into any one technology. The idea is to give you the taste of the new features of SQL Server 2016 and whatever spikes your interest, you can then go learn and test those features in your Dev environment.

SessionID: 52676

Pragmatic Power BI: Transforming Data

Back to calendar

Event Date: 24-09-2016 - Session time: 10:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: William E Pearson III

Title: Pragmatic Power BI: Transforming Data

Abstract:

Once we’ve extracted data from a source, we typically need to clean, or otherwise change, that data in preparation for loading it into Power BI. In this session, BI Architect, SQL Server MVP and Analysis Services Maestro Bill Pearson will explore the options Power BI offers to unpivot, filter, sort, aggregate, and perform other needed operations to make these preparations. We’ll employ a dataset containing issues that commonly present real-world challenges, and work through the steps we can take in Power BI to transform the data to a state that works within Power BI. Moreover, we’ll define calculations, and get a glimpse of the M language that underlies transformational processes we construct.

SessionID: 52727

Test Automation: Agile Enablement for DW and BI Teams

Back to calendar

Event Date: 24-09-2016 - Session time: 10:00:00 - Track: Other

Speaker: Cher Fox

Title: Test Automation: Agile Enablement for DW and BI Teams

Abstract:

SessionID: 52936

Introduction to Microsoft Analytics – Turning Data into Intelligent Action

Back to calendar

Event Date: 24-09-2016 - Session time: 10:00:00 - Track: BI Information Delivery

Speaker: Melody Zacharias

Title: Introduction to Microsoft Analytics – Turning Data into Intelligent Action

Abstract:

Data Science, Azure Machine Learning, and Analytics are all becoming core pieces to the success of every business. As data professionals we need to know how these will affect what we do, and how we can use it to help our business and clients. In this session we will take a look at these hot topics and learn how it helps us turn data into intelligence that will lead to actions that drive profits. We will take a look at how Microsoft’s Cortana suite is the central hub for learning and implementing each of these core pieces. An easy to follow example showing the flow from Data to Data Intelligence and thru to Action will be presented using Cortana Intelligence Suite.

SessionID: 53117

Biml: I got the basics - what's next?

Back to calendar

Event Date: 24-09-2016 - Session time: 10:00:00 - Track: Biml

Speaker: Ben Weissman

Title: Biml: I got the basics - what's next?

Abstract:

So you have made first contact with Biml and are excited? Good!

You're wondering, if Biml can do more than just transfer data from SQL table to another? Great!

Because Biml does so much more than just simple SSIS packages. We'll explore the potential on how to improve your existing packages using BimlScript and LINQ. Topics covered, amongst others, are derived columns, incremental changes and how to handle flat files.

You'll leave with sample code and hopefully a couple of ideas on how to bring your Biml development to the next level.

SessionID: 53165

SQL Server Databaseology: A Deep Dive Into Database Internals

Back to calendar

Event Date: 24-09-2016 - Session time: 10:00:00 - Track: Enterprise Database Administration Deployment

Speaker: John Morehouse

Title: SQL Server Databaseology: A Deep Dive Into Database Internals

Abstract:

Have you ever taken apart a toaster or an alarm clock just to see how it worked? Ever wondered how that database actually functions at the record level, behind the scenes? SQL Server Databaseology is the study of SQL Server databases and their structures down to the very core of the records themselves. In this session, we will explore some of the deep inner workings of a SQL Server database at the record and page level. You will walk away with a better understanding of how SQL Server stores data and that knowledge will allow you to build better, faster databases.

SessionID: 54387

Analyze Visualize SQL Server Data w/ PowerPivot, PowerView Excel

Back to calendar

Event Date: 24-09-2016 - Session time: 10:00:00 - Track: Analytics and Visualization

Speaker: Wylie Blanchard

Title: Analyze Visualize SQL Server Data w/ PowerPivot, PowerView Excel

Abstract:

Your end users want to analyze data in your data warehouse. They could deal with the learning curve of SSAS but they'd prefer to utilize a familiar application like MS Excel. Welcome PowerPivot, a tool that retrieves data from your data warehouse by combining the power of SSAS models and your SQL Server Data warehouse within the familiar interface of MS Excel. In this presentation well explore SSAS BI Semantic model, PowerView, PowerPivot in Excel.

SessionID: 49038

Data Migration Using BIML

Back to calendar

Event Date: 24-09-2016 - Session time: 12:45:00 - Track: Biml

Speaker: Kevin Feasel

Title: Data Migration Using BIML

Abstract:

Many companies scale out their databases horizontally, partitioning data by customer (or some other identifier) into separate databases or instances. Sometimes, it becomes important to move that data from one database to another. SQL Server Integration Services is a fantastic tool for ETL, but creating and maintaining dozens or hundreds of data flows by hand is exhaustingly tedious. Instead of doing it the hard way, use the BI Markup Language (BIML) to automate package development. This talk will show how we can use metadata tables and BIML to auto-create SSIS packages to migrate data from one database to another, handling foreign key constraints along the way.

SessionID: 50279

Microdata For Microservices

Back to calendar

Event Date: 24-09-2016 - Session time: 12:45:00 - Track: Application Database Development

Speaker: Chase Aucoin

Title: Microdata For Microservices

Abstract:

Applications continue to get more complicated and distributed as inexpensive hardware becomes more and more ubiquitous. Currently the trend is to lead more towards a microservice paradigm when ti comes to large scale application development.

The missing piece of the puzzle for most companies when it comes to micro services is "How does data fit in?" I hope to answer that question and give you and your organization some strategies on handling massive amounts of data and massive amounts of productivity in a highly concurrent/maintainable way.

SessionID: 51212

WIT: Identifying, Understanding and Combating Gender Bias

Back to calendar

Event Date: 24-09-2016 - Session time: 12:45:00 - Track: Professional Development

Speaker: Rie Irish

Title: WIT: Identifying, Understanding and Combating Gender Bias

Abstract:

Gender Bias is something we're all guilty of. It's typically unconscious and often stems from long held misperceptions about women and job responsibilities. We'll learn about the origins of some of these biases and how to identify gender bias when we see it. We'll discuss some strategies for how both men and women can combat this at work and in our every day lives. This session is about developing positive solutions to a problem that often goes undiscussed.

SessionID: 52597

Building a Modern Transaction System on SQL Server

Back to calendar

Event Date: 24-09-2016 - Session time: 12:45:00 - Track: Strategy and Architecture

Speaker: Bill Graziano

Title: Building a Modern Transaction System on SQL Server

Abstract:

Developers today face an onslaught of data storage applications. Various NoSQL offerings promise performance, scalability and easy development on commodity boxes. How does one get these benefits in SQL Server? What does a SQL Server application built today using the newest features and best practices look like? This session will discuss client applications, new SQL Server features and application architectures to support a modern, high-throughput transaction environments.

SessionID: 52883

Isolation Levels – Understanding Transaction Temper Tantrums

Back to calendar

Event Date: 24-09-2016 - Session time: 12:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Adam Koehler

Title: Isolation Levels – Understanding Transaction Temper Tantrums

Abstract:

In this session we will review Isolation levels and how they affect applications that run on SQL Server. We will explore what happens when multiple applications accessing the same data use different isolation levels, and how that effects the server as a whole. We will also explore different ways to relieve these tantrums, and make your applications play nice together.

SessionID: 53000

Introduction to BIML and BimlScript

Back to calendar

Event Date: 24-09-2016 - Session time: 12:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jeremy Marx

Title: Introduction to BIML and BimlScript

Abstract:

You have a lot of data to move and a lot of pieces to manage. Perhaps you're a developer and know that SSIS is the best way to move it, but you naturally dislike GUI-based development or you're just not looking forward to the tedium.

Or perhaps you're a team lead/architect and are looking for an efficient platform that best utilizes the development skills of your team.

Jeremy Marx will introduce BIML, a language you can quickly pick up to develop SSIS solutions with code, and BIMLscript, intelligently mixing in C# to make your BIML practically build itself.

Jeremy will demonstrate how to build a simple, single-table SSIS package using BIML, then extend it to many tables with just a few lines of code, and finally apply a more robust data flow designed for reuse. You'll leave with tools and resources to begin coding SSIS solutions faster and more efficiently.

SessionID: 53167

An Architect's Strategy for Consistent SSIS with SQL Server 2016

Back to calendar

Event Date: 24-09-2016 - Session time: 12:45:00 - Track: Biml

Speaker: Bill Fellows

Title: An Architect's Strategy for Consistent SSIS with SQL Server 2016

Abstract:

Now that you've developed solid patterns for SSIS, how do you communicate that to your junior team members? How do you ensure they are following your practices? Let's look at what SQL Server 2016 has to offer the busy architect. We'll address some basic recipes for SSIS and how innocuous deviations from that pattern can lead to disastrous results. With fear fresh in your minds, we'll then cover the great new features like Control Flow Templates. Finally, we'll look at other systematic approaches for standardizing solution development.

SessionID: 53314

SQL Server Tips and Tricks from a lazy DBA

Back to calendar

Event Date: 24-09-2016 - Session time: 12:45:00 - Track: Other

Speaker: Chuck Hieber

Title: SQL Server Tips and Tricks from a lazy DBA

Abstract:

Good managers believe lazy people don't accomplish much. Great managers realize that a lot of lazy people get their work done, just more efficiently. The right lazy person will find YOU a better way to accomplish the same amount.

In this session, I will show you several of the tips and tricks I have picked up and use to make my life easier. From keyboard shortcuts to some lesser-known SSMS built-in tools, I hope to make your life easier, and make you a lazy DBA, too!

SessionID: 49099

I’m It – Survival Techniques for the Lone DBA

Back to calendar

Event Date: 24-09-2016 - Session time: 14:15:00 - Track: Professional Development

Speaker: Monica Rathbun

Title: I’m It – Survival Techniques for the Lone DBA

Abstract:

Are you the only database person at your company? Are you both the DBA and the Developer? Being the only data professional in an environment can seem overwhelming, daunting, and darn near impossible sometimes. However, it can also be extremely rewarding and empowering. This session will cover how you can keep your sanity, get stuff done, and still love your job. We’ll cover how I have survived and thrived being a Lone DBA for 15 years and how you can too. When you finish this session, you’ll know what you can do to make your job easier, where to find help, and how to still be able to advance and enrich your career.

SessionID: 49145

Kerberos Delegation Made Simple

Back to calendar

Event Date: 24-09-2016 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Kathi Kellenberger

Title: Kerberos Delegation Made Simple

Abstract:

Kerberos delegation is often needed for SQL Server Reporting Services security. Many DBAs avoid Kerberos because of the complexity and come up with workarounds that may violate security policies in their shops. They also may not understand why Kerberos delegation is even required.

Configuring Kerberos for SSRS can be broken down into three simple steps: SPN registration, setting delegation properties, and application configuration. It’s really not so difficult, and there are a number of tools that can help you troubleshoot when things don’t go as planned. Attend this session to learn why Kerberos is necessary and how to configure and troubleshoot it.

SessionID: 49408

Turbo Charged Transaction Logs - Internals and Performance

Back to calendar

Event Date: 24-09-2016 - Session time: 14:15:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Turbo Charged Transaction Logs - Internals and Performance

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 what information is actually stored in the log. You'll learn how to optimize the log's performance, determining the right settings for log growth, and what to do when things get out of control.

SessionID: 50001

SSAS 2016 Tabular - Diving into the new features

Back to calendar

Event Date: 24-09-2016 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Brian Beswick

Title: SSAS 2016 Tabular - Diving into the new features

Abstract:

Taking a looking at all the new features of SSAS 2016 Tabular, how to use them effectively and avoid pitfalls. Features include Bi-Directional Cross Filtering, Parallel Partition Processing, Calculated Tables, etc.

SessionID: 52670

Lock, Block, and Two Smoking CPUs

Back to calendar

Event Date: 24-09-2016 - Session time: 14:15:00 - Track: Application Database Development

Speaker: Daniel Maenle

Title: Lock, Block, and Two Smoking CPUs

Abstract:

This is a talk on my own experience rewriting the locking mechanism that my company has used. Migrating from a locking table to using sp_getapplock. The ups and downs that I experienced in the transition.

Also to talk about how this can be a great streamline and better performing approach to gaining locks that could be used by the application or other queries.

SessionID: 53269

Get Your Optimizer to Give up All Its Secrets

Back to calendar

Event Date: 24-09-2016 - Session time: 14:15: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: 53303

Understanding Azure SQL Data Warehouse

Back to calendar

Event Date: 24-09-2016 - Session time: 14:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Pierre LaFromboise

Title: Understanding Azure SQL Data Warehouse

Abstract:

Microsoft recently announced general availability of Azure SQL Data Warehouse, a massively parallel processing elastic data warehouse platform in the cloud. In this session we will provide an overview of the fundamental technology behind Azure SQL Data Warehouse, talk about its origins, discus its future, compare it to alternative products, and discuss best practices for implementation.

SessionID: 53339

Incrementally Moving to the Cloud Using Biml

Back to calendar

Event Date: 24-09-2016 - Session time: 14:15:00 - Track: Biml

Speaker: Scott Currie

Title: Incrementally Moving to the Cloud Using Biml

Abstract:

Many organizations are interested in the cost savings, ease of maintenance, and other benefits of hosting data solutions on Microsoft Azure. For most, moving to the cloud is easier said than done, especially when they have a large existing solution that is being actively used by stakeholders.

In this session, we will examine various strategies for incrementally moving your solution to the cloud. This will include strategies that incorporate the use of:

  1. New value-added features and services, such as machine learning and big data
  2. Hybrid approaches where portions of your existing solutions can be moved to the cloud without requiring everything to be moved
  3. Failover and surge approaches that enable the cloud to supplement on premises resources
  4. and much more

Business Intelligence Markup Language (Biml) will be central to our approach, enabling the rapid movement of assets back and forth between on premises and cloud hosting.

All code will be shared with attendees.

SessionID: 49026

Using SQL Nexus for system health

Back to calendar

Event Date: 24-09-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Wendy Pastrick

Title: Using SQL Nexus for system health

Abstract:

How do you determine a root cause of failure in your database server? What do you do with stack dump data and other logging you may be collecting? What do you do if you don't have a 3rd party tool to diagnose issues? Take a look at SQL Nexus, the latest tool for SQL Server aimed at making you a Rockstar DBA! We will cover setup, collection and analysis of the data.

SessionID: 50697

Troubleshooting Skills for the DBA

Back to calendar

Event Date: 24-09-2016 - Session time: 15:45:00 - Track: Professional Development

Speaker: Ben DeBow

Title: Troubleshooting Skills for the DBA

Abstract:

Watching someone who is good at troubleshooting complex issues is like watching a magician perform on stage. It looks easy but unless you have the skills and know the trick, it can be black magic to you. Many DBAs and technology professionals can easily look in Books Online to find an answer to a technical question or how a SQL Server feature works. But where do you look on how you would become a better DBA at troubleshooting issues? How do you do you identify the root cause of the issue? This session will cover different approaches and skills to be a more efficient problem solver which is critical when your production system is down and time is money. The session will also cover how to create and present the root cause analysis so your team can learn from the mistakes and fix the issue.

SessionID: 52513

Powershell Jumpstart for SQL Server DBAs

Back to calendar

Event Date: 24-09-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Michael Fal

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.

SessionID: 52995

Revenge: The SQL!

Back to calendar

Event Date: 24-09-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Rob Volk

Title: Revenge: The SQL!

Abstract:

Pop quiz DBA: Your developers are running rampant in production. Logic, reason, and threats have all failed. You're on the edge. What do you do? WHAT DO YOU DO?

Hint: You attend Revenge: The SQL!

This session will show you how to "correct" all those bad practices. Everyone logging in as sa? Running huge cursors? Using SELECT * and ad-hoc SQL? Stop them dead, without actually killing them. Ever dropped a table, or database, or WHERE clause? You can prevent that! And if you’re tired of folks ignoring your naming conventions, make them behave with Unicode…and take your revenge!

Revenge: The SQL! is fun and educational and may even have some practical use, but you’ll want to attend simply to indulge your Dark Side. Revenge: The SQL! assumes no liability and is not available in all 50 states. Do not taunt Revenge: The SQL! or Happy Fun Ball.

SessionID: 53017

Understanding SQL Server 2016 Always Encrypted

Back to calendar

Event Date: 24-09-2016 - Session time: 15:45:00 - Track: Application Database Development

Speaker: Ed Leighton-Dick

Title: Understanding SQL Server 2016 Always Encrypted

Abstract:

Always Encrypted is a highly-touted new feature of SQL Server 2016 that promises to make encryption simple to use and transparent to applications while still protecting the data both at rest and in motion, even from high-privilege users such as developers and DBAs. Does that sound too good to be true? It isn’t - Always Encrypted is an incredible feature - but like any new technology, it does have some limitations. In this session, you’ll see how to configure Always Encrypted, and we’ll talk about when you should and shouldn’t use it in your environment.

SessionID: 53268

Your Data, in the Cloud

Back to calendar

Event Date: 24-09-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Walden

Title: Your Data, in the Cloud

Abstract:

We will talk about cloud-only and hybrid cloud features of SQL Server 2016 and Azure.

This session will include introductions to technologies such as Azure AlwaysOn AG replicas, Stretch Database, PolyBase, Azure Data Warehouse, HDInsight and Azure Data Lake. We will cover practical uses for features, and discuss migrating existing applications to Azure. We will also touch upon methods that can be used to secure your data in the cloud, too

SessionID: 53316

A New Approach to Unit and Integration Testing in SSIS

Back to calendar

Event Date: 24-09-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Reeves Smith

Title: A New Approach to Unit and Integration Testing in SSIS

Abstract:

Testing is a critical part of the release process and vital to a high-quality data management lifecycle. Unfortunately, Integration Services (SSIS) does not have built-in support for testing and the tools for relational database testing are limited. As a result, most organizations forgo automated testing and focus entirely on manual user testing, which is both expensive and often occurs too late in the process to address all of the issues discovered.

In this session, a new approach to unit testing (focusing on verifying the correctness of individual packages, tasks, or dataflows) and integration testing (focusing on validating that the data produced by an entire sequence of transformations) will be discussed. This development pattern uses metadata authored by analysts to automatically generate testing logic within the corresponding packages or to automatically generate standalone test packages that contain all of the necessary validation logic.

SessionID: 53360

Essential steps to ensure survivability of your SQL Server database

Back to calendar

Event Date: 24-09-2016 - Session time: 15:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Andre DuBois

Title: Essential steps to ensure survivability of your SQL Server database

Abstract:

Survivability of data should be the #1 priority for any database administrator. Corruption can happen to any database at any time. How soon corruption is detected and a quick response is key to minimize lost data and recovery in a timely manner. Have a plan ready when it happens, as this is one time you don’t want to “learn on the job”. In addition to daily and monthly maintenance that should be performed, other topics discussed will include e-mail notification when data becomes corrupt and Service Level Agreements.

SessionID: 54546

Dimensional Modeling Design Patterns: Beyond the Basics

Back to calendar

Event Date: 24-09-2016 - Session time: 15:45:00 - Track: BI Platform Architecture, Development Administration

Speaker: Jason Horner

Title: Dimensional Modeling Design Patterns: Beyond the Basics

Abstract:

Dimensional modeling is one of cornerstones of successful Business Intelligence initiatives. Even with new technologies like PowerPivot and Analysis Services Tabular models, you need to represent your organization’s data in a way that is accessible for end users and IT staff alike. An effective dimensional model will also ensure that your data warehouse or data mart will be responsive and capable of accommodating emerging requirements.

In this session, we will dive deeper into the art of dimensional modeling. We will look at how and when to create the different types of fact and dimension tables, Including patterns for enriching dimensional data, creating usable hierarchies for efficient navigation, and tracking historical changes. After attending this session you will be able to confidently assess the quality of your organization’s dimensional model and recommend and implement changes. Bring your toughest quandaries to help make this an interactive and engaging session.

This site is open source. Improve this page.