SQLPeople INSPIRE NYC - Coming this FALL - November 12, 2011
Nature abhors a
vacuum. So, when I see so many SQL
Server happenings going on all over the country, and indeed the...
2011-08-15
1,836 reads
Robert Pearl
T-SQL Tuesday #21 - Yes, Today is Wednesday!
T-SQL Tuesday #21 - A Day Late and Totally Full of It
Holy Crap! What in the world are we talking about...
2011-08-10
1,856 reads
Telecommuting - Hype or Happening? - Making the Case to your Higher-ups
We've seen the argument before, that working from home, actually increases productivity. This is one of the major cases in...
2011-08-01
2,540 reads
NYC SQL Server User Group - this Thursday - SQL2K8 Audit Feature
Quick update. This Thursday, July 28, 2011 at the NYC SQL Server User Group at Microsoft HQ in NYC, SQL MVP...
2011-07-26
1,460 reads
The SQLSaturday Sensation - Celebrating the 100th Event!
The SQLSaturday Sensation!
Congratulations, Brazil! You are the recipient host country for SQLSaturday #100!! On Saturday, November 26, 2011, when the...
2011-07-19
2,435 reads
Event: NJSQL UG Tomorrow 7/19 - Management Data Warehouse
If you're in the local NY/NJ Tri-State area, and planning on attending, this is a reminder from the New Jersey...
2011-07-18
688 reads
Manic Monday......Notes from the field, Playing catchup
It's the beginning of the new work week, and as they say, it's Just Another Manic Monday....[Bangles].
I have a...
2011-07-18
1,115 reads
SQLSaturday #80 - Wheeling, West Virginia!
Next up, on the super SQLSaturday extravaganza, is SQLSaturday #80, in Wheeling, West Virginia! Wheeling, known as the friendly city,...
2011-07-12
1,001 reads
Meme Monday in July - PearlKnows All
It’s time for July’s Meme Monday, and below is my entry, Star date 07:11:11. Started by Twitter|@SQLRockstar, Thomas LaRock, today’s...
2011-07-11
1,248 reads
The Dog Died, and The Cat's on the Roof
Despite the title, this is a serious blog entry, dedicated to all you pet lover's out there. Although, I seek to...
2011-07-11
1,006 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