Databases SSIS Row Comparison By Checksum I recently ran across an SSIS package that needed to be rewritten that included the Checksum Transformation from SQLIS.com . The main reason was that they wanted the removal of the component because they were using it to compare rows instead of using something
Databases SSIS Execute SQL Task : Mapping Parameters And Result Sets A very common scenario in an ETL process is one in which you need to call out to some configuration tables to figure out some values that it needs to use somewhere downstream in the process. Quite often you also want to pass in
Databases Fear Not the Mighty TRIM() Function! Jason Strate wrote up an excellent blog post dealing with the people asking for SQL Server to have a TRIM() function in addition to the LTRIM() and RTRIM() function and the possibility of performance issues creeping up. You can check out his
Databases SQL Server 2012 Firestarter Series Recordings! Sorry for the delay everyone. Looks like my blog had an issue with pre-scheduled postings. Below you can find the links to all of the recordings from our SQL Server 2012 Firestarter Series just in case you missed them. I will be
Databases Chicago SQL Connections Talk: Auditing Using SQL Audit in SQL Server 2008 R2 Thanks to everyone that attended the presentation last night! It was really great to have everyone there and engaged in the conversation. Also great to see some old comrades as well. Below you will find the link to my slides and the content from
Databases PTI SQL Server 2012 Firestarter Webcast Series Well, PTI is ramping up for the release of SQL Server 2012 which is coming out the first half of this year and in order to help get the community up to speed we are putting on TWO MONTHS worth of weekly webcasts based
Databases Swan Dive Into Filtered Indexes and Statistics Thanks to everyone that attended the session. It was great getting a lot of good questions. As promised, here are the slides and the scripts for everything. Please make sure to visit http://www.pragmaticworks.com cause they are the ones that provided the
Databases Change Data Capture: Restoring A Database Change Data Capture (CDC) is an awesome feature available in Enterprise Edition of SQL Server 2008. It enables tracking of changes all the way down to the column level and is a really great time saving feature if you are building complex data models
Databases Fixing Transactional Replication in SQL Server SQL Server has a very solid criteria for replication transactions to the subscribers. First it sends out a batch. If it completes then it goes on to the next one. If not, then it tries each of the transactions in the set individually to