Author Archives: Clay Lenhart

About Clay Lenhart

I am a DBA/Technical Architect for Latitude Group and love technology.

Code Generator Built-in to VS 2008

Posted on October 18, 2008 by Clay Lenhart

Guess what, a code generator is built-in to Visual Studio 2008.

Posted in Visual Studio | Tagged , | 18 Comments

MSSQL Compressed Backup 1.0 Released

Posted on August 24, 2008 by Clay Lenhart

I’ve just released version 1.0 of MSSQL Compressed Backup.  This is a command line utility that allows you to backup or restore your SQL Server 2005 databases to/from compressed files such as zip, bzip2, or gzip. http://mssqlcompressed.sourceforge.net/

Posted in MSSQL Compressed Backup | Tagged , | 16 Comments

Renaming a SQL Server machine

Posted on August 8, 2008 by Clay Lenhart

Below are a collection of links on how to rename a SQL Server server. Rename the SQL Server engine. This describes how to run Rename SQL Server Reporting Services server. This describes how to update a config file with the … Continue reading →

Posted in SQL Server Administration | Tagged | Leave a comment

SQL Server 2005 Compressed Backup

Posted on June 14, 2008 by Clay Lenhart

I’ve been working on a way to backup a SQL Server 2005 database to a compressed file recently, but without using temporary files, so I wrote MSSQL Compressed Backup. Continue reading →

Posted in MSSQL Compressed Backup | Tagged , | 91 Comments

Influencing the Execution Plan

Posted on April 14, 2008 by Clay Lenhart

I had a performance problem recently with SQL Server. This post shows an easy relatively hands-off approach to influencing the execution plan. Continue reading →

Posted in SQL Server Development | Tagged , , | 10 Comments

Cached Execution Plans in SQL Server

Posted on April 13, 2008 by Clay Lenhart

This blog entry describes how you can get the SQL Server execution plan of any running statement and display the graphical representation in Enterprise Manager. Continue reading →

Posted in SQL Server Administration | Tagged , , , , , , | 37 Comments

SSAS Beginner’s Guide: Storage Structure

Posted on April 7, 2008 by Clay Lenhart

This is a second entry in a series on SQL Server Analysis Services (SSAS). To see the other blog entries on this tutorial, click on the SSAS Beginner’s Guide on the top bar. Relational Databases Let’s take a quick look … Continue reading →

Posted in SSAS | Tagged , | 21 Comments

SQL Server Analysis Services (SSAS) Series

Posted on April 1, 2008 by Clay Lenhart

I am going to use this blog to convince a friend to use SQL Server Analysis Services (SSAS) in his projects because it makes it easier to write reports on as compared to relational databases. Part of the challenge is … Continue reading →

Posted in SSAS | Tagged , | 27 Comments

Table Size Query

Posted on March 8, 2008 by Clay Lenhart

The following query lists the tables and the space they use. This query is much faster (sub-second) than a standard SELECT COUNT(*) query since it uses the dynamic management views in SQL Server rather than scanning your data. SELECT sum … Continue reading →

Posted in SQL Server Administration | Tagged , | 16 Comments

HierarchyID in SQL Server 2008

Posted on February 23, 2008 by Clay Lenhart

SQL Server 2008 includes a new HierarchyID datatype!

Posted in SQL Server Development | Tagged | 5 Comments