Recently, I was asked why e-mails would mysteriously not be sent from one of the servers that I help maintain. One of the greatest things about working with SQL Server is most everything that happens in the server is data and all I had to figure out is where the data was stored. In msdb … Continue reading Database Mail Failed Items Log
Tag: SQL Server 2005
Database Edition msdb Sample Database Projects
I've been working with Database Professional a little bit more these days. One of the databases that I've been working on for a while provides a number of diagnostic features that utilizes some msdb stored procedures. Fortunately, going forward I can stop ignoring the systax errors that occurs because of those cross-database references. The Visual … Continue reading Database Edition msdb Sample Database Projects
CLR_AUTO_EVENT Wait Stat
I've was reviewing wait stats the other day and kept finding this wait stat peaking out the other wait stats by a few hundred milliseconds. Oh my! Should I care or not... well long story short is that if all of the CLR assemblies are created in safe mode there is no problem. Or at … Continue reading CLR_AUTO_EVENT Wait Stat
Transfer Logins Between SQL Server 2005 Instances
I've never been a fan of the SQL Server 2005 Integration Services task for transferring logins between servers. It seems that I always misconfigure it or something gets missed. And when I just want to move a single login its more effort to setup the task than it is worth. What I'm really saying here … Continue reading Transfer Logins Between SQL Server 2005 Instances
Change the Server Collation of SQL Server 2005
A nice little change in SQL Server 2005 has been the ability to change the collation of the server. Back in the day, circa SQL 2000, changing collation and reinstalling SQL Server were pretty much the same thing. By pretty much, I mean the exact same thing. In SQL Server 2005 you can now do … Continue reading Change the Server Collation of SQL Server 2005
Restoring a Database with Symmetric Encryption
For those unfamiliar with encryption in SQL Server, this article is a nice introduction to symmetric encryption in SQL Server 2005. I've only used encryption a few times and it's definitely been the godsend that the article states. I referenced the article recently when I had to restore a database on a new server that … Continue reading Restoring a Database with Symmetric Encryption
Deadlock Resources
Deadlocks are a not so wonderful unnaturally occurring event that all DBAs will eventually have the pleasure to take a look at. Since deadlocks are time senisitive it is important that at the time of the deadlock the correct mechanisms are in place to capture the detail of the deadlock in the SQL Server error … Continue reading Deadlock Resources
Is This Cluster Good Enough?
Earlier this year, Microsoft released the Microsoft Cluster Configuration Validation Wizard. A handy dandy tool for analyzing the setup and configuration of clustered servers. And this is definitely a tool to keep in the toolbelt when building clusters, especially the ones that I like to build with SQL Server on top of them. And as … Continue reading Is This Cluster Good Enough?
Reporting Services Resources
I honestly could have sworn up and down the church aisle that I'd posted something in these a few months ago. Obviously, wires got crossed either in the real world or the nether of my mind. But long story short, here are a couple great resources to use when building reports using Reporting Services. SSW … Continue reading Reporting Services Resources
Identify Reporting Services Version and Edition
While trying to identify the reporting services edition installed on a server today, I found quite a few ways to identify both the edition and version of reporting services. And now they are listed below from various news group threads for your reading pleasure. The version of an installed reporting services service can be found … Continue reading Identify Reporting Services Version and Edition
Strate SQL 