New Blog Space
I've decided to move my blog here. You'll see some old content being uploaded in the next few days. Look around, I hope you find some tidbits of information.
Older...
2022-10-17
19 reads
Josef Richberg
Using Managed Identities to authenticate Function Apps
I have a video detailing how to use Managed Identities to authenticate function apps in Azure.
2020-10-26
1 reads
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
22 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...
2013-11-14 (first published: 2013-11-05)
2,097 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
7 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
6 reads
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
442 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
906 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
375 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,271 reads
Blogs
SQL Server Wait Stats
By Kevin3NF
Everything in SQL Server is waiting for something…this is by design. And most people...
FabCon 2025 Recap
By DataOnWheels
Hey fellow data friends! Wow, March was an absolutely crazy month (in the best...
Privacy Policy
We value your privacy. This policy explains what personal data we collect and why. What...
Forums
Why would using a variable vs Hard Value impact a Query's Performance
Why would using variables in place of hard coded numbers impact a query's performance? ...
XML data import with poor stored procedure performance (needs optimization)
Hello SSC! I have been tasked with optimizing a stored procedure the imports data...
Trouble accessing hidden XML download link on Blazor-based government site
Hey everyone, I'm trying to access an XML file download from a government website...
Question of the Day
Importing Flat Files
What types of sources can be used with the Import Flat File Wizard in SQL Server Management Studio (SSMS)?
See possible answers