Gone Dark
This afternoon was quite interesting around the office. A strong thunderstorm moved through the area, a common occurrence in Texas...
2009-03-25
1,400 reads
Tim Mitchell
Building Reports, 2.0 Style
I’m getting my first taste of the new SQL Report Builder 2.0, and so far I’m enjoying the upgrade. Report...
2009-03-08
2,388 reads
[Off Topic] Get Fit in February – Wrap Up
During the month of February, I participated in the Get Fit in February challenge last month. Along with a few...
2009-03-04
628 reads
Finding a Work-Life Balance
Like most everyone who works hard in our industry, I’ve run into more than a few conflicts trying to balance...
2009-02-25
1,592 reads
Your Local User Group
When I talk to other SQL Server professionals, I’m often surprised at how many do not have any involvement in...
2009-02-17
1,228 reads
Things I Wish I Had Known
I was tagged by Grant Fritchey (aka Scary DBA) in the latest get-to-know-you question. This one asks, “What do you...
2009-02-11
2,242 reads
[Off Topic] Get Fit in February Developer Challenge
I’m on Day Two of the Get Fit in February Developer Challenge. This month-long competition boasts around 200 participants who...
2009-02-02
650 reads
Getting into the biz, Part 1
I’ve seen a good deal of coverage recently that is geared toward those who have recently begun a career as...
2009-02-01
852 reads
Presentation Notes from SQL Saturday
For those who were in my session on SSIS Scripting at SQL Saturday Tampa last weekend, I have posted the...
2009-01-26
1,363 reads
SQL Saturday Tampa
I’m sitting in the Tampa airport waiting for a flight back home from SQL Saturday 10 in Tampa. There was...
2009-01-25
1,677 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