Instance Wide Wait Stats

Over the last many weeks we have written quite a few blog post about query debugging, using Extended Events, Blocking...

SQL Azure Saturday, WIT NYC and other local events!

Good day!  Just wanted to share some exciting upcoming local events in the NYC/NJ area.
Hosted by the NJ SQL User...

SQL server failed to start the system cannot find the path specified

AdvertisementsRecently one of our SQL server unable to start it. The problem with the storage LUNs.
 

 
Things you have to do:...

Quick Reference: How Do I Read an Excel XSLM (Macro-Enabled) File in SSIS?

Excel 2010 (and presumably the next version of Excel) have taken some security precautions with regards to macros in Excel...

The Kimball Approach

The Kimball Approach
There are a lot of misconceptions about dimensional modeling and the Kimball approach to building a DW/BI system....

Calling Function / UDF using linked server

If one needs to call a UDF or System function ( ex: Serverproperty, Getdate(), etc ) on a remote server, then one...

Why shrink sql server data file failed?

Today I need to shrink a big data file, I know shrink file is not a best practise, and it...

Clean SQL Server Cache

           I lives alone, usually, I clean my small apartment at every weekend, wipe the table/firniture with cloth, clean the capet...

Designing Database Solutions for Microsoft SQL Server 2012 Beta exam (70-465 / 71-465) – My Thoughts

After sitting the Administering Microsoft SQL Server 2012 Databases Beta exam (71-462) on Monday, I was still a little disappointed...

Certification Exams: From the Other Side

Today I took the 70-464 beta exam today "Developing Microsoft SQL Server 2012 Databases" and after spending the last few...