Radio and PodcastLive Radio & PodcastsOpening Radio and Podcast...
Radio and PodcastLive Radio & PodcastsFetching podcast shows and categories...
Radio and PodcastLive Radio & PodcastsFetching podcast episodes...
GroupBy.org is free technical training by the community, for the community. Volunteer speakers submit abstracts at GroupBy.org and you – the attendee – vote to pick the sessions. Want to pre...
Ever had a manager standing over your shoulder, wanting to know why an instance is running slow or if it can handle additional workload? Wha...
Every time you see a Columnstore Index getting involved in the execution plan, do you realize that there are whole execution plans behind th...
The optimizer has options. Not every option is optimal. Optimistic query tuners hope that the optimizer will make optimal choices. Often, th...
What do you want to be when you grow up? I want to be a DBA, a teacher, a blogger, and a world-traveler. I'm living my dream. In this sessio...
Whether you love or hate buzzwords, the big ones signify critical cultural changes. In this session, Kendra Little will explain what executi...
A new release of SQL Server is like a new season of your favorite TV show. Some releases in the past were lacking; I always felt like SQL Se...
This mainly demo-based session will cover the following: An introduction to partitioning, core concepts, and benefits. Choosing a Partitioni...
Have you ever developed slowly running queries and wondered how to make your own SQL Server queries go faster? I know I did. It is how I stu...
One of most common problems a DBA or database developer may face is finding and syncing data changes efficiently between multiple systems. I...
There seems to be a common misconception that once you move from on premises SQL Server to Azure PaaS offerings a DBA is no longer required....
Creating indexes is one of the most powerful ways to improve performance in your SQL Servers. It's not easy to form indexes for a large and...
I want to show you how just a little neater and tighter code can also run a lot faster. These are some of the instant performance improvemen...
As the DBA for an Agile, Sprint-based team, you may feel like the bottleneck at every turn. You've stuck with the existing processes and too...
You've been writing T-SQL queries for a few years now, and when you have performance issues, you've been updating stats and using OPTION (RE...
You identified a query that is causing performance issues, and your mission is to optimize it and boost performance. You looked at the execu...
Today's applications are not using monolithic approach anymore and evolving into micro-services architecture. Monitoring tools are also evol...
The incredible Columnstore Indexes can increase your analytical query processing speed multiple times, they are updatable (Clustered from SQ...
Microsoft emphasizes use of containers for development and test on SQL Server 2017, and new solutions from Red Gate and Windocks add support...
Will cover all new SQL 2017 features that the Data Platform Community has requested and Microsoft has included in the next major version of...
This session will cover the pros and cons of four typical configurations of AlwaysOn Availability Groups; stand-alone instances, fail-over c...
SQL injection is one of the most common ways that hackers gain access to your SQL server. Do you know how to harden your queries and protect...
You've just been given a server that is having problems and you need to diagnose it quickly. This session will take you through designing yo...
There are tools available from Microsoft, as well as from a number of third party vendors, to ease the process of integrating database unit...
Do you work for an institution that fears its DBAs could go rogue on their production databases? Do you want to revoke continuous sysadmin p...
Congratulations on your recent move into the world of SQL Server development! You've got a handle on the basics -- SELECT, INSERT, UPDATE, a...
You're a DBA or Developer, and you have a gut feeling that these simple queries with an egregious number of columns in the SELECT list are d...
I'm going to look into the basics of how encryption works and then we'll learn how we can go about writing our own encryption routines withi...
SQL Server Failover Clustered Instances (FCI) and Availability Groups (AG) depend a lot on Windows Server Failover Clustering (WSFC). But wh...
You've just been handed a SQL Server, and you need to make sure there aren't any skeletons in the closet. What things should you check to ma...
One of the most exciting new features of SQL Server 2016 is the integration of the R statistical programming language into the platform with...
T-SQL can help solve many problems you are faced with at your job. Each problem can have many solutions, but not every solution is simple to...
In this session, I will talk about advantages of Query Store, features, configuration and query optimization using Query Store on SQL Server...
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 dat...
Based on the successful 500 Level talk at PASS 2016, this session will provide an internals view of how In-Memory OLTP works for SQL Server...
Are you faced with complaints from users, poor performing code from developers, and regular requests to build reports? Do you uncover instal...
Microsoft has introduced native capability to the database engine around masking sensitive data and restricting access at the row level. All...
On this session, we follow the movement of data through batch and speed layers via Azure Data Lake Store & Analytics, Data Factory, SQL Data...
It just works – performance and scale in SQL Server 2016 database engine and what is being added to in-market versions. This session will sh...
TSQL was voted best programming language in 2013, let's explore why! In this session, we will look at what makes SQL such a fascinating lang...
Once you have successfully configured Availability Groups, what comes next? In this session, we will go beyond setup and look at how to moni...
We can be better at our jobs if we have a good grasp of basic statistics. It doesn't matter if you're a DBA looking to understand query plan...
You've heard that In-Memory OLTP is fast, but how do you know if your workload can take advantage of this awesome feature? We will explore I...
For years, you've heard that you're supposed to reorganize your indexes to make SQL Server go faster. It sounds like it makes sense - keep t...
Imagine your Data Warehouse is growing exponentially to multi-terabytes and you have been tasked to make analytics queries even faster while...
I was required to prove that I had successfully installed and configured a backup solution across a large estate. I had a number of success...
Attendees will be taken through the following: Defining what containers are (benefits and limitations) Configuring Windows Server 2016 to ru...
How do you know your database change won't affect something you haven't thought of? Database objects can have many dependent objects in the...
The war between DBAs and developers has been raging since the dawn of relational databases. One reason for disagreement comes from developer...
SQL Server releases every 2 years. SSMS releases every month. Power BI releases every week. It's impossible to "keep up" with technology, an...
Are you new to SQL Server and not sure where to begin with T-SQL? Does it feel like a foreign language? The objective of this session is to...