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

Pragmatic Works' Master SSIS Workshop coming to NYC

Pragmatically
speaking, there’s no way you can learn all there is to know about Microsoft’s
native ETL tool, SQL Server Integration Services...

Tomorrow: NYC Metro SQL Server User Group Presents Paul Randal and Kimberly Trip

Well, they're baack in the City!Coming this Thursday April 4, 2013 to the Big Apple, hosted by the NYC
Metro SQL...

Total Number Of Records In each Table

Quite often in our day today activity we need to check the count of records in each table of the...

Implicit Conversions and Avoiding Them With Computed Columns

I recently encountered an interesting performance issue (due to implicit conversions) that I was able to solve using a lesser known...