Ever encountered the above error when starting SQL server management studio and connecting to SSAS ? The error has a few different root causes one of which is […]
Mary Series 3: Using SSIS to extract terms
All characters, events and data in this series are fictional. Any resemblance to any person living or dead is simply probability at work (More on that in the […]
Part 3 of 4: Video on Difference between partitioning and just multiple FGs
Sorry it took so long but here is the third video in our 4 part series on MS SQL Server partitioning. http://www.youtube.com/watch?v=GSNYGpNbidc I cover the difference between simple […]
Mary connects her Excel sheet to SQL and start using pivots to view her data
All characters, events and data in this series are fictional. Any resemblance to any person living or dead is simply probability at work (More on that in the […]
At long last Pagination
MS SQL Server 2012 introduced a very nice feature for developers with the PAGINATION OFFSET Syntax. It has always been a challenge to work with pagination in MS […]
CHOOSE, Is MS really giving a choice?
In this blog we are going to talk about a little known T-SQL Command called CHOOSE. As its name suggests it allows some kind of selection to be […]
Working with FORMAT
For a developer working on MS SQL server the correct formatting of data has always been a challenge. In India when working with dates we follow the dd/mm/yy […]
Video on MS SQL Server Partitioning
As promised here is a short video to start of the series on SQL Server partitioning. The video covers the difference between simply placing files in Filegroups with […]
MS SQL Performance tuning: – Partitioning explained
Today I am going to do a quick one hour session explaining partitioning. We will cover the difference between partitioning and placing tables in Filegroups, How to implement […]