Monday Morning SQL Break – November 16, 2015
It’s Monday time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-11-16
405 reads
StrateSQL
Monday Morning SQL Break – November 9, 2015
It’s Monday time for this week’s blog and twitter round-up for last week. If you haven’t already, follow me on...
2015-11-09
315 reads
Monday Morning SQL Break – November 2, 2015
It’s Wednesday and time to revive the Monday summary of last week’s blog activity and links shared on twitter. Hopefully I’ll be...
2015-11-04
427 reads
PASS Summit Session Follow-up: The Plan Cache Whisperer
I’ve wrapped up my session at my first session at this year’s PASS Summit. My session this Thursday was The Plan...
2015-10-29
810 reads
Monday Morning SQL Break – August 3, 2015
It’s (finally) time for Monday’s weekly blog and twitter round-up for last week (it’s even on time). This post is...
2015-08-03
599 reads
Monday Morning SQL Break – July 27, 2015
It’s past time for the Monday blog and twitter round-up for last week, but better late than never (or not)....
2015-08-02
633 reads
Monday Morning SQL Break – June 22, 2015
It’s (actually) Monday and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already,...
2015-06-22
591 reads
PASSMN Presentation Follow-Up: Strategies for SQL Server Index Analysis
This past Tuesday, I got a chance to speak at the Minnesota SQL Server User Group. It was a great...
2015-06-19
520 reads
Thursday Morning SQL Break – June 15, 2015
It’s Thursday and time for this week’s weekly blog and twitter round-up for last week. If you haven’t already, follow me...
2015-06-18
687 reads
Monday Morning SQL Break – June 8, 2015
It’s time for this week’s weekly blog and twitter round-up for last week, it would be better timed if I...
2015-06-10
595 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