In this show, we look back and recap the first 50 shows. among other topics, we talk about:

How we started the show

How a podcast is made and how we make SQL Server Radio

Highlights from the first 50 shows

Speculations about the future of SQL Server and the data world

The worst feature in the history of SQL Server!

]]>http://sqlserverradio.co.il/show50/feed/4Download Episode (mp3) It's our 50th show, and it's time to celebrate! - In this show, we look back and recap the first 50 shows. among other topics, we talk about: How we started the show How a podcast is made and how we make SQL Server Ra...<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show50.mp3" target="_blank">Download Episode (mp3)</a>
It's our 50th show, and it's time to celebrate!
In this show, we look back and recap the first 50 shows. among other topics, we talk about:
How we started the show
How a podcast is made and how we make SQL Server Radio
Highlights from the first 50 shows
Speculations about the future of SQL Server and the data world
The worst feature in the history of SQL Server!Guy Glantser and Matan Yungmanno50:33Show 49 – מצעד הבושהhttp://sqlserverradio.co.il/show49/
Wed, 09 Dec 2015 23:48:42 +0000http://sqlserverradio.co.il/?p=4195http://sqlserverradio.co.il/show49/#respondMatan YungmanDownload Episode (mp3)
Next month is our 50th show!
To celebrate that, we decided to make a countdown of the 30 best features of all times in SQL Server.
But then we realized it would be boring, so we didn't count from 30 to 1 like regular countdowns.
We count from 1 to 30, meaning we start with the best and count down to the worse and most awful features of all time in SQL Server. Who will be the worst?Download Episode (mp3)

Next month is our 50th show!

To celebrate that, we decided to make a countdown of the 30 best features of all times in SQL Server.

But then we realized it would be boring, so we didn’t count from 30 to 1 like regular countdowns.

We count from 1 to 30, meaning we start with the best and count down to the worse and most awful features of all time in SQL Server. Who will be the worst?

]]>http://sqlserverradio.co.il/show49/feed/0Download Episode (mp3) Next month is our 50th show! To celebrate that, we decided to make a countdown of the 30 best features of all times in SQL Server. - But then we realized it would be boring, so we didn't count from 30 to 1 like regular countdo...<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show49.mp3" target="_blank">Download Episode (mp3)</a>
Next month is our 50th show!
To celebrate that, we decided to make a countdown of the 30 best features of all times in SQL Server.
But then we realized it would be boring, so we didn't count from 30 to 1 like regular countdowns.
We count from 1 to 30, meaning we start with the best and count down to the worse and most awful features of all time in SQL Server. Who will be the worst?Guy Glantser and Matan Yungmanno32:11Show 48 – צ’יף אחלה אופיסרhttp://sqlserverradio.co.il/show48/
Thu, 26 Nov 2015 08:01:54 +0000http://sqlserverradio.co.il/?p=4009http://sqlserverradio.co.il/show48/#respondMatan YungmanDownload Episode (mp3)
Show 48 is here!
This time:
Our PASS Summit 2015 summary
Guy explains why he started his presentation as Superman
Performance Dashboard Reports
On Resource_Semaphore_Query_Compile waits
Why firms hire Chief Data Officers
And more..
Items mentioned in the show:
Firms Hire Chief Data Officers to Improve Data Management
Multi-fold increase in throughput for big gateway query compiles in SQL Server
SQL Server Performance Dashboard Reports
https://www.youtube.com/watch?v=aFQItkURnY0
https://www.youtube.com/watch?v=54w4IyGQeJ8
https://www.youtube.com/watch?v=UNANwv7j5TI
Download Episode (mp3)

How to use digital signatures instead of cross database ownership chaining

What do you do when we have SQL Server connectivity issues?

Compare execution plans in SQL Server 2016

Guy’s SQL Server killer feature

How to manage the availability of Azure virtual machines using Availability Sets

Profiler – the DBA’s best friend

]]>http://sqlserverradio.co.il/show47/feed/2Download Episode (mp3) In this show: The new cloud witness How to use digital signatures instead of cross database ownership chaining What do you do when we have SQL Server connectivity issues? Compare execution plans in SQL Server 2016 <a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show47.mp3" target="_blank">Download Episode (mp3)</a>
In this show:
The new cloud witness
How to use digital signatures instead of cross database ownership chaining
What do you do when we have SQL Server connectivity issues?
Compare execution plans in SQL Server 2016
Guy’s SQL Server killer feature
How to manage the availability of Azure virtual machines using Availability Sets
Profiler – the DBA’s best friendGuy Glantser and Matan Yungmanno38:54Show 46 – DBCC OPTIMIZER_WHAT_THE_F***http://sqlserverradio.co.il/show46/
Thu, 29 Oct 2015 03:00:19 +0000http://sqlserverradio.co.il/?p=3618http://sqlserverradio.co.il/show46/#commentsMatan YungmanDownload Episode (mp3)
In this show:
We congratulated Matan for being awarded as a SQL Server MVP. Go Matan!
We talked about the next Israeli SQL Server user group meeting and about the next SQL Saturday in Israel.
How to use SSIS to delete files older than a specified number of days?
Using OPTIMIZER_WHATIF and StatsStream to simulate a production environment.
Is it worth writing unit tests?
What is the Clipboard Manager in SSMS?
Why we hate indexed views…
Some interesting stories about forward-only cursors.
Which standup shows will make you laugh until you can’t breathe?Download Episode (mp3)

