Episode 103 Plan Reuse
When we write our queries to the database, SQL Server has to go and figure out the best way to go and bring back the data you asked for. A query plan is created to help SQL Server remember how to get ...
5 Heinä 201741min
Episode 102 Monitoring Availability Groups
One of the newer features in SQL Server is availability groups, which can help solve a number of business problems. As administrators, availability groups introduce some complexity as we are tasked t...
29 Kesä 201734min
Episode 101 Inspecting a new Database
Listener Cody Ford wrote in and asked if we could share some thoughts on getting familiar with an unfamiliar database. While we have done episodes in the past on best practices, this episode takes th...
21 Kesä 201737min
Episode 100 Role Reversal
Something a bit strange happened in episode 100--almost like something out of the twilight zone, but don't take our word for it. Check out our latest episode as tell some of the stories that led up t...
14 Kesä 201755min
Episode 99 Imposter Syndrome
Impostor syndrome (also known as impostor phenomenon or fraud syndrome) is a term coined in 1978 by clinical psychologists Dr. Pauline R. Clance and Suzanne A. Imes referring to high-achieving individ...
7 Kesä 201753min
Episode 98: The first change you make
In a recent SQLSaturday conference, I walked into the speakers room and asked the question--What is the first thing you change after you install SQL Server? It was interesting to get their take on th...
1 Kesä 201733min
Episode 97 Transactional Replication
If you have ever been responsible for a replication environment, you know what a pain that can be. Many of the guests of the show will point out their frustration with replication and many are loathe...
24 Touko 201752min
Epsiode 96 Building Community Tools
Have you ever created something and wanted to share it with others with the hope they will contribute and make it better? Sites like the new defunct codeplex and GitHub are full of functionality peopl...
17 Touko 201742min
