12 Days of Christmas 2013 Day 1
Last year I did a mini-series themed around the 12 Days of Christmas. I am going to do a similar...
2013-12-25
586 reads
SQL RNNR
12 Days of Christmas 2013 Day 1
Last year I did a mini-series themed around the 12 Days of Christmas. I am going to do a similar series this year. Over the next 12 days, I...
2013-12-25
5 reads
DC SQLSat
This past weekend I had the opportunity to go visit Washington DC. It was the first time I got to...
2013-12-11
826 reads
DC SQLSat
This past weekend I had the opportunity to go visit Washington DC. It was the first time I got to stay in the Nation’s capitol for more than just...
2013-12-11
3 reads
To DBA or Not to DBA (DBA Jumpstart)
This post is part of the SQL Community Project started by John Sansom called #DBAJumpStart.“If you could give a DBA...
2013-12-10
824 reads
To DBA or Not to DBA (DBA Jumpstart)
This post is part of the SQL Community Project started by John Sansom called #DBAJumpStart. “If you could give a DBA just one piece of advice, what would it...
2013-12-10
3 reads
SQL Claus and BI at S3OLV
Tis the season once again. We have SQL gifts a plenty for any and all who wish to partake.
This month,...
2013-12-10
653 reads
SQL Claus and BI at S3OLV
Tis the season once again. We have SQL gifts a plenty for any and all who wish to partake. This month, we have Stacia Misner (twitter) that will be...
2013-12-10
6 reads
Cloud Nirvana
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host...
2013-11-12
774 reads
Cloud Nirvana
T-SQL Tuesday is a recurring blog party, that is started by Adam Machanic (Blog | @AdamMachanic). Each month a blog will host the party, and everyone that want’s to can write...
2013-11-12
5 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