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