Tag Archives: sql server

Common SQL Server Mistakes

This presentation is designed to cover some of the basic mistakes that I find people making quite often when working with SQL Server. It is a mix of development and administrative items, designed to help beginners get a grounding in … Continue reading

Posted in Presentations | Tagged , , | Comments Off on Common SQL Server Mistakes

SLA Contracts

One of the things that is important for developing a high availability or disaster recovery is knowing what commitments you need to honor for your clients. After all, if you don’t know how quickly you need to be back up, … Continue reading

Posted in Editorial | Tagged | Comments Off on SLA Contracts

You Can’t Disable the CLR in SQL Server – MCM Prep

At least not completely. There are some functions in SQL Server that are built on the SQL CLR, and even if you have disabled the CLR for user written code, it still loads app domains and functions for system code. … Continue reading

Posted in Blog | Tagged , , | Comments Off on You Can’t Disable the CLR in SQL Server – MCM Prep

Backups after a DR Restore – MCM

If you have a disaster, and you need to restore to some point in time prior to the last log backup you have, what’s the first thing you should do at this point in time? Make a full backup, of … Continue reading

Posted in Blog | Tagged , , , | Comments Off on Backups after a DR Restore – MCM