Lag and Lead Functions in SQL Server 2012

Posted by on Sep 10, 2013 in SQL Server, T-SQL | No Comments

SQL Server 2012 has a set of useful functions to work in T-SQL environment. Lead and Lag are one of the most useful functions introduced in 2012. Lag function helps to access values from previous records, and Lead function helps to access values from next records in the data set. structure of working with these ...

Read More

Error Handling in SSIS; Download presentation materials and recording

Posted by on Aug 22, 2013 in Presentations, SSIS | No Comments

Thanks for all attendees of today’s webinar about Error Handling in SSIS. turnout was good, and good questions asked and responded. Here are topics that covered in this session: Error handling in SSIS Data Taps Logging SSIS Catalog stored procedures for Logging and execution Debugging and Troubleshooting SSIS packages some live demos about error handling, ...

Read More

T-SQL Script to get row count of all tables in the database

Posted by on Aug 18, 2013 in SQL Server, T-SQL | No Comments

Today I’ve wrote a simple script to get number of records for all tables in a database and fetch those tables that contains at least one record. This picture shows an example of result set: Here is the script: declare @tempTable table(tablename varchar(max), rowscount int,processed bit) insert into @tempTable select TABLE_NAME,0,0 from INFORMATION_SCHEMA.TABLES where TABLE_CATALOG=‘DEMO’ ...

Read More

Effective Control Flow Execution with 7 Different Types of Foreach Loop Enumerators

Posted by on Jul 24, 2013 in Presentations, SSIS | No Comments

Thanks for attending in my session at Pass DWBIVC today, it was my pleasure to see you there. Today’s talk was about; Effective Control Flow Execution with 7 Different Types of Foreach Loop Enumerators in SSIS Session description: Controlling execution of tasks in Control Flow tab of SSIS package can be much easier with getting ...

Read More

PIVOT Transformation Issue in SSIS

Posted by on Jul 23, 2013 in SSIS | No Comments

Today I’ve found a bug in SSIS Pivot Transform component reported as a question in TechNet forums here. Reported issue was related to pivoting some records based, result of PIVOT transformation in SSIS was not as expected to be. read below for detailed explanation; Scenario Explanation: This is a sample of incoming data set: The ...

Read More