Blog Archives

Reference Assembly in SSIS Script Task (.net Custom Assembly)

In this blog post I want to show how to reference custom .net Assembly in SSIS Script Task. Assume you want to use some JSON dll in your Script Task instead of this json connector. Here are the steps. Add

Tagged with: , ,
Posted in SSIS

Get File Column Count using SSIS C# Script Task

Sometimes you have changing schema in your flat file (Columns added or Removed) If you ever want to know how many columns you have in flat file then simply use below snippet and it will tell you column count. #region

Tagged with: , , ,
Posted in SSIS

How to use SSIS Data Viewer in DataFlow Task

SSIS Data Viewer - Debug Pipeline

In this post you will learn how to use SSIS Data Viewer to debug/troubleshoot SSIS DataFlow Pipeline issues at runtime. You can use SSIS Data Viewer any time you want to see what your data look like at given point

Tagged with: , ,
Posted in SSIS

How to use SSIS Derived Column Transform

SSIS Derived Column Transform Expression

What is SSIS Derived Column Transform SSIS Derived column transform is used to change existing columns coming from Source or add New Columns in the Pipeline Buffer. Note: For simplicity we have used Free DummyData Generator Source in this post

Tagged with: , ,
Posted in SSIS

How to show more than 8000 chars in SSMS output

T SQL Date format convert function

If you ever tried to display more than 8000 characters column such as varchar(MAX) column value in SSMS output in text mode then you will quickly realize that you hit the wall. SSMS truncates anything more than 8000 chars (approx.

Tagged with: ,
Posted in SQL Server, T-SQL Tips, Tips

DISTINCT vs GROUP BY Performance in SQL Query

T SQL Date format convert function

If you ever wonder which one is really faster in Distinct vs Group By Performance Test then I will show some facts in this post so you can write your query accordingly.   To test distinct vs group by performance in SQL Query

Tagged with: , ,
Posted in SQL Server, T-SQL Tips

Learn Microsoft DocumentDB – Fully managed NoSQL Database offering for Azure Platform

windowazurelogo

Yesterday Microsoft Azure services took a big leap forward by announcing their fully managed Cloud based NoSQL Database Service named as “DocumentDB” which will run under Azure Cloud Computing Platform. What is NoSQL database NoSQL database is a different category

Tagged with: , , ,
Posted in Big Data, Cloud Computing, NoSQL, Windows Azure

How to fix – Exception has been thrown by the target of an invocation – VS2012 VS2010.

Visual Studio 2012

I just installed few tools on my new laptop and at some point Visual Studio 2012 started throwing error “Exception has been thrown by the target of an invocation.“ … After Binging few mins I got some clue what could

Tagged with:
Posted in Visual Studio

How to overwrite SQL Server Backup rather than Append Mediaset

T SQL Date format convert function

In this post I will show you how to overwrite sql server backup file rather than append (default action is append to backup media set) If you try below t-sql command to take full sql server database backup then you

Tagged with: , ,
Posted in DBA, SQL Server, T-SQL Tips

Introduction to Microsoft SQL Server Parallel Data Warehouse (PDW)

Sql ServerParallel Data Warehouse (PDW)

Microsoft Parallel Data Warehouse (PDW) also known as Microsoft Analytics Platform System (APS) is a special version of SQL Server designed to handle petabytes worth of data. It has very different architecture compared to traditional Symmetric Multiprocessing (SMP) System. Check below presentation

Tagged with: , , , ,
Posted in Big Data, Parallel Data Warehouse (PDW)