Category Archives: Sql Server

Scripting SQL Server installations

January 10, 2014 11:48 pm / Leave a Comment /

Scripting SQL Server installations

I was addressing performance issues onsite just a couple of weeks ago. While waiting for the right authorizations, access tokens, and whatever you need nowadays just to run some scripts…, one of the developers approached me. They asked for some insights on how to Scripting SQL Server installations.

Read More →

SQL Database Integrity Reports

December 9, 2013 3:00 pm / Leave a Comment /

SQL Database Integrity Reports

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

Read More →