Blogs

5 Ways to Make SQL Server Backups

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 …

Continue reading

5 Types of 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 …

Continue reading

How Do You Find Good SQL Server Training Resources?

 Teacher-Mentor-pexels-christina-morillo-1181398 What process can you use to find SQL Server training resources that will be valuable? After all, not everything on the internet can or should be trusted. If you want training on something in this …

Continue reading

Azure SQL Boot Camp Day 3 Takeaways

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 …

Continue reading

Azure SQL Boot Camp Day 2 Key Takeaways

Hello dear reader. This is the second of a four part series on a recent online event hosted by Microsoft on their Microsoft Developer page over on YouTube. From August 17th to August 20th Ann Hoffman and Bob Ward hosted a live boot camp for Azure …

Continue reading

Azure SQL Boot Camp Day 1 Key Takeaways

Recently Microsoft hosted an Azure SQL Boot Camp over on the Microsoft Developer page on YouTube. The boot camp consisted of four days of two hour sessions describing the different features of Azure SQL. The hosts were Anna Hoffman and Bob Ward. This …

Continue reading

What Is the Value of Mentoring?

There aren’t many formal mentoring relationships these days. It seems to be rare when two people enter into an arrangement where one person agrees to give of their time energy and resources to answer questions and assist another person. Oh sure, you …

Continue reading

Lessons Learned Updating to SQL Server 2017 AlwaysOn Availability Groups

In late 2019, a project that had been in progress for well over a year finally came to a conclusion. I had collaborated with a number of people to migrate a stand alone SQL Server 2008 and two stand alone SQL Server 2008 R2 instances. Each stand …

Continue reading

Querying An AS400 Using SQL Server 2019 Data Virtualization

For those who have taken an interest in the latest SQL Server release, SQL Server 2019, you may have noticed a new feature called Data Virtualization. Perhaps you’ve seen a presentation about it, or maybe you’ve read about it in Bob Ward’s book …

Continue reading

SQL Server Install Guide Part 3

I’m in part 3 of a series on installing SQL Server. In the previous post I began discussing steps to take after the install is complete. Because there are quite a number of things to consider post-install, this part 3 will continue discussing the …

Continue reading