sqlsathistory

Nr: 563

Back to Main list

SQLSaturday #563 - Dallas 2016

Start Time (24h) Speaker Track Title
08:30:00 Stan Geiger BI Platform Architecture, Development Administration Polybase and Time Travel (Temporal Tables)
08:30:00 Ginger Grant BI Information Delivery Developing R and SQL Server 2016
08:30:00 Andy Tabisz Application Database Development Creating Access Web Apps with Power BI Integration
08:30:00 Trayce Jordan Enterprise Database Administration Deployment Intro to SQL Server 2016 - Always Encrypted, Masking Row level security
08:30:00 Rachael Martino Analytics and Visualization Power BI Performance Tips
08:30:00 William Wolf Application Database Development Stop Doing That! 5 Common T-SQL Anti-Patterns
08:30:00 Jared Nielsen Application Database Development RESTful JSON API Microservices and SQL Server
08:30:00 George Govantes Professional Development Agile Leadership Skills and Building High Performing Teams
09:45:00 Anthony van Gemert Application Database Development MICROSOFT: SQL Server 2016 Stretch Database
09:45:00 Ryan Casey BI Platform Architecture, Development Administration Create a Data Loading Strategy
09:45:00 Sean Werick Application Database Development SQL Server 2016: Data Masking and Encryption
09:45:00 Daniel Janik Advanced Analysis Techniques A DBA's guide to whole stack performance troubleshooting
09:45:00 Chris Shaw Enterprise Database Administration Deployment Tips for SQL Server Performance and Resiliency
09:45:00 Rick Lowe Application Database Development Weird stuff I saw ... while supporting a Java team
09:45:00 Roberto Cavalcanti Cloud Application Development Deployment Azure SQL Database v12 - Lessons learned from the trenches
11:00:00 Steve Allison Application Database Development Cursors temp tables and pivots oh boy
11:00:00 Bryan Smith Professional Development The Journey from Data to Insight
11:00:00 Mindy Curnutt Professional Development Imposter Syndrome: Are You Faking It Will they Find Out?
11:00:00 Jamey Johnston Analytics and Visualization Code Like a Pirate ... Intro to R and Data Science Tools in MS
11:00:00 David Klee Enterprise Database Administration Deployment Objective SQL Server Performance
11:00:00 Bala Shankar Cloud Application Development Deployment Deploy SQL Server with Microsoft Azure Virtual Machine
11:00:00 Ryan Adams Enterprise Database Administration Deployment Managing MSDB
11:00:00 Chris Shaw Enterprise Database Administration Deployment Standardize Your Baseline
11:00:00 Latish Sehgal Enterprise Database Administration Deployment SSMS Tips and Tricks
11:00:00 Amy Herold Professional Development WIT: Start 'em Young - Growing Women in IT
12:15:00 David Stein Professional Development Dell EMC - Maximizing Microsoft SQL Server Storage Investments
12:15:00 Craig Allen Professional Development Dell EMC - Maximizing Microsoft SQL Server Storage Investments
12:15:00 Michael Minichino Professional Development Kaminario - Pushing the SQL Turbo Button with All Flash Storage
12:15:00 Mark Wheeler Professional Development IA-Database Development using SQL Server Data Tools projects
13:15:00 Silvia Doomra Cloud Application Development Deployment Seamlessly Scaling Azure SQL DB with Elastic Database Tools
13:15:00 Stacy Gray Enterprise Database Administration Deployment Troubleshooting SQL Server Performance
13:15:00 Mike Byrd Application Database Development Indexes: Everything You Wanted to Know -- Help or Hinder
13:15:00 Matthew Brimer Enterprise Database Administration Deployment Getting Started With Your First SQL Server AWS RDS Migration
13:15:00 Rowdy Vinson Enterprise Database Administration Deployment Using Failover Clusters for High Availability
13:15:00 Bob Ward Enterprise Database Administration Deployment Understanding SQL Server R Services
13:15:00 Amy Herold Enterprise Database Administration Deployment Hi, my name is Powershell, let's be friends! An Intro to PoSH
13:15:00 Sri Sridharan Professional Development Power Networking for Data Professionals
14:30:00 Simon Cho BI Platform Architecture, Development Administration Build ETL efficiently (10x) with Minimal Logging
14:30:00 Lance Tidwell Enterprise Database Administration Deployment Ways SQL Server Lies and the Performance Tuning Headaches It Can Cause.
14:30:00 Bob Ward Enterprise Database Administration Deployment SQL Server 2016: It Just Runs Faster
14:30:00 John Harp Enterprise Database Administration Deployment The AG-ony of Defeat: Let's Break Some SQL Server Availability Groups!
14:30:00 David Stein BI Platform Architecture, Development Administration Agile Data Warehouse and ETL Design with Biml
14:30:00 Louis Mangiacapra Other IoT – Particle Photon to Azure and PowerBI integration
14:30:00 Lori Edwards Professional Development How To Plan Meetings That Work
14:30:00 Mike Burek BI Platform Architecture, Development Administration Step by Step SSIS Import Package Creation
15:45:00 Kris Hokanson Application Database Development Random Acts of Senseless Databasing
15:45:00 Naomi Williams Enterprise Database Administration Deployment SQL Server Internals
15:45:00 John Sterrett Enterprise Database Administration Deployment Why Did My Execution Plan Change? Introduction to Query Store
15:45:00 Steven Ormrod Application Database Development SQL Server Window Functions
15:45:00 Michael Bourgon Enterprise Database Administration Deployment Know what your machines are doing besides SQL Server! WMI,WQL,CIM and PoSH
15:45:00 Konstantin Melamud BI Platform Architecture, Development Administration Optimizing your data warehouse for OLAP Processing
15:45:00 Ryan Adams Enterprise Database Administration Deployment Detecting and Preparing for Corruption
15:45:00 Russel Loski Application Database Development JSON in SQL Server 2016

