Show 21 – Noam Binyamini

Play

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

 

 

Show 20 – High Availability

Play

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.

 

Show 19 – Back to the Future

Play

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:

Show 18 – Mucho Balaganos

Play

On show 18, we talk a lot about the “Balagan” around the Pass Summit session selection process and around the last 24 Hours of Pass.

We also talk about certifications, Guy’s trips in Bnei-Brak, courses, what are number tables and why you need them, what we love about SQL Server, a strange problem with mirroring, and more..

Links mentioned in the show:

Show 17 – The Czech Locomotive

Play

On our 17th show, we have updated about two major issues discussed on the previous show – Guy’s running status and the post office.

We also talk about wait types, a new trace flag, memory estimates in SQL Server 2014, data loss bug, events, and much more..

Items mentioned in the show:

Show 16 – Shy Engelberg

Play

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.

 

Show 15 – Five Devices Per Person

Play

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

Play

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!

Play

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

Play

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: