Enhanced Threading Framework V3 for SSIS
I decided to revisit my framework to see if I could improve the performance and possibly increase the number of scenarios this framework could be used in. Turns out...
2016-03-24
2 reads
SQLRunner
Validating in-line DataFlow records with a Stored Procedure
I have text file that contains data for a given fiscal period. In this particular file there are around 2...
2013-11-14 (first published: 2013-11-05)
2,086 reads
Validating in-line DataFlow records with a Stored Procedure
I have text file that contains data for a given fiscal period. In this
particular file there are around 2 million records. The file needs to be
split into...
2013-11-05
Validating in-line DataFlow records with a Stored Procedure
I have text file that contains data for a given fiscal period. In this
particular file there are around 2 million records. The file needs to be
split into...
2013-11-05
PASS Summit 2013 - Examples Package
I was asked by some attendees of my PASS 2013 Session, Unseen Minions : Improving parallel processing in SSIS, if I had any...
2013-10-22
436 reads
SSWUG Summer Camp
I'm speaking at SSWUG Summer Camp! Thankfully, I can be at home, in my pool AND be at summer camp...
2013-06-26
903 reads
Speaking at PASS Summit 2013!
I am honored to say that have been selected to present this year. I'll be giving a talk on my...
2013-05-22
368 reads
Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4...
2013-02-26
1,170 reads
Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...
2013-02-26
Converting Inches to Centimeters - Long Hand
Today I had to write a little function that takes the long had version of a fraction, say 8 3/4 and convert it a proper number (float) and then...
2013-02-26
Blogs
Quick Start to Using Influxdb on Macos
By Sheldon Hull
Intro OSS 2.0 is a release candidate at this time, so this may change once...
Error: 8623 - The query processor ran out of internal resources and could not produce a query plan
Unfortunately a common error in many of our client environments is this: -- Error: 8623, Severity:...
Goal Progress– October 2020
By Steve Jones
This is my report, which continues on from the Aug report. After that report,...
Forums
What is Possible?
Comments posted to this topic are about the item What is Possible?
I cannot add a replica because of difference between instances
Hi There, Let me start with to say I am not a SQL administrator,...
Tip for getting trifocals made for computer monitor use.
I want to share with those of you advancing in years something I learned...
Ask SSC