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

Quick tip: Using sp_server_diagnostics

In SQL Server 2012 a new procedure sp_server_diagnostics returns a payload of information about server health and performance. The sproc...

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