sqlsathistory

Nr: 553

Back to Main list

SQLSaturday #553 - Oklahoma City 2016

Start Time (24h) Speaker Track Title
08:30:00 Shawn Weisfeld Cloud Application Development Deployment Scale out SQL Server PaaS in Azure Elastically
08:30:00 Bob Ward Enterprise Database Administration Deployment SQL Server 2016: It Just Runs Faster
08:30:00 Bala Shankar Cloud Application Development Deployment Deploy SQL Server with Microsoft Azure Virtual Machine
08:30:00 Jeremy Marx BI Platform Architecture, Development Administration Introduction to BIML and BimlScript
08:30:00 Jennifer McCown Application Database Development T-SQL's Hidden Support Feature
09:45:00 Ben Miller Enterprise Database Administration Deployment PoShDBA: Practical PowerShell for the DBA
09:45:00 Bob Ward Enterprise Database Administration Deployment Inside the SQL Server Query Store
09:45:00 Brian Hansen Enterprise Database Administration Deployment Get Your Optimizer to Give up All Its Secrets
09:45:00 Simon Cho BI Platform Architecture, Development Administration Build ETL efficiently (10x) with Minimal Logging
09:45:00 Kenneth Fisher Application Database Development Accidental DBA Dev Edition
11:15:00 William Barnes Other Lunch
11:15:00 William Barnes Other EMC - Maximizing Microsoft SQL Server Storage Investments
11:15:00 William Barnes Other Microsoft
11:15:00 William Barnes Other Techlahoma
12:45:00 Ryan Casey BI Platform Architecture, Development Administration Create a Data Loading Strategy
12:45:00 Tim Mitchell BI Platform Architecture, Development Administration Testing SSIS Packages
12:45:00 Kevin Boles Application Database Development Unit Testing SQL Server
12:45:00 Jennifer McCown Application Database Development Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos
12:45:00 Tim Costello BI Platform Architecture, Development Administration TARDIS: Time And Relative Dimensions in SQL!
14:00:00 Tim Mitchell BI Platform Architecture, Development Administration Are There Time Bombs in your SSIS Packages?
14:00:00 Kevin Boles Application Database Development Know What Your Code is Doing to SQL Server!
14:00:00 Ben Miller Enterprise Database Administration Deployment Administering SQL Server on Server Core with PowerShell
14:00:00 Daniel Janik Advanced Analysis Techniques Analyze your query plan like a Microsoft Engineer! (SQL 2016 Edition)
14:00:00 Chris Hyde Analytics and Visualization SQL Server R Services in SQL 2016
15:15:00 Amy Herold Enterprise Database Administration Deployment Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks
15:15:00 Matthew Brimer Strategy and Architecture Intro Data Warehousing for the DBA\Dev: From “Stupid Data" to Star Schema
15:15:00 Rudy Rodarte BI Information Delivery SQL Server Reporting Services - Zero to Automated Reports Today!
15:15:00 Sean McCown Enterprise Database Administration Deployment Loading SQL Server Data with Powershell
15:15:00 David Stein BI Platform Architecture, Development Administration SSIS Performance Tuning with Biml

SessionID: 49765

Scale out SQL Server PaaS in Azure Elastically

Back to calendar

Event Date: 27-08-2016 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Shawn Weisfeld

Title: Scale out SQL Server PaaS in Azure Elastically

Abstract:

You have heard all the hype how the cloud can help you scale your databases horizontally, providing you limitless capacity, but how do you do that? In this presentation we will take a look at the Elastic Database tools. We will focus on the key use cases for shard map management, data dependent routing and multi-shard querying.

SessionID: 51042

SQL Server 2016: It Just Runs Faster

Back to calendar

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

Speaker: Bob Ward

Title: SQL Server 2016: It Just Runs Faster

Abstract:

