Is your Team Willing to Take Control?
The calendar tells us that once again we have reached the second tuesday of the month. In the SQL Community,...
2014-07-08
562 reads
Jason Brimhall
Free SQL Training In Sacramento
In a few short days the newest SQL Saturday event. This one will be on the far West coast of...
2014-07-07
472 reads
Free SQL Training In Sacramento
In a few short days the newest SQL Saturday event. This one will be on the far West coast of the United States. This marks the first time for...
2014-07-07
5 reads
Using Synonyms to Extend SSIS
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality is, not all of those uses are good for...
2014-07-03
3 reads
Using Synonyms to Extend SSIS
There are a million and one uses for synonyms. There are at least that many uses for SSIS. The reality...
2014-07-03
1,724 reads
Auditing and Event SubClasses
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some...
2014-06-02 (first published: 2014-05-28)
1,938 reads
Can you partition a temporary table?
Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too...
2014-05-29 (first published: 2014-05-23)
3,786 reads
Auditing and Event SubClasses
A recent discussion got me to thinking about Auditing. To be honest, it got started with a complaint about some documentation that seemed overly light about the various fields...
2014-05-28
5 reads
Can you partition a temporary table?
Reading that title, you might sit and wonder why you would ever want to partition a temporary table. I too would wonder the same thing. That withstanding, it is...
2014-05-23
4 reads
Missing Indexes Script v2
Frequently we hear the analogy that <insert item here> is like opinions, everybody has one and not all of them...
2014-05-22 (first published: 2014-05-15)
4,227 reads
Blogs
Identity Columns Can’t Be Updated: #SQLNewBlogger
By Steve Jones
I’m not sure I knew identity column values could not be updated. I ran...
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...
Forums
Can someone please explain what happens?
I have mentioned this several times over several years. Can someone please help me...
SELECT COUNT(DISTINCT) returns null when nothing is found instead of 0
SELECT COUNT(DISTINCT Component) AS Found FROM tblComponents WHERE(Component NOT LIKE '%[a-z]%') AND(LTRIM(RTRIM(Component)) = 'GM13622')...
Remotely Engineer Fabric Lakehouse objects: The Fabric Modern Data Platform
Comments posted to this topic are about the item Remotely Engineer Fabric Lakehouse objects:...
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