sqlpasshistory

ID: 773

Back to Main list

24 Hours of PASS: Summit Preview 2017

Session Date/Time (dd-MM-YYYY 24h) Speaker Category Track Title
19-07-2017 12:00 Brent Ozar, Erik Darling 24 Hours of PASS (60 minutes) Perform Last Season's Performance Tuning Techniques
19-07-2017 13:00 Scott Currie 24 Hours of PASS (60 minutes) Build Create and Load a Staging Environment from Scratch in an Hour with Biml
19-07-2017 14:00 Lynn Winterboer 24 Hours of PASS (60 minutes) Build Writing User Stories and Slicing Epics for DW/BI Teams
19-07-2017 15:00 Oscar Li 24 Hours of PASS (60 minutes) Build Introduction to Global Data Quality
19-07-2017 16:00 Kendra Little 24 Hours of PASS (60 minutes) Build Why Did My Clever Index Change Backfire? (Preview)
19-07-2017 17:00 Kellyn Pot'Vin-Gorman 24 Hours of PASS (60 minutes) Support DevOps and the Agile DBA
19-07-2017 18:00 Allan Hirt 24 Hours of PASS (60 minutes) Build The SQL Server 2017 Availability Story on Linux
19-07-2017 19:00 Erin Stellato 24 Hours of PASS (60 minutes) Perform Help me, Query Store. You're My Only Hope
19-07-2017 20:00 Sidney Andrews 24 Hours of PASS (60 minutes) Design Building Polyglot Data Solutions in Azure with Azure Cosmos DB
19-07-2017 21:00 Chrissy LeMaire, Constantine Kokkinos 24 Hours of PASS (60 minutes) Perform PowerShell ?? SQL Server: Modern Database Administration
19-07-2017 22:00 Martin Wild 24 Hours of PASS (60 minutes) Build SQL Server on Linux – Don’t be afraid… this is the same SQL Server that you already know and love.
19-07-2017 23:00 Ike Ellis 24 Hours of PASS (60 minutes) Perform A Lap Around Azure Big Data and MPP Offerings
20-07-2017 00:00 Ginger Grant 24 Hours of PASS (60 minutes) Analyze Implementing Advanced Analytics with SQL Server 2017 and Python
20-07-2017 01:00 Joseph D'Antoni 24 Hours of PASS (60 minutes) Perform Lessons on Linux for the SQL Server Professional
20-07-2017 02:00 Paul Turley 24 Hours of PASS (60 minutes) Analyze Can’t We Just Get Along? Making SSRS, Power BI and Excel Play Well Together
20-07-2017 03:00 David Klee 24 Hours of PASS (60 minutes) Perform Virtual CPUs: Right to Ludicrous Speed
20-07-2017 04:00 Kenneth Urena 24 Hours of PASS (60 minutes) Build Azure SQL VM - Implementing Basic AG in SQL 2016 STD
20-07-2017 05:00 Greg White 24 Hours of PASS (60 minutes) Analyze Getting the most from SQL Server – Deploying and Optimizing on Hyperconverged Infrastructure
20-07-2017 06:00 Cathrine Wilhelmsen 24 Hours of PASS (60 minutes) Design Tools and Tips: From Accidental to Efficient Data Warehouse Developer
20-07-2017 07:00 Ben Miller 24 Hours of PASS (60 minutes) Build PowerShell for DBAs, What’s in it For Me?
20-07-2017 08:00 Kathi Kellenberger 24 Hours of PASS (60 minutes) Perform SQL Server Data Compression
20-07-2017 09:00 Niko Neugebauer 24 Hours of PASS (60 minutes) Perform Becoming Proficient with Columnstore Indexes
20-07-2017 10:00 Jay Robinson 24 Hours of PASS (60 minutes) Scale A Guided Tour of the SqlClient Namespace
20-07-2017 11:00 Gail Shaw 24 Hours of PASS (60 minutes) Build On Transactions and Atomic Operations

SessionID: 66924

Last Season's Performance Tuning Techniques

Back to calendar

