12 Days of Christmas 2013 Day 2

This is the second installment in the 12 day series for SQL tidbits during this holiday season. Previous articles in this mini-series on quick tidbits: SQL Sat LV announcement...

12 Days of Christmas 2013 Day 2

This is the second installment in the 12 day series for SQL tidbits during this holiday season.
Previous articles in this...

Powershell Backups and Post Frequency Change

It's been a good run doing a post every day. I'm scaling it back a bit. I liked getting these...

12 Days of Christmas 2013 Day 1

Last year I did a mini-series themed around the 12 Days of Christmas.  I am going to do a similar series this year.  Over the next 12 days, I...

12 Days of Christmas 2013 Day 1

Last year I did a mini-series themed around the 12 Days of Christmas.  I am going to do a similar...

Christmas Day Winner and RDC Clients: Day 13

Finally we'll see who won the final training prize! The winner is Komal! Merry Christmas and Happy Holidays to everyone! The free...

Question of the Week -25/12/2013- Question1

Suppose we have a table says tbl_students whose structure is given below:-

Create table tbl_students(Studentid int identity(1,1) , Studentname nvarchar(150))

Suppose it contains...

Ranking Functions in SQL Server

Ranking Function:- Sometimes we need to provide a Row number to the rows in a table or within a partition....

MDX Implementing Logical AND On Members of the Same Hierarchy

Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In my prior blog post, I discussed implementing logical OR in MDX on members of...

MDX Implementing Logical AND On Members of the Same Hierarchy

Reference: MDX with Microsoft SQL Server 2008 R2 Analysis Services Cookbook by Tomislav Piasevoli In my prior blog post, I discussed implementing logical OR in MDX on members of...