Tag Archives: SQL Server Administration

SQL Server Compressed Backup v1.2 Released

Posted on November 23, 2009 by Clay Lenhart

I’ve just released version 1.2-20091123 of SQL Server Compressed Backup. SQL Server Compressed Backup will back up a SQL Server database to a compressed file, using either gzip, zip and bzip2. The new features are: Continue reading →

Posted in MSSQL Compressed Backup | Tagged , | 129 Comments

Execution Plan of Frequent Queries

Posted on May 29, 2009 by Clay Lenhart

Bill Galashan, DBA of bet365 sent over the following query that lists the execution plan of the 10 most frequently executed queries. Continue reading →

Posted in SQL Server Administration | Tagged , , , , , | 28 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

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