Join me in taking a deep dive and a behind the scenes look at how SQL Server 2016 ‘It Just Runs Faster’, focused on scalability and performance enhancements. This talk will discuss the improvements, not only for awareness, but expose design and internal change details. The beauty behind ‘It Just Runs Faster’ is your ability to just upgrade, in place, and take advantage without lengthy and costly application or infrastructure changes. If you are looking at why SQL Server 2016 makes sense for your business, you won't want to miss this session.

SessionID: 51146

Deploy SQL Server with Microsoft Azure Virtual Machine

Back to calendar

Event Date: 27-08-2016 - Session time: 08:30:00 - Track: Cloud Application Development Deployment

Speaker: Bala Shankar

Title: Deploy SQL Server with Microsoft Azure Virtual Machine

Abstract:

Microsoft Azure provides multiple options to migrate SQL Server to the Cloud. But migrating SQL Server requires good understanding of the different options and the constraints. This session focuses on Microsoft Cloud option for SQL Server, how to deploy SQL Server on Azure Virtual Machine, how SQL Licensing works on Azure Virtual Machine, deploying Alwayson AG and Hybrid Cloud Scenarios.

SessionID: 52998

Introduction to BIML and BimlScript

Back to calendar

Event Date: 27-08-2016 - Session time: 08:30: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: 53049

T-SQL's Hidden Support Feature

Back to calendar

Event Date: 27-08-2016 - Session time: 08:30:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: T-SQL's Hidden Support Feature

Abstract:

The most effective T-SQL support feature comes installed with every edition of SQL Server, is enabled by default, and costs no overhead. Yet, the vast majority of database administrator underutilize or completely neglect it. That feature's name is "comments".

#160; In this session, Microsoft Certified Master Jennifer McCown will demonstrate the various commenting methods that make code supportable. Attendees will#160;learn what’s important in a header comment, use code blocking to edit code, build a comprehensive help system, and explore alternative comment methods in stored procedures, SSIS packages, SSRS reports, and beyond.#160; These methods help prevent errors and reduce troubleshooting.

SessionID: 50343

PoShDBA: Practical PowerShell for the DBA

Back to calendar

Event Date: 27-08-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Miller

Title: PoShDBA: Practical PowerShell for the DBA

Abstract:

This session will cover real world functions that are used for real DBA work. There will be a few slides but mostly demos with actual scripts to help you do your job. I will also introduce some outside modules created to assist as well. Things like Reading/Changing the following: Permissions, DB Owner maintenance and database space management. We all could use a few standard things in our DBA world of ever changing roles and "I have to have it now" stuff, that Management Studio can get in the way of getting it done faster. Join me for a fun PowerShell hour and never try to reuse a click again.

SessionID: 51041

Inside the SQL Server Query Store

Back to calendar

Event Date: 27-08-2016 - Session time: 09:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Bob Ward

Title: Inside the SQL Server Query Store

Abstract:

In this session you will understand how the SQL Server Query Store can be used to take you to the next level for query performance monitoring, tuning, and troubleshooting. You will see how the Query Store works, what its capabilities are, and even how to troubleshoot when problems occur with its execution. There will be plenty of demos in this session covering both SQL Server 2016 and Azure SQL Database scenarios/

SessionID: 52364

Get Your Optimizer to Give up All Its Secrets

Back to calendar

Event Date: 27-08-2016 - Session time: 09:45: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: 52452

Build ETL efficiently (10x) with Minimal Logging

Back to calendar

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

Speaker: Simon Cho

Title: Build ETL efficiently (10x) with Minimal Logging

Abstract:

This session is designed to teach DBAs and developers the best strategy to transfer large data.

We will first analyze how data gets accessed from the source and how data gets updated or inserted to the target server: index access patterns in read operation and minimal logging in wring operation. I will introduce TF610 and cover its benefit for minimal logging even in full recovery mode.

SessionID: 52641

Accidental DBA Dev Edition

Back to calendar

Event Date: 27-08-2016 - Session time: 09:45:00 - Track: Application Database Development

Speaker: Kenneth Fisher

Title: Accidental DBA Dev Edition

Abstract:

There is a steep learning curve moving from a traditional application development role into writing database code. Your experience is telling you one thing and the DBAs are telling you another. Making sense of what's going on can be quite a struggle. Join me and let's try to smooth out some of the biggest points of confusion. Including subjects like, the anatomy of a table, what's up with NULLs, why should I be cautious with functions, and how can I start tuning my queries.

SessionID: 53963

Lunch

Back to calendar

Event Date: 27-08-2016 - Session time: 11:15:00 - Track: Other

Speaker: William Barnes

Title: Lunch

Abstract:

none

SessionID: 53964

EMC - Maximizing Microsoft SQL Server Storage Investments

Back to calendar

Event Date: 27-08-2016 - Session time: 11:15:00 - Track: Other

Speaker: William Barnes

Title: EMC - Maximizing Microsoft SQL Server Storage Investments

Abstract:

Bradly Crowe will be presenting for EMC on the below Abstract:

2016 is the year of All-Flash for primary storage and EMC’s industry leading portfolio of All-Flash arrays unlock the speed, efficiency, and agility that your business stakeholders have been demanding. Whether supporting 1,000 or 10,000,000 IOPS, EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type.

Beyond just production database performance, EMC provides robust database repurposing via our iCDM or Integrated Copy Data Management capabilities. Creating and maintaining test/dev, near real-time analytic, or sandbox environments has never been simpler. Join us and hear how we can address the needs of all of your Microsoft SQL Server instances.

SessionID: 53965

Microsoft

Back to calendar

Event Date: 27-08-2016 - Session time: 11:15:00 - Track: Other

Speaker: William Barnes

Title: Microsoft

Abstract:

Lunch Sponsor Session

SessionID: 53966

Techlahoma

Back to calendar

Event Date: 27-08-2016 - Session time: 11:15:00 - Track: Other

Speaker: William Barnes

Title: Techlahoma

Abstract:

Lunch Sponsor Session

SessionID: 49759

Create a Data Loading Strategy

Back to calendar

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

Speaker: Ryan Casey

Title: Create a Data Loading Strategy

Abstract:

Loading large amounts of data into SQL Server can be challenging. Many factors may challenge your goal for tuned performance. To make the decision making process more difficult, many of the choices listed below have both Pros and Cons to their implementation. For this reason, bulk loading large amounts of data requires a strategy.

Create a strategy to optimize your massive data loading processes. • High Performance Data Loading • Minimal Logging and Bulk Loading • Indexing Considerations • Delayed Durability • Eager Write

This session uses a Virtual Sandbox to demonstrate “real” data loads using these techniques listed above. We will look at the T-SQL used in these data loads. We will briefly discuss how the different settings and configurations effect the data loads. Power Point slides and sample SQL will be provided.

SessionID: 49837

Testing SSIS Packages

Back to calendar

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

Speaker: Tim Mitchell

Title: Testing SSIS Packages

Abstract:

Senior developer: “How do you test your code?” Junior developer: “I compile it.” It’s an old joke, but too often this reflects the reality of testing. If the code compiles, it has passed its test. Sadly, this principle is sometimes applied to Extract-Transform-Load (ETL) processes as well: “When the SSIS package runs without error, testing is complete.”

As in software development, testing of SQL Server Integration Services (SSIS) packages should not end at when the package executes successfully. You must also confirm that the package does what it was intended to do without placing an undue performance burden on the system.

This session walks through design patterns for testing SSIS packages during and after the development process. The session covers topics such as these:

SessionID: 50410

Unit Testing SQL Server

Back to calendar

Event Date: 27-08-2016 - Session time: 12:45:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Unit Testing SQL Server

Abstract:

In the nearly 20 years I have been working with SQL Server, most of that as an independent consultant, I can count on two hands the number of clients I have come across that had ANY database tests constructed. I can count on TWO FINGERS the number of them that had repeatable database tests. Even the most ardent Agile/Scrum/pick-your-new-and-shiny-development-mantra shops hardly ever do anything more than wave a magic wand at testing the database, because it can be REALLY HARD to do and do correctly. In this session we will cover examples of why repeatable database testing is CRITICALLY important and then examine both a free and a low-cost commercial product to ease the pain and improve developer efficiency.

