sqlsathistory

Nr: 600

Back to Main list

SQLSaturday #600 - Chicago 2017

Start Time (24h)	Speaker	Track	Title
08:15:00	Anthony Nocentino	Enterprise Database Administration Deployment	Networking Internals for the SQL Server Professional
08:15:00	Chris Hyde	Advanced Analysis Techniques	SQL Server R Services in SQL 2016
08:15:00	Dave Bland	Enterprise Database Administration Deployment	How to use Execution Plans to find Performance Issues
08:15:00	Wylie Blanchard	BI Information Delivery	Analyzing SQL Server Data using PowerPivot in MS Excel
08:15:00	Rayis Imayev	BI Information Delivery	Power BI with Narrative Science: Look Who's Talking!
08:15:00	Sean Werick	BI Platform Architecture, Development Administration	SQL Server 2016 and PolyBase
08:15:00	Sean McCown	Enterprise Database Administration Deployment	Loading SQL Server Data with Powershell
08:15:00	Ross LoForte	Enterprise Database Administration Deployment	Find out why SQL Server 2016 Service Pack 1 is an Industry Game changer
09:35:00	Janis Griffin	Enterprise Database Administration Deployment	Welcome To the 2016 Query Store!
09:35:00	Vazi Okhandiar	Analytics and Visualization	Building a PowerPivot BI Dashboard in an Hour
09:35:00	Ameena Lalani	Enterprise Database Administration Deployment	Learn History from Temporal Tables
09:35:00	David Klee	Enterprise Database Administration Deployment	Zen and the Art of Perfmon
09:35:00	Paresh Motiwala	Enterprise Database Administration Deployment	TempDB- More permanent impact than you think
09:35:00	Chirag Shah	Enterprise Database Administration Deployment	SQL 2016 Scalability and Performance Enhancements
09:35:00	Rie Irish	Professional Development	Let Her Finish: Supporting Women's Voices from meetings to the board room
09:35:00	Doug Lane	Application Database Development	The Junior Developer's Handbook
09:35:00	Kevin Kline	Enterprise Database Administration Deployment	The Optimizer Secrets of 860X
09:35:00	John Morehouse	Application Database Development	Database Continuous Delivery Your Salvation!
10:55:00	David Maxwell	Enterprise Database Administration Deployment	Wait Statistics - The Top 5 Waits You Should Know
10:55:00	Jim Dorame	Enterprise Database Administration Deployment	JSON for the Data Mortals
10:55:00	Vladimir Oselsky	Application Database Development	Crash Course on Better SQL Development
10:55:00	Brian Hansen	Enterprise Database Administration Deployment	Visualize Your Transaction Log
10:55:00	Phillip Labry	Cloud Application Development Deployment	Analysis Services is in Azure? Seriously!? Let's build a model!
10:55:00	Armando Lacerda	Enterprise Database Administration Deployment	Why are you still taking backups?
10:55:00	Haidong Ji	Enterprise Database Administration Deployment	Introducing SQL Server on Linux
10:55:00	Monica Rathbun	Professional Development	I’m It – Survival Techniques for the Lone DBA
10:55:00	Anthony Nocentino	Enterprise Database Administration Deployment	How SQL Monitor speeds YOU up!
10:55:00	Bob Pusateri	Application Database Development	Cameron Jones - Adopting Agile Database Management
12:25:00	Karlyn LeBlanc	Professional Development	Whip Away Stress at Home Work to Create a Better You
12:25:00	Warren Sifre	Advanced Analysis Techniques	Introduction to Azure Machine Learning
12:25:00	Jennifer McCown	Application Database Development	Designing Stored Procedure Solutions
12:25:00	Thomas Lane	Enterprise Database Administration Deployment	Help! My Replication Has Fallen and We Can#39;t Get it Replicating again.
12:25:00	Allen White	Enterprise Database Administration Deployment	Emergency! Are You Ready for Disaster to Strike?
12:25:00	Eddie Wuerch	Enterprise Database Administration Deployment	Digging Out From Corruption
12:25:00	Jason Strate	Application Database Development	Introduction to SQL Server Indexes
12:25:00	Jason Horner	BI Information Delivery	Advanced Spatial Analysis Beyond Bubble Charts
12:25:00	Bob Pusateri	Application Database Development	Devon Lawler - Native Scheduler Showdown
12:25:00	David Bermingham	Enterprise Database Administration Deployment	SANLess SQL Server Clusters on Windows and Linux
13:45:00	Adam Koehler	Enterprise Database Administration Deployment	Isolation Levels – Understanding Transaction Temper Tantrums
13:45:00	Lance Tidwell	Enterprise Database Administration Deployment	Parameter Sniffing the Good, the Bad, and the Ugly
13:45:00	Adam Machanic	Application Database Development	Don't Let History Be a Mystery! Temporal Data in SQL Server 2016
13:45:00	David Bermingham	Enterprise Database Administration Deployment	SQL Server High Availability in Azure IaaS
13:45:00	Brian Beswick	BI Platform Architecture, Development Administration	SSAS 2016 Tabular - Diving into the new features
13:45:00	Lonny Niederstadt	Advanced Analysis Techniques	SQL Server System Behavior: Observation Intervention
13:45:00	Ed Leighton-Dick	Application Database Development	Protecting Your Data with Encryption
13:45:00	Jason Strate	Enterprise Database Administration Deployment	Strategies for SQL Server Index Analysis
13:45:00	Scott Ellis	Cloud Application Development Deployment	Tricks and Traps to Deploying SaaS to SQL in the Azure Cloud
15:05:00	John Deardurff	Professional Development	How to get Microsoft Certified
15:05:00	Greg Moore	Enterprise Database Administration Deployment	Tips that have saved my bacon
15:05:00	Simon Cho	BI Platform Architecture, Development Administration	Build ETL efficiently (10x) with Minimal Logging
15:05:00	Aaron Cutshall	Application Database Development	The Lost Science of Set Theory
15:05:00	Mike Hays	Professional Development	Tackling Technical Blogging
15:05:00	Allan Hirt	Enterprise Database Administration Deployment	A Closer Look at Distributed Availability Groups
15:05:00	Gil Raviv	Analytics and Visualization	Common Data Patterns that You've Never Dared to Transform with Power BI
15:05:00	Andrew Loree	Enterprise Database Administration Deployment	Stretch Database and Managed Backups: Cloud Services for your SQL Servers
15:05:00	Pat Phelan	Application Database Development	Relational Data Architecture 101
15:05:00	David Klee	Other	My Brain Has Blue Screened - Let's Laugh

