In one of my recent data visualization projects I’ve had the need to generate the dense rank for a set of data after splitting them into horizontal groups. I’ve come up with the logic in DAX to find the dense rank…
Getting OS locale settings from SQL Server
Recently I had a requirement to identify the language settings of windows operating system from SQL Server. The purpose behind this was to resolve the format in which date values were send by a client program executing from the server. I came across…
Data Quality Services in SQL Server 2012
I’ve started a new series of posts through my group blog regarding Data Quality Services in SQL Server 2012. The first set of posts can be accessed from the below links http://blog.gnetgroup.com/bi/2012/08/30/configuring-microsoft-data-quality-services-to-generate-quality-source-data/ http://blog.gnetgroup.com/bi/2012/09/13/generating-high-quality-source-data-using-microsoft-data-quality-services-knowledge-base/ Configuring DQS to use cloud based domain (Azure…
Easy Package Execution monitoring in SSIS 2012
Previously I had blogged about new project deployment model available in SSIS 2012 in one of my groups blogs. This is a follow up post giving details on monitoring options for package execution in SSIS 2012.Till SQL 2012 we didn’t…