How I prepared myself for the MCSE certification

Last week I took the final exam to acquire the MCSE – Business Intelligence certification. This blog post describes my preparation...

Is BETWEEN faster than GTE and LTE?

I know I have been light on blog posting this year. They always say that life tends to get in...

SQL Server Events in the UK – April 2013

The bank holiday and work have put me a few days behind schedule, but here is the list out all of the...

The PUBLIC role – Do not use it for database access!

As per Microsoft Books Online and SQL Server Security best practice white paper, it is recommended to periodically review privileges...

Time Based Power Settings

Just recently I was part of an online presentation in which the intended audience was unable to install any of...

Windows Azure SQL Database Backups

You can get backups of your WASD databases. But, if you want them to be transactionally consistent, you need to...

Compression Backup with BUFFERCOUNT parameter

If you want to make you backup faster, you can try BUFFERCOUNT parameter with compression backup.

From Book Online description:
BUFFERCOUNT = { buffercount | @buffercount_variable...

DMV-4 : Find top most expensive cached queries ?……..sys.dm_exec_query_stats

sys.dm_exec_query_stats DMV (Dynamic Management View), described in BOL as follows : http://msdn.microsoft.com/en-us/library/ms189741.aspx
Returns aggregate performance statistics for cached query plans. The view...

Failing to Overreach

I’m not sure what put this phrase in my head, though I think in part it came from various posts...

How do I move a SQL login from one server to another without the password?

This is an uncommon task but one that does turn up every once in awhile. A SQL login has to...