I was doing some adhoc data importing from Excel to SQL server for some analysis and I encountered a strange issue. The excel was not returning data for some of the fields correctly. The excel data looks like below (for simplicity I’ve…
DQS Knowledge Discovery Project – Issues with geometric datatypes
Recently I was working on a data cleansing project using Microsoft Data Quality Services (DQS) in SQL 2012 and was trying to create a Knowledge discovery project by setting up a domain from a SQLServer table. The domain was created…
Delimited String Split – XML Parsing Method
I’d blogged previously on a string splitting function which splits up CSV onto individual valueshttp://visakhm.blogspot.in/2010/02/parsing-delimited-string.htmlThe same scenario can be handled by means of XML functions too. This blog provides a method of splitting up of delimited string into its component…
Calculating factorial in T-SQL
Couple of days before I got a question on one of the forums asking for user defined function to calculate factorial of a number. I came up with the below function for calculating factorial and thought I would share it…
Got renewed for 4th time
Got official mail regarding my renewal fourth time in a row as MVP. Nice way to start the new year. Thanks for all who have been supporting and encouraging me in all my endeavours.May this new year bring all goodness…
Selective File Archiving using SSIS
File Archiving is one of the major maintenance tasks in every database. There are numerous occasions where data transfer happens in the form of files (xls,csv etc) so there has to be an efficient archiving mechanism as a part of…
Different ways to implement date range comparison logic in Transact SQL
There are multiple ways of implementing date range comparisons in Transact SQL. The purpose of this post is to explain one of the efficient ways by which we can implement date range comparison. The impetus for this post was the…
Implementing dynamic secure FTP process using SSIS
This blog post explains one of the approaches for automating file export/import between a remote secure FTP site and local folder. This is one of the common scenarios which we come across when data transfer has to be take place…
Data Taps in SSIS 2012
Data Taps is one of coolest features introduced in SSIS 2012. They give us the ability to debug the SSIS packages at runtime from command line using T-SQL. I’ve written a blog on it explaining the step by step way…
Keeping On Premise and Cloud Databases Synchronised
There were few scenarios in which we had part of our data being published to Cloud DB (Microsoft Azure DB) for external access. One of the main requirements was to keep both databases synchronized There are couple of ways by which you can…