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 …
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 …
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 …
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 …
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 …
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 …
In part 1 of this series, I discussed pre-installation steps. There are many guides available online for the actual installation process so I’m not going to give a step by step installation guide here. Rather, I’m going to focus on what to think …
In part 1 of a series on installing SQL Server, I’m going to discuss things to do prior to running the installation program for SQL Server. There are a number of install guides for SQL Server on the internet and plenty of recommendations around …
Have you ever looked at sys.dm_os_virtual_file_stats and saw horrible latency for your database files? Generally speaking, you want to see latency below 20 ms on your database files. much above that and there are some problems somewhere that need …
Suppose you’ve been working on cleaning up SQL Agent jobs and their email operators and find that you have more than one operator with the same email address. How would you tidy this up to ease administration? Let’s do a little setup to demonstrate …