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 services, tips, tricks, and much more. Among other topics, we talk about:

• Why pulling from a Linked Server is A LOT faster than pushing
• The effect of new hardware on Writelog waits
• Ways to improve the throughput of your data loading processes
• The architecture of Transaction Replication
• A weird bug with sequence
• DocumentDB, Microsoft's new NoSQL database service
• String search solutions in SQL Server
• Why you should wear the Database Architect hat from time to time
• How Paul Simon is related to SQL Server

Items mentioned in the show:

• Guy Glantser – Parameterization Series
• Linchi Shea – Linked servers and performance impact: Direction matters!
• Maria Zakourdaev – Choosing SEQUENCE instead of IDENTITY? Watch your step
• SQLBits Session Recordings
• Klaus Aschenbrenner – Latches, Spinlocks, and Lock Free Data Structures
• 24 Hours of Pass
• Denny Cherry – PASS Summit 2014 Speaker Idol Competition
• SQL Server Days
• Microsoft NoSQL database and full-text search service previews available on Azure
• Bob Beauchemin – New Azure services and evolution of the Service/SQL Server relationship
• Stuart Ainsworth – From DBA to Data Architect: Changing Your Game (zip file for download)

Download Episode (mp3)

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 take a deep dive into performance tuning and talk about:

* The Top-Down and Bottom-Up methods and when to use which

* The various tools SQL Server gives us for performance tuning

* How to pinpoint the problem in any of the methods

* What to look for when tuning a slow running query or process

* What to look for when analyzing execution plans

* Why you should always blame the network :)

* And more..

What's your method for performance tuning? What are the tools that you use? Tell us in the comments..

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 take a deep dive into performance tuning and talk about:

• The Top-Down and Bottom-Up methods and when to use which
• The various tools SQL Server gives us for performance tuning
• How to pinpoint the problem in any of the methods
• What to look for when tuning a slow running query or process
• What to look for when analyzing execution plans
• Why you should always blame the network
• And more..

What's your method for performance tuning? What are the tools that you use? Tell us in the comments..

Download Episode (mp3)

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 WPC (Microsoft Worldwide Partner Conference). He explains what WPC is, about the Microsoft vision and its effects on the DBA's work.

We then talk about interesting blog posts, forum discussions, news and incidant we encountered in the last month:

* The less known but deadly drawback of User Defined Functions

* The real meaning of Blocking Iterators

* The real meaning of PAGEIOLATCH waits

* Perofrmance monitoring and baselines

* Automatic code

* And more..

Items mentioned in the show:

* Adam Machanic - Query Tuning Mastery: The Art and Science of Manhandling Paralellism

* Paul Randal - Knee-Jerk Wait Statistics : PAGEIOLATCH_SH

* Eitan Blumin - Let SQL Server Write Code for You

* Avi Niv - Generating Email Reports using XML

* Kendal Van Dyke – Troubleshooting Transactional Replication

* Microsoft’s unified technology event for enterprises

* Adam Machanic - PASS Summit 2014 and the Contradiction of Long Running Things

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 WPC (Microsoft Worldwide Partner Conference). He explains what WPC is, about the Microsoft vision and its effects on the DBA's work.

We then talk about interesting blog posts, forum discussions, news and incidant we encountered in the last month:

• The less known but deadly drawback of User Defined Functions
• The real meaning of Blocking Iterators
• The real meaning of PAGEIOLATCH waits
• Perofrmance monitoring and baselines
• Automatic code
• And more..

Items mentioned in the show:

• Adam Machanic – Query Tuning Mastery: The Art and Science of Manhandling Paralellism
• Paul Randal – Knee-Jerk Wait Statistics : PAGEIOLATCH_SH
• Eitan Blumin – Let SQL Server Write Code for You
• Avi Niv – Generating Email Reports using XML
• Kendal Van Dyke – Troubleshooting Transactional Replication
• Microsoft's unified technology event for enterprises
• Adam Machanic – PASS Summit 2014 and the Contradiction of Long Running Things

Download Episode (mp3)

Welcome to the first show of SQL Server Radio (English Edition)!

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

On the first show, we talk about Pass and the various activities it facilitates like Pass Summit, SQLSaturday, Local Chapters and Virtual Chapters.

Later on, we talk about our favorite features from SQL Server 2014.

Items mentioned in the show:

* Pass

* SQLSaturday

* Pass Professional Development Virtual Chapter

* Guy Glantser - The Pass Spirit

* Guy Glantser - How to Use Parameters Like a Pro and Boost Performance

How to Listen:

You can listen to the show using any podcast app on your Smartphone, whether you use iPhone, Android or Windows Phone. Just search for "SQL Server Radio" in the app (don't get confused with the Hebrew edition). If the app can't find it, you can add the feed manually using the following URL: http://www.sqlserverradio.com/feed/podcast/

A few recommended podcast apps are the built-in iPhone and Windows Phone apps, BeyondPod (for Android only) and Stitcher.

You can also listen to the show on this website, or download the file and hear it on your car stereo, MP3 player or mobile phone.

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

On the first show, we talk about Pass and the various activities it facilitates like Pass Summit, SQLSaturday, Local Chapters and Virtual Chapters.

Later on, we talk about our favorite features from SQL Server 2014.

Items mentioned in the show:

• Pass
• SQLSaturday
• Pass Professional Development Virtual Chapter
• Guy Glantser – The Pass Spirit
• Guy Glantser – How to Use Parameters Like a Pro and Boost Performance

How to Listen:

You can listen to the show using any podcast app on your Smartphone, whether you use iPhone, Android or Windows Phone. Just search for "SQL Server Radio" in the app (don't get confused with the Hebrew edition). If the app can't find it, you can add the feed manually using the following URL: http://www.sqlserverradio.com/feed/podcast/

A few recommended podcast apps are the built-in iPhone and Windows Phone apps, BeyondPod (for Android only) and Stitcher.

You can also listen to the show on this website, or download the file and hear it on your car stereo, MP3 player or mobile phone.