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
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 post-install configuration items. Configure SQL Server Alerts One of the things … Continue reading SQL Server Install Guide Part 3
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 about after the install is complete. Recent versions of SQL Server will … Continue reading SQL Server Install Guide Part 2
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 installation best practices and how-to’s. This will be what I’ve arrived … Continue reading SQL Server Install Guide Part 1
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 some tuning. But, how do you know what queries are causing your issue? What’s causing those … Continue reading Correlating IO Wait with Queries
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 the scenario. The T-SQL below will create three operators with different … Continue reading Consolidate Multiple Email Operators
How would you go about finding jobs that have failed and why would you want to look for these? You might want to do this to ensure that you are being notified appropriately of job failures. For instance, after reviewing failed jobs, you may realize that there are job failures that no one knew about. … Continue reading Finding Failed Jobs
In the last post we found jobs that had no email notification. Once you find them, how do you fix this problem? I’m going to assume that database mail is already enabled and configured on the SQL Server instance. 1. Create an operator, assuming one does not exist. This can be done either through T-SQL … Continue reading Fixing Jobs With No Email Notification