As data professionals responsible for SQL Server, it is drilled into our heads that we need to take backups. But, how do we know we actually have backups available to us when we need them? How can we verify that a backup has been taken? Some types of auditing that an employer has to … Continue reading 3 ways to verify that a backup has taken place
You’ve just been hired into a DBA role at a new company, or you’ve been given the DBA keys at your current company. Maybe you’re a SysAdmin and your boss has informed you that you are now supposed to manage the SQL Servers as well as everything else on your plate. In any of … Continue reading Four Areas to Focus on When You Start A New DBA Role
So, I realize it’s now almost April of 2021 when I’m posting this. Normally this sort of post would come out in January for the previous year. However, I have a reason for this being late and I’ll actually post about that separately. Showing My Blog Some Love In mid-2020 I decided to give my … Continue reading Top 3 Most Popular Posts of 2020
Last time we discussed 5 backup types for SQL Server. Now I want to introduce you to five ways to make backups in SQL Server. I can’t possibly explore all the options available with each of these six methods. There is a lot to cover for even a “simple” topic like backups. Method 1: Using … Continue reading 5 Ways to Make SQL Server Backups
One of the foundational responsibilities of a DBA is making sure that backups are available. SQL Server has several foundational types of backups that can be made. Before I dive into that though, I want to ask a question that seems to have a fairly obvious answer. Why take backups? You want to be able … Continue reading 5 Types of SQL Server Backups
Hello reader! Here we are with the much anticipated post for day 3 of the recent Azure SQL Boot Camp. Here are the previous posts for days one and two . If you want to get started with Azure SQL, the boot camp is a great way to do it. You’ll get Azure experts like … Continue reading Azure SQL Boot Camp Day 3 Takeaways