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…
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…
Extended analytic and window functions in SQL 2012
This post explains couple of scenarios where new analytic and aggregation windowing functions of sql 2012 can be effectively used to achieve functionality as compared to sql 2008.In one of my previous postshttp://visakhm.blogspot.com/2010/01/multipurpose-apply-operator.html I’d explained the application of APPLY operator in various…
Implementing multiple table based check constraints
A common scenario we come across is the requirement to implement a constraint on a table to enforce a business rule based on another table. Though this can be implemented by means of trigger its not so efficient at times…
Julian to iso date conversion function
Recently I had helped out a friend on logic for converting Julian date value to iso date value in T-SQL. Julian dates are in format CYYDDD where C will denote century YY year and DDD the day of year. So…
Display total rows with pivotting in t-sql
There were couple of occasions of late where people asked me way to display total rows along with detailed data while applying crosstabbing using PIVOT. Though this can be very easily generated in front end languages especially when you’re using…
Iterative queries using Common table Expressions
Common Table Expression or CTEs was a very useful feature which got added from SQL 2005. Though they’re mostly associated to recursive query scenario, they can be used for scenarios involving iterative logic also. The…
Clear cache programatically while rendering the report
Last week I was working on a SQL Reporting services report for displaying a report on financial data for one of my client. One of the requirements involved was to include ability to export this report to excel sheet.For this…