Good article. You did a good job of describing how to add distribution databases, which is something that I had never considered before.

However, I am curious about the factors behind...

Good article. I am curious about how restoring a backup that includes the filestream on to a dev server might work. Suppose filestream was enabled on the dev server, and...

One further note - for the step type T-SQL the step is actually executed under the context of the owner. You can test this out easily enough by creating a...

You are making an incorrect assumption. You are correct that the job runs under a different context than the owner of the job. What you are failing to realize is...

The QOD on March 16th was kind of related to this:

http://www.sqlservercentral.com/questions/PBM/69340/

The key, in my mind to understanding how SQL Server "figures it out" is that everything is backed...

It doesn't matter that much because they would be the owner o the job, and could not do anything inside the job for which they do not have permissions. The...

In my environment I allow auto update stats to do the updating of statistics for the most part. However, there are certain situations where procedures actually update statistics in the...

All the data you need is in msdb, in the following tables for the most part:

msdb.dbo.sysmail_server

msdb.dbo.sysmail_account

msdb.dbo.sysmail_configuration

msdb.dbo.sysmail_principalprofile

msdb.dbo.sysmail_profile

msdb.dbo.sysmail_profileaccount

Based on the values in those tables you would want to create a script that...

Right click SQL Server Agent in SSMS for properties and click on Alert System. At the top there is Mail system and Mail profile. Toggle the profile to the one...

This was unexpected behavior. I had no idea that web pages could be tabbed in SSMS.

What information do you really want about the transaction? You can get the session_id by correlating your query with sys.dm_tran_session_transactions. From there you can get information about the session from...

The 3 million rows is likely not the most important factor. If you look at the execution plan of the request that is timing out you might find that it...

Good article 🙂

I used recursion in in 2000 and CTE in 2005, and always had the thought that while my solution seemed clever, the aftermath of dealing with it was...

It was a trick question. Because of the way it was asked I didn't perceive the possibility of multiple check boxes. I did select submitter, and if the question went...

A job can be run on any schedule you define. However, I am unclear what you want to do with the output. In any case, you probably want to write...