Re-blog – November 25 – December 1
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer...
2011-12-02
500 reads
StrateSQL
Speaking in Colorado Springs
I’m probably going to have to put together a new SQL video, because I’ve been accepted to speak at SQL...
2011-12-01
555 reads
SQL Saturday 99 – Digineer Interview
Welcome to the second of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-12-01
773 reads
2011-11-30
1,480 reads
SQL Saturday 99 – Quest Interview
Welcome to the first of a few sponsor interview posts from SQL Saturday 99. After reading Arnie Rowland’s (Blog | @ArnieRowland)...
2011-11-29
514 reads
SQL Server Special Ops
SQL Server 2012 is coming to 12 cities next year. Is your city on the list? It can be – or...
2011-11-29
862 reads
Last Push For Movember
Do you have $5 you could re-direct from a cup of coffee to a donation on men’s health issues?
If you...
2011-11-28
484 reads
Adelaide SQL Server User Group Slides and Scripts
You can find the slides and scripts from Monday’s Extended Events session for the Adelaide SQL Server User Group in the...
2011-11-25
525 reads
Re-blog – November 18 – November 24
Welcome to the Friday Re-Blog summary post. The aim of these posts is to bring some old posts that newer...
2011-11-25
894 reads
17 WordPress Plug-Ins That I Use
In the past week, I’ve had a number of requests for a list of the WordPress plug-ins that I use. ...
2011-11-21
1,142 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