Darren_Green.jpg

Darren Green

Darren is an independent consultant specialising in data solutions with SQL Server. Having been working with SQL Server from 6.5 onwards he has extensive experience in many aspects of SQL Server, but now focuses on solving problems with SQL Server and SSIS.
http://www.konesans.com http://www.sqlis.com/sqlis/syndication.axd?author=Darren%20Green

Do you wonder about SSIS performance? Well I do, and I've compiled my research into this session. We'll cover various design patterns for solving common problems like inserts vs. updates, is it faster to use a lookup, or can you just catch the errors and process them afterwards? As well as the richer patterns we'll look at some straight comparisons between two components that can be used to do perform the same task and ask which one is quicker?
After years of careful observation and recording of the Species SSIS, Genus ETL, in both natural and artificial environments, I’ve gathered a large collection of fieldnotes. Find out the little decisions that get made that can have big impacts on you project later on. What option to choose for better performance, or better management, and what are the trade-offs? This session won’t just focus on holy grail of performance, it will review the way you build and use SSIS taking into account the on going maintenance and management aspects as well.

Blog posts RSS

SSMS copy and paste from results grid losing CR+LF - SQL Server 2016 06 Jun 2016
When you start using SQL Server Management Studio (SSMS) for SQL Server 2016, you may notice a new bug feature to do with the Results Grid. If you copy and paste one or more cells from the results grid the copied text loses any carriage returns (CR) and line feeds (LF). To avoid too much head ...

File Watcher Task 06 Jun 2016
The task will detect changes to existing files as well as new files, both actions will cause the file to be found when available. A file is available when the task can open it exclusively. This is important for files that take a long time to be written, such as large files, or those that are just ...

Checksum Transformation 06 Jun 2016
The Checksum Transformation computes a hash value, the checksum, across one or more columns, returning the result in the Checksum output column. The transformation provides functionality similar to the T-SQL CHECKSUM function, but is encapsulated within SQL Server Integration Services, for use ...

File Watcher Task 06 Sep 2014
The task will detect changes to existing files as well as new files, both actions will cause the file to be found when available. A file is available when the task can open it exclusively. This is important for files that take a long time to be written, such as large files, or those that are just ...

RegexClean Transformation 06 Sep 2014
Use the power of regular expressions to cleanse your data right there inside the Data Flow. This transformation includes a full user interface for simple configuration, as well as advanced features such as error output configuration. Two regular expressions are used, a match expression and a ...