Multi-monitor desktop layout

Why are people using side by side screen layout in windows when there exists a far superior layout...

Read »

Debugging TSQL Code on SQL Server 2008

SQL Server 2008 once again comes with a TSQL Debugger (which is really quite good). The only condition for using it is that the code is available in a non-encrypted form on the database...

Read »

One-on-One Meetings

When managing a team most managers organise team meetings, standups, demo meetings, retrospectives, but does your manager book some solid one on one time?

Read »

Query the content of a temp table from another connection in SQL Server

The SQL Server debugger is quite powerful, but it has the major flaw that you can't peek into a temp table when hitting a breakpoint. Until now...

Read »

Going beyond sp_help_index

The procedure sp_help_index is an important tool for the DBA, but it is lacking quite some information.

Read »

How to determine the default database path in all SQL Server Versions

There is no function available within SQL Server to determine the default database file path.

Read »

How to create SQL Server temp tables without collation problems

Creating temp tables on mixed collation servers can have some nasty surprises in store.

Read »

How to strip trailing zeros

Strip trailing spaces from a string in TSQL is a bit tricky

Read »

More articles...