What SQL version is my SSIS package?
When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how...
2015-04-27
1,102 reads
When SSIS first came out there were huge numbers of jokes and posts about all of the problems and how...
2015-04-27
1,102 reads
This month for T-SQL Tuesday Mike Donnelly (b/t) decided to pick a topic to fit in with Ed Leighton-Dick’s (b/t)...
2015-04-23 (first published: 2015-04-14)
5,325 reads
You should always be recoverable. If you haven’t heard that before, take note of it. It’s important.
A while back...
2015-04-22
499 reads
To be fair it’s not actually hidden, just not so well known.
Have you ever wondered how to grant permissions...
2015-04-20
1,507 reads
I was recently asked to do some fairly heavy modifications to a table. It involved adding 6 new columns, removing...
2015-04-16
964 reads
I’m by no means an expert in SQL Server encryption. What I do know however, is that the Service Master...
2015-04-08
818 reads
CTEs (Common Table Expressions) are one of the most interesting and useful tools added to T-SQL in the last decade....
2015-04-06
697 reads
I made a mistake the other day. I’ll admit it. I was wrong. Now I know all of you are...
2015-04-03 (first published: 2015-03-30)
8,984 reads
It seems that Microsoft has finally gotten tired of all the jokes about the word “performant” or using “ask” as...
2015-04-01
485 reads
I have a customer who is having a problem with a load. He is getting a fair number of bad...
2015-03-25
1,101 reads
By Steve Jones
I haven’t done one of these in awhile, but I saw an article recently...
In last months one of the scenarios where you can use AI has been...
By ChrisJenkins
Do you spend so long manipulating your data into something vaguely useful that you...
Comments posted to this topic are about the item Creating JSON II
Comments posted to this topic are about the item Engineer Lessons
On SQL Server 2025, what happens when I run this code:
SELECT JSON_OBJECTAGG( N'City':N'Denver' RETURNING JSON) GOSee possible answers