Weekly Links – 05/04/2013

I’m starting a new tradition:
Before each weekend, I will post links to the best SQL Server stuff i’ve read, heard...

Ask the Expert Panel: NJ Special Event

Ever wanted to know all there is to know about SQL Server, and afraid to ask?  Have questions about how...

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...