Event Date: 19-07-2017 12:00 - Category: 24 Hours of PASS (60 minutes) - Track: Perform

Speaker(s): Brent Ozar, Erik Darling

Title: Last Season's Performance Tuning Techniques

Description:

You're kinda-sorta comfortable doing performance tuning on SQL Server. You've read a few blogs, you monitor Page Life Expectancy, you rebuild your indexes, and you add an index here or there. However, you haven't been to a day-long performance tuning class yet, and you're wondering what you're missing.Thing is, in SQL Server, performance tuning changes fast. One day Perfmon counters are in, and the next day they're out. It's totally okay if you're still using SQL Server 2008 - that's not the problem. You shouldn't be wearing hammer pants, and you shouldn't be looking at PLE, monitoring Disk Queue Length, or putting your data and log files on separate drives.In this rapid-fire session, we'll show you specific examples of why performance tuning tips and tricks have fallen out of fashion, and why they're not too legit to quit.

SessionID: 66920

Create and Load a Staging Environment from Scratch in an Hour with Biml

Back to calendar

Event Date: 19-07-2017 13:00 - Category: 24 Hours of PASS (60 minutes) - Track: Build

Speaker(s): Scott Currie

Title: Create and Load a Staging Environment from Scratch in an Hour with Biml

Description:

Business Intelligence Markup Language (Biml) automates your BI patterns and eliminates the manual repetition that consumes most of your SSIS development time. During this hour long presentation, Scott Currie from Varigence will use the free BimlExpress add-in for SSDT to introduce Biml and use to automatically generate large quantities of custom SSIS packages. The session will be largely demonstration driven, and reusable sample code will be distributed for you to use in your own projects. Using a live-typing approach, Scott will start from scratch and by the end of the session create a full-blown staging environment. This will include the creation of hundreds of target table creation scripts, data load packages, data scrubbing rules, logging, and more. The best part is that you can freely reuse the code in your own environment just by changing the connection strings - or make small changes to implement your own data load patterns.

SessionID: 66935

Writing User Stories and Slicing Epics for DW/BI Teams

Back to calendar

Event Date: 19-07-2017 14:00 - Category: 24 Hours of PASS (60 minutes) - Track: Build

Speaker(s): Lynn Winterboer

Title: Writing User Stories and Slicing Epics for DW/BI Teams

Description:

Agile is all the rage in software development, and many data warehousing and business intelligence (DW/BI) professionals are interested in leveraging Agile approaches to change the way they deliver value to their organizations. One of the first things we learn about in a book or course on Agile is replacing "requirements" with "user stories", yet the examples provided are usually not relevant to the data world. This can leave us somewhat skeptical about whether this approach to requirements would work for DW/BI projects.

This session shares how to write user stories for a DW/BI project, and explains how these user stories contribute to several key Agile principles: ? Satisfy customers through early and continuous delivery ? Working BI features are our primary measure of progress ? Business people and the delivery team work together regularly

Attendees will leave understanding what a well-written DW/BI user story looks like.

SessionID: 66916

Introduction to Global Data Quality

Back to calendar

Event Date: 19-07-2017 15:00 - Category: 24 Hours of PASS (60 minutes) - Track: Build

Speaker(s): Oscar Li

Title: Introduction to Global Data Quality

Description:

In an increasingly globalized data driven world, you may already know of the impact of data growing at an exponential rate. The amount of data in the data pond is doubling every year, and that quickly changes how we approach and understand data. Additionally, emerging global markets introduces problematic international data sets that traditional data quality methods do not always address definitively. Learn about the fundamentals of a data quality life cycle and best practices to approach international data sets with technologies like SSIS and SQL Server.

SessionID: 66925

Why Did My Clever Index Change Backfire? (Preview)

Back to calendar

Event Date: 19-07-2017 16:00 - Category: 24 Hours of PASS (60 minutes) - Track: Build

Speaker(s): Kendra Little

Title: Why Did My Clever Index Change Backfire? (Preview)

Description:

