SQL Saturday: You can’t have it all.

SQL Saturday’s are awesome! Let’s get that clear up front. The organizers of SQL Saturday events are glorious individuals. Let’s...

Start with stupid

True story: I worked in a computer lab many years ago and one day this guy (a grad student) checked...

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

Tip: COLLATE for “Cannot resolve collation conflict” error

Some data professionals are VERY well versed with collation, and some never ever have to touch the concept. That second...

Using Configuration Files in SSIS

Now in SQL 2012 we have parameters that make it easy, but configuration files are still an option and I...

Wishing You a Very Happy Holi

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

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

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

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