SQL Server Diaries

This week we implemented a database onto a production environment.  The implementation had been tested a number of times to prepare and verify the final set of scripts.  On D-Day we started the implementation according to the previously tested steps and I’m proud to say that all went fine.  We... [Read More]

We were recently applying a number of changes on a test environment and which were due for implementation on the production database once testing was verified. What one of the testers failed to notice was that one of the applications was connecting to the production database instead. Luckily no harm... [Read More]

In an earlier post I explained a number of migration or upgrade issues arising from the usage of SELECT TOP 100 PERCENT…ORDER BY… constructs when used in a VIEW. I wrote the below script to identify the VIEW objects which are implemented in this way and also identify from which... [Read More]

When it comes to testing queries I noticed that most developers usually write the query, verify that it returns the required result set then deploy it in the application or report and move on to the next query. While some might see this as one of the rapid development techniques,... [Read More]

For a while now, business have been more aware of the importance of protecting their data, at least from unwanted changes or deletions.  I will not go into the specifics of which method to use, whether to comply with an international standard or not, or even whether to use in-house... [Read More]