Wishing You a Very Happy Holi

Steps for Windows Cluster Installation on Windows Server 2008

Here, You have steps with screenshot to install 2 Nodes windows cluster on Windows Server 2008.
Step 1: Validate Cluster Configuration
a)...

A Tale of Two SQL Server Webcasts

Things have been quiet on my blog of late (hosting issue) but now things are back online. Talking of online,...

My Favorite Free Scripts

SQL Server Maintenance Solution
I'll start off with Ola Hallengren's scripts. I'm not a fan of reinventing the wheel. If someone...

Verify a success of database backups

One of the most important tasks on a DBA’s to-do list is backing up databases on a regular basis. This...

Happy Holi

Holi is the time to unwind de-stress and bond with sweets,Thandai and colours.Come let’s rejuvenate by immersing ourselves in the...

When Good BI Goes Bad – Data Quality

Regardless of the Technology BI is about Data
Many BI projects are sold as a technology solution.  Vendors come in a...

PASS SQLSaturday Events: April 2014

PASS SQL Saturday is a training event for SQL Server professionals and those wanting to learn about SQL Server. Please...

Ten Years and Counting …

On March 8, 2014, I reached ten years of service at Magenic Technologies. When I started in 1999 (don’t do...

Uniquifiers: all rows or the duplicate keys only?

Some days ago I was talking with my friend Davide Mauri about the uniquifier that SQL Server adds to clustered...