Category Archives: Sql Server


SSMS color code your environments

SQL Server SP_what

Ever executed a script on the wrong environment? Neither do I… but for those who do need a visual queue as to which server you are on, I’ve included some helpful steps below:

Read More →

Group Server Queries: ad hoc management

Group Server Queries: ad hoc management

Recently, I worked on a project which involved auditing a dozen of SQL server instances. A process I usually script upfront however, due to constraints on my time and some local challenges (a very “opinionated” customer) wasn’t able to do so. Fortunately I discovered this somewhat unknown “Group Server Queries” option a while ago, so gave it a try and was pleasantly surprised.

Read More →

SQL Server – Default to simple recovery model

SQL Server - Default to simple recovery model

SQL server’s recovery model is crucial for designing a backup and restore strategy. However, it can be a bit of a management chore when dealing with Development server.

If you don’t want to be bothered to look at databases where the log file is 100 times larger than the data files then the following might come in handy:

Read More →

SQL Database Integrity Reports

SQL Database Integrity Reports

Validating database integrity on a regular basis is a fundamental task that is often forgotten by the accidental DBA. Fortunately SQL Server database corruption issues aren’t very common, however finding out that you have been backing up a corrupt database for weeks might be somewhat hard to explain to the business.

Read More →

Tridion DB – Poor performance after upgrade

Tridion DB

Probably one of the most common issues customers run into after completing the upgrade is performance degradation. This post covers how you can identify and solve SQL Server related issues after upgrading to a newer version.

Read More →

sp_what: Seek and ye shall find

SQL Server SP_what

On-site performance tuning analysis can be as rewarding as it is frustrating. There are some aspects you just can’t control; Ranting managers or dealing with a passive DBA, which often stands behind you with popcorn and drinks. Fortunately, you can prepare your scripts in advance based as i did based on prior leanings.

Read More →