SessionID: 50334

Polybase and Time Travel (Temporal Tables)

Back to calendar

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

Speaker: Stan Geiger

Title: Polybase and Time Travel (Temporal Tables)

Abstract:

"With the release of SQL Server 2016, Microsoft has included two features that could fundamentally change the way we look at Data Warehousing. The addition of Polybase for connecting to external data sources such as Hadoop and Azure Blob for native TSQL queries extends the reach of the DW. The Temporal Table feature creates all kinds of possibilities for implementing Type 1 and 2 dimensions as well as time based reporting and logical data recovery. In this session we will take an in depth lock at the features and scenarios for use. We will also look at some actual demos of the technologies so you can get a feel for the technologies in action."

SessionID: 52418

Developing R and SQL Server 2016

Back to calendar

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

Speaker: Ginger Grant

Title: Developing R and SQL Server 2016

Abstract:

If you have heard about R and want to learn how to write it yourself and run it within SQL Server 2016 you will want to come to this session. As Microsoft is now incorporating the R language into SQL Server 2016, the language is going to be a required skill for all data professionals in the near future. SQL Server 2016 uses a non-open source version of R, and the benefits of using that version will be reviewed too.

Using SQL Server 2016, attendees will learn how to incorporate R in SQL Server as well write R code in Visual Studio which gets data from and runs on SQL Server. The version of R which ships with SQL Server incorporates the ability to run with more data than can be loaded into memory, and attendees will learn the best use cases for it.

Attendees will learn the setup requirements for running R from within SQL Server 2016, and learn how to run R code from within Server Management Studio.

SessionID: 52544

Creating Access Web Apps with Power BI Integration

Back to calendar

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

Speaker: Andy Tabisz

Title: Creating Access Web Apps with Power BI Integration

Abstract:

In this session, you'll learn how to quickly build an Access Web App within SharePoint, tour the online development environment and see a real, live working app in action. We'll discuss sharing the app and Power BI integration. And lastly, you'll learn the pros/cons of Access Web Apps and hybrid solutions in a corporate environment as well as how to extend the data to iPhone and Android phones. Presented by Andy Tabisz, Microsoft MVP, WorkSmart Database Masters (Michigan).

SessionID: 52734

Intro to SQL Server 2016 - Always Encrypted, Masking Row level security

Back to calendar

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