SessionID: 56730

Networking Internals for the SQL Server Professional

Back to calendar

Event Date: 11-03-2017 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Anthony Nocentino

Title: Networking Internals for the SQL Server Professional

Abstract:

Once data leaves your SQL Server do you know what happens or is the world of networking a black box to you? Would you like to know how data is packaged up and transmitted to other systems and what to do when things go wrong? Are you tired of being frustrated with the network team? In this session we introduce how data moves between systems on networks and TCP/IP internals. We’ll discuss real world scenarios showing you how your network’s performance impacts the performance of your SQL Server and even your recovery objectives.

SessionID: 56955

SQL Server R Services in SQL 2016

Back to calendar

Event Date: 11-03-2017 - Session time: 08:15: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: 57363

How to use Execution Plans to find Performance Issues

Back to calendar

Event Date: 11-03-2017 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Dave Bland

Title: How to use Execution Plans to find Performance Issues

Abstract:

This is a introductory session on how a DBA and developers can use Execution plans to find performance bottlenecks. This will cover the fundamentals and cover some of the basic techniques that can be used to find hidden performance problems.

SessionID: 57410

Analyzing SQL Server Data using PowerPivot in MS Excel

Back to calendar

Event Date: 11-03-2017 - Session time: 08:15:00 - Track: BI Information Delivery

Speaker: Wylie Blanchard

Title: Analyzing SQL Server Data using PowerPivot in MS 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: 57600

Power BI with Narrative Science: Look Who's Talking!

Back to calendar

Event Date: 11-03-2017 - Session time: 08:15:00 - Track: BI Information Delivery

Speaker: Rayis Imayev

Title: Power BI with Narrative Science: Look Who's Talking!

Abstract:

You’ve created many Power BI reports and have become very skillful in connecting different data sources; your data model is filled with all necessary measures, calculated columns and eventually your Power BI report with various powerful visualizations is presented to your customers. What’s next? What if you can add some artificial intelligence to your report?

There is a Chicago-based company Narrative Science that has developed a very unique component that can consume your report model numeric data and automatically generate textual narratives within your Power BI report. Such natural language descriptions can provide you with some unexpected insights and extend your common data interpretation.

Let’s go together though this interactive data adventure and explore different scenarios of how this Narrative Science component can be used with your Power BI reports and check if it can also be used for Predictive Analytics.

SessionID: 59318

SQL Server 2016 and PolyBase

Back to calendar

Event Date: 11-03-2017 - Session time: 08:15:00 - Track: BI Platform Architecture, Development Administration

Speaker: Sean Werick

Title: SQL Server 2016 and PolyBase

Abstract:

This session will focus on the brand new SQL Server 2016 feature called PolyBase. PolyBase#160;is a technology that accesses and combines both non-relational and relational data, all from within SQL Server. It allows you to run queries on external data in Hadoop or Azure blob storage. The queries are optimized to push computation to Hadoop.

In this session, you will learn how to install and set up PolyBase, and how to use it once you've got it configured.

SessionID: 59320

Loading SQL Server Data with Powershell

Back to calendar

Event Date: 11-03-2017 - Session time: 08: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: 61031

Find out why SQL Server 2016 Service Pack 1 is an Industry Game changer

Back to calendar

Event Date: 11-03-2017 - Session time: 08:15:00 - Track: Enterprise Database Administration Deployment

Speaker: Ross LoForte