SessionID: 50683

Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos

Back to calendar

Event Date: 27-08-2016 - Session time: 12:45:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: Unraveling Tangled Code:A Spellbinding Tale of Victory Over Chaos

Abstract:

Once upon a time, you inherited an application or a database that was filled with chaos and inconsistencies. The T-SQL code is overly complex and impossible to ken. The architecture is painful to behold, and grueling to code for. One might optimistically say that query performance is “spectacularly mediocre”. If you’re without good documentation or system architects to guide you, how do you break the curse of confusion? In this session you’ll learn several methods for conquering chaotic code, and how to seek and destroy some of the nastier coding mistakes and inefficiencies. We will break complicated queries into key pieces, turn them upside-down, and reform them into something sensible. We will vanquish major issues like data abuse and index negligence. We will restructure joins and tame subqueries. We will emerge victorious!

SessionID: 51101

TARDIS: Time And Relative Dimensions in SQL!

Back to calendar

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

Speaker: Tim Costello

Title: TARDIS: Time And Relative Dimensions in SQL!

Abstract:

In this session, you'll learn why you need a date table, how to build one and how to use one. We'll look at a couple common uses for date tables and explore how to get the most of them!

SessionID: 49832

Are There Time Bombs in your SSIS Packages?

Back to calendar

Event Date: 27-08-2016 - Session time: 14:00:00 - Track: BI Platform Architecture, Development Administration

Speaker: Tim Mitchell

Title: Are There Time Bombs in your SSIS Packages?

Abstract:

Could your seemingly-normal SSIS package be hiding a disaster, waiting to detonate at the most inconvenient time? Integration Services is an incredibly flexible product, and that flexibility can lead to good - and occasionally bad - design patterns. Small and seemingly trivial design decisions can lead to big issues down the road, including leaky data flows, data quality issues, paralyzing performance issues, and other explosive behaviors.

In this session, we will explore some of the most common SSIS design patterns that are potentially more harmful than they first appear. From package configuration to control flow constraints, and data flow transformations to logging, we'll demonstrate what can go wrong and show some alternative designs to prevent these types of problems from developing into bigger issues.

SessionID: 50408

Know What Your Code is Doing to SQL Server!

Back to calendar

Event Date: 27-08-2016 - Session time: 14:00:00 - Track: Application Database Development

Speaker: Kevin Boles

Title: Know What Your Code is Doing to SQL Server!

Abstract:

ORMs - oh how I LOVE them! As a consultant when I see them in play at a client I go KACHIIINNNNGGGG!! :-D Seriously though, they can provide some substantial benefits for coding throughput. But if you don't Read The Fine Manual and do some things right and avoid some major gotchas you will fall prey to one of my favorite Guruisms: "Anything that allows developers to slap code together more quickly is inversely proportional to the performance and scalability you will get from that code"! Although this talk is based on Entity Framework, most ORMs suffer from a lot of the same flaws.

SessionID: 50651

Administering SQL Server on Server Core with PowerShell

Back to calendar

Event Date: 27-08-2016 - Session time: 14:00:00 - Track: Enterprise Database Administration Deployment

Speaker: Ben Miller

Title: Administering SQL Server on Server Core with PowerShell

Abstract:

Ever wondered what the craze of Server Core is all about? There is a lot of power in Core and with it comes the admin challenge of NO GUI. But there are settings that you want to change in the OS, how do you do that? This session will take you through some of the challenges that are not really challenges when you know. We will use the builtin method of making some changes and also use PowerShell and commandline tools to get you where you want to be with Core. I built a 6 node cluster on Server Core and created it with PowerShell (Cluster and all) and it runs very nicely with a little footprint in RAM for the effort.

SessionID: 51161