SQL Server is full of advanced techniques to build powerful indexes: indexed views, filtered indexes, columnstore indexes, and more. But many of these techniques have risks: your cool indexing idea may backfire and leave your users frustrated. In this preview session, you'll see a few demos of how different indexing patterns may slow down queries, have dangerous side effects, or not work at all. If you have a solid knowledge of index basics and are comfortable reading query execution plans, this session will improve your index tuning skills.

SessionID: 66926

DevOps and the Agile DBA

Back to calendar

Event Date: 19-07-2017 17:00 - Category: 24 Hours of PASS (60 minutes) - Track: Support

Speaker(s): Kellyn Pot'Vin-Gorman

Title: DevOps and the Agile DBA

Description:

DevOps came out of the Agile movement and the idea that operations needed to be part of the solution for agile development to be successful. The DBA was often the most resilient and robust member of the operations team and most resistant to change. This mentality was essential to the protection of company’s critical production data. This session discusses common database challenges and how they can be minimized or solved with newer DevOps practices without impacting the DBAs “safe zone”. We’ll discuss how to use these vital skills and motivate everyone towards solutions for more success in agile development environments. Development, testing, provisioning, patching, upgrading and managing will become easier with agile tools, virtualization and collaboration.

The take-aways from this session are to embrace DevOps basics with a “DBA twist” such as:

Discover the power of virtualization and powerful agile development practices providing more value to even the most senior database expert. We’ll demo different scenarios surrounding DevOps, virtualization and how to make the DBA pivotal to DevOps success.

SessionID: 66927

The SQL Server 2017 Availability Story on Linux

Back to calendar

Event Date: 19-07-2017 18:00 - Category: 24 Hours of PASS (60 minutes) - Track: Build

Speaker(s): Allan Hirt

Title: The SQL Server 2017 Availability Story on Linux

Description:

Although the paint on SQL Server 2016 just finished drying, the next version of SQL Server – SQL Server 2017 –  is almost here. One of the biggest changes is that SQL Server will be supported on Linux in addition to Windows Server. This means that all of the considerations we have for deploying instances and databases will be relevant and possibly different on Linux, including how we make SQL Server installations highly available. This session will cover the availability options for Linux-based SQL Server deployments, interoperability with Windows-based deployments, and known tips and gotchas. If you want to get a head start with availability for SQL Server on Linux, this session is for you.

SessionID: 66936

Help me, Query Store. You're My Only Hope

Back to calendar

Event Date: 19-07-2017 19:00 - Category: 24 Hours of PASS (60 minutes) - Track: Perform

Speaker(s): Erin Stellato

Title: Help me, Query Store. You're My Only Hope

Description:

The Query Store feature in SQL Server is marketed as a flight recorder for your database. It's the black box in an airplane; it's Obi-Wan Kenobi to Princess Leia in A New Hope.  But you don't have to be a Jedi to know how to use it.  

In this preview of my full-day workshop on Query Store, you'll learn how to find regressed and problematic queries using the Query Store data.  We’ll look at the information that SQL Server captures and see how to use the SSMS reports and catalog views to find the worst offenders.  No longer will you have to flail about, trying to find the issue.  After this session you’ll be able to quickly and confidently pinpoint the problem.

SessionID: 66928

Building Polyglot Data Solutions in Azure with Azure Cosmos DB

Back to calendar

Event Date: 19-07-2017 20:00 - Category: 24 Hours of PASS (60 minutes) - Track: Design

Speaker(s): Sidney Andrews

Title: Building Polyglot Data Solutions in Azure with Azure Cosmos DB

Description:

Let’s look at the new Azure Cosmos DB and how we can use it as a core part of polyglot data solutions combining NoSQL databases, relational databases and search engines together for a best of all worlds. In our demos, we will look at how you can populate a relational database from Azure Cosmos DB, push documents from Azure Cosmos DB into Azure Search and even use a key-value store as a quick cache mechanism.

SessionID: 66934

PowerShell ?? SQL Server: Modern Database Administration

Back to calendar

Event Date: 19-07-2017 21:00 - Category: 24 Hours of PASS (60 minutes) - Track: Perform

