This is likely the last in a series of three posts about backups and restores. My aim with this series has been to give you an idea of the options available and a basic start on using those options. I’m not trying to go in-depth on the subject of backups and restores. Today will be … Continue reading 3 Ways to Restore SQL Server Databases
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
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 constantly changing world of technology, how do you locate that training? How do you find information that is … Continue reading How Do You Find Good SQL Server Training Resources?
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
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 SQL. This post provides you with key takeaways from … Continue reading Azure SQL Boot Camp Day 2 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 will be the first of a four part series offering you key … Continue reading Azure SQL Boot Camp Day 1 Key Takeaways
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 do it casually when you give an assignment to someone and say, “Let … Continue reading What Is the Value of Mentoring?
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 alone SQL Server was migrated to a three … Continue reading Lessons Learned Updating to SQL Server 2017 AlwaysOn Availability Groups
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 entitled “SQL Server 2019 Revealed.” I myself was curious about this … Continue reading Querying An AS400 Using SQL Server 2019 Data Virtualization