Speaker: Trayce Jordan

Title: Intro to SQL Server 2016 - Always Encrypted, Masking Row level security

Abstract:

In this session we will go into depth of several new security features in SQL Server 2016: Always Encrypted, Data Masking and Row Level Security just to name a few. We will discuss how the features work and demonstrate how to implement.

SessionID: 52795

Power BI Performance Tips

Back to calendar

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

Speaker: Rachael Martino

Title: Power BI Performance Tips

Abstract:

It is quick and easy to build large, complex data models in Power BI (based on Power Pivot). However, building a model that performs well might seem hit or miss unless you are aware of how Power BI manages your data. This session provides design techniques and tips that will have you building your own models to deliver solutions without those nasty performance surprises!

SessionID: 52933

Stop Doing That! 5 Common T-SQL Anti-Patterns

Back to calendar

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

Speaker: William Wolf

Title: Stop Doing That! 5 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 then 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 rockstar!

SessionID: 53018

RESTful JSON API Microservices and SQL Server

Back to calendar

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

Speaker: Jared Nielsen

Title: RESTful JSON API Microservices and SQL Server

Abstract:

Transforming your enterprise or startup using micro services that rely on SQL Server data can be a challenge. There are so many options out there. I will introduce how you can jump into API driven develop with lightning fast frameworks that make your job easy and simple. Explore how we leverage Entity Framework to quick start your data models with code-first prototyping. Then we will explore how to transition back when you're ready for deployment. SQL Server offers native tools for JSON support in the newest 2016 release but if you don't have that luxury we'll explore legacy versions as well. API driven development can transform your software development lifecycle so join me as we get you going in the right direction with the latest frameworks and tools. Source code will be provided of a standard API framework with a real data model to accompany your efforts. We will also touch on OAuth 2.0, Unit Testing, and Continuous Integration (CI) for truly streamlined SQL powered apps.

SessionID: 54412

Agile Leadership Skills and Building High Performing Teams

Back to calendar

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

Speaker: George Govantes

Title: Agile Leadership Skills and Building High Performing Teams

Abstract:

How do you build an environment that inspires innovation and individual ownership to deliver operational excellence? How to move away from the Command and Control leadership style that is so pervasive within the IT culture? How do you move from Manager to Leader? In today’s modern Enterprise, attracting and keeping talented employees is a challenge. We’ll cover the importance of: Spirit of Service, Project Vision, Allowing Team Input, and Trust in Team Members, and the impact these areas make on both Individual and Team performance. Thus altering how the organization is Managed/Lead from: “How do I accomplish corporate goals?” to the more empowering: “How do WE accomplish our corporate goals?”.

SessionID: 50310

MICROSOFT: SQL Server 2016 Stretch Database

Back to calendar

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

Speaker: Anthony van Gemert

Title: MICROSOFT: SQL Server 2016 Stretch Database

Abstract:

Your SAN consumption is increasing faster than your budget, you have tables so big that you dread re-indexing, or your end-users demand their cold or archived data always be online. There’s a solution that lets you take advantage of the Cloud, on your terms, all without impacting your existing end-user applications or queries.

Come and meet some of the SQL Server Stretch database product team, and find out how you can move your data securely and transparently, free up disc space and reduce your SAN consumption, while retaining full control from the on-premises SQL Server. You’ll reduce maintenance operations time and resources, plus lower overall cost. Learn how SQL Stretch database will simplify your journey to the Cloud!

SessionID: 50317

Create a Data Loading Strategy

Back to calendar

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

SQL Server 2016: Data Masking and Encryption

Back to calendar

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

Speaker: Sean Werick

Title: SQL Server 2016: Data Masking and Encryption

Abstract:

Learn about data masking and encryption, the pros and cons of each, as well as when to use which.

SessionID: 52999

A DBA's guide to whole stack performance troubleshooting

Back to calendar

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

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

Tips for SQL Server Performance and Resiliency

Back to calendar

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

Speaker: Chris Shaw

Title: Tips for SQL Server Performance and Resiliency

Abstract:

