Tag Archives: SQL Server Administration

SQL Server Compressed Backup v1.2 Released

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

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

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

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

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

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