Speaker(s): Chrissy LeMaire, Constantine Kokkinos

Title: PowerShell ?? SQL Server: Modern Database Administration

Description:

This session is aimed at data professionals, from junior to senior, who want to embrace the ease of automation and increase their DevOps toolset.

SessionID: 66929

SQL Server on Linux – Don’t be afraid… this is the same SQL Server that you already know and love.

Back to calendar

Event Date: 19-07-2017 22:00 - Category: 24 Hours of PASS (60 minutes) - Track: Build

Speaker(s): Martin Wild

Title: SQL Server on Linux – Don’t be afraid… this is the same SQL Server that you already know and love.

Description:

Please join Quest database expert Martin Wild in this informative session on Microsoft SQL Server vNext and learn how easy it is to deploy the new SQL Server on Linux technology.

Join to learn: • The timelines and mechanics of deploying SQL Server vNext/2017 on Linux • Insights and observations on setup and configuration • The simplicity of performing common SQL Server DBA tasks on SQL Server on Linux (demos) • A side-by-side benchmark session of workloads running on Windows and Linux • Some great Quest SQL Server monitoring and diagnostics solutions, along with some cool free tuning tools.

SessionID: 66930

A Lap Around Azure Big Data and MPP Offerings

Back to calendar

Event Date: 19-07-2017 23:00 - Category: 24 Hours of PASS (60 minutes) - Track: Perform

Speaker(s): Ike Ellis

Title: A Lap Around Azure Big Data and MPP Offerings

Description:

In this session, we'll explore the big three PAAS offerings of Azure:  SQL Server Data Warehouse, Azure Data Lake Analytics, and HDInsight.  We'll discuss when you'd use one over the other, how to implement them, how to know what you're paying for, and best practices for tuning and maintaining your projects with these tools.  We'll even demonstrate how you can use them all together!  

SessionID: 66937

Implementing Advanced Analytics with SQL Server 2017 and Python

Back to calendar

Event Date: 20-07-2017 00:00 - Category: 24 Hours of PASS (60 minutes) - Track: Analyze

Speaker(s): Ginger Grant

Title: Implementing Advanced Analytics with SQL Server 2017 and Python

Description:

Looking to find out what is coming next with SQL Server? Thinking about learning a new analytical language to keep up with market demand? You will want to attend this session.

SQL Server 2016 added R to the analytical toolset and SQL Server 2017 is adding Python.  When looking at various lists of the most popular programming languages, Python always has one of the top positions.  This session provides an introduction to Python, including why it is a good choice for analyzing data.  If you have not had a chance to review SQL Server 2017 yet, please attend to see some of the new changes coming later this year.  One of the features covers will show what is needed to incorporate Python into SQL Server and how Python can be incorporated in stored procedures to provide the ability to analyze data using arguably the most popular programming language to review data.

SessionID: 66931

Lessons on Linux for the SQL Server Professional

Back to calendar

Event Date: 20-07-2017 01:00 - Category: 24 Hours of PASS (60 minutes) - Track: Perform

Speaker(s): Joseph D'Antoni

Title: Lessons on Linux for the SQL Server Professional

Description:

In this session you will learn about the new release of SQL Server on Linux. You will learn about how to choose Windows versus Linux, the changes needed to make SQL Server run on Linux, and high availability and disaster recovery solutions.

SessionID: 66932

Can’t We Just Get Along? Making SSRS, Power BI and Excel Play Well Together

Back to calendar

Event Date: 20-07-2017 02:00 - Category: 24 Hours of PASS (60 minutes) - Track: Analyze

Speaker(s): Paul Turley

Title: Can’t We Just Get Along? Making SSRS, Power BI and Excel Play Well Together

Description:

Choosing the right reporting tool can be a challenge but can different reporting tools be blended to create a unified solution?  Learn the strengths and limits of each; for Self-service, IT-driven and Business-Driven BI, reporting and analytics.  We’ll review an actual solution to see how these tools are being used together to meet the needs of users and technical professionals in different roles in a large organization.

SessionID: 66933

Virtual CPUs: Right to Ludicrous Speed