Analyze your query plan like a Microsoft Engineer! (SQL 2016 Edition)

Back to calendar

Event Date: 27-08-2016 - Session time: 14:00:00 - Track: Advanced Analysis Techniques

Speaker: Daniel Janik

Title: Analyze your query plan like a Microsoft Engineer! (SQL 2016 Edition)

Abstract:

This session is a deep dive into query plans and is presented by a former Microsoft PFE (Field Engineer). Learn how a Microsoft Engineer looks at plans and go beyond the typical! There will be plenty of demos and a lot to learn. Join me as I cover the "noteworthy" query plan patterns that go beyond the normal areas that customer tend to investigate. This session covers SQL Server 2005 forward and includes the new SQL Server 2016 Query Store and Live Query Statistics.

SessionID: 52690

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 27-08-2016 - Session time: 14:00:00 - Track: Analytics and Visualization

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: 50668

Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Back to calendar

Event Date: 27-08-2016 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Amy Herold

Title: Deadlock, Block Two Smoking Barrels: Breaking Down Blocking and Deadlocks

Abstract:

While blocking and deadlocks are part of the territory for a DBA, dealing with them can be another story. In this session we will break down locking types, capturing and identifying deadlocks and the code behind them, and things you can do to resolve and prevent blocking and deadlocks. If you are frequently dealing with deadlocks in your databases this session is for you.

SessionID: 51046

Intro Data Warehousing for the DBA\Dev: From “Stupid Data" to Star Schema

Back to calendar

Event Date: 27-08-2016 - Session time: 15:15:00 - Track: Strategy and Architecture

Speaker: Matthew Brimer

Title: Intro Data Warehousing for the DBA\Dev: From “Stupid Data" to Star Schema

Abstract:

Data Warehouses are expensive, right? I mean, companies charge hundreds of thousands of dollars to build them for you. We all know the hardest part is just getting started, in this session we will talk about general dimensional design, how to start modeling your schemas, and by the end of this session you will have built your first star schema.

SessionID: 52694

SQL Server Reporting Services - Zero to Automated Reports Today!

Back to calendar

Event Date: 27-08-2016 - Session time: 15:15:00 - Track: BI Information Delivery

Speaker: Rudy Rodarte

Title: SQL Server Reporting Services - Zero to Automated Reports Today!

Abstract:

Perhaps you've heard about the power of SQL Server Reporting Services. Or, you have created some basic reports and you're ready to automate delivery. If so, this session is for you. You'll learn how to create your first SSRS report using Business Intelligence Design Studio (BIDS) and deliver reports to the business automatically in under an hour.

SessionID: 52771

Loading SQL Server Data with Powershell

Back to calendar

Event Date: 27-08-2016 - Session time: 15:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Sean McCown

Title: Loading SQL Server Data with Powershell

Abstract:

Powershell has become the defacto standard for scripting Microsoft products. However, putting data in text files doesn’t scale. Here I’m going to show you the ins and outs of loading data into SQL Server using Powershell for the purpose of centralizing collections. We’re going to cover RBAR as well as bulk operations and the types of things you need to take into consideration in an enterprise setting. This is a no holds barred session taught by an enterprise SQL Server scripting expert. You can’t afford to miss this session if you do any level of scripting in your shop.

SessionID: 52775

SSIS Performance Tuning with Biml

Back to calendar

Event Date: 27-08-2016 - Session time: 15:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: David Stein

Title: SSIS Performance Tuning with Biml

Abstract:

You may heard that Biml can automate ETL loads, but what if your data warehouse is several terabytes with a tight load window. In this demo focused presentation, we’ll discuss how to use BimlScript to dynamically create multiple SSIS packages for a data warehouse ETL load, each following a different best practice design pattern. The included framework then automatically executes each package repeatedly, records the results for analysis, and determine which package version should be used in production.

The only way to be sure that your SSIS packages are performing optimally is to test them against multiple patterns. Make your life easier and let BimlScript do the work for you.

This site is open source. Improve this page.