By Steve Bolton
…………Longer code and substantial performance limitations were the prices we paid in return for greater sophistication with Cook’s...
2015-09-23 (first published: 2015-09-12)
3,575 reads
I want to drive home the importance of the predicate order when dealing with Extended Events. This is an important topic because it can be very helpful in maintaining...
2015-09-23
46 reads
I am going to ignore the fact that people don't want to install visual studio on a build server, in...
2015-09-23
529 reads
I am going to ignore the fact that people don’t want to install visual studio on a build server, in...
2015-09-23
41 reads
I am going to ignore the fact that people don’t want to install visual studio on a build server, in...
2015-09-23
45 reads
I am going to ignore the fact that people don't want to install visual studio on a build server, in the future there will likely be a way to...
2015-09-23
5 reads
TIMESTAMP vs. DATETIME: What’s the diff? The TIMESTAMP data type in SQL Server is not what you may think it...
2015-09-23
979 reads
Counter offers (and the related discussions) are an emotional topic. The comments on two of my editorials for SQLServerCentral (The...
2015-09-23
596 reads
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
Continuation from the previous 66 parts, the whole series can be found at http://www.nikoport.com/columnstore/.
Continuing from the last couple of blog...
2015-09-22
613 reads
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
By Steve Jones
We had an interesting discussion about deployments in databases and how you go forward...
By ChrisJenkins
You could be tolerating limited reporting because there isn’t an off the shelf solution...
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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