Back to calendar

Event Date: 20-07-2017 03:00 - Category: 24 Hours of PASS (60 minutes) - Track: Perform

Speaker(s): David Klee

Title: Virtual CPUs: Right to Ludicrous Speed

Description:

One of the largest points of contention with virtual SQL Servers and the VM administrators is how to configure the CPUs. Experience says more CPUs are better for performance. VM admins say less is better. Third-party vendors say you need all of them (and it doesn’t matter how many your hosts have either). Can over-provisioning virtual machine CPUs speed things up, or does it slow things down? What is the right methodology to determine the correct number of virtual CPUs? How does this configuration align with the physical servers? From sampling and analyzing performance data, to “right-sizing’ your SQL Server virtual machine CPU count, to properly aligning the VM with the physical server NUMA topology, you will gain the understanding of how to properly manage and validate your virtual SQL Server vCPU configuration in this insightful session. Valuable tips and tricks will be shared that you can take back to your virtual SQL Servers and immediately apply to your own environments.

SessionID: 66938

Azure SQL VM - Implementing Basic AG in SQL 2016 STD

Back to calendar

Event Date: 20-07-2017 04:00 - Category: 24 Hours of PASS (60 minutes) - Track: Build

Speaker(s): Kenneth Urena

Title: Azure SQL VM - Implementing Basic AG in SQL 2016 STD

Description:

For a long time Database Professionals have been asking Microsoft to make Always on Availability Groups (AG) available in Standard Edition. With SQL Server 2016 SP1, Microsoft responded with Basic Availability Groups, a limited but very functional version of Always on Availability Groups.

Basic Availability Groups enable Data Professionals to provide enterprise class High Availability solutions using SQL Server Standard Edition, which allows organizations to save money by providing High Availability (HA) for applications that require HA without paying for SQL Server Enterprise Edition features they do not need.

In this session, we will be covering:

SessionID: 66918

Getting the most from SQL Server – Deploying and Optimizing on Hyperconverged Infrastructure

Back to calendar

Event Date: 20-07-2017 05:00 - Category: 24 Hours of PASS (60 minutes) - Track: Analyze

Speaker(s): Greg White

Title: Getting the most from SQL Server – Deploying and Optimizing on Hyperconverged Infrastructure

Description:

SQL Server is one of the most virtualized business applications and one that can benefit from changing technology trends like hyperconvergence. Hyperconverged platforms, where compute, storage, virtualization and more are combined into a single software-defined appliance, are increasingly being adopted to provide better availability, predictable performance and easier management for critical applications and databases like SQL Server. This session will discuss the benefits, pitfalls and best practices of running SQL Server with hyperconverged solutions as part of an enterprise cloud approach, including details on performance, sizing, test/dev, data protection, high availability, and real-world examples.

SessionID: 66939

Tools and Tips: From Accidental to Efficient Data Warehouse Developer

Back to calendar

Event Date: 20-07-2017 06:00 - Category: 24 Hours of PASS (60 minutes) - Track: Design

Speaker(s): Cathrine Wilhelmsen

Title: Tools and Tips: From Accidental to Efficient Data Warehouse Developer

Description:

You have probably heard about the Accidental DBA, but what about the Accidental Data Warehouse Developer? We stumbled into the world of data warehousing, learned dimensional modeling and work with T-SQL and SSIS daily. We are masters of googling solutions to our problems and making sure our ETL processes run without errors. We deliver data to business users… and the more we deliver, the more they want. This is a good thing! But how do we keep up with the increased demand?

You might not be able to rewrite your entire ETL process or change your team's processes over night, but there are many things you can do to increase your own productivity and become a more efficient and valuable Data Warehouse developer.

In this session, I will show you some of what I have learned and discovered that has made me say "Oh wow! Why did I not know this yesterday!?" - including SSMS features, tools for query analysis and tuning, free tools and scripts, Biml for SSIS and even a couple of things I used to think were only useful for those scary DBAs.

SessionID: 67026

PowerShell for DBAs, What’s in it For Me?

Back to calendar

