Blogs

SQL Server Install Guide Part 2

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 …

Continue reading

SQL Server Install Guide Part 1

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 …

Continue reading

Correlating IO Wait with Queries

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 …

Continue reading

Consolidate Multiple Email Operators

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 …

Continue reading

Finding Failed Jobs

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 …

Continue reading

Fixing Jobs With No Email Notification

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 …

Continue reading

Finding Jobs With No Email Notifications

When you take over a new SQL Server instance one of the things you might consider doing early on is finding SQL Agent jobs that have no email notification set up. These will be jobs that could fail and they will never alert anyone. I am of the …

Continue reading

Steps to Catch Up Log Shipping Secondary

 If you are using Log Shipping, there have probably been times that you have discovered that the Log Shipping Secondary is not up to date. Perhaps you found out by right clicking on your SQL Server instance and running the performance dashboard …

Continue reading

Three Reasons to Use a Custom Database Role

Ever had a situation where a small in-house application written for a small group of employees needed some permissions in the database? How do you handle that? I want to walk through the scenario and provide three reasons that using a Database Role …

Continue reading

Retiring sp_who and sp_who2

 Sp_who and sp_who2 have been some very popular T-SQL commands. What if I told you that you could get more and better information from DMVs that have been around since SQL Server 2005? With the advent of SQL Server 2005 came along new objects called …

Continue reading