chrisbohling.blogspot.com
SQLServer.NET.SSIS Dev Notes: SSIS and DTC Notes, Part 3a: A Query to Collect a Rowset of PKs with a Subset of Duplicated Attributes
http://chrisbohling.blogspot.com/2009/02/ssis-and-dtc-notes-part-3a-query-to.html
SQLServer.NET.SSIS Dev Notes. Development notes from experience in Microsoft shops. Thursday, February 5, 2009. SSIS and DTC Notes, Part 3a: A Query to Collect a Rowset of PKs with a Subset of Duplicated Attributes. The "entity-by-entity" backfill in the context of a DTC transaction (which I discussed in SQLServer.NET.SSIS Dev Notes: SSIS and DTC Notes, Part 2: A Backfill Example. Minutes (even excluding some of the dataflow steps). 160;@AllRows int. 160;@DupRows int. 160;@AllRows =. 160;14059 ;.
chrisbohling.blogspot.com
SQLServer.NET.SSIS Dev Notes: February 2009
http://chrisbohling.blogspot.com/2009_02_01_archive.html
SQLServer.NET.SSIS Dev Notes. Development notes from experience in Microsoft shops. Monday, February 16, 2009. What naming conventions do you use? Use a single case with underscores (parrot color or PARROT COLOR). Always use Pascal case (ParrotColor). Apply upper case, Pascal case, lower case, and underscores to different types of objects, and also keywords ( WHERE. Parrot.parrot color IS NULL). Can re-case all keywords (and sometimes object identifiers) automatically. Discomfort from using the Shift and...
chrisbohling.blogspot.com
SQLServer.NET.SSIS Dev Notes: SSIS and DTC Notes: Part 1
http://chrisbohling.blogspot.com/2009/01/ssis-and-dtc-notes-part-1.html
SQLServer.NET.SSIS Dev Notes. Development notes from experience in Microsoft shops. Sunday, January 18, 2009. SSIS and DTC Notes: Part 1. Most of what I have to say relates to entity-by-entity inserts and updates from staging tables to (funky) data warehouse tables. A failure for a row or a set of rows in related tables, defining an entity, requires a rollback, but the rollback should not affect any other entities being loaded. A few points stand out in my experience:. My follow-ups to this post will foc...
rosihollinbeckthewritestuff.blogspot.com
The Write Stuff: August 2014
http://rosihollinbeckthewritestuff.blogspot.com/2014_08_01_archive.html
Sunday, August 31, 2014. The Secret at Haney Field - Review and Giveaway. Thought for the Day:. 8220;Mistakes are part of the dues that one pays for a full life.”. Gifts for My Writer Friends:. The Editor reminds us HERE. That our characters do not live in a vacuum. Not only does nature abhor a vacuum, but our readers do as well. Read this one. Such a great post on dialogue on Adventures in YA Publishing. You really must read this one. Click HERE. Darcy Pattison has a great post, Tea Party or Fist Fights?
chrisbohling.blogspot.com
SQLServer.NET.SSIS Dev Notes: SSIS and DTC Notes, Part 3c: The Row-by-Row Loop Package
http://chrisbohling.blogspot.com/2009/02/ssis-and-dtc-notes-part-3c-row-by-row.html
SQLServer.NET.SSIS Dev Notes. Development notes from experience in Microsoft shops. Wednesday, February 11, 2009. SSIS and DTC Notes, Part 3c: The Row-by-Row Loop Package. The goal of this series has been to create an SSIS package that wraps "entity-by-entity" updates from tables in a staging database to the corresponding tables in a target database (see SQLServer.NET.SSIS Dev Notes: SSIS and DTC Notes, Part 2: A Backfill Example. The requirements for this scenario are:. It seems logical that the import ...
chrisbohling.blogspot.com
SQLServer.NET.SSIS Dev Notes: A Word 2007 Macro to Insert and Format Code
http://chrisbohling.blogspot.com/2009/01/word-2007-macro-to-insert-and-format.html
SQLServer.NET.SSIS Dev Notes. Development notes from experience in Microsoft shops. Friday, January 30, 2009. A Word 2007 Macro to Insert and Format Code. I use Word 2007 to write my blog posts. Getting code into the post was somewhat of a hassle, so I wrote a VBA macro to insert and format the code text. My goals were to retains the syntax coloring and indentation, and remove the extra line spacing incurred by the use of the HTML p /p tags. 160;@StartDate datetime. 160;@StartDate =. 160; &#...160;...
chrisbohling.blogspot.com
SQLServer.NET.SSIS Dev Notes: SSIS and DTC Notes, Part 2: A Backfill Example
http://chrisbohling.blogspot.com/2009/01/ssis-and-dtc-notes-part-2-backfill.html
SQLServer.NET.SSIS Dev Notes. Development notes from experience in Microsoft shops. Thursday, January 22, 2009. SSIS and DTC Notes, Part 2: A Backfill Example. Part 1 of this discussion (see SSIS and DTC Notes: Part 1. The two main tables involved in the load to the data warehouse are HistoricalStage.CustomerStage and HistoricalDW.CustomerDW. There is also a log table that stores the ExecutionInstanceGUID from the package and some other information. The control flow is:. In these tests, the CustomerDW ta...
chrisbohling.blogspot.com
SQLServer.NET.SSIS Dev Notes: January 2009
http://chrisbohling.blogspot.com/2009_01_01_archive.html
SQLServer.NET.SSIS Dev Notes. Development notes from experience in Microsoft shops. Friday, January 30, 2009. A Word 2007 Macro to Insert and Format Code. I use Word 2007 to write my blog posts. Getting code into the post was somewhat of a hassle, so I wrote a VBA macro to insert and format the code text. My goals were to retains the syntax coloring and indentation, and remove the extra line spacing incurred by the use of the HTML p /p tags. 160;@StartDate datetime. 160;@StartDate =. 160; &#...160;...
chrisbohling.blogspot.com
SQLServer.NET.SSIS Dev Notes: Database Disagreements
http://chrisbohling.blogspot.com/2009/02/database-disagreements.html
SQLServer.NET.SSIS Dev Notes. Development notes from experience in Microsoft shops. Monday, February 16, 2009. What naming conventions do you use? Use a single case with underscores (parrot color or PARROT COLOR). Always use Pascal case (ParrotColor). Apply upper case, Pascal case, lower case, and underscores to different types of objects, and also keywords ( WHERE. Parrot.parrot color IS NULL). Can re-case all keywords (and sometimes object identifiers) automatically. Discomfort from using the Shift and...
SOCIAL ENGAGEMENT