Next Gen File System ReFS(Resilient File System) and SQLServer !

“ReFS”, this term was absolutely new to me when I was reading this white paper from Microsoft ‘Storage Windows Server...

Plan cache bloat by SQLAgent (Prior to SQL2008) !

Recently I was checking the plan cache utilization with the help of the below query which I normally use for...

PASS Summit 2012 News – Check- in Experience!

Registration and Check in for PASS Summit 2012 was opened yesterday (Nov 4th), and I decided to utilize this opportunity...

PASS Summit 2012 Countdown Begins !!!

All roads lead to Seattle!

If you are a SQLServer professional, then you don’t want to miss this event.
Over 190 technical...

Tale of detaching a database which was enabled for replication!

In development environments I prefer to use ‘detach’ database option to move around databases. It’s simple, fast and easy.

Almost all...

Backing up the “log” of a database which is in Simple recovery model ! – Watch out for this!

In theory we cannot backup the log of a database which is in Simple recovery model, however there is a...

Cannot assign a default value to a local variable !

You will hit this error Cannot assign a default value to a local variable in case you are running SQL 2005/below,and you try...

Max Text Replication Size – When you might have to care about this number !

One of the advanced Server level options for SQL Server is Max Text Replication Size and this is really not a common...

You don’t want to miss this out,Serious SQLServer training – 24 Hours of PASS event !

Back to back quality SQLServer sessions! Yes, you heard it right and that’s what 24 Hours of PASS is all...

Installing SQLServer for SCCM 2012 – Some points to note on patch levels

The prerequisite SQLServer 2008 R2 patch level for System Center Config Manager 2012(SCCM) is SP1 with Cumulative Update 6 (CU)

 
 
 
 
For...