Sessions & Content

Search
Content Type
Conference
Tags
Introduction to Perf Troubleshooting Using Wait Statistics Paul Randal
Learn what wait statistics are and how to use them to identify performance bottlenecks.
Behind the Query Store… Kalen Delaney
Look inside Query Store to see what it does and how it works
DAX for the SQL developer Alexander Arvidsson
Learning DAX can be tricky, especially if you have a background in SQL.
The video is not available to view online.
DAX Gotchas Chris Woolderink
The FILTER function does not create a new filter context but a row context. The ROW function is executed in a filter context without creating a row context. To demystify this and all the other DAX Gotchas that I bumped into is the goal of my session.
Deeper Integration and New Transformation for SSIS in ADF Sandy Winarko
This session focuses on the deeper integration of SQL Server Integration Services (SSIS) in Azure Data Factory (ADF) and the broad extensibility of Azure-SSIS Integration Runtime (IR).
Lets go deep in SQL Server Unit Testing with Visual Studio Geovanny Hernandez
Everyone that has been involved in Software Development can notice how huge the impact of a bug can be, and Databases are not the exception. In this session, you will learn how to test your SQL Server projects using Visual Studio and SQLUnitTesting.
The video is not available to view online.
Lightning Talks Various Speakers
A chance for speakers new and seasoned to take the stage for 5 minutes and effuse about something/anything in SQL Server they love.
The video is not available to view online.
PowerShell Medley Jonathan Allen
A stream of handy tips, tricks, and ideas to boost your PowerShell skills and productivity.
Slack for the DBA Stuart Moore
Slack, Bots, ChatOps? Is any of this useful to a DBA? Yes, come and let me show you how!
The video is not available to view online.
Understanding Gremlin and Azure Cosmos DBs Graph API for SQL Professionals Dave Lusty
Azure Cosmos DB has many use-cases, and not all of them are clear to Azure Cosmos DB newcomers. If you're a relational expert and have been wondering about graph, how you'd survive without a schema, and scale out databases this session can help.
Data Science For The DBA - Get Started Now Manohar Punna
If you are a DBA and want to get started with Data Science, then this session is for you. This demo-packed session will show you an end-to-end Data Science project covering the core technologies in Microsoft Data + AI stack.
DAX Best Practices Marco Russo
Best bractices in DAX formulas from real world experience.
Introduction to Graph Processing with SQL Server 2017 Markus Ehrenmüller-Jensen
Hierarchies and graphs are the bread and butter of most business applications. SQL Server 2017 comes now with a different approach: Graph Database. You will learn best practices, have fun and will leave with handy scripts.
Parallel Database Maintenance with 24/7 Systems and Huge DBs Grzegorz Łyp
Session deals with the database maintenance problems (like defragmentation) in situation of 24/7 system. As we walk through the basic maintenance we keep in mind that our database is big and it takes a lot of time to do the proper maintenance.
Performance Monitoring Using Extended Events, DMVs & Query S Ola Hallengren
Extended Events, Dynamic Management Views, and Query Store are powerful and lightweight tools. In this session you will learn techniques for combining the data from these tools, to gain great insight, when analyzing performance problems.
Revenge: The SQL! Rob Volk
Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.
The video is not available to view online.
Row Level Security-A real world example Bjørn D. Jensen
Row Level Security based on related tables
Simplifying XEvents Management with dbatools Chrissy LeMaire
Bye #TeamProfiler and hi #TeamXEvents with the power of dbatools
Tame Your Unruly Data...With Constraints! Rob Volk
Is your data badly behaved and embarrassing you? Are you tired of cleaning up its messes? Constraints can help you straighten out your wayward data and put it on the right path before it gets into too much trouble.
Temporal Data in SQL Server Dejan Sarka
Use temporal support in SQL Server and add what is missing out of the box.
What is the Azure SQL Datawarehouse? Vitor Fava
In this session we will discuss about the Azure SQLDW and how we can use it to help on our day to day.
A Beginner’s Guide to Cloud Computing and SQL Azure David Postlethwaite
This talk takes a look at Cloud Computing – what it is, the types of Cloud available and their advantages and disadvantages along with what Microsoft Azure has to offer.
The video is not available to view online.
Advanced MDX Tips And Tricks Chris Webb
Think you know MDX? This session will show you some advanced, little-known but nonetheless practical tips and tricks for writing complex calculations and making your queries run faster.
The video is not available to view online.
Enhancements that will make your SQL engine roar #1 Pedro Lopes
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
The video is not available to view online.
Enhancements that will make your SQL engine roar #2 Pedro Lopes
Do you have an application running with an in-market version of SQL Server, such as 2012 or 2014? Then this session is for you! We will see more in-depth what enhancements are in the latest SPs and 2016, and why you should install them.
The video is not available to view online.
Locking and Blocking Kalen Delaney
Locking and blocking is SQL Server’s default method of managing concurrency in a multi-user environment. In this session we’ll look at the three main aspects of locking, including when locks cause blocking and also examine ways to minimize blocking.
The video is not available to view online.
Recovery Models Made SIMPLE Kalen Delaney
This session looks inside the transaction log to see exactly what is logged for minimally logged operations in each of the recovery models. We also look at other factors in our SQL Server operations that affect what is actually written to the log.
The video is not available to view online.
Responding to Extended Events in near real-time Gianluca Sartori
In this session we will see how the Extended Events streaming API can be used to process events in a near real-time fashion. We will demonstrate how this technology enables new possibilities to solve real world problems.
The video is not available to view online.
SQL Server 2016-Security Obscurity and Encryption Andreas Wolter
Security is one of the top topics for the new release of SQL Server. A total of 3 completely new features are coming to us: Always Encrypted, Dynamic Data Masking and Row Level Security.
The video is not available to view online.
Testing T-SQL Made Quick and Easy Steve Jones
Everyone tests their code, but most people use ad hoc, non-repeatable testing with simple queries. This session will show you how to begin implementing testing into your development process, giving you a growing library that improves code quality.
The video is not available to view online.
The Query Store and Query Tuning in SQL Server vNext Grant Fritchey
SQL Server 2016 introduces the Query Store. The Query Store will change how you tune queries. Come to this session to learn everything you'll need.
The video is not available to view online.
A Comedy of Errors Andrew Whettam
Error handling in T-SQL stored procedures
A Look at 3 Big Data Tools Allan Mitchell
This session will look at SQOOP, PIG and HIVE. Three tools which are essential in your Big Data Toolbox. We'll look at what they do, how they do it and why you would want to use them
Advanced Reporting Techniques & Managing Reports Dr. Subramani Paramasivam
What are the techniques to implement linked reports, subscriptions, report history, snapshot options, editing report using browser based Report Builder? Find out in this session.
Building Your T-SQL Tool Kit: Window Function Fundamentals Christina E. Leo
Sets are king when it comes to SQL Server, but sometimes you need to see data row by row. Window Functions help you get the best of both worlds. Learn when and where these functions can help you get what you need without compromising performance.
Dive into the Query Optimizer-Undocumented Insight Benjamin Nevarez
This 500 level session will focus on using undocumented statements and trace flags to get insight into how the query optimizer works and show you which operations it performs during query optimization.
Inside Ola Hallengrens Maintenance Solution Ola Hallengren
In this session I will talk about backup, integrity check, and index and statistics maintenance, and how you can use my maintenance solution (http://ola.hallengren.com) in an enterprise environment.
Intro to R Steph Locke
R was originally for doing stats, but it now does database CRUD, reporting, documentation, and even websites. It can be awkward to know where to start, so this session fast tracks you to the sections you need to know about.
Latches, Spinlocks, and Lock Free Data Structures Klaus Aschenbrenner
Join this session to make a deep dive into how SQL Server implements physical locking with lightweight synchronization objects like Latches and Spinlocks.
Power BI, zero to expert Peter ter Braake
PowerBi is hot. This session starts with an empty Excel workbook and walks you via Power Pivot and Power Query to Power View and Power Map.
Query Progress Tracking in SQL Server Matan Yungman
It's 18:00 o'clock on Friday. You execute a process that usually takes a few minutes and start packing in order to start the weekend. You are already with your bag on your back, but the process doesn't finish. What should you do now?
Revenge: The SQL! Rob Volk
Are you a frustrated DBA? Ready to snap? Before you do, come see Revenge: The SQL! and learn a kinder, gentler form of vengeance.
T4 Templating within SSDT using SQL Server 2014 Geoff Clark
T4 templating will be a first class citizen in SSDT for SQL Server 2014. This session will show why you should use this technology for SQL code generation and how you can automate the process. The session will be demo rich.
The dangerous beauty of Bookmark Lookups Klaus Aschenbrenner
Join me in this session to get a basic understanding of Bookmark Lookups, and why they can be dangerous in SQL Server.
The SSDT way or the highway (sqlproj) Craig Ottley-Thistlethwaite
So you have heard of SQL Server Data Tools (SSDT), you have started using it but not entirely sure how to use it to it's full potential. This session is perfect for adopters of SSDT and how to get the most out of it.
Things You Can Find in the Plan Cache Matan Yungman
The plan cache is one of SQL Server's fundamental components. Getting to know it can take you a few steps ahead in optimizing your system. In this session we will demonstrate ways the Plan Cache can help us identify performance problems.
T-SQL : Bad Habits & Best Practices Aaron Bertrand
Come to this session to learn how bad habits develop, the problems they lead to, and how you can avoid them.
T-SQL Tips and Tricks Itzik Ben-Gan
The purpose of this session is to have some fun with T-SQL and to learn practical tips and tricks that will help you improve and optimize your solutions.
Understanding Parameter Sniffing Benjamin Nevarez
This session will show you how parameter sniffing works and in which cases could be a problem. How to diagnose and troubleshoot parameter sniffing problems and their solutions will be discussed as well.
Data loading at warp speeds Ami Levin
Do you struggle to reduce those frustrating long hours it takes to load data? Are your time windows for loading becoming too short for comfort? If so – you simply can’t afford to miss this session…
<<123>>