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
25 reads
SQLRunner
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
7 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
29 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,108 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
13 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
451 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,306 reads
Blogs
Beware of Generic SQL Server License Keys (What to Use Instead)
By SQLPals
Beware of Generic SQL Server License Keys (What to Use Instead) ...
On Speaking Well
By Brian Kelley
Professor Patrick Winston of MIT used to give a one-hour talk about how to...
Monday Monitor Tips: Oracle Custom Metrics
By Steve Jones
One of the popular features of Redgate Monitor has been the ability to add...
Forums
Creating a JSON Document II
Comments posted to this topic are about the item Creating a JSON Document II
Backing Up Azure Key Vault EKM Key: Stairway to TDE Level 6
By VishnuGupthanSQLPowershellDBA
Comments posted to this topic are about the item Backing Up Azure Key Vault...
Every Database Has Problems
Comments posted to this topic are about the item Every Database Has Problems
Question of the Day
Creating a JSON Document II
I want to create a JSON document that contains data from this table:
TeamID TeamNameCity YearEstablished 1 Cowboys Dallas 1960 2 Eagles Philadelphia 1933 3 Packers Green Bay 1919 4 Chiefs Kansas City 1960If I run this code, what document(s) is/are returned?
SELECT json_objectagg( n.city : n.TeamName) FROM dbo.NFLTeams;See possible answers