Download Episode (mp3)

 On this show:

Once and for all - which locks does Nolock put on a table?

Nolock behavior differences between SQL Server 2008 and SQL Server 2012

Spools in execution plans - what they are and why they're needed?

Weird performance issue with a Many-to-Many table

Download Episode (mp3)

Happy holidays everyone!

On this show, we talk about:

Some weird acronyms

The right way to move Tempdb files on Azure VMs

What is Optimize for Ad-hoc Workload and how it affects the Plan Cache

Web analytics and aggregations

What to do when a SQL Server instance doesn't come up

And also Al and Kelly Bundy, Noah, the Pink Floyd, and much more..

Items mentioned in the show:

Noa Brodezky - The Right Way to Move Tempdb Files on Azure Virtual Machines

Let's Chat About SQL Server Migration

Itzik Ben-Gan - New Solution to the Packing Intervals Problem

Download Episode (mp3)

On show 43, we talk about:

SQLSaturday Israel 2016!

The last and previous user group meetings

24 Hours of PASS, which happens today (September 17)!

Matan's experience from Oslo and travelling to Belgium

Row Level Security and why should be careful when using it

Optimizing Ad-hoc queries and Azure DocumentDB

We also have some ice cream recommendations and other "important" updates..

Download Episode (mp3)

Show 42 is here..

This time, we talk about:

Calculating the right number of files for Tempdb

Calculating IOPS and balancing files between disks

How Brent Ozar handles emails and tasks

Replaying a workload with Distributed Replay

Intent locks

And more..

Download Episode (mp3)

Another show is here, and this time we talk about:

Out sessions at PASS Summit 2015

What is BIML

Reporting Services new features

DBA scariest sentences

SQL Server 2000 troubleshooting, DBCC Inputbuffer and DBCC Outputbuffer

Lots of SSIS stuff, including dynamic import and new features throughout the versions

More about SQL Server 2016

Tempdb on SQL Server 2016 and in general

Guy also shares a discussion he's heard about how to stay young and what he thinks about it.

Items mentioned in the show:

24 Hours of PASS session recordings

Matan Yungman - The Data Loading Performance Presentation

Download Episode (mp3)

Show 40!

During the show, we talk a little bit about Bob Marley, his songs and their meaning.

We also talk about:

Recommended bucket count for In-Memory OLTP

On Index rebuild, disable and statistics update

How the Datetime2 data type is stored

Various SQL Server tuning switches

Which operators can work in batch mode

AlwaysOn Availability Groups enhancements in SQL Server 2016

Async_network_io issues

The CXPacket and SOS_scheduler_yield wait types and what they mean

Download Episode (mp3)

This episode doesn't talk about SQL Server at all.

It talks about changing the way we think and behave around work.

Many of us High-Tech workers are constantly working long hours, checking emails on the phone and taking work home.

We talk about how it can be done differently, and Guy brings his own personal story about how he's done it.

We talk about working hours and adjusting between work and family life, but also about being home mentally and not only physically, about being disconnected, and about managing a company in a challenging and different way than what most companies do.

You really don't want to miss this one.

Items mentioned in the show:

Ricardo Semler - How to Run a Company with (almost) No Rules

Ricardo Semler Books

Download Episode (mp3)

Another show is here, and as usual, we have a few items up our sleeves.

Among other topics, we talk about:

Best practices for patching SQL Server

SQL Server 2016 In-Memory OLTP Enhancements

JSON "support" in SQL Server 2016 and XML

Database Kosher Certification

Erland Sommarskog's beta_lockinfo

SQL Server Monitoring

How Albert Einstein came up with his theories

We also talk about family meals, Bar Mitzvas, a funny Druze guy, and more.

Download Episode (mp3)

On this show, we have a guest again - Eitan Blumin!

We talk to Eitan about his specialties and about what he loves about SQL Server and what project he's proud of.

We also talk extensively about Azure DocumentDB, its concepts and when to use it rather than SQL Server.

At the end, Eitan also gives a good advice to people just starting their database career.

Items mentioned in the show:

Eitan Blumin - Introduction to Azure DocumentDB

Eitan Blumin - Efficiently UPDATE and DELETE using TOP and ORDER BY

Eitan Blumin - Service Broker Sample: Asynchronous Triggers

Eitan Blumin - Service Broker Sample: Multi-Threading

Download Episode (mp3)

Microsoft arranged to huge confrences lately - Build and Ignite, in which they announced some big news. We talk about the news in general, and the things that relate to us as data people.

Among other topics, we talk about:

SQL Server 2016 new features

Azure SQL Database Enhancements

Azure SQL Data Warehouse

Azure SQL Data Lake

The new way of Microsoft

We also cover other "ordinary stuff":

Internals of In-Memory OLTP

Displaying format vs. storing format

Items mentioned in the show:

Ronen Ariely - Date displaying format, vs Date storing format