Featured Article(s)
Attach all databases in a single sp execution
The following procedure called usp_AttachAllDBFromINI takes a database name and mdf files list that resides in an INI file. The procedure loops over the file and attaches all databases listed in it to the server.
Do You Have Your SQL Server Operators and Notification Set Up… Yet?
I am repeatedly surprised when people don’t have notifications and operators set up on SQL Server, but they do have a number of jobs and automatic processes running. If you’ve not yet set up these notifications, you should carefully consider them.
Essentially, these notifications will let you know when things go wrong (or right, if you decide to use them for that). You set up operators, which are targets of the notifications, then indicate when you’d like to have notifications go out to those operators. You can do this a couple of ways. First, you can have the system monitor for certain error conditions and notify if they occur.
Second, you can reference these operators for conditions that pertain to SQL jobs that run. You can have operators notified on success, failure and even just completion of a given step or job.
I bring all of this up because this is one of those tools that can bring a lot of leverage to your SQL Server installation. You can set up these notifications and you’ll likely find out about issues on the system before users have a chance to report them, all automatically.
Check it out – operators in books online will get you started.
In Tucson, AZ? We’re Considering a New SQL Server User Group
If you’re here in Tucson, or in an area where you’d be interested in coming to a Tucson-based SQL Server group meeting, please drop me a note and let me know. I’ll get you details and locations for the premier meeting in February. I’d love to hear from you!
Featured White Paper(s)
Uncovering a Hidden SQL Server Performance Killer
So youve checked all the likely suspects, but your SQL Server performance is still poor. Before you put that capital request… (read more)