Rodney Landrum Presenting at oPASS on March 20, 2014

Almost time for another meeting! This month Rodney Landrum is presenting Data Analytics and the DBA – Using PowerView to Uncover...

Speaking In Madison At #sqlSatMadison

In just under 2 weeks I’ll be speaking at my first SQL Saturday of 2014. On Saturday, March 29th, I’m...

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