SQL Server Radio

Download Episode (mp3)

On show 18, we host Sean McCown, a.k.a Midnight DBA.

We start the show with some tips about working from home without hurting your productivity.

We then take a deep dive into two of Sean's favorite topics: Reindexing and backup performance.

Sean shares quite a few tips regarding the two topics, and takes us into the bits and bytes of his new free maintenance solution, Minion Reindex.

About Sean:

Sean McCown is a Microsoft Certified Master in SQL Server 2008. He is also a SQL Server MVP with over 20 years experience in databases. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL Server training videos and co-hosts the popular webshow, DBAs@Midnight.

Items mentioned in the show:

* MidnightDBA

* Minion Reindex

* Midnight DBA Web Show

On show 18, we host Sean McCown, a.k.a Midnight DBA.

We start the show with some tips about working from home without hurting your productivity.

We then take a deep dive into two of Sean's favorite topics: Reindexing and backup performance.

Sean shares quite a few tips regarding the two topics, and takes us into the bits and bytes of his new free maintenance solution, Minion Reindex.

About Sean:

Sean McCown is a Microsoft Certified Master in SQL Server 2008. He is also a SQL Server MVP with over 20 years experience in databases. Sean is also founder and co-owner of the renowned website MidnightDBA.com where he records free SQL Server training videos and co-hosts the popular webshow, DBAs@Midnight.

Download Episode (mp3)

On show 17, we start the show with a small small-talk about a few cool researches.

We then dive in to SQL Server and talk about:

* Backup and DR to Azure

* Weird lock behavior

* Isolation Levels Visualization

* The risk of SQL Server ownership chaining

* Parallelism, Max Degree of Parallelism and Cost Threshold for Parallelism

* Azure row level security

* And more..

Items mentioned in the show:

* Tony Hawk Rides the Hover Board

* Michael J Swart - Visualizing Transaction Isolation Levels for SQL Server

* Eyal Golombek - The Risk of Ownership Chaining

On show 17, we start the show with a small small-talk about a few cool researches.

We then dive in to SQL Server and talk about:

• Backup and DR to Azure
• Weird lock behavior
• Isolation Levels Visualization
• The risk of SQL Server ownership chaining
• Parallelism, Max Degree of Parallelism and Cost Threshold for Parallelism
• Azure row level security
• And more..

Items mentioned in the show:

• Tony Hawk Rides the Hover Board
• Michael J Swart – Visualizing Transaction Isolation Levels for SQL Server

Download Episode (mp3)

We love working with SQL Server, but over the years, we've had some interesting, funny, sad and horrific cases related to it. On this show, we talk about some of those cases.

Among other topics, we talk about:

* How to bring SQL Server online when it has no tempdb files

* Stored Procedure and Plan Cache optimization over the phone

* Finding out who dropped a database

* A very destructive MERGE statements that kills clusteres

* Data corruptions

* Table variable horrors

* And more..

Items mentioned in the show:

* Matan Yungman - The Strange Story About the MERGE that Killed the Cluster

* Paul Randal - Advanced Data Recovery Techniques

* Russ Thomas' Monthly DBA Challenge

If you like the show, please consider leaving a short review about the show on iTunes. 

We love working with SQL Server, but over the years, we've had some interesting, funny, sad and horrific cases related to it. On this show, we talk about some of those cases.

Among other topics, we talk about:

• How to bring SQL Server online when it has no tempdb files
• Stored Procedure and Plan Cache optimization over the phone
• Finding out who dropped a database
• A very destructive MERGE statements that kills clusteres
• Data corruptions
• Table variable horrors
• And more..

Items mentioned in the show:

• Matan Yungman – The Strange Story About the MERGE that Killed the Cluster
• Paul Randal – Advanced Data Recovery Techniques
• Russ Thomas' Monthly DBA Challenge

If you like the show, please consider leaving a short review about the show on iTunes.

Download Episode (mp3)

2015 started well, fast, and furious.

We start the show by congratulating Guy for earning the MVP title, and Guy explains what he did in order to get this achievement, and what you can do to earn it too.

We also talk about the crazy March we're going to have, with a lot of flights, conferences and many other events.

In addition, talk about: 

* A weird scenario of updating a table using a view

* How to perform an ordered update efficiently

* What to expect when transitioning from DBA to consultant

* Parameterization

* Productivity and learning optimizations

* DBA challenges

* Physical joins

* And more..

Items mentioned in the show:

* Guy Glantser - I'm a SQL Server MVP!

* Matan Yungman - Things I learned in 2014

* Guy Glantser - Parameterization Part 7: Summary

* Matan Yungman - What to Expect When Transitioning from DBA to Consultant

* Russ Thomas - Monthly DBA Challenge

* SQL Hangouts

2015 started well, fast, and furious.

We start the show by congratulating Guy for earning the MVP title, and Guy explains what he did in order to get this achievement, and what you can do to earn it too.

We also talk about the crazy March we're going to have, with a lot of flights, conferences and many other events.

In addition, talk about:

• A weird scenario of updating a table using a view
• How to perform an ordered update efficiently
• What to expect when transitioning from DBA to consultant
• Parameterization
• Productivity and learning optimizations
• DBA challenges
• Physical joins
• And more..

Items mentioned in the show:

• Guy Glantser – I'm a SQL Server MVP!
• Matan Yungman – Things I learned in 2014
• Guy Glantser – Parameterization Part 7: Summary
• Matan Yungman – What to Expect When Transitioning from DBA to Consultant
• Russ Thomas – Monthly DBA Challenge
• SQL Hangouts

Download Episode (mp3)

On this show, we talk about monitoring in SQL Server. But actually, monitoring is not only monitoring: It's also baselining, data collection, data analysis, reporting and alerting, and we cover all of those in the show. Among other topics, we talk about:

* The different levels of monitoring

* Why it's important to have a baseline

* Trend analysis

* What should you monitor in SQL Server

* The set of tools for monitoring, baselining, data collection, reporting and alerting

* What should you do when you get an alert about a certain problem

* And more..

Items mentioned in the show:

* Conor Cunningham - Managing 1 Million+ DBs-How Big Data is used to run SQL Azure

* Maria Zakourdaev - Alert Visualization Recipe

Happy 2015, everybody!