Reblog: October 25 to October 31
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-11-01
815 reads
StrateSQL
Last Weeks Top “Reading” Links #55
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-28
1,106 reads
Reblog: October 18 to October 24
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-25
957 reads
Webcast Follow-Up: Choosing Your Clustered Index
Earlier this month, I presented a session for Pragmatic WorksTraining on the T’s on the selecting the clustered index for a...
2013-10-23
966 reads
Webcast Follow-Up: How Do Non-Clustered Indexes Improve Performance?
Earlier this month, I presented a session for Pragmatic WorksTraining on the T’s on the selecting the clustered index for a...
2013-10-23
958 reads
Last Weeks Top “Reading” Links #54
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-21
864 reads
Reblog: October 11 to October 17
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-18
475 reads
October 2013 – Monthly SQL Server Checklist
It’s not the first Monday of October, instead it’s the second Tuesday (oops, had Wednesday in here originally). As we...
2013-10-15
621 reads
Last Weeks Top “Reading” Links #53
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-14
759 reads
I’m 40 and I’ve Had Enough
I’m not old, but I did turn 40 today. If you ask my kids, they are likely to say that...
2013-10-11
812 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