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

Items mentioned in the show:

Global Hebrew - Steve Rezhener: Introduction to SSRS, and SSRS on SSRS

Azure SQL Database Service Tiers and Performance Levels

SQLDownUnder with Paul Larson

TechEd North America Lectures

Pass Application Development - In-Memory OLTP for Developers

RunAs Radio - SQL 2014 Panel with the SQL Team

Geri Reshef - Transaction Nesting

Paul Randal - Most common wait stats over 24 hours and changes since 2010

Shimon Gibraltar - On Security and Humans: Finding Weak Password in SQL Server

SQL Server 2014 Managed Lock Priority Prevents Log Truncation

Show 14 is up, and as usual, we cover lots of stuff.

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

Items mentioned in the show:

Adir Miller at Verint

CSS Engineers - SQL Server 2014: TEMPDB Hidden Performance Gem

CSS Engineers - SQL Server 2014’s new cardinality estimator

Kendra Little - The SQL 2014 Cardinality Estimator Eats Bad TSQL for Breakfast

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

Michael Zilberstein - Clustered Columnstore Index in SQL Server 2014

Doug Lane - Refactoring T-SQL with Windowing Functions

Aaron Bertrand - Some great news for Standard Edition customers in SQL Server 2014

Next User Group Meeting

It's launch day!

SQL Server is officially released today. With In-Memory OLTP ("Hektaon"), Clustered Columnstore Indexes, Azure integration, AlwaysOn enhancements, Buffer Pool Extension, a new Cardinality Estimator, Delayed Durability, and other smaller but VERY handy features, SQL Server 2014 is an exciting version.

On this show, we talk all about the features of the new version.

After the live show, we're back in the studio.

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.

Oh, and we also talk about Matan's new job...

Items mentioned in the show:

SQL Server 2014 Launch Event

Top 10 presentations of Pass Summit 2013

User group meeting #141

Michael Zilberstein - Clustered Columnstore Index in SQL Server 2014

Michael Zilberstein - Updateable Columnstore Index Gotchas

Maria Zakourdaev - Think and Rethink Every Thing

Meir Dudai - The List of Unsupported Things I Do with Replication

Bob Pusateri - Auditing Database Snapshots

Jonathan Kehayias - Event Notifications vs Extended Events

Red-Gate SSMS Ecosystem Project

Marc Pryce-Maher - Building an SSMS Add-in

tSQLt

Guy Glantser - How to Load Data from Excel in SSIS – 32-bit vs. 64-bit

Matan Yungman - The Strange Story About the MERGE that Killed the Cluster

Matan Yungman - A Community Challenge

This episode is the recording of the live show we had on the February meeting of the Israeli SQL Server user group. We had a great discussion with the crowd about Clustered Indexes vs. Heaps, load testing, the cloud, Filtered Indexes, SQL Alerts, and much more.

We also conducted a quick survey about relevant topics for future meetings of the group.

Items mentioned in the show:

Thomas Kejser - Clustered Indexes vs. Heaps

Matan Yungman - Know When it's Good Enough

Brent's Crazy Career Challenges

RunAs Radio - Distributed Replay in SQL Server 2012

Glenn Berry - Selecting a Processor for SQL Server 2014 - Part 1

Brent Ozar - What Do You Ask the Leaving DBA?

Kenneth Fisher - The "most recent sql handle" column

From the Forum - Filtered Indexes Issue

Statistics IO Parser

Meir Dudai - Experiences From the Field in Cloud Environment (recording)

Believe it or not, this is our 10th show!

This time, we're going freestyle. We talk about a wide variety of topics, spanning query tuning, good and bad defaults, Tempdb, Azure, important trace flags, Logon Triggers and much more..

We don't forget recent and upcoming events, and in addition, Guy shares his special birthday celebrations and raises an idea for a new reality show..

If you don't already know, we will record a live show on the next Israeli SQL Server user group meeting. We will have 3 mics: One for Guy, one for Matan and one that will travel between people in the audience. Click here to register!

 

Items mentioned in the show:

Next Israeli SQL Server User Group Meeting

Previous and Next Global Hebrew Virtual Chapter Meetings

Tribal Awards

Pini Krisher - Problems Working with SQL Azure

Thomas Kejser - Default Configuration of SQL Server

Guy Glantser - SQL Server Error Log Management

Tempdb Best Practices

On our 9th show, we host SQL Server MVP Geri Reshef.

Geri just came back from the MVP summit in Seattle, and he's here to tell us how it was, in addition to telling us about his way to becoming an MVP and the benefits of being one.

Geri also shares an unusual combination of T-SQL and the Hebrew calendar, his experience with SQL Server in Latin America and how blogging has helped him in his career.

Items mentioned in the show:

SQL Server on Wikipedia

Hierarchical and Recursive Queries in SQL Server on Wikipedia

Hebrew Calendar using T-SQL

Pass Nicaragua Facebook Group

24 Horas de Pass

After the conference season, we go back to the regular format of events, blogs, forum discussions and other goodies.

Here's some of the topics we cover:

Is index maintenance still necessary in 2013?

How to really monitor page splits?

"Smelly" code

What CXPacket really means and how can we leverage it

Past and future events

We also have a very interesting "top 10" list, and much more..

Links mentioned in the show:

Next Israeli SQL Server User Group meeting

Previous Israeli SQL Server User Group meeting

An index build takes a long time when a SQL Server database backup is running

Guy Glantser - Forty Things You Didn’t Know About SQL Server

The Data Loading Performance Guide

Ola Hallengren's Index and Statistics Maintenance Script

#FiveWordTechHorrors

Eitan Blumin - Service Broker Sample: Asynchronous Triggers

Matan Yungman - Using CXPacket Waits to Detect Query Bottlenecks

Michael J. Swart - Overly Complex Views, Procedures And Functions

Matan Yungman - Finding The Needle In The Haystack

Continuing our conference season summary from shows 6 and 7, this show is a special English edition that holds the interviews recorded on SQLRally Amsterdam with three of the biggest names in the industry: Brent Ozar (blog | twitter), Adam Machanic (blog | twitter) and Denny Cherry (blog | twitter).

The interviews cover quite a few topics. Among them are professional development, the future of DBA work, SQL Server 2014, storage, parallelism, virtualization and SQLCLR.

Update:

On August 2014, we started the English edition of SQL Server Radio. If you liked the interviews, check out the other shows we have there.

Items mentioned in the show:

Brent Ozar - Rock Stars, Normal People, and You

Brent Ozar - Why Index Fragmentation Doesn't Matter (Video)

Denny Cherry's Podcast - People Talking Tech

Adam Machanic - Next-Level Parallel Plan Forcing: An Alternative to 8649

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

Adam Machcnic - Data, Faster: Microsoft SQL Server Performance Techniques with SQLCLR

T-SQL Tuesday

This show is the second part of our conference season summary. As in part 1, We are with Maria Zakourdaev again, and this time we talk about the professional side of the conferences and share some of the exciting things we learned.

In addition, we have a very special and fun interview with Brent Ozar!

Items mentioned in the show:

Brent Ozar - Rock Stars, Normal People, and You

Brent Ozar - Why Index Fragmentation Doesn't Matter (Video)

Paul White - Iterators, Query Plans, and Why They Run Backwards

Paul White - Parallel Query Execution (Video)

Paul Randal - Index Fragmentation: Internals, Analysis, and Solutions (Video)

Kimberly Tripp - Skewed Data, Poor Cardinality Estimates, and Plans Gone Bad (Video)

David DeWitt - Hekaton: Why, What, and How (Video)

SQLSkills Extended Events Add-In

Michael Zilberstein - New DMV: yes… no… that’s complicated (look at the comments)

Thomas LaRock - SQL Someday (Video)