Podcasts by SQL Server Radio

Nick the Optimizer from 2018-03-20T16:25

Today in the show:

• The Best SQL Server Five-Words Tech Horror
• MongoDB Aggrega...
  Listen

People Born in the 1900s are Old from 2018-03-18T16:26:53

Today in the show:

• How to Schedule a Failover
• Use Inline Functions Instead of Scalar Functions
• Listen

SSMS, Continuous Integration and Page Splits from 2018-03-18T16:26:18

Today in the show:

• SSMS Unuseful Tips
• Why Database Continuous Integration is Challenging?
• Monitoring Page Splits

Will Machines Eventually Haunt Us? from 2018-03-18T16:23:39

Today in the show:

• How to Deploy Schema Changes with Zero Downtime
• We are All Experts in Identifying Cats
• How to Troubleshoot Application Timeouts...
  Listen

Getting Things Done from 2018-01-11T08:04:43

Be as Lazy as Possible from 2017-12-28T06:34:12

Let Me Index That for You from 2017-11-28T16:07:02

SQL Server 2017 from 2017-11-09T08:55:58

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

Help the Optimizer from 2017-10-12T08:00:18

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 addition, we talk about use cases for Big Dat...

Virtuaization, Data Science and More from 2017-09-28T20:14:50

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

Client Stories from 2017-07-05T04:15:29

In this show, we share some client stories from recent projects:

One nice thing of being a consultant
Another consolidation project with a client implemented with views
Perfor...

If Clippy Found His Way to SQL Server Radio from 2017-06-21T05:25:17

In this show:

* The challenges of consolidation projects
* What is the Remote Query Harden error with Availability Groups
* PASS Summit precons
* Describe your professio...

A Sign Your Wife is Married to a DBA… from 2017-05-24T18:07:12

In this show, we talk about:

• Our sessions at the GroupBy conference
• Another d...
  Listen

SQL Server 2000 Good Old Days from 2017-01-26T17:00

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

The Elephant in the Room from 2017-01-12T07:44:19

12 Days of Christmas from 2016-12-23T12:00:35

Matan Loves Marriage from 2016-12-14T23:31:23

SQL Server Hydra from 2016-12-02T15:51:24

Watermelon Shake from 2016-11-16T20:12:54

In this show, we host our good friend and great DBA, Shy Engelberg.

Together with Shy, we talk about:

• Listen

Closed as Fixed from 2016-11-03T05:40:15

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 Server 2016 and ...
  Listen

PASS Summit 2016 from 2016-10-20T14:58:51

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 from 2016-10-04T06:06:05

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 version? Listen

Don't Stop Me Now from 2016-09-20T07:20:31

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 Effect and how it's...
  Listen

Paul Has it All from 2016-09-01T08:04:11

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

The Itzik Ben-Gan Trick from 2016-08-18T06:55:04

Itzik Ben-Gan has many T-SQL tricks.

In this show, we talk about a few of them:

• How to get Batch Mode Pr...
  Listen

If You Need to Think, You’re Doing It Wrong from 2016-08-05T06:43:51

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 upcoming speaking gigs (PASS Summit ...

Data Science with Tomaz Kastrun from 2016-07-21T10:50:17

Tomaž Kaštrun (blog | twitter) about what Data Science is, what does a...

SQL Server Radio Show 51 - SQL Server 2016 from 2016-07-08T07:58:43

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 from 2016-06-23T11:08:27

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 countdown of the top 50 SQL Server features of...

Show 49 - Presentation Design and More with Boris Hristov from 2016-06-09T07:25:23

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, we talk to Boris Hristov (Listen

Show 48 - Pomodoro from 2016-05-26T08:19:35

In this show, we talk about:

• The top 100 percent trick and whether or not it works
• A weird bug...
  Listen

Show 47 - How to Find a DBA Job with Brent Ozar from 2016-05-12T07:46:39

Continuing the show from two weeks ago, we have another show with B...

Show 46 - Big Mistakes with Brent Ozar from 2016-04-28T06:04:50

Show 45 - Managing the New York Stock Exchange with Lior King from 2016-04-21T10:19:19

In this show, we talk to Listen

Show 44 - SSMS Can Beep from 2016-04-07T06:09:22

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

Show 43 - Projects We're Proud of from 2016-03-17T11:43:13

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 from 2016-03-07T09:12:31

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

In this show, we talk to Steve Jones ( Listen

Show 41 - IFI from 2016-02-21T11:46:10

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

Show 40 - Just Another Show from 2016-01-28T09:08:49

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

Show 39 - SQL Server and Independent Consulting with William Durkin from 2016-01-14T11:13:14

In this show, we talk to William Durkin (Blog | Twitter), an Englishman...

Show 38 - DevOps, Cloud and Podcasting with Richard Campbell from 2015-12-30T17:54:31

On this show, we talk to the famous podcaster, Richard Campbell (Listen

Show 37 - Be Happy from 2015-12-16T22:21:50

Show 36 – Podcasters Panel at PASS Summit 2015 from 2015-11-29T16:14:40

Show 35 – What the Hell is DPM? from 2015-11-18T09:32:35

Show 34 – Do You Have a Backup? from 2015-11-10T23:35:59

Show 33 – What Google and Facebook Know about You… from 2015-10-22T07:24:35

Show 32 – Morning Checklists, Policy Based Management and Automation with Pieter Vanhove from 2015-10-15T04:40:48

Show 31 – The Hadoop Ecosystem with Carlos Bossy from 2015-10-06T08:57:38

Show 30 – Coffee and Water from 2015-09-22T21:13:37

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 relevant for us as DBAs, and we start the s...

Show 29 – Architecture, Microsoft APS and Azure SQL Datawarehouse with Bradley Ball from 2015-09-07T02:26:43

We start to warm up the engines towards PASS Summit, which will take place in Seattle at the end of October.

Before the summit,...

Show 28 – Backups, Scripting and Regular Expressions with Sean McCown from 2015-08-22T00:41:03

A few months ago we hosted Sean McCown for a talk about indexing tips and backup performance.

On ...

Show 27 – Earth 2.0 from 2015-08-10T13:24:56

We tried something new this time, and broadcast the show live on Persicope.

Periscope is a service by Twitter that ...

Show 26 – Boris Hristov from 2015-07-27T12:04:03

On this show, we host a good friend of both of us – Boris Hristov!

Boris (blog | Listen

Show 25 – Oh, I’m on the Prod Server from 2015-07-11T10:21:31

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 sessions we’ll deliver at the summit....

Show 24 – Virtualization, High Availability and Independent Consulting with David Klee from 2015-06-29T11:26:11

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 show, we have David Klee (Listen

Show 23 – Scattergories from 2015-06-15T04:59:47

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 and have to tell an interesting story a...

Show 22 – Columnstore Indexes with Niko Neugebauer from 2015-05-24T20:18:35

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, about the improveme...

Show 21 – Get Up Stand Up from 2015-05-12T08:24:21

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

Show 20 – One Must Work Hard to Remain Stupid from 2015-04-27T05:32:10

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 Madness, with the presentations, the people, the ...

Show 19 – Thomas LaRock from 2015-03-26T15:42:46

Show 19 was recorded at the SQLBits conference in London, where we had the pleasure to interview PASS President, Thomas LaRock (Listen

Show 18 – Sean McCown from 2015-03-19T09:20:17

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

Show 17 – It’s Scientific from 2015-03-05T17:19:56

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

Show 16 – SQL Server Horror Stories from 2015-02-19T08:05:27

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.

Amon...