Visiting Atlantis
This week I got to visit Atlantis. Not the mythical island, but rather the ship, the Space Shuttle Atlantis at...
2013-06-26
1,350 reads
SQLAndy
PASS Nominating Committee for 2013 Elections Announced
I was pleased to see the email this morning announcing that community volunteers Erin Stellato, Ryan Adams, and Tamera Clark...
2013-06-26
1,245 reads
Kindle vs Library
Since I bought a Nexus 7 (two of them, I broke the first one) I’ve been interested to see if...
2013-06-17
621 reads
Is $160 Per Day a Lot?
Recently I was in a small coffee/sandwich shop for early morning coffee and while waiting watched one of the employees...
2013-06-17
752 reads
Interesting Approach-One Time Tools
Recently I ordered a Paolini Pocket Rule from Woodpecker. It is one of a series of OneTime Tools they’ve produced...
2013-06-17
871 reads
Vacation Notes
First stop was Philadelphia, mostly because we scheduled our vacation to coincide with SQLSaturday #200, but also because we had...
2013-06-11
922 reads
Presenting at SQLSaturday #231 in Cocoa Beach
I’ll be attending the very first SQLSaturday held in Cocoa Beach on July 27, 2013, and doing a brand new...
2013-06-07
623 reads
Train Rides and A Silly Train Story
This past week I took my kids on a train ride from Philadelphia to Washington DC. It was their first...
2013-06-07
614 reads
Notes from SQLSaturday #200
My first time in Philadelphia (and in Malvern, the actual event location). I drove up Friday night for the speaker...
2013-06-07
774 reads
Back to Plan A
At the end of April I posted a bit on my change in plans and what I thought I’d be...
2013-05-28
790 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