After working 20 years in the industry on hundreds of SQL Servers clear patterns emerge. These observations of patterns and best practices directly relate to the health of the server.#160; During this session we will review the patterns of healthy SQL Servers and identify unhealthy behavior that clearly shows servers that are at risk.#160;

We will review shared patterns, configuration and practices.#160;#160; Which of these repeating patterns represent healthy Servers and which of these patterns are#160; shared with servers that are having issues daily.#160; These patterns are so clear in fact that I many SQL Servers will benefit from the application of at least one if not more of the tips we will cover.#160; At the end of this session attendees will have the tools to identify and correct common issues that impact SQL Servers Performance and Resiliency.

SessionID: 54262

Weird stuff I saw ... while supporting a Java team

Back to calendar

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

Speaker: Rick Lowe

Title: Weird stuff I saw ... while supporting a Java team

Abstract:

After spending more than a decade completely devoted to the Microsoft stack, over the last few years I've been getting pulled into work supporting Java teams. Yes, sure, Java is just another language so there aren't really and issues that are absolutely unique to the Java world. But it is a different stack, different culture, and different group of folks giving bad advice to developers ... just enough different to keep life interesting. Come hear about my misadventures with server side cursors, output parameters, integrated authentication, and NOCOUNT settings.

SessionID: 54265

Azure SQL Database v12 - Lessons learned from the trenches

Back to calendar

Event Date: 24-09-2016 - Session time: 09:45:00 - Track: Cloud Application Development Deployment

Speaker: Roberto Cavalcanti

Title: Azure SQL Database v12 - Lessons learned from the trenches

Abstract:

In this session you will learn the best practices, tips and tricks on how to successfully use Azure SQL Database on production environments. You will learn how to monitor and improve Azure SQL Database query performance. I will cover how Microsoft CSS has been using Query Store, Extended Events, Azure SQL Database Advisor and PerfStat Scripts with SQL Nexus to help customers monitor and improve query response times when running their databases in the Microsoft Azure cloud. These learnings are all fruit of CSS support cases, and customer field engagements. This session includes several demos.

SessionID: 50324

Cursors temp tables and pivots oh boy

Back to calendar

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

Speaker: Steve Allison

Title: Cursors temp tables and pivots oh boy

Abstract:

Will do an overview of the PIVOT and UNPIVOT functions and how to manipulate your data in really cool ways. Then we will move on to how to deal with Cursor functions and looping through data, then the joys of #tables vs @tables for your temporary table issues.

SessionID: 50327

The Journey from Data to Insight

Back to calendar

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

Speaker: Bryan Smith

Title: The Journey from Data to Insight

Abstract:

Regardless of the tools and techniques we might employ, the fundamental task of the analyst is to turn data into business-relevant insight. This is not a simple task and not one that is fully under our conscious control.

In this session, we will discuss the our current understanding of how this process works and practices analysts can employ to improve the quantity and quality of insights they produce.

SessionID: 50424

Imposter Syndrome: Are You Faking It Will they Find Out?

Back to calendar

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

Speaker: Mindy Curnutt

Title: Imposter Syndrome: Are You Faking It Will they Find Out?

Abstract:

Have you ever thought to yourself “All these people think I’m smarter than I really am" or "I really don’t know what I’m doing, they're going to figure out I'm a fraud!” If yes, then you suffer from the Impostor Syndrome. And despite all the accomplishments, awards and accolades, you still doubt yourself. It’s rampant in the modern day tech workplace, and the fear will make you shrink back from opportunities. You dismiss praise. You overcompensate by working harder, being charming and demanding perfection from yourself. What would happen if you were released from this bondage, and kicked your impostor to the curb? In this session, learn 3 powerful techniques that can help to improve your confidence and silent that annoying voice in your head!

SessionID: 50636

Code Like a Pirate ... Intro to R and Data Science Tools in MS

Back to calendar

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

Speaker: Jamey Johnston

Title: Code Like a Pirate ... Intro to R and Data Science Tools in MS

Abstract:

Come to this session to get an introduction to the R language including:

We will finish with a brief introductions of how R integrates in Azure ML, Power BI and SQL Server 2016 using real demos.

The focus of the session will be primarily on the introduction to the R language and getting attendees comfortable with using R to start the journey into Data Science!