In this show:

We congratulated Matan for being awarded as a SQL Server MVP. Go Matan!

How to use SSIS to delete files older than a specified number of days?

Using OPTIMIZER_WHATIF and StatsStream to simulate a production environment.

Is it worth writing unit tests?

What is the Clipboard Manager in SSMS?

Why we hate indexed views…

Some interesting stories about forward-only cursors.

Which standup shows will make you laugh until you can’t breathe?

]]>http://sqlserverradio.co.il/show46/feed/5Download Episode (mp3) In this show: We congratulated Matan for being awarded as a SQL Server MVP. Go Matan! We talked about the next Israeli SQL Server user group meeting and about the next SQL Saturday in Israel. <a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show46.mp3" target="_blank">Download Episode (mp3)</a>
In this show:
We congratulated Matan for being awarded as a SQL Server MVP. Go Matan!
We talked about the <a href="http://israel.sqlpass.org/">next Israeli SQL Server user group meeting</a> and about the <a href="http://www.sqlsaturday.com/481/EventHome.aspx">next SQL Saturday in Israel</a>.
How to use SSIS to delete files older than a specified number of days?
Using OPTIMIZER_WHATIF and StatsStream to simulate a production environment.
Is it worth writing unit tests?
What is the Clipboard Manager in SSMS?
Why we hate indexed views…
Some interesting stories about forward-only cursors.
Which standup shows will make you laugh until you can’t breathe?Guy Glantser and Matan Yungmanno43:52Show 45 – שני דביליםhttp://sqlserverradio.co.il/show45/
Thu, 15 Oct 2015 09:00:22 +0000http://sqlserverradio.co.il/?p=3397http://sqlserverradio.co.il/show45/#respondMatan YungmanDownload 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 tableDownload Episode (mp3)

]]>http://sqlserverradio.co.il/show45/feed/0Download 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? <a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show45.mp3" target="_blank">Download Episode (mp3)</a>
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 tableGuy Glantser and Matan Yungmanno37:17Show 44 – Disk D (fixed)http://sqlserverradio.co.il/show44_/
Thu, 01 Oct 2015 05:59:57 +0000http://sqlserverradio.co.il/?p=3269http://sqlserverradio.co.il/show44_/#respondMatan YungmanDownload 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 ProblemDownload 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

http://sqlserverradio.co.il/show44_/feed/0Download 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 <a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show44.mp3" target="_blank">Download Episode (mp3)</a>
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:
<a href="http://www.madeiradata.com/move-tempdb-files-on-azure-virtual-machines/" target="_blank">Noa Brodezky - The Right Way to Move Tempdb Files on Azure Virtual Machines</a>
<a href="https://www.instant.ly/s/uucEP/nav#p/186a0" target="_blank">Let's Chat About SQL Server Migration</a>
<a href="http://sqlmag.com/sql-server/new-solution-packing-intervals-problem" target="_blank">Itzik Ben-Gan - New Solution to the Packing Intervals Problem</a>Guy Glantser and Matan Yungmanno32:26Show 43 – לא לנתק את הכבלhttp://sqlserverradio.co.il/show43/
Thu, 17 Sep 2015 05:05:39 +0000http://sqlserverradio.co.il/?p=3079http://sqlserverradio.co.il/show43/#respondMatan YungmanDownload 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)

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

]]>http://sqlserverradio.co.il/show43/feed/0Download 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 <a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show43.mp3" target="_blank">Download Episode (mp3)</a>
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..Guy Glantser and Matan Yungmanno36:26Show 42 – The Systemhttp://sqlserverradio.co.il/show42/
Thu, 27 Aug 2015 08:00:08 +0000http://sqlserverradio.co.il/?p=2791http://sqlserverradio.co.il/show42/#respondMatan YungmanDownload 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)

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

]]>http://sqlserverradio.co.il/show42/feed/0Download 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 <a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show42.mp3" target="_blank">Download Episode (mp3)</a>
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..
Guy Glantser and Matan Yungmanno46:38Show 41 – Go Climb a Mountainhttp://sqlserverradio.co.il/show41/
Thu, 13 Aug 2015 05:53:39 +0000http://sqlserverradio.co.il/?p=2551http://sqlserverradio.co.il/show41/#respondMatan YungmanDownload 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 PresentationDownload Episode (mp3)

