Welcome to the world (new face) of Knowledge Sharing Network.
To track the older blog posts refer to our historical knowledge sharing site  and you will find this as your destination for SQL Server knowledge pool.

Follow SQLMaster on Twitter SqlServer-QA.net - Knowledge Sharing Network (@sqlmaster)

ssis - SQL Server Knowledge Sharing Network (@sqlmaster)

Browse by Tags

All Tags » ssis (RSS)

SQL Relay - Cardiff Usergroup my presentation #sqlserverfaq #sqlrelay #upgrade #bpa

It was a great opportunity to meet and greet the SQL professionals in Cardiff on 05th October 2011 as a part of SQL Relay Usergroup metings across UK. Thanks to Adam Morton for giving me chance to present, since last year and half we have been trying...

SQL Server Integration Services - think about Transactions and Checkpointing?

Transactions and Checkpoints are important factors for data consistency, when it comes for ETL processes that too on SSIS what is your stand? I'm covering this important task for the sake of newbie & junior DBAs, also the similar question was...

How to get rowcount efficiently within a SSIS package?

I would like to call this as how efficiently you can obtain counting rows in SSIS package. Usual thought would come is @@rowcount or COUNT_BIG functions, but this is not that efficient way to obtain the results. SSIS provides the snippet within its components...

Data Warehouse Scalability Features in SQL Server 2008

By now you might be aware or have gone through the web resources and conferences about what's new within SQL Server 2008 version, one thing is sure scalability for your database platform. Though there isn't a real-time data warehouse implementation within...