SessionID: 50755

Objective SQL Server Performance

Back to calendar

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

Speaker: David Klee

Title: Objective SQL Server Performance

Abstract:

SessionID: 51147

Deploy SQL Server with Microsoft Azure Virtual Machine

Back to calendar

Event Date: 24-09-2016 - Session time: 11:00: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: 52935

Managing MSDB

Back to calendar

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

Speaker: Ryan Adams

Title: Managing MSDB

Abstract:

You put a lot of time into managing your databases, but MSDB often flies under the radar or only gets backed up. There are a ton of things that get stored in MSDB, so how are you supposed to know what all those items are? More importantly, how do you manage the data that is getting stored in there and keep it from growing out of control? We will take an in-depth look at all the SQL features that put data in MSDB and the best approach to managing that data. You will walk away with scripts you can use to automate the grooming of MSDB.

SessionID: 53057

Standardize Your Baseline

Back to calendar

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

Speaker: Chris Shaw

Title: Standardize Your Baseline

Abstract:

The concept of baselines have been around for many years, yet all too often they are not executed on a regular basis and don't contain enough information, I believe this is because most DBA's don't have a standard baseline to execute. Baselines can tell you how the server should be performing under normal workloads with the configuration that is currently in place.

During this session we will look at the kinds of data that you should be collecting while spending the majority of our time reviewing the methods on how this data can be collected, stored, automated and reported on.

These standardized baselines will give you a head start the next time you are looking to upgrade your server to new hardware, recover a server and performance troubleshooting.

SessionID: 53580

SSMS Tips and Tricks

Back to calendar

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

Speaker: Latish Sehgal

Title: SSMS Tips and Tricks

Abstract:

In this talk, we’ll go through tips and tricks to make you much more productive and efficient with SQL Server Management Studio, so that IDE does not get in your way and lets you focus on writing SQL.

SessionID: 54263

WIT: Start 'em Young - Growing Women in IT

Back to calendar

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

Speaker: Amy Herold

Title: WIT: Start 'em Young - Growing Women in IT

Abstract:

Guest Speakers : Abha Jos

SessionID: 54431

Dell EMC - Maximizing Microsoft SQL Server Storage Investments

Back to calendar

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

Speaker: David Stein

Title: Dell EMC - Maximizing Microsoft SQL Server Storage Investments

Abstract:

2016 is the year of All-Flash for primary storage and DELL 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, DELL EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type.

Beyond just production database performance, DELL 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: 54455

Dell EMC - Maximizing Microsoft SQL Server Storage Investments

Back to calendar

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

Speaker: Craig Allen

Title: Dell EMC - Maximizing Microsoft SQL Server Storage Investments

Abstract:

2016 is the year of All-Flash for primary storage and DELL 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, DELL EMC has a broad portfolio to ensure consistent sub-millisecond response time regardless of workload type.

Beyond just production database performance, DELL 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: 54470

Kaminario - Pushing the SQL Turbo Button with All Flash Storage

Back to calendar

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

Speaker: Michael Minichino

Title: Kaminario - Pushing the SQL Turbo Button with All Flash Storage

Abstract:

TBD

SessionID: 54471

IA-Database Development using SQL Server Data Tools projects

Back to calendar

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

Speaker: Mark Wheeler

Title: IA-Database Development using SQL Server Data Tools projects

Abstract:

In this session we will use SSDT to create and deploy a database project that includes unit tests to validate the stored procedures and post deployment scripts to insert data. We will also look at the other capabilities of SSDT like being able to refactor columns and do a schema compare.

By the end of the session, you will have the working knowledge on how to use database projects to simplify your next development project. We will also look at the different methods for deploying your changes and why one may be better than the other.

SessionID: 50316

Seamlessly Scaling Azure SQL DB with Elastic Database Tools

Back to calendar

Event Date: 24-09-2016 - Session time: 13:15:00 - Track: Cloud Application Development Deployment

Speaker: Silvia Doomra

Title: Seamlessly Scaling Azure SQL DB with Elastic Database Tools

Abstract:

Elastic Database Tools for Azure SQL DB offers a set of features that make it easier to build and manage a scaled-out data tier for cloud applications. With elastic database tools, applications can easily access data spanning multiple DBs, coordinate management tasks and manage how data is distributed among them. As part of the session, we explore workloads that are a natural fit for Azure SQL DB's elastic database tools. Patterns discussed in depth include multi-tenant applications created by cloud ISVs and SaaS vendors, and applications relying on temporal data distribution. The session will illustrate how easy it is now to build, scale and manage cloud applications in SQL DB when using elastic tools capabilities such as the elastic database client library for .NET.

SessionID: 50319

Troubleshooting SQL Server Performance

Back to calendar

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

Speaker: Stacy Gray

Title: Troubleshooting SQL Server Performance

Abstract:

Microsoft SQL Support Engineers troubleshoot performance issues all day, every day. They use a set of tools that not only gather all the data necessary to troubleshoot any performance issue, but the tools also analyze the data and generate visually attractive reports. These tools have been available to the public for free for years. This presentation explains the tools, how to run them and how to interpret the results, including how to determine disk latency root cause, top reasons for high cpu, and what to do when you have excessive waits.

SessionID: 50396

Indexes: Everything You Wanted to Know -- Help or Hinder

Back to calendar

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

Speaker: Mike Byrd

Title: Indexes: Everything You Wanted to Know -- Help or Hinder

Abstract:

Indexes can be a boon or decrement for query performance. This presentation will present what they are (in layman’s terms) and how they may affect query performance – both from a read (SELECT) viewpoint as well as a data modification aspect (INSERT, UPDATE, DELETE). This session will concentrate with a deep dive into clustered indexes and nonclustered indexes, their syntax and utilization, and their effect on performance in transaction and data warehouse databases. Covering nonclustered indexes will also be examined in detail and the scenarios they should be applied. There will be many query demos illustrating index utilization using statistics and query plans. Attendee should have some TSQL and Management Studio experience.

SessionID: 51047

Getting Started With Your First SQL Server AWS RDS Migration

Back to calendar

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

Speaker: Matthew Brimer

Title: Getting Started With Your First SQL Server AWS RDS Migration

Abstract:

Cloud Computing is all the rage but how do you get data from your on-premise SQL Server to your shiny new Amazon RDS instance? We'll go over the various iterations and offerings of AWS, proper sizing, cost, etc. and then we'll dive into the nitty gritty on how to migrate your data either in one shot or continuously over time.

SessionID: 51079

Using Failover Clusters for High Availability

Back to calendar

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

Speaker: Rowdy Vinson

Title: Using Failover Clusters for High Availability

Abstract:

As DBAs, we know that AlwaysOn AGs and Failover Cluster Instances are built on the foundation of Windows Server Failover Clustering and that HA is their goal, but have you ever seen it work? Are they a good solution for your org? Do you know if your SysAdmins can do their part? We’ll discuss these points and more, diving in under the hood of WSFC in demos and showing a few scripts to make support and troubleshooting a little easier.

SessionID: 52385

Understanding SQL Server R Services

Back to calendar

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

Speaker: Bob Ward

Title: Understanding SQL Server R Services

Abstract:

SQL Server 2016 introduces a new platform for building intelligent, advanced analytic applications called SQL Server R Services. This session is for the SQL Server Database professional to learn more about this technology and its impact on developing and managing a SQL Server environment. We will cover the basics of this technology but also look at how it works, troubleshooting topics, and even usage case scenarios. You don't have to be a data scientist to understand SQL Server R Services so come upgrade you career by learning more about SQL Server and advanced analytics

SessionID: 53005

Hi, my name is Powershell, let's be friends! An Intro to PoSH

Back to calendar

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

Speaker: Amy Herold

Title: Hi, my name is Powershell, let's be friends! An Intro to PoSH

Abstract:

Powershell wants to be your friend - your very powerful friend. In this session we will go over some Powershell basics that will help get you started as well as some known "gotchas" when working in Powershell. This is a beginner session - no Powershell experience necessary. WARNING: You may get warm-fuzzies about Powershell by attending this session.

SessionID: 54513

Power Networking for Data Professionals

Back to calendar

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

Speaker: Sri Sridharan

Title: Power Networking for Data Professionals

Abstract:

SessionID: 50322

Build ETL efficiently (10x) with Minimal Logging

Back to calendar

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

Ways SQL Server Lies and the Performance Tuning Headaches It Can Cause.

Back to calendar

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

Speaker: Lance Tidwell

Title: Ways SQL Server Lies and the Performance Tuning Headaches It Can Cause.

Abstract:

Have you ever tried to tune a query or searched for a performance bottleneck just to have SQL Server lead you down a rabbit hole? In this session we will look at some common performance issues that can occur that might be masked or hidden by misleading information you get from SQL Server. We will also talk about why SQL Server gives you the information it does, and how to see past this information and find the real issues causing your performance problems.

SessionID: 51040

SQL Server 2016: It Just Runs Faster

Back to calendar

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

The AG-ony of Defeat: Let's Break Some SQL Server Availability Groups!

Back to calendar

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

Speaker: John Harp

Title: The AG-ony of Defeat: Let's Break Some SQL Server Availability Groups!

Abstract:

Some database administrators create availability groups. Some database administrators have availability groups thrust upon them. Whether you're just starting to investigate SQL Server's own high availability solution, or if you've become responsible for an Always On Availability Group that's already been built, come get a glimpse of what can/will go wrong in an Availability Group implementation, from the commonplace to the spectacular.

SessionID: 52777

Agile Data Warehouse and ETL Design with Biml

Back to calendar

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

Speaker: David Stein

Title: Agile Data Warehouse and ETL Design with Biml

Abstract:

Business Intelligence Markup Language is literally changing the way we think about Data Warehouse design and ETL. In this interactive presentation you'll see how you can rapidly iterate through the Data Warehouse Development Cycle and provide ROI almost immediately. Learn how you can use BimlScript to automatically create staging tables, SSIS Packages, and other necessary objects during the modeling process.

SessionID: 52972

IoT – Particle Photon to Azure and PowerBI integration

Back to calendar

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

Speaker: Louis Mangiacapra

Title: IoT – Particle Photon to Azure and PowerBI integration

Abstract:

This session is an introduction into integrating the Particle Photon Wi-Fi development kit and Microsoft Azure to analyze, collect, and provide PowerBI reports on IoT data.

Azure Event Hubs is a highly scalable publish-subscribe event ingestor that can intake millions of events per second to process and analyze massive amounts of data. Once collected into Event Hubs the data can be transformed and stored using any real-time analytics provider or a batching/storage adapters.

The Particle Photon has a simple but very robust development environment. When combined with Microsoft Azure using webhooks it is capable of ingesting millions of events per second using a remotely programmable Particle Photon.

For this training we will specifically look at publishing data from a Particle Photon (equipped with a Photon Weather Shield) to an Azure Event Hub. Next we will store the data using blog storage, SQL database, and data lake storage to then graphically represent the IoT data in PowerBI.

SessionID: 52984

How To Plan Meetings That Work

Back to calendar

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

Speaker: Lori Edwards

Title: How To Plan Meetings That Work

Abstract:

Too often we find ourselves in meetings that seem to have no purpose, that run long and we walk out with little more information than we started with. In this session, you’ll learn how to organize meetings that are both efficient and effective from the start. We’ll provide tips to help with participation, keeping the meeting rolling and even ending on time. Be the person whose meetings people actually look forward to. Both Lori and Allen have years of experience participating in and planning meetings both for work and volunteer settings including the PASS Board of Director, Election Review Committee and the Nominations Committee meetings.

SessionID: 54411

Step by Step SSIS Import Package Creation

Back to calendar

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

Speaker: Mike Burek

Title: Step by Step SSIS Import Package Creation

Abstract:

Go step by step to create an SSIS package to import files. This will use SSIS variables, loops, expressions, and passing variables to SQL Server. The 6 objectives covered are:

1 - Read multiple files from a folder with changing file names 2 - Import to a Raw table 3 - Include a step to clean data into a Staging table 4 - Log the file name and the number of rows imported 5 - Move the imported file to a Done folder 6 - Send an email report for each file imported

