Starting Conversations - Part 3
If you haven't already, start with Part 1 and Part 2. In Part 2 I mentioned that I have hired...
2009-04-28
1,414 reads
SQLAndy
Making Forums Work
I saw this post about Why I Dislike Newsgroups from Tom Larock and he did a pretty good job of...
2009-04-27
1,024 reads
Notes on SQLSaturday #13
I drove up on Friday with my friend Kendal Van Dyke. Long drive from Orlando, just over 8 hours. Arrived...
2009-04-27
661 reads
Visiting West Palm Beach SQL Group on April 29, 2009
I'm going to West Palm Beach on Apr 29th to visit Scott Klein and his group. I'll be doing a...
2009-04-26
626 reads
Book Review: The Speed of Trust
I finally finished up reading the Speed of Trust and have to say I struggled with it. I'm a big...
2009-04-23
788 reads
Building Something Fun
A little further off topic than usual today, something not about technology and work for a change. Woodworking is one...
2009-04-23
1,406 reads
Want a SQLSaturday Polo or Tshirt?
I've had a few requests for these, so I'll take orders through May 8, 2009. The polo is a very...
2009-04-23
831 reads
Internal Outsourcing
We'll all heard about or lived with outsourcing, and hopefully we know it's good and bad. Outsourcing the janitorial services...
2009-04-22
975 reads
Day of DotNutNuke in Tampa on June 13, 2009
My friend Will Strohl is managing the Day of DNN on June 13, 2009 at the Microsoft office in Tampa....
2009-04-22
707 reads
PASS Connector Editorial for April 22, 2009
I currently write the editorial for the PASS Connector which is published every two weeks as part of my role...
2009-04-22
563 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