This post is regarding an issue I found while working with SSIS 2005/2008 fuzzy lookup using 32 bit runtime on a 64 bit instance.Recently I was using fuzzy lookup in SSIS package data flow as a part of my requirement in…
Shred data as well as metadata from XML document
Quite often I’ve come across requirements where we’ve the data coming in XML nodes and requiring us to create a table using them. The below code gives us a method to shred the data from XML document. The code shreds…
DENSE RANK simulation in DAX
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…
Creating server independent day comparison logic in Transact SQL
There are quite a few occasions where we require writing logic based on day comparisons from a date value. Some of the common scenarios include Counting days elapsed between two dates excluding weekends Getting the Thursday (or any other day) of…
Retrieve the filtered indexes on a db
Filtered indexes were introduced from SQL Server 2008 . Its a special type of Non Clustered index with a filter applied. This comes particularly handy in cases where we’e interested in only some subsets of data more frequently in a…
Floating point formats in SQL Server
The impetus for this post is a recent discussion we had in one of the forums with my fellow MVP friend.To start off, run the below query in management studio editor and check the output SELECT ‘2d5’ + 2e6 +…
Getting database set options in SQL 2012
sp_dboption used to be a very useful system procedure available till SQL 2008 R2 which helps us to identify the set options for database as well as modiying already set option values. I’ve used it numerous times for setting options for…