Category Archives: SQL Server

SQLPASS @ Microsoft NL: Migrating and consolidating SQL Server

On Tuesday 3 November I organized an evening session for SQLPASS at Microsoft the Netherlands. Me and 2 other speakers (Marcel Fernee and Menzo Steinhorst) presented various topics on migrating the SQL Server components like Database Engine, SSRS, SSAS You can download the presentations (in English) on the SQL PASS Netherlands site at

SQLSaturday Holland. Moving to Extended Events

On the 26th of September I had a session on SQL Saturday Holland on Extended events. This is a session for beginners explaining architecture, GUI and also the SSMS 2008 Addin (on codeplex) for Extended events. Link to presentation Link to demo’s Extended events manager Downloads for the other SQLSaturday sessions can […]

Performance analysis: different ways to investigate the query plan cache

When monitoring your SQL instance for performance the most convenient way to start is by analyzing the query plan cache using DMV’s. The plan cache contains all query plans used on the instance since the last restart. A key benefit of using this method is that an explicit trace (using SQL Profiler or preferably Extended […]

Start thinking about data archiving early

Dealing with data growth is a big challenge for DBA’s and sysadmins. The main problems to deal with areĀ  storage capacity (server storage is not cheap!), backups / index maintenance windows and query performance. Implementing data retention helps dealing with these issues and I often make a checklist: What kind of data are we dealing […]

Troubleshoot login errors with SQL Server login failed states

Whenever you receive a Login failed error from a SQL instance your faced with the problemĀ  of context. In the SQL Server log you can find a more detailed description. You should see the client generating the error and the state. The table below helps to find the cause of the failed login attempt. Error […]

Checking the progress of a backup or restore

With SQL Server’s powerful DMV’s it’s easy to monitor the progress of a SQL Backup or restore operation, but you can also use it to see the current running queries on your SQL instance. In this case you should delete the last WHERE command in the query. Note that the percent_complete column is not updated […]