http://sqlserverradio.co.il/show41/feed/0Download 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,<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show41.mp3" target="_blank">Download Episode (mp3)</a>
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:
<a href="http://www.sqlpass.org/24hours/2015/goc/Sessions.aspx" target="_blank">24 Hours of PASS session recordings</a>
<a href="https://www.youtube.com/watch?list=PLoGAcXKPcRvYPypKMZhVM4Vs4Yt1hUoZV&v=YPakjmZpsiA" target="_blank">Matan Yungman - The Data Loading Performance Presentation</a>Guy Glantser and Matan Yungmanno39:23Show 40 – Bob the Builderhttp://sqlserverradio.co.il/show40/
Thu, 30 Jul 2015 03:00:37 +0000http://sqlserverradio.co.il/?p=2365http://sqlserverradio.co.il/show40/#commentsMatan YungmanDownload 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)

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

]]>http://sqlserverradio.co.il/show40/feed/3Download 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 <a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show40.mp3" target="_blank">Download Episode (mp3)</a>
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
Guy Glantser and Matan Yungmanno51:47Show 39 – Life Balancehttp://sqlserverradio.co.il/show39/
Thu, 16 Jul 2015 07:30:46 +0000http://sqlserverradio.co.il/?p=2110http://sqlserverradio.co.il/show39/#commentsMatan YungmanDownload 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 BooksDownload 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.

]]>http://sqlserverradio.co.il/show39/feed/2Download 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,<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show39.mp3" target="_blank">Download Episode (mp3)</a>
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:
<a href="https://www.ted.com/talks/ricardo_semler_radical_wisdom_for_a_company_a_school_a_life?language=en" target="_blank">Ricardo Semler - How to Run a Company with (almost) No Rules</a>
<a href="http://www.amazon.com/Ricardo-Semler/e/B000APW260" target="_blank">Ricardo Semler Books</a>
<a href="http://sqlserverradio.co.il/wp-content/uploads/11901448_10155996074525302_6091205797197628260_o.jpg"></a>Guy Glantser and Matan Yungmanno47:15Show 38 – Let the Kids Playhttp://sqlserverradio.co.il/show38/
Sun, 28 Jun 2015 21:13:19 +0000http://sqlserverradio.co.il/?p=1881http://sqlserverradio.co.il/show38/#respondMatan YungmanDownload 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)
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.

]]>http://sqlserverradio.co.il/show38/feed/0Download 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 <a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show38.mp3" target="_blank">Download Episode (mp3)</a>
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.
Guy Glantser and Matan Yungmanno36:07Show 37 – Eitan Bluminhttp://sqlserverradio.co.il/show37/
Mon, 15 Jun 2015 05:54:49 +0000http://sqlserverradio.co.il/?p=1713http://sqlserverradio.co.il/show37/#respondMatan YungmanDownload 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)
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.

]]>http://sqlserverradio.co.il/show37/feed/0Download 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,<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show37.mp3" target="_blank">Download Episode (mp3)</a>
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:
<a href="http://www.madeirasql.com/introduction-to-azure-documentdb/" target="_blank">Eitan Blumin - Introduction to Azure DocumentDB</a>
<a href="http://www.madeirasql.com/efficiently-update-and-delete-with-sorting/" target="_blank">Eitan Blumin - Efficiently UPDATE and DELETE using TOP and ORDER BY</a>
<a href="http://www.madeirasql.com/service-broker-asynchronous-triggers/" target="_blank">Eitan Blumin - Service Broker Sample: Asynchronous Triggers</a>
<a href="http://www.madeirasql.com/service-broker-sample-multi-threading/" target="_blank">Eitan Blumin - Service Broker Sample: Multi-Threading</a>
Guy Glantser and Matan Yungmanno26:47Show 36 – Build, Ignite and SQL Server 2016http://sqlserverradio.co.il/show36/
Sun, 24 May 2015 23:00:56 +0000http://sqlserverradio.co.il/?p=1309http://sqlserverradio.co.il/show36/#respondMatan YungmanDownload 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 formatDownload 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.

]]>http://sqlserverradio.co.il/show36/feed/0Download 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: - <a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show36.mp3" target="_blank">Download Episode (mp3)</a>
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:
<a href="http://ariely.info/Blog/tabid/83/EntryId/161/Date-displaying-format-vs-Date-storing-format.aspx" target="_blank">Ronen Ariely - Date displaying format, vs Date storing format</a>Guy Glantser and Matan Yungmanno27:57Show 35 – Give Me Sambusakhttp://sqlserverradio.co.il/show35/
Thu, 07 May 2015 04:58:34 +0000http://sqlserverradio.co.il/?p=1189http://sqlserverradio.co.il/show35/#respondMatan YungmanDownload 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 MatchDownload 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.

]]>http://sqlserverradio.co.il/show35/feed/0Download 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 Lo...<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show35.mp3" target="_blank">Download Episode (mp3)</a>
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:
<a href="http://www.madeirasql.com/log-shipping-without-shipping-the-log/" target="_blank">Matan Yungman - Can Log Shipping Work Without Shipping the Log?</a>
<a href="https://msdn.microsoft.com/en-us/library/azure/jj650016.aspx" target="_blank">Azure SQL Database Backup and Restore</a>
<a href="http://www.nikoport.com/2015/04/04/clustered-columnstore-indexes-part-50-columnstore-io/" target="_blank">Niko Neugebauer - Columnstore IO</a>
<a href="http://sqlblog.com/blogs/rob_farley/archive/2011/03/22/probe-residual-when-you-have-a-hash-match-a-hidden-cost-in-execution-plans.aspx" target="_blank">Rob Farley - Probe Residual when you have a Hash Match</a>Guy Glantser and Matan Yungmanno47:20Show 34 – GuyDBhttp://sqlserverradio.co.il/show34/
Wed, 08 Apr 2015 05:42:55 +0000http://sqlserverradio.co.il/?p=807http://sqlserverradio.co.il/show34/#respondMatan YungmanDownload 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 CacheDownload 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.

]]>http://sqlserverradio.co.il/show34/feed/0Download 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 201...<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show34.mp3" target="_blank">Download Episode (mp3)</a>
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:
<a href="http://www.sqlpass.org/Events/PASSSummit/BestofPASSSummit2014.aspx" target="_blank">Top 10 sessions of PASS Summit 2014</a>
<a href="http://israel.sqlpass.org" target="_blank">Next Israeli SQL Server User Group meeting</a>
<a href="http://sqlperformance.com/2015/02/sql-performance/more-online-operations" target="_blank">Aaron Bertrand - More Online Operations for Azure SQL Database</a>
<a href="https://dev.mysql.com/doc/refman/5.1/en/query-cache.html" target="_blank">MySQL Query Cache</a>Guy Glantser and Matan Yungmanno45:46Show 33 – Speculationshttp://sqlserverradio.co.il/show33/
Thu, 19 Mar 2015 10:18:25 +0000http://sqlserverradio.co.il/?p=625http://sqlserverradio.co.il/show33/#respondMatan YungmanDownload 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 StatisticsDownload 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.

]]>http://sqlserverradio.co.il/show33/feed/0Download 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,<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show33.mp3" target="_blank">Download Episode (mp3)</a>
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:
<a href="http://www.madeirasql.com/monitor-query-statistics/" target="_blank">Guy Glantser - Monitor Query Statistics</a>Guy Glantser and Matan Yungmanno37:55Show 32 – פוריםhttp://sqlserverradio.co.il/show32/
Sun, 08 Mar 2015 09:05:10 +0000http://sqlserverradio.co.il/?p=616http://sqlserverradio.co.il/show32/#commentsMatan YungmanDownload Episode (mp3)
We have a special episode today:
SQL Server Radio Purim editionDownload Episode (mp3)
We have a special episode today:

SQL Server Radio Purim edition

]]>http://sqlserverradio.co.il/show32/feed/2Download Episode (mp3) We have a special episode today: SQL Server Radio Purim edition<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show32.mp3" target="_blank">Download Episode (mp3)</a>
We have a special episode today:
SQL Server Radio Purim editionGuy Glantser and Matan Yungmanno12:29Show 31 – SQLSaturday Israel Recaphttp://sqlserverradio.co.il/show31/
Thu, 19 Feb 2015 05:57:25 +0000http://sqlserverradio.co.il/?p=606http://sqlserverradio.co.il/show31/#respondMatan YungmanDownload 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)
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..

]]>http://sqlserverradio.co.il/show31/feed/0Download 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,<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show31.mp3" target="_blank">Download Episode (mp3)</a>
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..
Guy Glantser and Matan Yungmanno50:39Show 30 – סילומיותhttp://sqlserverradio.co.il/show30/
Wed, 04 Feb 2015 20:22:10 +0000http://sqlserverradio.co.il/?p=590http://sqlserverradio.co.il/show30/#commentsMatan YungmanDownload 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_MSforeachdbDownload 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

]]>http://sqlserverradio.co.il/show30/feed/2Download 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 "סילומיות",<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show30.mp3" target="_blank">Download Episode (mp3)</a>
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:
<a href="http://www.madeirasql.com/im-sql-server-mvp/" target="_blank">Guy Glantser - I'm a SQL Server MVP!</a>
<a href="https://social.technet.microsoft.com/Forums/he-il/home?forum=sqlhe" target="_blank">TechNet SQL Server Forum</a>
<a href="http://www.sqlpass.org/Community/PASSBlog/tabid/1476/entryid/687/15-SQLFamily-Wishes-for-2015.aspx" target="_blank">15 #SQLFamily Wishes for 2015</a>
<a href="https://www.youtube.com/watch?v=tOiFlCyWz8E&feature=share" target="_blank">Data Exposed - Insights into Azure SQL Database</a>
<a href="http://www.sqlservercentral.com/articles/Power+View/119430/" target="_blank">Amir Charania - Create Stunning Visualizations with Power View in 20 Minutes or Less</a>
<a href="http://sqlblog.com/blogs/aaron_bertrand/archive/2010/12/29/a-more-reliable-and-more-flexible-sp-msforeachdb.aspx" target="_blank">Aaron Bertrand - A More Reliable and More Flexible sp_MSforeachdb</a>Guy Glantser and Matan Yungmanno53:26Show 29 – Adi Sapir (Part 2)http://sqlserverradio.co.il/show29/
Sun, 04 Jan 2015 08:41:34 +0000http://sqlserverradio.co.il/?p=557http://sqlserverradio.co.il/show29/#respondMatan YungmanIt'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"
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.

]]>http://sqlserverradio.co.il/show29/feed/0It'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: - It's part 2 of the fascinating interview we had with Adi Sapir (<a href="https://www.linkedin.com/in/adisapir" target="_blank">LinkedIn</a>, <a href="https://twitter.com/adisapir" target="_blank">Twitter</a>).
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 <a href="http://www.doccolabs.com/" target="_blank">cool handy tools Adi develops</a>.
Items mentioned in the show:
<a href="http://www.doccolabs.com/" target="_blank">doccolabs.com</a>
<a href="http://www.sqlpass.org/Community/PASSBlog/tabid/1476/entryid/647/Simply-PASS.aspx" target="_blank">PASS is no longer "Professional Association for SQL Server"</a>
Guy Glantser and Matan Yungmanno45:52Show 28 – Adi Sapir (Part 1)http://sqlserverradio.co.il/show28/
Sun, 21 Dec 2014 05:32:51 +0000http://sqlserverradio.co.il/?p=555http://sqlserverradio.co.il/show28/#respondMatan YungmanDownload 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.comDownload 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 notto 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

]]>http://sqlserverradio.co.il/show28/feed/0Download 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 tw...<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show28.mp3" target="_blank">Download Episode (mp3)</a>
On this show, we have an important guest from abroad - <a href="http://about.me/adisapir" target="_blank">Adi Sapir!</a>
Adi (<a href="https://www.linkedin.com/in/adisapir" target="_blank">LinkedIn</a>, <a href="https://twitter.com/adisapir" target="_blank">Twitter</a>) 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 <a href="http://www.doccolabs.com/" target="_blank">www.doccolabs.com</a>Guy Glantser and Matan Yungmanno26:02Show 27 – Partitioninghttp://sqlserverradio.co.il/show27/
Thu, 04 Dec 2014 08:09:14 +0000http://sqlserverradio.co.il/?p=545http://sqlserverradio.co.il/show27/#respondMatan YungmanDownload 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)
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..

]]>http://sqlserverradio.co.il/show27/feed/0Download 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 <a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show27.mp3" target="_blank">Download Episode (mp3)</a>
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..
Guy Glantser and Matan Yungmanno41:17Show 26 – Migrutzhttp://sqlserverradio.co.il/show26/
Thu, 20 Nov 2014 08:13:50 +0000http://sqlserverradio.co.il/?p=538http://sqlserverradio.co.il/show26/#respondMatan YungmanDownload 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?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.

]]>http://sqlserverradio.co.il/show26/feed/0Download 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 <a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show26.mp3" target="_blank">Download Episode (mp3)</a>
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:
<a href="http://blogs.lessthandot.com/index.php/datamgmt/dbprogramming/mssqlserver/the-magic-alt-button/" target="_blank">Koen Verbeeck - The Magic Alt Button</a>
<a href="http://www.dbnewsfeed.com/2013/04/30/five-ways-to-improve-your-productivity-with-ssms/" target="_blank">Matan Yungman - Five Ways to Improve Your Productivity with SSMS</a>
<a href="http://www.madeirasql.com/transaction-durability/" target="_blank">Dudu Sinai - Transaction Durability</a>
<a href="http://itaibinyamin.blogspot.co.il/2014/11/extended-properties.html" target="_blank">Itai Binyamin - What are Extended Properties Good For?</a>Guy Glantser and Matan Yungmanno44:05Show 25 – Jet Laghttp://sqlserverradio.co.il/show25/
Mon, 03 Nov 2014 04:04:34 +0000http://sqlserverradio.co.il/?p=534http://sqlserverradio.co.il/show25/#respondMatan YungmanDownload Episode (mp3)
On this show, which is recorded in Seattle, we share our plans, schedules, thoughts and hopes for Pass Summit 2014.
We focus on the schedule each one of us has built for the summit and reflect our thoughts about how the topics of those sessions can help all of us in our day-to-day jobs.
We also discuss if and how the agenda fits the current Microsoft strategy.Download Episode (mp3)
On this show, which is recorded in Seattle, we share our plans, schedules, thoughts and hopes for Pass Summit 2014.

