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
Category: SQL Server
SQL Server 2008 Resources
Sometimes I just post a blog with a link so that I can go back and look at it later. This is one of those cases... hopefully others find this as useful as I hope I will. SQL Server 2008 Videos, Webcasts, Courses, Datasheets, and Downloads
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?
Divide By Zero
Often times I get to write calculations where the it is necessary to divide one value from another. Simple little math equations. But in many of these cases, the denominator has the chance to be valued at zero (0). And for these, I usually write my SQL statements similar to the following: A simple case … Continue reading Divide By Zero
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
Troubleshooting Performance Problems in SQL Server 2005
I was working through some performance issues on a "fun" table. A bit of half a billion rows and with some apparent I/O issues as the entire table is being read by some of the clients services to create an extract. In working through some of the performance bottlenecks, I found the following white paper … Continue reading Troubleshooting Performance Problems in SQL Server 2005
Default Trace
A quick link to a blog I read today on the default trace and determining what is in it. It's cool that we can get to all of this information in SS2005
IIF(IsEasier(Many-to-Many Dimensional Modeling) = TRUE, JOYFUL, CRY)
In a former life on a SQL Server 2000 project with I had the immense joy of building a few cubes in Analysis Services that took advantage of many-to-many relationships. At the start I was thrilled to be trying something new and by the end I was cross-eyed trying to keep all of the calculations … Continue reading IIF(IsEasier(Many-to-Many Dimensional Modeling) = TRUE, JOYFUL, CRY)
Strate SQL 