Kicking the Tires on SSIS 2016
Last week I hosted a webinar in which I reviewed some of the coming changes for SQL Server Integration Services...
2015-10-19 (first published: 2015-10-07)
3,019 reads
Tim Mitchell
Advanced SSIS Training Course Preview
If you are looking for some end-of-year training before the new budget year rolls around, consider joining Andy Leonard and...
2015-10-02 (first published: 2015-09-28)
2,032 reads
Webinar: Kicking the Tires on SSIS 2016
The next version of SSIS is on the horizon. Are you ready?
In next Tuesday’s webinar, I’ll be reviewing and demonstrating...
2015-09-23
582 reads
Ryan Adams for SQL PASS Board
It’s election season! No, I’m not talking about The Donald, The Clinton, The Neurosurgeon, The Veep, or any of those...
2015-09-15
566 reads
Webinar: Change Tracking for Data Warehouse Loads
For data warehouse professionals, change detection is critical. Accurately detecting new, changed, and deleted records means the difference between doing...
2015-09-14
518 reads
Building Better SSIS Packages Class in Dallas
I’m happy to announce a new, full-day class in the Dallas area next month. I’ll be presenting my Building Better...
2015-09-15 (first published: 2015-09-08)
1,602 reads
Sixty Days to Summit–Are You Ready?
In just two short months – exactly sixty days from today – the SQL PASS Summit will begin. Although it’s still a...
2015-08-28
657 reads
Above All, Good Judgment
What is permissible is not always honorable. – Marcus Tullius Cicero
Rules. Best practices. Guidelines. Design patterns. Policies. All are good and...
2015-08-24
578 reads
We Don’t Trust This Data
“Learning to trust is one of life’s most difficult tasks.” – Isaac Watts
As data professionals, there are times when our jobs...
2015-08-19 (first published: 2015-08-14)
2,982 reads
Downloading SFTP Files with SSIS
If you’ve used SSIS for any significant amount of time, you’ve almost certainly run into this roadblock: You need to...
2015-08-03
7,710 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