Show 15 – Five Devices Per Person

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:

Show 14 – Simplification

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:

Show 13 – SQL Server 2014!

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.




Show 12 – Ctrl C

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:

Show 11 – Live Show

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:

Show 10 – A DBA is Born

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:

Show 9 – Geri Reshef

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:


Show 8 – Works Great with NOLOCK

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:

Show 7.5 – SQLRally Interviews

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.


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:

Show 7 – Conference Season (Part 2)

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: