Tag Archives: 2008

SQL Server database file size

Keeping track of database size and growth is a critical part of a DBA’s job which I wrote about in an earlier blog post. But now I have improved my scripts that reveal the status of all my db files … Continue reading

Posted in Miscellany | Tagged , , , , , | Leave a comment

SQL Server copy_only backup and restore

Previously I wrote an article listing information on SQL Server backups. I want to expand a little on the practical use of the new and useful copy_only backup available in SQL Server 2005 and 2008. You can’t get to copy_only … Continue reading

Posted in Miscellany | Tagged , , , , | 1 Comment

Autocompletion and Intellisense in SQL Server

I understand you can use third party tools to add autocompletion and intellisense to Management Studio 2005 (for example, Redgate offers SQL Prompt Pro) but I haven’t tried it yet. I have installed SQL Server Express 2008 to play with.  … Continue reading

Posted in Miscellany | Tagged , , , | Leave a comment

American Political Lampoon

Of course this campaign is different this year: more substance than I would have believed possible although not as much as I could have hoped… but there’s always room for humour. Here are some links that tickled my fancy: The … Continue reading

Posted in Miscellany | Tagged , , , | Leave a comment