Title: Find out why SQL Server 2016 Service Pack 1 is an Industry Game changer

Abstract:

Come to this session to find out why SQL Server 2016 SP1 revolutionized SQL Server allowing a consistent feature and functionality surface area for developers and organizations across all SQL Server 2016 editions, a first in the industry. This will enable developers, ISVs and customers to build advanced applications that scale across editions and cloud as you grow. SQL Server 2016 SP1 Standard Edition sets the bar for rich programming capabilities, security innovations, and fast performance for mid-tier applications and data marts. Then easily upgrade to Enterprise Edition for mission critical capabilities as your workload scales, without having to re-write your application.

Key Learning: Learn the new features made available with SQL Server 2016 SP1 Standard Edition Develop more powerful application that were not possible before with Standard Edition Learn how to upgrade to SQL Server 2016 Service Pack 1

SessionID: 56783

Welcome To the 2016 Query Store!

Back to calendar

Event Date: 11-03-2017 - Session time: 09:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Janis Griffin

Title: Welcome To the 2016 Query Store!

Abstract:

One of my favorite new features in SQL Server 2016 is the Query Store. The Query Store houses valuable information on performance of your queries as well as gives you great insights into your query workload. This presentation will take a look at the Query Store, how it works and the type information it holds and how you can use it to analyze performance issues. New DMVs will be introduced and the performance impact of enabling the Query Store will be discussed. Both DBAs and developers can increase their performance tuning skills by attending this session.

SessionID: 56816

Building a PowerPivot BI Dashboard in an Hour

Back to calendar

Event Date: 11-03-2017 - Session time: 09:35:00 - Track: Analytics and Visualization

Speaker: Vazi Okhandiar

Title: Building a PowerPivot BI Dashboard in an Hour

Abstract:

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

SessionID: 56984

Learn History from Temporal Tables

Back to calendar

Event Date: 11-03-2017 - Session time: 09:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Ameena Lalani

Title: Learn History from Temporal Tables

Abstract:

SQL Server 2016 came out with a bucket full of cool new features. One of them is Temporal Tables. They are basically history tables of the normal tables; that allow us to retrieve data from any point in time for every change such as updates and deletes . It does this all without any change to application code and without using any behind the scene triggers. In this session, we will see what the requirements of creating temporal tables are. We will see the demo on insert and update functionality and how to query historical information using new TSQL clause. It will also cover some security concerns around theTemporal Tables.

SessionID: 57784

Zen and the Art of Perfmon

Back to calendar

Event Date: 11-03-2017 - Session time: 09:35:00 - Track: Enterprise Database Administration Deployment

Speaker: David Klee

Title: Zen and the Art of Perfmon

Abstract:

If your boss asked you for the list of the five most CPU-hungry databases in your environment six months from now for an upcoming licensing review, could you come up with an answer? Performance data can be overwhelming, but you can make sense of the mess. Twisting your brain and looking at the data in different ways can help you identify resource bottlenecks that are limiting your SQL Server performance today. Painting a clear picture of what your servers should be doing can help alert you when something is abnormal. Trending this data over time will help you project how much resource consumption you will have months away. Come learn how to extract meaning from your performance trends and how to use it to proactively manage the resource consumption from your SQL Servers.

SessionID: 58260

TempDB- More permanent impact than you think

Back to calendar

Event Date: 11-03-2017 - Session time: 09:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Paresh Motiwala

Title: TempDB- More permanent impact than you think

Abstract:

As a DBA you hear different theories and "gospel truths" about TempDB from many people. Frankly there is no single version of the truth except that if you don't use and manage it well, it will make your life a real h*ll.

What works for you in one situation may not work for you in another situation. What works for a situation today, might not guarantee its success for a similar situation tomorrow.

We will talk about Temporary User Objects, Work Tables, Interim Results Version Store for Data Standards for its configuration Contention Data Files Per CPU - Myth or Reality? Dynamic Growth or Pre Sized? Trace Flags to Manage Tempdb? Should we store the entire Tempdb on SSDs? Should we shrink TempDB or not?

Hopefully at the end of the session your knowledge on Tempdb won't be Temp.

SessionID: 59362

SQL 2016 Scalability and Performance Enhancements

Back to calendar

Event Date: 11-03-2017 - Session time: 09:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Chirag Shah

Title: SQL 2016 Scalability and Performance Enhancements

Abstract:

With an advent of SQL 2016 we at Microsoft bringing a new level of scalability and performance enhancements from core relational SQL engine to improvised user experience in toolset like management studio. Even if you are a seasoned DBA worked with SQL product for many years come join in this session to find out how and what is different in SQL Server 2016 in terms of massive scalability, user experience and performance tuning enhancements.

SessionID: 59597

Let Her Finish: Supporting Women's Voices from meetings to the board room

Back to calendar

Event Date: 11-03-2017 - Session time: 09:35:00 - Track: Professional Development

Speaker: Rie Irish

Title: Let Her Finish: Supporting Women's Voices from meetings to the board room

Abstract:

Next time you attend a meeting, watch what happens when women at the table offer ideas. If your office is like most in America, you’ll notice women are interrupted almost three times as often as men. Some interruptions are to assert dominance but sometimes people do it to be helpful offer affirmation. Regardless of the intent, the results are the same. Women are being left out of the conversation. The consequences are real. Male executives that speak more frequently in meetings are rewarded with 10% higher competence ratings from peers better performance reviews from bosses. This translates into $ when raises and bonuses are handed out.

This discussion will cover positive solutions that help women’s voices be heard. Women need to be more assertive. We need to learn to say “Stop interrupting me.” and “I just said that.” However, men can be, no HAVE to be, part of the solution. They can help women become part of the conversation.

SessionID: 59643

The Junior Developer's Handbook

Back to calendar

Event Date: 11-03-2017 - Session time: 09:35:00 - Track: Application Database Development

Speaker: Doug Lane

Title: The Junior Developer's Handbook

Abstract:

Boy Scouts, Role-Playing Gamers, Human Resources...they all have handbooks to help them navigate their roles. Now database developers have one too! In this session, we'll cover the essentials for any T-SQL developer to succeed. Topics include a method for writing new queries, measuring query performance, the importance of date tables and window functions, and time-saving tricks you never knew were possible in Management Studio. If you're looking for the missing manual for developers in their first two years, this session is for you.

SessionID: 61030

The Optimizer Secrets of 860X

Back to calendar

Event Date: 11-03-2017 - Session time: 09:35:00 - Track: Enterprise Database Administration Deployment

Speaker: Kevin Kline

Title: The Optimizer Secrets of 860X

Abstract:

Debugging SQL using the 8600 Series of Trace Flags: You already know a thing or two about tuning a SQL query on Microsoft SQL Server. You can read an execution plan and know the most significant red flags to look for. And you have also learned about the important information revealed by SET STATISTICS statements. But you want to take it up another level! In this session, go even deeper with query tuning with three new lessons. First, we’ll examine a few new and seldom used features inside of SSMS specifically for query performance. Second, we’ll spend a bit of time learning query related DMVs and how to read query plans in directly within XML. Finally, we will discuss and demo a set of powerful Trace Flags, the 8600 series, that reveal additional details about how the query optimizer behaves as it processes a query.

SessionID: 61034

Database Continuous Delivery Your Salvation!

Back to calendar

Event Date: 11-03-2017 - Session time: 09:35:00 - Track: Application Database Development

Speaker: John Morehouse

Title: Database Continuous Delivery Your Salvation!

Abstract:

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

SessionID: 56767

Wait Statistics - The Top 5 Waits You Should Know

Back to calendar

Event Date: 11-03-2017 - Session time: 10:55:00 - Track: Enterprise Database Administration Deployment

Speaker: David Maxwell

Title: Wait Statistics - The Top 5 Waits You Should Know

Abstract:

Wait statistics are a great tool for troubleshooting performance problems in SQL Server. However, there are so many different wait types in SQL Server, it can be challenging to determine what to focus on and what can be ignored. Even after discovering that SQL Server is waiting for something, most DBAs don't know where to look next. In this session, we'll examine 5 of the most frequently seen wait types in SQL Server and how to troubleshoot each of them. You'll learn how to determine the root cause of a particular wait type, and how to avoid common mistakes made when troubleshooting with wait statistics.

SessionID: 56768

JSON for the Data Mortals

Back to calendar

Event Date: 11-03-2017 - Session time: 10:55:00 - Track: Enterprise Database Administration Deployment

Speaker: Jim Dorame

Title: JSON for the Data Mortals

Abstract:

In SQL Server 2016 Microsoft has include native handling of JSON. What does that mean? What is JSON? Why do I care? Will there be knives and hockey masks? Come to this session and you will learn what JSON is, where and how it is used and why as a data professional you need to know this.

SessionID: 57103

Crash Course on Better SQL Development

Back to calendar

Event Date: 11-03-2017 - Session time: 10:55:00 - Track: Application Database Development

Speaker: Vladimir Oselsky

Title: Crash Course on Better SQL Development

Abstract:

SQL Development is a broad subject with many roads to choose from. Often times SQL Developers feel overwhelmed and unsure which areas they need to focus on. The purpose of this session is to give a high-level overview and present paths for further study and growth. Subjects reviewed in this session will include coding patterns, error handling, and execution plans. Demonstrations of free tools will also help developers find ways of simplifying their daily tasks. Attendees will leave this session empowered with knowledge and directions for further growth.

SessionID: 58276

Visualize Your Transaction Log

Back to calendar

Event Date: 11-03-2017 - Session time: 10:55:00 - Track: Enterprise Database Administration Deployment

Speaker: Brian Hansen

Title: Visualize Your Transaction Log

Abstract:

The SQL transaction log can be a mystery to many DBAs. We live in the age of visualizations, so let#39;s visualize the log! In this session, we will examine the purpose and organization of the transaction log and will explore the log through a unique visualization tool. We will consider common performance issues that are related to the logging mechanism and how to overcome these problems. Finally, we will discuss some techniques to monitor the log so that potential performance problems can be addressed pro-actively.