Event Date: 20-07-2017 07:00 - Category: 24 Hours of PASS (60 minutes) - Track: Build

Speaker(s): Ben Miller

Title: PowerShell for DBAs, What’s in it For Me?

Description:

Today DBAs have a tough job as data becomes more important to everyone involved. We need to be everything to everyone and we have historically been limited in toolset.

Today is different.

DBAs now have an arsenal available to us and the new tool in the belt is PowerShell. I will show you some reasons to add PowerShell to your toolbelt and give you some reasons and examples of where this toolset will be a great addition to your day. Join me for a great insight into using PowerShell for your DBA career.

SessionID: 66921

SQL Server Data Compression

Back to calendar

Event Date: 20-07-2017 08:00 - Category: 24 Hours of PASS (60 minutes) - Track: Perform

Speaker(s): Kathi Kellenberger

Title: SQL Server Data Compression

Description:

When I first heard about data compression back when it was introduced with SQL Server 2008, I thought that it would be a performance killer. But did you know that data compression can actually improve performance? I've wanted to recommend it many of my customers over the years but often couldn't because they were running Standard Edition. Starting with SQL Server 2016 SP1, data compression is available in all editions. Now any size shop and budget can take advantage of this great feature.

SessionID: 66940

Becoming Proficient with Columnstore Indexes

Back to calendar

Event Date: 20-07-2017 09:00 - Category: 24 Hours of PASS (60 minutes) - Track: Perform

Speaker(s): Niko Neugebauer

Title: Becoming Proficient with Columnstore Indexes

Description:

Would you like to know how to become proficient with Columnstore Indexes? Would you be interested in finding out the most important & essential elements are?

Join this session to get an understanding of how to start becoming proficient with Columnstore Indexes & Batch Execution Mode. We shall be considering the necessary steps on the way to get the best possible performance out of the most important Database Engine feature for the Data Warehouses, Business Intelligence & Reporting.

SessionID: 66922

A Guided Tour of the SqlClient Namespace

Back to calendar

Event Date: 20-07-2017 10:00 - Category: 24 Hours of PASS (60 minutes) - Track: Scale

Speaker(s): Jay Robinson

Title: A Guided Tour of the SqlClient Namespace

Description:

The prototypical bridge between Transact-SQL and .NET languages is the Framework's SqlClient namespace. As developers, how well do we really know that bridge? Let's face it - sometimes we take a careful, deliberate approach to our code, and sometimes we simply copy/paste code snippets from StackExchange and move on to the next problem. That approach may work in the short term, but its success as the application grows and matures is a roll of the dice. Do you want to take this gamble with your data access code, or do you want to be confident that it will scale? A deeper understanding of the SqlClient namespace will help you write more robust code now, saving you from rewriting it later, under pressure, when the gamble doesn't pay off.

This session is a survey of some of the vital elements of the SqlClient namespace, and, depending on your experience, may serve as an introduction, a refresher, or a new perspective on a part of the .NET Framework that is often taken for granted. Demos will use C#, though the principles can be applied in any of the .NET languages.

Some Selected Topics:

Following this session, attendees should be better prepared to develop scalable and reliable solutions that use the .NET Framework to communicate with SQL Server databases.

SessionID: 66923

On Transactions and Atomic Operations

Back to calendar

Event Date: 20-07-2017 11:00 - Category: 24 Hours of PASS (60 minutes) - Track: Build

Speaker(s): Gail Shaw

Title: On Transactions and Atomic Operations

Description:

"If there’s one thing that we, as SQL developers don’t do, it’s use transactions as often as we should.

Transactions are critical when multiple changes need to be made entirely or not at all, but even given that it’s rare to see transactions used at all in most production code

In this session, we’ll look at what transactions are and why we should use them. We’ll explore the effects transactions have on locking and the transaction log. We’ll investigate methods of handling errors and undoing data modifications, and we’ll see why nested transactions are a lie.

  1. Understand what transactions are and what they do.

  2. Learn how to use transactions in combination with error handling to roll back changes on errors

  3. Learn how transactions affect logging and locking.

"