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
30 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
10 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
32 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,110 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
15 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
16 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
454 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
917 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
381 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,310 reads
Blogs
Demo for Parameter Sniffing and Memory Grant Feedback
Disclaimer: The following is built with Claude Code. Just need to justify my $100/mo...
My Social Media Rules
By Brian Kelley
I developed these rules a while back, before COVID. I had a period of...
Why Use TRY_PARSE(): #SQLNewBlogger
By Steve Jones
Someone asked why I would use TRY_PARSE after I posted a question at SQL...
Forums
Partitioning a table with TEXTIMAGE_ON option
I have a table that ends in ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]. I'm about to...
OUTER APPLY Fundamentals: Part 2
Comments posted to this topic are about the item OUTER APPLY Fundamentals: Part 2
Building Great Software
Comments posted to this topic are about the item Building Great Software
Question of the Day
The Range of Customers
I have this data in the OrderHeader table in a SQL Server 2025 database (ordered by CustomerID ASC):
orderid orderdate customerid complete 3 2025-05-10 00:00:00.0002 1 21 2024-01-10 00:00:00.0003 1 15 2023-10-28 00:00:00.0004 1 13 2025-03-08 00:00:00.0006 1 11 2024-04-02 00:00:00.0007 1If I run this query, how many rows are returned?
SELECT * from dbo.OrderHeader where customerid between 3 and '6'See possible answers