Transparent data encryption is the built-in method for at-rest data encryption in SQL Server. Taking steps towards security has always been important, but it is becoming even more important every day as there is a looming cyber threat industry hungry for easy high-profit data. We should also remember that not all threats are from the … Read more
People are always saying things about the importance of data, like how it is the lifeblood of a business. It sounds cliché, but there’s a lot of truth to that. You and I can’t survive without any blood, and there’s a good chance your business wouldn’t exist for long if they suddenly lost all their … Read more
There are many ways to setup High Availability and Disaster Recovery, most of which are focused on SQL Server Enterprise edition. However, the licensing for Enterprise edition gets costly fast. One less talked about approach to building a cost-effective HA/DR solution is building a failover cluster instance using SQL Server Standard with SIOS Datakeeper. SQL … Read more
Availability groups, Failover Clusters, Log Shipping, and more. These are tools we use to ensure that the data is highly available and disaster recoverable. This post will be the general walkthrough for how to determine what may be going wrong with your HA/DR solution, as well as some general tips and tricks from what we … Read more
The best EMTs and Medics are the ones who realize, “This isn’t my emergency,” early enough. You’ll be a better DBA or technologist the quicker you learn the freedom that comes from that line of thought. (Also, a warning – in this post, I talk about – in vague terms and no medical specificity about … Read more
Thanks for coming to my PASS Summit session this year (or watching it) on HA/DR concepts. Come back here on Monday next week for updates based on questions asked during the session or any notes on tangents I went off on because of the talk. I’ll put links here I reference in the presentation/Q&A after … Read more
I was having a twitter interaction the other day. Since High Availability and Disaster Recovery topics are on my mind as I just wrapped up delivering an online class on SQL Server HA/DR last week and am preparing for my next free webinar series talking about HA/DR, that twitter thread piqued my interest. The short … Read more