SessionID: 59329

Analysis Services is in Azure? Seriously!? Let's build a model!

Back to calendar

Event Date: 11-03-2017 - Session time: 10:55:00 - Track: Cloud Application Development Deployment

Speaker: Phillip Labry

Title: Analysis Services is in Azure? Seriously!? Let's build a model!

Abstract:

Have you used SSAS before? Have you created reports using T-SQL and Group by? Are you interested in Power BI? Do you you have a need for analysis services but don't want to have to deal with the hassle of buying and installing a server? Is your organization using Office 365? If you answered yes to any of these questions, you might need Azure Analysis Services. The wait is almost over! Azure Analysis services is the platform as a service version of the wildly popular Analysis Services Tabular product. Join Phillip as he builds and deploys an Azure Analysis services solution.

SessionID: 59406

Why are you still taking backups?

Back to calendar

Event Date: 11-03-2017 - Session time: 10:55:00 - Track: Enterprise Database Administration Deployment

Speaker: Armando Lacerda

Title: Why are you still taking backups?

Abstract:

Keep doing things the same way because they have always worked in the past is a very comfortable mistake we all make in many areas. That includes backup strategies and service account administration. In this one hour presentation full of demos I will explore many options available in SQL Server 2016 and Azure that can potentially reduce the amount of data and time required for backups and even eliminate the need all together. It sounds scary but it will be really fun.

SessionID: 59471

Introducing SQL Server on Linux

Back to calendar

Event Date: 11-03-2017 - Session time: 10:55:00 - Track: Enterprise Database Administration Deployment

Speaker: Haidong Ji

Title: Introducing SQL Server on Linux

Abstract:

SQL Server is from Microsoft, and has been running exclusively on Windows since the early 90s! However, with the increasing usage of cloud computing and wide adoption of Linux in data centers and cloud service providers, Microsoft has decided to bring SQL Server to Linux.

In this session, I'll demonstrate how to set up and test SQL Server on Fedora/Red Hat and Ubuntu/Debian based systems. You'll gain practical insights on how to create your own SQL Server running on Linux and test its usage. I'll compare and contrast of its similarities and differences of SQL Server on these two vastly different operating systems. Come to my talk to keep abreast of this interesting development.

SessionID: 59596

I’m It – Survival Techniques for the Lone DBA

Back to calendar

Event Date: 11-03-2017 - Session time: 10:55: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: 62663

How SQL Monitor speeds YOU up!

Back to calendar

Event Date: 11-03-2017 - Session time: 10:55:00 - Track: Enterprise Database Administration Deployment

Speaker: Anthony Nocentino

Title: How SQL Monitor speeds YOU up!

Abstract:

Are you a lone DBA shop or a big shop with too many servers to handle? If so, how do you keep up with the availability and performance of your SQL Servers? Have you rolled your own monitoring solution…even that’s hard to keep up with. It’s time for a professional grade monitoring tool to help YOU do your job…more efficiently. In this session we’re going to discuss why you should monitor your SQL servers, and specifically why you should use a monitoring tool. We’ll introduce Redgate’s SQL Monitor and demonstrate how you can use this tool to make YOU faster and your SQL Servers!

SessionID: 63205

Cameron Jones - Adopting Agile Database Management

Back to calendar

Event Date: 11-03-2017 - Session time: 10:55:00 - Track: Application Database Development

Speaker: Bob Pusateri

Title: Cameron Jones - Adopting Agile Database Management

Abstract:

TBA

SessionID: 56752

Whip Away Stress at Home Work to Create a Better You

Back to calendar

Event Date: 11-03-2017 - Session time: 12:25:00 - Track: Professional Development

Speaker: Karlyn LeBlanc

Title: Whip Away Stress at Home Work to Create a Better You

Abstract:

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

SessionID: 57955

Introduction to Azure Machine Learning

Back to calendar

Event Date: 11-03-2017 - Session time: 12:25:00 - Track: Advanced Analysis Techniques

Speaker: Warren Sifre

Title: Introduction to Azure Machine Learning

Abstract:

We will discuss what is Azure Machine Learning, how it works, what it can do, and why would you use it. This session includes demonstration and use case scenarios. The goal of this session it to provide an understand of what Azure ML can do and how it may apply to business use cases.

SessionID: 59317

Designing Stored Procedure Solutions

Back to calendar

Event Date: 11-03-2017 - Session time: 12:25:00 - Track: Application Database Development

Speaker: Jennifer McCown

Title: Designing Stored Procedure Solutions

Abstract:

With a little T-SQL experience, you can create a stored procedure that completes a task. But it's harder to formulate a stored procedure solution with the big picture in mind. In this session, we will work through a real world scenario to develop a thorough solution. You will learn about:

Asking the right questions to set yourself up for success Making the case for stored procedures over ad hoc code and other objects Pro tips for standardization and cross-version compliance Reevaluating and expanding on your solution Limiting inputs to reduce unexpected behaviors and errors Choosing between alternate solutions Evaluating for performance

This session is for data professionals who can write T-SQL, but haven't spent a lot of time in SQL development.

SessionID: 59336

Help! My Replication Has Fallen and We Can#39;t Get it Replicating again.

Back to calendar

Event Date: 11-03-2017 - Session time: 12:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Thomas Lane

Title: Help! My Replication Has Fallen and We Can#39;t Get it Replicating again.

Abstract:

The audience will be presented with a number of broken-down replication scenarios and they will hunt down the cause of each failure and find ways to correct the problem and/or prevent it from happening again. Throughout the adventure, the various replication types will be discussed and pro-active methods of monitoring and fault tolerances will be discussed.

SessionID: 59360

Emergency! Are You Ready for Disaster to Strike?

Back to calendar

Event Date: 11-03-2017 - Session time: 12:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Allen White

Title: Emergency! Are You Ready for Disaster to Strike?

Abstract:

Most of the time pilots are learning to fly, they're actually learning how to recover from emergency conditions. While we as Database Administrators focus on taking backups, how much time do we actually spend practicing recovering with those backups? This session will focus on the kinds of situations that can dramatically affect a data center, and how to use checklists to practice recovery processes to assure business continuity.

SessionID: 59599

Digging Out From Corruption

Back to calendar

Event Date: 11-03-2017 - Session time: 12:25:00 - Track: Enterprise Database Administration Deployment

Speaker: Eddie Wuerch

Title: Digging Out From Corruption

Abstract:

A "Disaster" doesn't need to be on a massive scale to cause widespread destruction in your enterprise. Simple things like failing hardware, strange storage bugs, a forgotten WHERE clause, or an angry employee can either cause devastation or be just a nuisance to the properly-prepared DBA. This session is a survey of recovery techniques that should be in every DBA's toolbox.

SessionID: 59623

Introduction to SQL Server Indexes

Back to calendar

Event Date: 11-03-2017 - Session time: 12:25:00 - Track: Application Database Development

Speaker: Jason Strate

Title: Introduction to SQL Server Indexes

Abstract:

Having the right indexes supporting your databases is a critical need. But how do you determine what indexes are most effective? Should you have single or multi-column indexes? Should the index be filtered? What are included columns and columnstore indexes and when should they be used? In this session, we explore various ways to implement indexes and provide the performance expected out of your databases.

SessionID: 59705

Advanced Spatial Analysis Beyond Bubble Charts

Back to calendar

Event Date: 11-03-2017 - Session time: 12:25:00 - Track: BI Information Delivery

Speaker: Jason Horner

Title: Advanced Spatial Analysis Beyond Bubble Charts

Abstract:

Are you finally ready to unlock the power in your spatial data? In this session, we will explore some advanced spatial analysis techniques, including clustering, binning, and the basic use of spatial statistics. We will then discuss several options for visualizing the results in SQL Server Reporting Services and Power BI. Get ready to go beyond bars and bubble charts!

SessionID: 63206

Devon Lawler - Native Scheduler Showdown

Back to calendar

Event Date: 11-03-2017 - Session time: 12:25:00 - Track: Application Database Development

Speaker: Bob Pusateri

Title: Devon Lawler - Native Scheduler Showdown

Abstract:

This will be a presentation on the native Task Schedulers of the world (Windows Task Scheduler, SQL Agent and Cron), and the gaps that can be filled by JAMS.

SessionID: 63217

SANLess SQL Server Clusters on Windows and Linux

Back to calendar

Event Date: 11-03-2017 - Session time: 12:25:00 - Track: Enterprise Database Administration Deployment

Speaker: David Bermingham

Title: SANLess SQL Server Clusters on Windows and Linux

Abstract:

Join this session to learn how to add disaster recovery protection to your Windows cluster or to create a SANLess cluster for complete failover protection in environments where shared storage clusters are impossible or impractical, such as cloud, virtual servers, and high performance storage environments.

SessionID: 57373

Isolation Levels – Understanding Transaction Temper Tantrums

Back to calendar

Event Date: 11-03-2017 - Session time: 13: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: 57785

Parameter Sniffing the Good, the Bad, and the Ugly

Back to calendar

Event Date: 11-03-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Lance Tidwell

Title: Parameter Sniffing the Good, the Bad, and the Ugly

Abstract:

Parameter sniffing is something that more than often helps performance on your servers; however, there are times when it can hinder performance as well. In this session we will define exactly what parameter sniffing is, and examine when it is good and when it is bad. Lastly, we will explore the different options available to fix bad parameter sniffing. After this session, you will be able to locate and fix bad parameter sniffing when it occurs on your servers.

SessionID: 57894

Don't Let History Be a Mystery! Temporal Data in SQL Server 2016

Back to calendar

Event Date: 11-03-2017 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Adam Machanic

Title: Don't Let History Be a Mystery! Temporal Data in SQL Server 2016

Abstract:

It's been said that the only constant is change, and no truism better defines the average database workload. With data constantly shifting in form and focus, DBAs and developers find themselves fielding myriad questions about whens and whys: When did this fact get updated? Why is data quality lower than it was last week? And where did my sales figures go?!? Solutions such as Change Tracking, Change Data Capture, and hand-rolled triggers can each be leveraged to help in this scenario, but with various ugly tradeoffs. SQL Server 2016 introduces Temporal Tables, a new technology that finally gets us what we've needed all along. In this session you'll learn how to enable seamless and automatic history collection, take control of a great query experience, and build on a solid platform to help your users understand data history. By taking advantage of this fantastic feature, you'll approach your next project ready to answer all of the questions that constant change brings to the table.

SessionID: 58279

SQL Server High Availability in Azure IaaS

Back to calendar

Event Date: 11-03-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: David Bermingham

Title: SQL Server High Availability in Azure IaaS

Abstract:

Deploying mission critical SQL Server in Azure IaaS requires an in-depth understanding of storage, virtual networks, load balancers, SQL Server AlwaysOn and more. To qualify for Azure’s SLA of 99.95% availability, steps must be taken to mitigate downtime by leveraging Fault Domains and Update Domains in conjunction with traditional HA options.

Azure Resource Manager (ARM) replaces Azure “Classic” as the preferred deployment method in Azure. New features such as Deployment Templates and Resource Groups introduced in ARM make it a powerful tool in managing the entire life-cycle of SQL Server in Azure.

In this session attendees will learn how to leverage ARM to deploy SQL AlwaysOn Availability Groups and Failover Cluster Instances. Template Deployments and manual configurations using the Azure Portal and Azure PowerShell will be demonstrated.

SessionID: 59367

SSAS 2016 Tabular - Diving into the new features

Back to calendar

Event Date: 11-03-2017 - Session time: 13:45: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: 59564

SQL Server System Behavior: Observation Intervention

Back to calendar

Event Date: 11-03-2017 - Session time: 13:45:00 - Track: Advanced Analysis Techniques

Speaker: Lonny Niederstadt

Title: SQL Server System Behavior: Observation Intervention

Abstract:

Workload, resource demand and resource capabilities blend together; system behavior and responsiveness emerge.

See how various perfmon counters (and DMV data) inter-relate, hinting at capacity planning and system optimizations. In this session attendees will see profiles and interventions based situations including

1. CPU network waits
2. CPU disk waits
3. CPU parallel threads
4. Memory pending memory grants

SessionID: 59609

Protecting Your Data with Encryption

Back to calendar

Event Date: 11-03-2017 - Session time: 13:45:00 - Track: Application Database Development

Speaker: Ed Leighton-Dick

Title: Protecting Your Data with Encryption

Abstract:

We’ve all seen the recent news stories about companies whose data has been stolen by hackers. What was once a rare event has become all too common, and companies large and small are at risk. While it isn’t always possible to prevent intrusions, you can reduce the risk by encrypting your data. In this presentation, I’ll show you the four ways that SQL Server provides to encrypt data: hashes, cell-level encryption, database-level encryption (also known as transparent data encryption), and backup encryption. We’ll also discuss the keys required for each type of encryption and discuss how to protect the keys themselves.

SessionID: 59625

Strategies for SQL Server Index Analysis

Back to calendar

Event Date: 11-03-2017 - Session time: 13:45:00 - Track: Enterprise Database Administration Deployment

Speaker: Jason Strate

Title: Strategies for SQL Server Index Analysis

Abstract:

Properly managing indexes for a database is a common usse in many environments. When reviewing an index, should it have a single or multiple columns? Should the table be a heap, a clustered index or clustered columnstore index? These considerations are often at the forefront when analyzing your indexes. In this session, we#39;ll look at easy methods for identifying new indexes, we'll review patterns for index consolidation, and discuss how and when to remove indexes. At the end, you'll have a strategy that helps design indexes to improve performance.

SessionID: 62657

Tricks and Traps to Deploying SaaS to SQL in the Azure Cloud

Back to calendar

Event Date: 11-03-2017 - Session time: 13:45:00 - Track: Cloud Application Development Deployment

Speaker: Scott Ellis

Title: Tricks and Traps to Deploying SaaS to SQL in the Azure Cloud

Abstract:

Scott will discuss some of the challenges he has faced at kCura, moving Relativity to SaaS: TDE, AOAG, SIDS, Deleting AOAG databases, Regression, parity between all environments, SQL consolidation (Azure listeners, the network, and planning migrations).

SessionID: 56754

How to get Microsoft Certified

Back to calendar

Event Date: 11-03-2017 - Session time: 15:05:00 - Track: Professional Development

Speaker: John Deardurff

Title: How to get Microsoft Certified

Abstract:

This session focuses on what you need to know to get Microsoft Certified on SQL Server. The session is led by an expert Microsoft Certified Trainer (MCT) who regularly teaches the SQL Server certification courses. The presenter walks you through the certifications, exams, and resources available to get you ready for certification..

SessionID: 56764

Tips that have saved my bacon

Back to calendar

Event Date: 11-03-2017 - Session time: 15:05:00 - Track: Enterprise Database Administration Deployment

Speaker: Greg Moore

Title: Tips that have saved my bacon

Abstract:

In this session, I propose to share some of the tricks I've used on the operational side of being a DBA.

There's saying, never perform small miracles, people to rely on them, but isn't it useful to have a few in your back-pocket.

Everyone knows log-shipping is great for DR recovery, but what about using it for minor issues, like a delete or update gone bad? Want to move a large table someplace else (like that "oh it'll just be a small audit table, it won't grow large because we'll write the functionality later to keep it small" and they never do? UNC backups... an often overlooked but useful option for making a backup AND getting it off your server. Run a small operation where too many fingers have access to the operational DB and you want to catch them? These are some of the tricks I've picked up over the years and used more than once to perform small miracles and have saved my bacon or the bacon of others

SessionID: 56844

Build ETL efficiently (10x) with Minimal Logging

Back to calendar

Event Date: 11-03-2017 - Session time: 15:05: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: 57385

The Lost Science of Set Theory

Back to calendar

Event Date: 11-03-2017 - Session time: 15:05:00 - Track: Application Database Development

Speaker: Aaron Cutshall

Title: The Lost Science of Set Theory

Abstract:

Many database developers today do not have a Computer Science degree and may also have begun their career developing software using procedural programming languages (Java, C#, etc.). As a result, they may not have the background needed to conceptualize solutions in terms of sets of data and therefore may not be able to develop efficient set-based queries. In this session, we will review the basics of set theory and how it applies to database development to enable you to turn cursors, loops, and other procedural programming practices into efficient set-based operations that make the most use of a relational database engine.

SessionID: 57666

Tackling Technical Blogging

Back to calendar

Event Date: 11-03-2017 - Session time: 15:05:00 - Track: Professional Development

Speaker: Mike Hays

Title: Tackling Technical Blogging

Abstract:

Ever thought of writing a technical blog? This session will cover the Ws (who, what, when, where, why, how) of getting a technical blog started. Answer the question of how it can be done for free. Discuss why pay for your own domain name. Explain how to be on the first page of a search engine. Learn how to determine the time commitment. And finally determine topics to write about.

SessionID: 58250

A Closer Look at Distributed Availability Groups

Back to calendar

Event Date: 11-03-2017 - Session time: 15:05:00 - Track: Enterprise Database Administration Deployment

Speaker: Allan Hirt

Title: A Closer Look at Distributed Availability Groups

Abstract:

SQL Server 2016 introduces a new way of deploying an availability group: Distributed Availability Groups. This new form of an AG allows you to span different underlying Windows Server Cluster topologies which can enable both disaster recovery and migration scenarios. This session will cover how Distributed Availability Groups work, how you need to think about them in a possible deployment scenario, as well as show a demo of one in action.

SessionID: 59370

Common Data Patterns that You've Never Dared to Transform with Power BI

Back to calendar

Event Date: 11-03-2017 - Session time: 15:05:00 - Track: Analytics and Visualization

Speaker: Gil Raviv

Title: Common Data Patterns that You've Never Dared to Transform with Power BI

Abstract:

Power BI Query Editor (AKA Power Query / Get Transform in Excel) is a magnificent tool for self-service ETL. While it is so easy to perform basic data cleansing with its user interface, there are common data patterns that are not easily achieved. Many users will shy away from Power BI Desktop when confronting these patterns. But not you! Join this session to learn the almost secret sequence of transformation steps in the UI to resolve the most common data wrangling challenges.

SessionID: 59530

Stretch Database and Managed Backups: Cloud Services for your SQL Servers

Back to calendar

Event Date: 11-03-2017 - Session time: 15:05:00 - Track: Enterprise Database Administration Deployment

Speaker: Andrew Loree

Title: Stretch Database and Managed Backups: Cloud Services for your SQL Servers

Abstract:

Utilizing Azure cloud services does not mean moving all of your data or control away from your on-premises SQL Servers. In this session we will cover the new SQL 2016 Stretch Database and the SQL 2014 Managed Backups to Azure features. We will look at use-cases and limitations of both features to illustrate how these cloud services may fit into your current SQL Server environment.

SessionID: 59617

Relational Data Architecture 101

Back to calendar

Event Date: 11-03-2017 - Session time: 15:05:00 - Track: Application Database Development

Speaker: Pat Phelan

Title: Relational Data Architecture 101

Abstract:

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

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

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

SessionID: 62789

My Brain Has Blue Screened - Let's Laugh

Back to calendar

Event Date: 11-03-2017 - Session time: 15:05:00 - Track: Other

Speaker: David Klee

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

Abstract:

Is your brain mush from too much technical content, but you just need a break before the next session or the raffle? Come share your IT war stories with the group and laugh for an hour. This open panel session is guaranteed to at least get a chuckle as we all relax and share our experiences.

This site is open source. Improve this page.