SQL Server Radio

SSMS, Continuous Integration and Page Splits

18 Mar 2018

Contributed by Lukas

Today in the show:   SSMS Unuseful Tips Why Database Continuous Integration is Challenging? Monitoring Page Splits

Will Machines Eventually Haunt Us?

18 Mar 2018

Contributed by Lukas

Today in the show: How to Deploy Schema Changes with Zero Downtime We are All Experts in Identifying Cats How to Troubleshoot Application Timeouts Si...

Getting Things Done

11 Jan 2018

Contributed by Lukas

Be as Lazy as Possible

28 Dec 2017

Contributed by Lukas

Let Me Index That for You

28 Nov 2017

Contributed by Lukas

SQL Server 2017

09 Nov 2017

Contributed by Lukas

In this show, we talk about everything that's new in SQL Server 2017

Help the Optimizer

12 Oct 2017

Contributed by Lukas

There are many ways to write efficient queries in SQL Server. In this show we talk about a few of those ways, when the key is - "keep it simple". In ...

Virtuaization, Data Science and More

28 Sep 2017

Contributed by Lukas

In this show, we talk about: How to tell if you have a CPU problem in a virtualized environment SQL Server setup tips Guy's experience from his data ...

Client Stories

05 Jul 2017

Contributed by Lukas

In this show, we share some client stories from recent projects: One nice thing of being a consultant Another consolidation project with a client impl...

If Clippy Found His Way to SQL Server Radio

21 Jun 2017

Contributed by Lukas

In this show: * The challenges of consolidation projects * What is the Remote Query Harden error with Availability Groups * PASS Summit precons * ...

A Sign Your Wife is Married to a DBA…

24 May 2017

Contributed by Lukas

In this show, we talk about: Our sessions at the GroupBy conference Another difference between the old and new Cardinality Estimators Lightweight Pro...

SQL Server 2000 Good Old Days

26 Jan 2017

Contributed by Lukas

Today in the show, we talk about: Another optimization for cases where you have to use cursors How to migrate a database to a lower version Paging in...

The Elephant in the Room

12 Jan 2017

Contributed by Lukas

12 Days of Christmas

23 Dec 2016

Contributed by Lukas

Matan Loves Marriage

14 Dec 2016

Contributed by Lukas

SQL Server Hydra

02 Dec 2016

Contributed by Lukas

Watermelon Shake

16 Nov 2016

Contributed by Lukas

In this show, we host our good friend and great DBA, Shy Engelberg. Together with Shy, we talk about: Guy's new online course - Advanced Query Tunin...

Closed as Fixed

03 Nov 2016

Contributed by Lukas

In this show of SQL Server Radio: Transactional Replication tips How to self destruct a SQL Server Agent job Storage at speed of memory on Windows Se...

PASS Summit 2016

20 Oct 2016

Contributed by Lukas

PASS Summit is next week, and in this show, we cover the sessions, the parties, the networking opportunities and the other goodies of the summit.

Yes/No Questions

04 Oct 2016

Contributed by Lukas

We start the show with a game of Yes/No questions.  Afterwards, we talk about: Must we wait to service pack 1 before installing a new SQL Server ver...

Don't Stop Me Now

20 Sep 2016

Contributed by Lukas

Show 56 is here, and this time we talk about: Itzik Ben-Gan's ways for unpivoting data Auditing every change in every table The Dunning-Krugher Effec...

Paul Has it All

01 Sep 2016

Contributed by Lukas

Today in the show, we: Check whether Set Nocount On is still needed Extract data easily Deep dive into Always Encrypter Unmask Dynamic Data Masking C...

The Itzik Ben-Gan Trick

18 Aug 2016

Contributed by Lukas

Itzik Ben-Gan has many T-SQL tricks. In this show, we talk about a few of them: How to get Batch Mode Processing with regular tables How to share Ide...

If You Need to Think, You're Doing It Wrong

05 Aug 2016

Contributed by Lukas

Guy is back from a one month trip in the United States, and we're back with another show of SQL Server Radio. In this show, we talk about a few of our...

Data Science with Tomaz Kastrun

21 Jul 2016

Contributed by Lukas

Tomaž Kaštrun (blog | twitter) about what Data Science is, what does a Data Scientist do, what insights is he looking for, what tools does he use, w...

SQL Server Radio Show 51 - SQL Server 2016

08 Jul 2016

Contributed by Lukas

What's new in SQL Server 2016? In this show, we celebrate the official release of SQL Server 2016 and talk about the new features of the version.

Show 50 - Top 50 Features

23 Jun 2016

Contributed by Lukas

