Download Episode (mp3)

On this show, we talk about Alan Turing and how he broke the Enigma machine, about "Ma Yesh", "Zehu Ze", and about Sambusak. We also tell a few bad geek jokes.

Oh, we also talk about SQL Server related stuff: About adjusting Log Shipping, about identity and sequence, about execution plans, Azure SQL Database backups, and about Columnstore.

Items mentioned in the show:

Matan Yungman - Can Log Shipping Work Without Shipping the Log?

Azure SQL Database Backup and Restore

Niko Neugebauer - Columnstore IO

Rob Farley - Probe Residual when you have a Hash Match

Download Episode (mp3)

On this show, we summarize our European trip, talk about some enhancements in Azure SQL Database and why it's now a big thing, talk about why In-Memory OLTP is not good enough yet, talk about the best sessions in PASS Summit 2014, talk a bit about MySQL, and more.

Items mentioned in the show:

Top 10 sessions of PASS Summit 2014

Next Israeli SQL Server User Group meeting

Aaron Bertrand - More Online Operations for Azure SQL Database

MySQL Query Cache

Download Episode (mp3)

On this show, we take a deep dive into the Plan Cache and talk about how you can monitor and learn about query behavior using its DMVs.

We also talk about how a Dates table can benefit you, and why, and about weird issues with Dynamic SQL and locking.

Items mentioned in the show:

Guy Glantser - Monitor Query Statistics

Download Episode (mp3)

We have a special episode today:

SQL Server Radio Purim edition

Download Episode (mp3)

On this show, we summarize the technical part of SQLSaturday Israel which took part last month. We talk about the interesting sessions we attended, and about the things we covered about in our sessions.

Among other topics, we talk about:

What is Bulk Loading

What is Minimal Logging and how you can achieve it (not as easy as you think)

What is EAV and how you can make it super fast

Clustered Index Scan vs Allocation Order Scan

How to start thinking about "Big Data" technologies

How we get prepared for delivering a presentation

And more..

Download Episode (mp3)

We're in Israel, and unlike in this site where we write in English, some people (Maria Zakourdaev and Yoni Nakache) insist on writing in the language of the Hebrew man. That's how we learned about the word "סילומיות", and in the episode we explain what it means, with demonstrations.

Another important milestone in this show is the fact that Guy is now an MVP!. We talk about how Guy got this achievement, and how you can do it too.

In addition, we talk about:

Azure SQL Database enhancements and possible mistakes Microsoft makes with the new features

sp_MSforeachdb - How to use it the right way

Gaps in Identity and Sequence

Change Data Capture (CDC)

SQLSaturday Israel recap

And more..

Items mentioned in the show:

Guy Glantser - I'm a SQL Server MVP!

TechNet SQL Server Forum

15 #SQLFamily Wishes for 2015

Data Exposed - Insights into Azure SQL Database

Amir Charania - Create Stunning Visualizations with Power View in 20 Minutes or Less

Aaron Bertrand - A More Reliable and More Flexible sp_MSforeachdb

It's part 2 of the fascinating interview we had with Adi Sapir (LinkedIn, Twitter).

On this part, we deal a lot with deploying changes to production, and mainly whether to do it using automatic tools or manually.

In addition, we talk about:

SSDT

Continues Deployment

The Cloud

Version upgrades

The next version of SQL Server

Living in America

We also talk about the cool handy tools Adi develops.

Items mentioned in the show:

doccolabs.com

PASS is no longer "Professional Association for SQL Server"

Download Episode (mp3)

On this show, we have an important guest from abroad - Adi Sapir! 

Adi (LinkedIn, Twitter) is a DBA for many years and today he's a Data Architect at Getty Images in Seattle.

We had a fascinating talk and we divided it to two parts.

On this part, we talk about:

The role of the Database Architect

The current place of SQL Server in the jungle of database systems

What not to do with SQL Server

Fighting with ORMs

And more..

Adi also develops a few cool products for DBAs and developers. Check them out on www.doccolabs.com

Download Episode (mp3)

On this show, our topic is Partitioning.

We first talk about how we implemented Partitioning before SQL Server 2005 (or on Standard Edition).

After that, we talk about:

How to implement Partitioning

When it's right and wrong to use it

Will Partitioning help with query performance

How to make sure you leverage its benefits

Improvement Microsoft implemented over the years

Partitioning maintenance tactics

and much more..

Download Episode (mp3)

What's the best way to migrate from SQL Server 2008R2 to SQL Server 2014 with a possible fallback? We start the show with an interesting discussion about this subject.

Later on, we talk about:

Cool tips for SSMS

Central Management Servers

Plan Guides

What needs does Azure DocumentDB come to address

Delayed Durability

Interesting behaviors of Availability Groups

Database documentation

Items mentioned in the show:

Koen Verbeeck - The Magic Alt Button

Matan Yungman - Five Ways to Improve Your Productivity with SSMS

Dudu Sinai - Transaction Durability

Itai Binyamin - What are Extended Properties Good For?