SessionID: 50428

Random Acts of Senseless Databasing

Back to calendar

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

Speaker: Kris Hokanson

Title: Random Acts of Senseless Databasing

Abstract:

After years of snake oil salesmen and good-meaning but part-time developers, Acme Oil Gas company’s databases have become something Rube Goldberg would be proud of and they've hired you to sort everything out. What are some of the things you can expect to find and how can you fix them? From spaghetti code that references views inside of views nested in other views, to overly indexed tables that generate 10x the disk IO and contention they should, we’ll talk about database development, administration, and plenty of things in between.

SessionID: 50458

SQL Server Internals

Back to calendar

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

Speaker: Naomi Williams

Title: SQL Server Internals

Abstract:

How does SQL do what it does? Take a look under the hood at how the SQL database engine works with the storage engine. What causes those waits and where do we look to resolve them!

SessionID: 50540

Why Did My Execution Plan Change? Introduction to Query Store

Back to calendar

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

Speaker: John Sterrett

Title: Why Did My Execution Plan Change? Introduction to Query Store

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 to 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 a new feature in SQL Server 2016 called Query Store.

SessionID: 50627

SQL Server Window Functions

Back to calendar

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

Speaker: Steven Ormrod

Title: SQL Server Window Functions

Abstract:

Window functions are a great TSQL tool that will allow you to write simpler, more elegant code. They were first introduced in SQL 2005, and then expanded in SQL 2012. By using TSQL Window functions you can simply your code and make it easier to understand. They allow you to see both aggregations and details all at the same time. In this demo-centric session we will begin with the basics introduced in SQL 2005, then move on to examine the new functions that were added with SQL 2012.

SessionID: 52755

Know what your machines are doing besides SQL Server! WMI,WQL,CIM and PoSH

Back to calendar

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

Speaker: Michael Bourgon

Title: Know what your machines are doing besides SQL Server! WMI,WQL,CIM and PoSH

Abstract:

There's far more happening on your Windows servers than just SQL Server, and looking at ERRORLOG won't show you the whole story: other applications stealing your memory, OS issues, hardware errors, and more. We'll start by looking at several different ways to collect Event Logs automatically. From there we'll delve into WMI and WQL, which allow us to query servers (remotely or locally) to get information such as performance statistics, System and Event Logs, and even changes within SQL Server.

We'll finish it off with two immediately-usable implementations you can set up on Monday.

SessionID: 52987

Optimizing your data warehouse for OLAP Processing

Back to calendar

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

Speaker: Konstantin Melamud

Title: Optimizing your data warehouse for OLAP Processing

Abstract:

Analysis Services have become a major part of upper management daily decision making activities. However, with our DW sizes reaching multiple terabytes minimizing time required to process our data has become our top priority. In this session, we will cover the options we have as DBA’s to improve the performance of our DW processing time. We will look at features and general best practices available to us within SSAS and the database engine to ensure optimal performance, as well as enterprise level features within the database engine and SSAS available to us and how aligning those to work side by side would yield us significant improvement in our processing time.

SessionID: 54343

Detecting and Preparing for Corruption

Back to calendar

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

Speaker: Ryan Adams

Title: Detecting and Preparing for Corruption

Abstract:

Corruption is a scary thing, so if it happens tomorrow are you prepared for it? In this introduction we'll look at what causes corruption and the things you can do now to be able to detect it when it happens. We'll even see how you can implement a self healing configuration. You will also learn the different techniques for recovering from corruption. Preparation is key and you'll be prepared to handle the situation without panic.

SessionID: 54349

JSON in SQL Server 2016

Back to calendar

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

Speaker: Russel Loski

Title: JSON in SQL Server 2016

Abstract:

There have been many data lingua franca over the years (EDI, CSV, XML). Let's meet a new comer JSON (aka Jason). JSON is the web developers new best friend, providing a schema free way to transmit and persist data. SQL Server 2016 has provided new functionality to work with JSON. In this session we will look at how to read a JSON document using the OPENJSON function. We will also look at other methods for extracting information from JSON. Finally, we will look at how to generate JSON documents from TSQL queries.