We can't really believe it, but it's the 50th show of SQL Server Radio! Time does fly when having fun! To celebrate the 50th show, we have a countdow...

Show 49 - Presentation Design and More with Boris Hristov

09 Jun 2016

Contributed by Lukas

Most of us will have to deliver some kind of a presentation in our professional lives, whether it's inside the organization or at a conference. Today...

Show 48 - Pomodoro

26 May 2016

Contributed by Lukas

In this show, we talk about: The top 100 percent trick and whether or not it works A weird bug that was solved in SQL Server 2012 SP2 What is SSISDB ...

Show 47 - How to Find a DBA Job with Brent Ozar

12 May 2016

Contributed by Lukas

Continuing the show from two weeks ago, we have another show with Brent Ozar we recorded when he was in Israel a few weeks ago. This time, we talk a...

Show 46 - Big Mistakes with Brent Ozar

28 Apr 2016

Contributed by Lukas

Show 45 - Managing the New York Stock Exchange with Lior King

21 Apr 2016

Contributed by Lukas

In this show, we talk to Lior King, DBA Team Manager at Intercontinental Exchange (ICE), the company who manages the New York Stock Exchange. Lior ha...

Show 44 - SSMS Can Beep

07 Apr 2016

Contributed by Lukas

Did you know SSMS can make sounds? We start the show with some interesting things you might do with it. In addition, we talk about: SQL Server on ...

Show 43 - Projects We're Proud of

17 Mar 2016

Contributed by Lukas

In this show, we talk about a few projects we took part in and we're proud of.  

Show 42 - Database Testing and Continuous Integraton wiith Steve Jones

07 Mar 2016

Contributed by Lukas

In today's world where deployments to production are very frequent, continuous integration and testing code become more important than ever.  In t...

Show 41 - IFI

21 Feb 2016

Contributed by Lukas

In this show, we talk about: External deadlines The RS.EXE utility and what it is used for Why you shouldn't use Task Manager to check how much ...

Show 40 - Just Another Show

28 Jan 2016

Contributed by Lukas

Another two weeks have passed, and another show is live. Today on the show: Error handling in SSIS Why Big Data systems use ELT and not ETL Wha...

Show 39 - SQL Server and Independent Consulting with William Durkin

14 Jan 2016

Contributed by Lukas

In this show, we talk to William Durkin (Blog | Twitter), an Englishman "stuck in Germany". William just switched to being an independent SQL Server ...

Show 38 - DevOps, Cloud and Podcasting with Richard Campbell

30 Dec 2015

Contributed by Lukas

On this show, we talk to the famous podcaster, Richard Campbell (LinkedIn | Twitter). Richard is the co-host of the .NET Rocks podcast, host of the...

Show 37 - Be Happy

16 Dec 2015

Contributed by Lukas

Show 36 – Podcasters Panel at PASS Summit 2015

29 Nov 2015

Contributed by Lukas

Show 35 – What the Hell is DPM?

18 Nov 2015

Contributed by Lukas

Show 34 – Do You Have a Backup?

10 Nov 2015

Contributed by Lukas

Show 33 – What Google and Facebook Know about You…

22 Oct 2015

Contributed by Lukas

Show 32 – Morning Checklists, Policy Based Management and Automation with Pieter Vanhove

15 Oct 2015

Contributed by Lukas

Show 31 – The Hadoop Ecosystem with Carlos Bossy

06 Oct 2015

Contributed by Lukas

Show 30 – Coffee and Water

22 Sep 2015

Contributed by Lukas

Do you know what FOMO means? It means "Fear of Missing Out", and it's a term used in the startup and venture capital fields. However, it's also releva...

Show 29 – Architecture, Microsoft APS and Azure SQL Datawarehouse with Bradley Ball

07 Sep 2015

Contributed by Lukas

We start to warm up the engines towards PASS Summit, which will take place in Seattle at the end of October. Before the summit, we will host a few sp...

Show 28 – Backups, Scripting and Regular Expressions with Sean McCown

22 Aug 2015

Contributed by Lukas

A few months ago we hosted Sean McCown for a talk about indexing tips and backup performance. On this show, we have Sean again. Sean reveals tons of...

Show 27 – Earth 2.0

10 Aug 2015

Contributed by Lukas

We tried something new this time, and broadcast the show live on Persicope. Periscope is a service by Twitter that allows each one to start a live br...

Show 26 – Boris Hristov

27 Jul 2015

Contributed by Lukas

On this show, we host a good friend of both of us – Boris Hristov! Boris (blog | twitter) is a SQL Server MVP from Bulgaria and a really passio...

Show 25 – Oh, I'm on the Prod Server

11 Jul 2015

