Sunday, April 6, 2014

Sri Lanka crowned T20 champs - 2014

›
We did it again! Thanks Sanga, Mahela and the team, proud to be a Sri Lankan.

Reasons for adding a surrogate key for dimension tables

›
As a best practice, we always add a new key, known as a surrogate key to dimension tables for identifying the records uniquely. However, gen...
Saturday, April 5, 2014

Free eBook: Introducing Microsoft SQL Server 2014

›
Want to know some major features added to SQL Server 2014? Here is an easy way. This book explains how SQL Server 2014 leverages in-memory...
Wednesday, April 2, 2014

Easy way of adding your Microsoft Certification to LinkedIn Profile

›
If you are maintaining your profile with world largest professional network (Im sure that you are) and you have done a Microsoft Certificati...

SQL Server exams update: SQL Server 2012 and 2014

›
Are you planning to do Microsoft SQL Server certifications in next few weeks? If so, here is an announcement on exams updates. All MCSE rela...
Tuesday, April 1, 2014

Data Warehouse does not need a large number of non-clustered indexes?

›
It is a fact that non-clustered indexes improve the performance of data retrieval and we tend to add them mostly based on predicates used. A...
Sunday, March 30, 2014

Magic Quadrant for Business Intelligence and Analytics Platforms – 2014 February

›
Gartner has published its Magic Quadrant for Business Intelligence and Analytics platforms covering 17 capabilities grouping them into 3 ca...
Thursday, March 20, 2014

Door-Quiz – SQL Server Sri Lanka User Group Meet-up

›
We had another Door-Quiz at SS SLUG yesterday and as usual, the question asked was tricky. However, many had circled the correct answer and ...
Thursday, March 13, 2014

Who invented dimensional modeling?

›
Who introduced or invented Dimensional Modeling? Was it invented by Ralph Kimball ? Since he completely aligns with Dimensional Modeling in ...

Why SQL Server does not drop the procedure and recreate the object when the code is written properly?

›
This is bit funny, it took few minutes to figure out the reason for getting “ There is already an object named '' in the database. ”...
Sunday, March 9, 2014

Cumulative update package 11 for SQL Server 2008 R2 Service Pack 2

›
Cumulative update #11 is available for SQL Server 2008 R2 SP2. Refer the following link for downloading it and understanding the fixes done....
Thursday, February 27, 2014

SQL Server: Calculating running totals using T-SQL

›
This is not a new topic. If you search, you will surely find many posts on this, mostly with traditional techniques but not using newest cap...
5 comments:
Wednesday, February 26, 2014

Analysis Services (SSAS): Calculating running totals for a given period using MDX

›
Calculating running totals against a numeric is not an easy task with both relational databases using T-SQL and multidimensional databases u...
6 comments:
Sunday, February 23, 2014

SQL Server Management Studio: Exploring General Options for T-SQL – Part I

›
SQL Server Management Studio is an integrated management, development and querying application that we use for working with SQL Server insta...
Friday, February 21, 2014

SQL Server 2012: Getting Previous and Next values using Offset functions

›
How can we access other rows in a set while accessing one particular row? In other words, can we access values in other rows other than curr...
Monday, February 17, 2014

UNION ALL is possible. How about INTERSECT ALL and EXCEPT ALL?

›
Not expecting duplicates but a significant improvement in performance, we tend to use UNION ALL when no duplicates are guaranteed in combini...