Monthly Archives: August 2015

How to create first basic package with SSIS ? tip #113

Dear friends, In last post #112 we understood WWH (What ,Why & How ) of SSIS. Now , lets move now real quick in practical session where we will try to create a basic simple package. The example which we are creating is well known Export data from SQL SERVER to a flat file. Step …

WWH of SSIS Zero to Hero in SSIS series (How to Use SSIS ?) TIP #112

Hello Friends, Welcome, back to Zero to Hero in SSIS series(Post #110). In last post #111 ,We gone through the WW (What & Why part) of SSIS in this post we will try to understand How to start SSIS ? How to use SSIS tool ? You can start SSIS with SQL Server Data Tools  …

How easy or difficult to write dynamic SQL ? TIP#110

This is one of the challenge for most of the developer to write dynamic SQL. Generally we follow the approach of string concatenation. This seems very easy but we need to cast the  parameters in VARCHAR and sometimes we stuck in single code. I am sure this happened with all of us.  Let’s understand first …

An interesting setting for NULL but don’t use it for future TIP #109

As we discussed earlier in TIP#103 for NULL in which I shared that we have to take extra care for NULL. Now in this tip I would like to share one of the interesting setting for NULL. Although it is just for knowledge but don’t use it because it is deprecated in future version and …

A big issue when try to Alter user define table type structure TIP #108

  I hope all of you aware of  User define table type (a table value parameter) which we discussed earlier in TIP #57. Now recently one interesting incident happened. We are using a user define table type in few stored procedure and due to some business requirement change we need to change /update data type …

An interesting way of aliasing TIP#107

I recently gone through something and found a unique way of aliasing. I thought it must be share so other techies also aware of it (or might be you already aware of it). See below example SELECT *FROM (VALUES (‘Rajat’,30),             (‘Sandeep’,40),             (‘Sunil’,35),             (‘Shreya’,50),             (‘Virendra’,45)) AS T(Name,Runs) Now when you it  you will get following result …