In my SQL Server Recovery Models blog, I touched a bit on my experience with recovery using Tail Log Backup. In this post we will take an in-depth look at Tail Log Backup; what they are, why they should be in your toolbelt, and lastly line out the steps to successfully take a Tail Log […]
Great question! Before I answer this right off, ask yourself these questions: “Do I want to lose access to all other databases on the instance? What would happen if I lose the model my company demands for the specific way every new database must be created? Would anyone notice if I had to […]
The Procure SQL team is out and about in September, sharing their knowledge for free at SQL Saturdays as well as online webinars! We are very proud of our team and their efforts to share knowledge and experiences. Be sure to say hello and ask questions when you see them! GroupBy September 7, 2018 We […]
Time is money! Your boss keeps talking about RPO (Recovery Point Objective) and RTO (Recovery Time Objective). Do you just nod your head like you know what he/she is talking about? Maybe that scenario just happened and you are searching the internet for what these terms mean. If so, welcome! No one likes […]
Corruption. We know it is everywhere. It is surely a hot-button issue in the news. If you have not given much thought to database integrity, now is the time to sit up and pay attention. Corruption can occur at any time. Most of the time database corruption is caused by a hardware issue. No matter […]
Full disclosure time: Bulk Logged Recovery Model is quite confusing to me. And as it seems, to many others. I wrote a bit about it in SQL Server Recovery Models and decided that it was so complex, I really wanted to learn more and to explore what works and what doesn’t. Let’s take […]
Recently I have heard a lot of people discussing SQL Server System Databases. The topic of system databases seems to be a deceptively basic one. But how many people truly take the time to understand what system databases are and what purpose they serve? Come along with me and let’s explore system databases. What are […]
We are back this year! Not only are we sponsoring SQL Saturday Houston, we are also speaking! All three of us are presenting! Go here to see the full schedule. What is SQL Saturday? SQL Saturday is a free training event for Microsoft Data Platform professionals and those wanting to learn about SQL Server, Business […]
I had the distinct honor of helping John Sterrett (t/b) and Dolph Santorine (t) organize and run SQL Saturday #717 in Wheeling, West Virginia on April 28, 2018. It was a chance meeting at the event that drove home to me why we invest so much of our personal time and effort into organizing/running/presenting at […]
You have your SQL Server Backup Plan and your Database Recovery Model set. How do you know if your Backups are good? TEST! Validating SQL Server Backups will ensure that you are in a good place when it is time to bring your database back from the dead! Don’t assume that your Backups are solid […]