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:

Show 11 – Live Show

Play

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: