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: 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
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
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
Reblog: October 4 to October 10
I’ve always been a fan of the feeling when I find an old blog post that’s got just the information...
2013-10-11
607 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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