We focus on the schedule each one of us has built for the summit and reflect our thoughts about how the topics of those sessions can help all of us in our day-to-day jobs.

We also discuss if and how the agenda fits the current Microsoft strategy.

]]>http://sqlserverradio.co.il/show25/feed/0Download Episode (mp3) On this show, which is recorded in Seattle, we share our plans, schedules, thoughts and hopes for Pass Summit 2014. We focus on the schedule each one of us has built for the summit and reflect our thoughts about how the topics ...<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show25.mp3" target="_blank">Download Episode (mp3)</a>
On this show, which is recorded in Seattle, we share our plans, schedules, thoughts and hopes for Pass Summit 2014.
We focus on the schedule each one of us has built for the summit and reflect our thoughts about how the topics of those sessions can help all of us in our day-to-day jobs.
We also discuss if and how the agenda fits the current Microsoft strategy.Guy Glantser and Matan Yungmanno41:54Show 24 – Asaf Avivhttp://sqlserverradio.co.il/show24/
Sat, 18 Oct 2014 22:00:04 +0000http://sqlserverradio.co.il/?p=528http://sqlserverradio.co.il/show24/#respondMatan YungmanDownload Episode (mp3)
It's show 24, and guess what - we have a guest again: Asaf Aviv!
Asaf is very much into SQL Server Scale-Out solutions and SQL Server Replication, and not surprisingly, we take a VERY deep dive into those subjects (get ready for a lot of pro tips).
In addition, we talk about the history of Asaf as a rock star, about guitars and how they are related to SQL Server, and about a very weird issue Guy had with a motorcycle...
Download Episode (mp3)
It’s show 24, and guess what – we have a guest again: Asaf Aviv!

