Don't Alienate Your Customer

This should go without saying, because most of us have been on the receiving end of poor customer support. However,...

Time Based Power Settings

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

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

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

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

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

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

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

Failing to Overreach

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

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