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