Asaf is very much into SQL Server Scale-Out solutions and SQL Server Replication, and not surprisingly, we take a VERY deep dive into those subjects (get ready for a lot of pro tips).

In addition, we talk about the history of Asaf as a rock star, about guitars and how they are related to SQL Server, and about a very weird issue Guy had with a motorcycle…

]]>http://sqlserverradio.co.il/show24/feed/0Download Episode (mp3) It's show 24, and guess what - we have a guest again: Asaf Aviv! Asaf is very much into SQL Server Scale-Out solutions and SQL Server Replication, and not surprisingly, we take a VERY deep dive into those subjects (get ready fo...<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show24.mp3" target="_blank">Download Episode (mp3)</a>
It's show 24, and guess what - we have a guest again: Asaf Aviv!
Asaf is very much into SQL Server Scale-Out solutions and SQL Server Replication, and not surprisingly, we take a VERY deep dive into those subjects (get ready for a lot of pro tips).
In addition, we talk about the history of Asaf as a rock star, about guitars and how they are related to SQL Server, and about a very weird issue Guy had with a motorcycle...
Guy Glantser and Matan Yungmanno58:36Show 23 – 0 Microsecondshttp://sqlserverradio.co.il/show23/
Sun, 05 Oct 2014 07:52:49 +0000http://sqlserverradio.co.il/?p=516http://sqlserverradio.co.il/show23/#respondMatan YungmanDownload Episode (mp3)
This is the monthly all-over-the-place edition of our show. As usual, we cover a lot of issues we encountered the past month, interesting blog posts, tips, tricks, events and random thoughts.
Among other topics, we talk about:
A weird scenario with backups, and the difference between Backupset and Mediaset
A weird scenario with a procedure ran 150 times a second
Visualization of DBCC SHOWSTATISTICS in SSMS
Various New Azure templates
Scenarios for In-Memory OLTP
Presentation skills
And more..
Items mentioned in the show:
Maria Zakourdaev - Using Google Charts API to Visualize Schema Changes
Mark Wiklinson - Visualizing Statistics in SSMS
New Optimized OLTP and Data Warehousing SQL Server Images on Azure
SQLSaturday Israel
24 Hours of Pass Summit Preview Edition
Julie Koesmarno - I Want It NOW!" Data Visualization with Power View
24 Hours of Pass SQL Server 2014 Edition
Sunil Agarwal - SQL Server 2014: In-Memory OLTP for Database Administrators
Sunil Agarwal - Columnstore Technical Deep Dive
Jimmy May - Columnstore Indexes in SQL Server 2014: Flipping the DW Faster BitDownload Episode (mp3)
This is the monthly all-over-the-place edition of our show. As usual, we cover a lot of issues we encountered the past month, interesting blog posts, tips, tricks, events and random thoughts.

Among other topics, we talk about:

A weird scenario with backups, and the difference between Backupset and Mediaset

]]>http://sqlserverradio.co.il/show23/feed/0Download Episode (mp3) This is the monthly all-over-the-place edition of our show. As usual, we cover a lot of issues we encountered the past month, interesting blog posts, tips, tricks, events and random thoughts. Among other topics,<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show23.mp3" target="_blank">Download Episode (mp3)</a>
This is the monthly all-over-the-place edition of our show. As usual, we cover a lot of issues we encountered the past month, interesting blog posts, tips, tricks, events and random thoughts.
Among other topics, we talk about:
A weird scenario with backups, and the difference between Backupset and Mediaset
A weird scenario with a procedure ran 150 times a second
Visualization of DBCC SHOWSTATISTICS in SSMS
Various New Azure templates
Scenarios for In-Memory OLTP
Presentation skills
And more..
Items mentioned in the show:
<a href="http://sqlblog.com/blogs/maria_zakourdaev/archive/2014/09/08/using-google-charts-api-to-visualize-schema-changes.aspx" target="_blank">Maria Zakourdaev - Using Google Charts API to Visualize Schema Changes</a>
<a href="http://m82labs.com/visualizing-statistics-in-ssms-2/" target="_blank">Mark Wiklinson - Visualizing Statistics in SSMS</a>
<a href="http://blogs.technet.com/b/dataplatforminsider/archive/2014/09/17/new-optimized-oltp-and-data-warehousing-sql-server-images-on-azure.aspx" target="_blank">New Optimized OLTP and Data Warehousing SQL Server Images on Azure</a>
<a href="https://www.sqlsaturday.com/360/eventhome.aspx" target="_blank">SQLSaturday Israel</a>
<a href="http://www.sqlpass.org/24hours/2014/summitpreview/Sessions.aspx" target="_blank">24 Hours of Pass Summit Preview Edition</a>
<a href="http://www.sqlpass.org/24hours/2014/summitpreview/Sessions/SessionDetails.aspx?sid=7290" target="_blank">Julie Koesmarno - I Want It NOW!" Data Visualization with Power View</a>
<a href="http://www.sqlpass.org/24hours/2014/ss2014launch/Sessions.aspx" target="_blank">24 Hours of Pass SQL Server 2014 Edition</a>
<a href="http://www.sqlpass.org/24hours/2014/ss2014launch/sessions/details.aspx?sid=7151" target="_blank">Sunil Agarwal - SQL Server 2014: In-Memory OLTP for Database Administrators</a>
<a href="http://www.sqlpass.org/24hours/2014/ss2014launch/sessions/details.aspx?sid=7158" target="_blank">Sunil Agarwal - Columnstore Technical Deep Dive</a>
<a href="http://www.sqlpass.org/24hours/2014/ss2014launch/sessions/details.aspx?sid=7159" target="_blank">Jimmy May - Columnstore Indexes in SQL Server 2014: Flipping the DW Faster Bit</a>Guy Glantser and Matan Yungmanno47:40Show 22 – Career Managementhttp://sqlserverradio.co.il/show22/
Sat, 20 Sep 2014 22:30:10 +0000http://sqlserverradio.co.il/?p=507http://sqlserverradio.co.il/show22/#respondMatan YungmanDownload Episode (mp3)
On show 22, we talk about career management.
We actually recorded this show a few months ago, but it might be the best and most important show we've had.
We talk about about our careers: How we got to be DBAs, how we progressed, our difficulties, what steps took us forward, what processes we went through, and how getting involved in the community has helped us.
Furthermore, we talk about:
Why consistent learning is so important
How blogging and public speaking can help you
Why it's important to have a mentor
How Guy started his own company
Time management tips
And how are candies related to Guy's career?
Let us know what you think about career management in the DBA world. We would love to hear what you think!Download Episode (mp3)
On show 22, we talk about career management.

We actually recorded this show a few months ago, but it might be the best and most important show we’ve had.

We talk about about our careers: How we got to be DBAs, how we progressed, our difficulties, what steps took us forward, what processes we went through, and how getting involved in the community has helped us.

Furthermore, we talk about:

Why consistent learning is so important

How blogging and public speaking can help you

Why it’s important to have a mentor

How Guy started his own company

Time management tips

And how are candies related to Guy’s career?

Let us know what you think about career management in the DBA world. We would love to hear what you think!

]]>http://sqlserverradio.co.il/show22/feed/0Download Episode (mp3) On show 22, we talk about career management. We actually recorded this show a few months ago, but it might be the best and most important show we've had. - We talk about about our careers: How we got to be DBAs,<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show22.mp3" target="_blank">Download Episode (mp3)</a>
On show 22, we talk about career management.
We actually recorded this show a few months ago, but it might be the best and most important show we've had.
We talk about about our careers: How we got to be DBAs, how we progressed, our difficulties, what steps took us forward, what processes we went through, and how getting involved in the community has helped us.
Furthermore, we talk about:
Why consistent learning is so important
How blogging and public speaking can help you
Why it's important to have a mentor
How Guy started his own company
Time management tips
And how are candies related to Guy's career?
Let us know what you think about career management in the DBA world. We would love to hear what you think!Guy Glantser and Matan Yungmanno1:07:47Show 21 – Noam Binyaminihttp://sqlserverradio.co.il/show21/
Sat, 06 Sep 2014 19:22:41 +0000http://sqlserverradio.co.il/?p=491http://sqlserverradio.co.il/show21/#respondMatan YungmanDownload Episode (mp3)
On show 21, we have a guest again - Noam Binyamini, Senior Support Engineer at Microsoft.
We talk with Noam about his job, about interesting incidents he encountered, common mistakes customers make, and about the importance of installing service pack and cumulative updates.
Later on, we talk about the massive investments Microsoft puts into the cloud, the right scenarios to work with the cloud, and the maturity of Microsoft Azure SQL Database (formerly SQL Azure).
Download Episode (mp3)
On show 21, we have a guest again – Noam Binyamini, Senior Support Engineer at Microsoft.

We talk with Noam about his job, about interesting incidents he encountered, common mistakes customers make, and about the importance of installing service pack and cumulative updates.

Later on, we talk about the massive investments Microsoft puts into the cloud, the right scenarios to work with the cloud, and the maturity of Microsoft Azure SQL Database (formerly SQL Azure).

]]>http://sqlserverradio.co.il/show21/feed/0Download Episode (mp3) On show 21, we have a guest again - Noam Binyamini, Senior Support Engineer at Microsoft. We talk with Noam about his job, about interesting incidents he encountered, common mistakes customers make,<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show21.mp3" target="_blank">Download Episode (mp3)</a>
On show 21, we have a guest again - Noam Binyamini, Senior Support Engineer at Microsoft.
We talk with Noam about his job, about interesting incidents he encountered, common mistakes customers make, and about the importance of installing service pack and cumulative updates.
Later on, we talk about the massive investments Microsoft puts into the cloud, the right scenarios to work with the cloud, and the maturity of Microsoft Azure SQL Database (formerly SQL Azure).
Guy Glantser and Matan Yungmanno37:01Show 20 – High Availabilityhttp://sqlserverradio.co.il/show20/
Sat, 23 Aug 2014 06:17:57 +0000http://sqlserverradio.co.il/?p=484http://sqlserverradio.co.il/show20/#commentsMatan YungmanDownload Episode (mp3)
On show 20, we talk about High Availability.
We start with talking about the distinction between High Availability and Disaster Recovery. Then, we talk about the importance of having a RESTORE strategy rather than a backup strategy.
After that, we talk about the various High Availability/Disaster Recovery technologies: AlwaysOn Failover Cluster Instances, Log Shipping, Database Mirroring and AlwaysOn Availability Groups. We talk about the specifics and capabilities of each technology, in which editions its supported and its pros and cons.
Download Episode (mp3)
On show 20, we talk about High Availability.

