SQL Lunch #32: SSIS Design Patterns, with Andy Leonard
Don't miss SQL Server MVP Andy Leonard on the SQL Lunch, Monday, October 11th.
#32-SSIS Design Patterns 1c: Variables, Events, and...
2010-10-08
796 reads
Patrick LeBlanc
Speaking at the Houston Techfest
I am heading down to Houston, TX to speak at the Houston Techfest this weekend. Being a Houston native makes...
2010-10-07
402 reads
SQL Lunch: Change of Schedule
There has been a slight change to this weeks SQL Lunch meeting. Our scheduled speaker cannot present this week, therefore...
2010-10-05
411 reads
SQL Lunch One Year Anniversary
I am very excited to announce the 1 year anniversary of the SQL Lunch. Last year around this time I...
2010-10-04
420 reads
Maintain Change Data Capture Configuration when restoring a database
I have been working with a several clients that are leveraging Change Data Capture (CDC) as a tool for incrementally...
2010-10-03
1,337 reads
SQL Saturday #57 (Houston) Call for Speakers and Registration is Open!!
So many people have been waiting for a SQL Saturday in Houston and now it’s finally here. As a native...
2010-10-03
711 reads
SSIS: Assign a value to Variable using Dataflow Script task
I am not quite sure how many of you have tried to set or change the value of a variable...
2010-09-19
4,751 reads
Baton Rouge SQL Server User Group Tonight
Last Night (9/14/2010) I had the opportunity to present to the Wisconsin SQL Server User Group. My topic was SSIS-...
2010-09-15
522 reads
Where do you get your motivation and drive?
I was asked by someone the other day, where do you get your drive and motivation? For a second, I...
2010-09-06
648 reads
MDX Puzzle #7 - Solution
Puzzle #7 had an interesting twist. You were required to add a column to the result set that dynamically displayed...
2010-09-03
595 reads
Blogs
Rolling Back a Broken Release
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
A bespoke reporting solution doesn’t have to cost the earth
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
Presenting with Visual Studio Code
A while back I wrote a quick post on setting up key mappings in...
Forums
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
Testing is Becoming More Important
Comments posted to this topic are about the item Testing is Becoming More Important
Question of the Day
Creating JSON III
In a SQL Server 2025 table, called Beer, I have this data:
BeerIDBeerName 1Becks 2Fat Tire 3Mac n Jacks 4Alaskan Amber 8KirinI run this code:
SELECT JSON_OBJECTAGG(
BeerID: BeerName )
FROM beer;
What are the results? See possible answers