Contributed by Lukas

Two weeks have passed, and another show is here! We start by talking about scary DBA sentences We continue with PASS Summit 2015 and about the sessio...

Show 24 – Virtualization, High Availability and Independent Consulting with David Klee

29 Jun 2015

Contributed by Lukas

A few shows ago, we talked briefly about Virtualization and mentioned it would be a good idea to have a Virtualization expert on the show. In this sh...

Show 23 – Scattergories

15 Jun 2015

Contributed by Lukas

We have a different show this time – in which we play a game! On each round, as in the famous Scattergories game, we draw a SQL Server-related term...

Show 22 – Columnstore Indexes with Niko Neugebauer

24 May 2015

Contributed by Lukas

On this show, we host Niko Neugebauer, a.k.a "Mr Columnstore"!. On this very fun conversation, we talk to Niko about his various roles and activities...

Show 21 – Get Up Stand Up

12 May 2015

Contributed by Lukas

We start show 21 with some inspiring quote competition (and ending with some as well). During the show, we talk about: Index rebuilds and fragmentati...

Show 20 – One Must Work Hard to Remain Stupid

27 Apr 2015

Contributed by Lukas

It seems like ages ago, but we had a pretty busy month on March, with lots of conferences and great time. We start the show by summarizing March Madne...

Show 19 – Thomas LaRock

26 Mar 2015

Contributed by Lukas

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

Show 18 – Sean McCown

19 Mar 2015

Contributed by Lukas

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 t...

Show 17 – It's Scientific

05 Mar 2015

Contributed by Lukas

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 Azu...

Show 16 – SQL Server Horror Stories

19 Feb 2015

Contributed by Lukas

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 ...

Show 15 – March Madness

04 Feb 2015

Contributed by Lukas

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 g...

SQLServerRadio_Show14.mp3

20 Jan 2015

Contributed by Lukas

Show 13 – SQL Server Monitoring

01 Jan 2015

Contributed by Lukas

On this show, we talk about monitoring in SQL Server. But actually, monitoring is not only monitoring: It's also baselining, data collection, data ...

Show 12 – The Other One Mode

17 Dec 2014

Contributed by Lukas

Show 12 is here, and yet again we have a mix of various SQL Server topics. Among them are High Availability, development, performance, Columnstore Ind...

Show 11 – T-SQL

03 Dec 2014

Contributed by Lukas

Did you know that SQL was initially called "Sequel" (Structured English Query Language)? On this show, we go back to basics and talk about our favorit...

Show 10 – Coolest Thing Ever

19 Nov 2014

Contributed by Lukas

On previous shows, we talked about an interesting behavior of the Sort operator and missing nodes in execution plans. On this show, we finally have th...

Show 9 – PASS Summit 2014 Recap

09 Nov 2014

Contributed by Lukas

PASS Summit 2014 is over, and wh're here for a recap of what happened, what was announced, what we learned in the sessions we attended, and some thoug...

Show 8 – SQLRally Interviews

06 Nov 2014

Contributed by Lukas

We're currently at PASS Summit, and things are pretty busy here, so we didn't manage to record a new show. Instead, we republish an episode which feat...

Show 7 – In-Memory OLTP and Columnstore Indexes

23 Oct 2014

Contributed by Lukas

On this in-depth show, we take a deep dive into the two biggest features of SQL Server 2014: In-Memory OLTP (aka Hektaon) and Clustered Columnstore In...

Show 6 – It's the Cursor

06 Oct 2014

Contributed by Lukas

It's the monthly all-over-the-place version of the show, and this time we have a mix of various topics like the cloud, T-SQL development, performance...

Show 5 – Kevin Kline

24 Sep 2014

Contributed by Lukas

On show 5, we have our first guest – Kevin Kline! We talk with Kevin about various topics, covering professional development, the direction of Micr...

Show 4 – Push or Pull?

10 Sep 2014

Contributed by Lukas

Two weeks have passed, and it's time for our 4th show. As always, we have a mix of interesting stuff covering performance, data architecture, new se...

Show 3 – Performance Tuning

27 Aug 2014

Contributed by Lukas

You know you have a performance problem in your server, but where do you start looking in order to find what that problem is? On our 3rd show, we tak...

Show 2 – Death to UDFs

09 Aug 2014

Contributed by Lukas

On our 2nd show, we start by talking about our trips. Matan shares about how great SQLBits was (including the custome party), and Guy talks about WP...

Show 1 – Pass, Community and SQL Server 2014

08 Aug 2014

Contributed by Lukas

We've been broadcasting for about a year in Hebrew. We love it a lot, and after we got some great feedback and encouragement, we decided to do it in E...