Monthly Archives: December 2013

Getting started with the AMR tool for migration to SQL Server In-memory OLTP Tables

SQL Server 2014 introduces In-memory OLTP to create memory optimized tables for OLTP workloads to significantly improve performance and reduce processing time when you have a significant amount of memory and multi-core processors. But how do you decide which tables or stored procedures might benefit if migrated to In-memory OLTP and how much estimated work is required to migrate the objects? Check out this tip to learn more.

Overview of Applications, Indexes and Limitations for SQL Server 2014 In-Memory OLTP Tables

SQL Server 2014’s In-Memory OLTP feature is intended to significantly improve performance and reduce processing time for servers with large amounts of memory and multi-core processors. What types of applications can take advantage of this new feature? What are the different types of indexes which can be created on memory optimized tables? Are there any considerations, restrictions or limitations? Check out this tip to learn more.

Presenting Using Biml as a Design Patterns Engine to Midlands PASS 9 Jan 2014!

I am honored to present Using Biml as a Design Patterns Engine to the Midlands PASS Chapter Thursday 9 Jan 2014! Summary: Business Intelligence Markup Language provides a powerful solution for creating and managing SSIS Design Patterns. Andy Leonard, one of the authors of SSIS Design Patterns , demonstrates the flexibility of BIML in this session. Register here ! If you will be near Columbia, SC one week from Thursday and read this blog, stop by and introduce yourself. I’m the fat guy with a fu….(read more)

Parallel execution of child SQL Server Integration Services Packages using For Loop Containers

It may happen, that you need to execute a child SQL Server Integration Services (SSIS) package many times like in case of processing large number of flat files from a directory. You can execute a child package in a sequential way using For Each Loop container, however this can take a long time. In such scenarios, a running SSIS packages in parallel comes into mind. But how do you do it? Check out this tip to learn more.