We start with talking about the distinction between High Availability and Disaster Recovery. Then, we talk about the importance of having a RESTORE strategy rather than a backup strategy.

After that, we talk about the various High Availability/Disaster Recovery technologies: AlwaysOn Failover Cluster Instances, Log Shipping, Database Mirroring and AlwaysOn Availability Groups. We talk about the specifics and capabilities of each technology, in which editions its supported and its pros and cons.

]]>http://sqlserverradio.co.il/show20/feed/2Download Episode (mp3) On show 20, we talk about High Availability. We start with talking about the distinction between High Availability and Disaster Recovery. Then, we talk about the importance of having a RESTORE strategy rather than a backup stra...<a href="http://traffic.libsyn.com/madeirasqlserverradio/IsraeliSQLServerRadio_Show020.mp3" target="_blank">Download Episode (mp3)</a>
On show 20, we talk about High Availability.
We start with talking about the distinction between High Availability and Disaster Recovery. Then, we talk about the importance of having a RESTORE strategy rather than a backup strategy.
After that, we talk about the various High Availability/Disaster Recovery technologies: AlwaysOn Failover Cluster Instances, Log Shipping, Database Mirroring and AlwaysOn Availability Groups. We talk about the specifics and capabilities of each technology, in which editions its supported and its pros and cons.
Guy Glantser and Matan Yungmanno36:19Show 19 – Back to the Futurehttp://sqlserverradio.co.il/show19/
Thu, 07 Aug 2014 05:31:52 +0000http://sqlserverradio.co.il/?p=475http://sqlserverradio.co.il/show19/#respondMatan YungmanDownload Episode (mp3)
We're back from our trips, and on show 19, we juggle around a few topics.
We talk about super indexes, trivial plans and whether they're the best choice, Dynamic SQL and automatic code, Replication, a hidden and yet important property of Failover Clusters, and more..
Also, Matan declares that User Defined Functions need to be wiped out. Listen to hear why!
Links mentioned in the show:
Super Index
Kendal Van Dyke - Troubleshooting Transactional Replication
Eitan Blumin - Let SQL Server Write Code for You
Avi Niv - Generating Email Reports Using XML
Michael J Swart - Trivia about Trivial Plans
Paul White - Forcing a Parallel Query Execution Plan
Guy Glantser - How to Use Parameters Like a Pro and Boost Performance
Modifying Clustered Service Settings
Global Hebrew Virtual Chapter August Meeting
Israeli SQL Server User Group Meeting #145Download Episode (mp3)

We’re back from our trips, and on show 19, we juggle around a few topics.

We talk about super indexes, trivial plans and whether they’re the best choice, Dynamic SQL and automatic code, Replication, a hidden and yet important property of Failover Clusters, and more..

]]>http://sqlserverradio.co.il/show17/feed/0Guy Glantser and Matan Yungmanno35:51Show 16 – Shy Engelberghttp://sqlserverradio.co.il/show16/
Sun, 15 Jun 2014 15:32:41 +0000http://sqlserverradio.co.il/?p=447http://sqlserverradio.co.il/show16/#respondMatan Yungman
After a long time, we have a guest again – Shy Engelberg from HYNT!

We had a great conversation that spanned a lot of subjects. Among other topics, we talked about Microsoft and Google, Views and bad plans, Hekaton best practices, good and bad features, the life of the consultant, how Shy is doing in his new adventure, and about the professionals who influenced us the most.

]]>http://sqlserverradio.co.il/show16/feed/0Guy Glantser and Matan Yungmanno1:02:40Show 15 – Five Devices Per Personhttp://sqlserverradio.co.il/show_15/
Tue, 27 May 2014 07:38:57 +0000http://sqlserverradio.co.il/?p=441http://sqlserverradio.co.il/show_15/#commentsMatan Yungman
On show 15, as always, we cover a lot of interesting stuff. We talk how our lives and databases will look in the year 2025. We also talk about changes to Azure SQL Database, Interesting webinars, weak passwords, Recompilations, SQL Server 2014, transaction nesting, and much more. Of course we talk about past and future events, and also about the top 3 jobs for DBAs.

Guy also shares his running experience, and explains how a SQL Server feature is related to the post office..

We talk a lot about the new Cardinality Estimator, why Views are dangerous, and on the other hand, tricks you can do with them, what is the async_network_io wait type, and about another cool little feature in SQL Server 2014.

We also cover two webinars worth watching, and translate (and invent) some words..

We covered quite a lot of topics. Among them are auditing, Extended Events and Event Notifications, cluster issues, database unit tests, SSMS Add-ins and Hadoop. In addition, we have a countdown featuring the 10 best presentations Pass Summit 2013.