Media Summary: You finally got approval to move to new hardware and a fresher version of In this quick video, we'll guide you through the process of Your boss wants you to automate patching for your

Should I Upgrade To Sql Server 2016 Dear Sql Dba Episode 22 - Detailed Analysis & Overview

You finally got approval to move to new hardware and a fresher version of In this quick video, we'll guide you through the process of Your boss wants you to automate patching for your Does your team know what it's doing when it comes to Performing a switcharoo between new and old tables can cause blocking nightmares. Partition switching may help on existing ... The first time you test a query it's slow, but when you run it again, it's much faster. Learn how

Learn about emerging features to speed up

Photo Gallery

Should I Upgrade to SQL Server 2016? (Dear SQL DBA Episode 22)
Why Upgrades can Cause Performance Regressions (Dear SQL DBA Episode 9)
Upgrade SQL 2014 to SQL 2022 - Preparing for SCCM 2309 Upgrade!
How Do I Analyze a SQL Server Execution Plan? (Dear SQL DBA Episode 50)
Upgrade SQL Server 2016 to SQL Server 2019 without Reinstalling
The Death of SQL Server Service Packs (Dear SQL DBA Episode 52)
Upgrade SQL Server 2014 to SQL Server 2016 without Reinstalling
Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? (Dear SQL DBA Episode 16)
Should I Automate Windows Updates against SQL Server? (Dear SQL DBA Episode 10)
Signs Your SQL Server is Running with Scissors (Dear SQL DBA Episode 24)
Why You Should Switch in Staging Tables Instead of Renaming (Dear SQL DBA Episode 26)
Why is a Query Faster on the Second Run? (Dear SQL DBA Episode 23)
View Detailed Profile
Should I Upgrade to SQL Server 2016? (Dear SQL DBA Episode 22)

Should I Upgrade to SQL Server 2016? (Dear SQL DBA Episode 22)

Learn

Why Upgrades can Cause Performance Regressions (Dear SQL DBA Episode 9)

Why Upgrades can Cause Performance Regressions (Dear SQL DBA Episode 9)

You finally got approval to move to new hardware and a fresher version of

Upgrade SQL 2014 to SQL 2022 - Preparing for SCCM 2309 Upgrade!

Upgrade SQL 2014 to SQL 2022 - Preparing for SCCM 2309 Upgrade!

In this quick video, we'll guide you through the process of

How Do I Analyze a SQL Server Execution Plan? (Dear SQL DBA Episode 50)

How Do I Analyze a SQL Server Execution Plan? (Dear SQL DBA Episode 50)

Prefer a written transcript? Go to https://littlekendra.com/2017/09/

Upgrade SQL Server 2016 to SQL Server 2019 without Reinstalling

Upgrade SQL Server 2016 to SQL Server 2019 without Reinstalling

Learn how to

The Death of SQL Server Service Packs (Dear SQL DBA Episode 52)

The Death of SQL Server Service Packs (Dear SQL DBA Episode 52)

SQL Server

Upgrade SQL Server 2014 to SQL Server 2016 without Reinstalling

Upgrade SQL Server 2014 to SQL Server 2016 without Reinstalling

Learn how to

Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? (Dear SQL DBA Episode 16)

Which is Worse: an Unused Index, or an Un-Indexed Foreign Key? (Dear SQL DBA Episode 16)

Should

Should I Automate Windows Updates against SQL Server? (Dear SQL DBA Episode 10)

Should I Automate Windows Updates against SQL Server? (Dear SQL DBA Episode 10)

Your boss wants you to automate patching for your

Signs Your SQL Server is Running with Scissors (Dear SQL DBA Episode 24)

Signs Your SQL Server is Running with Scissors (Dear SQL DBA Episode 24)

Does your team know what it's doing when it comes to

Why You Should Switch in Staging Tables Instead of Renaming (Dear SQL DBA Episode 26)

Why You Should Switch in Staging Tables Instead of Renaming (Dear SQL DBA Episode 26)

Performing a switcharoo between new and old tables can cause blocking nightmares. Partition switching may help on existing ...

Why is a Query Faster on the Second Run? (Dear SQL DBA Episode 23)

Why is a Query Faster on the Second Run? (Dear SQL DBA Episode 23)

The first time you test a query it's slow, but when you run it again, it's much faster. Learn how

What's Adaptive Query Processing in SQL Server? (Dear SQL DBA Episode 21)

What's Adaptive Query Processing in SQL Server? (Dear SQL DBA Episode 21)

Learn about emerging features to speed up

SQL Server 2016 End of Support: What You Need to Know | Data Exposed

SQL Server 2016 End of Support: What You Need to Know | Data Exposed

SQL Server 2016

Upgrade SQL Server 2008 to SQL Server 2016 without Reinstalling

Upgrade SQL Server 2008 to SQL Server 2016 without Reinstalling

Learn how to

Updating Statistics in SQL Server: Audience Q&A

Updating Statistics in SQL Server: Audience Q&A

Should

Dear SQL DBA: Everything I Never Wanted to Know About Collation

Dear SQL DBA: Everything I Never Wanted to Know About Collation

I'm not an expert on collation in