SQL Server Radio

Download Episode (mp3)
We start show 21 with some inspiring quote competition (and ending with some as well).

During the show, we talk about:

• Index rebuilds and fragmentation
• How efficient Columnstore is in terms of IO
• Debugging stored procedures
• Uses for Log Shipping and why it’s still relevant
• Solving latch problems
• And more..

Items mentioned in the show:

• Niko Neugebauer – Columnstore IO
• Guy Glatnser – Debug Managed Code and Stored Procedures Seamlessly
• Matan Yungman – Can Log Shipping Work Without Shipping the Log?
• Matan Yungman – How to Fix Latch Problems when Working with Ascending Keys in SQL Server

 

Download Episode (mp3)
Show 19 was recorded at the SQLBits conference in London, where we had the pleasure to interview PASS President, Thomas LaRock (blog | twitter).

We talk to Tom about his long time volunteering at PASS and about his current role as the president of the organization.

Among other topics, we cover:

• What does it mean to be PASS president?
• What’s the path to being on the board of directors?
• How does Tom manage to balance between his job at Solarwinds, his role at PASS and his family?
• How did 24 Hours of PASS come to the world?
• What is PASS Summer Camp?
• And more..

About Tom:

Tom LaRock works as a Head Geek for Solarwinds, where his mission is to give IT and Data Professionals longer weekends.

He also serves as the president of the PASS board of directors.

He’s a Microsoft Certified Master, a SQL Server MVP, a VMWare vExpert, and also a Microsoft Certified Trainer. He has over 15 years experience in the IT industry in various roles such as programmer, developer, analyst, and database administration.

Tom is also the author of DBA Survivor: Become a Rock Star DBA and have participated in the technical review of several other books.

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

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