What the Exec?
I’ve been working with SQL Server for 10 years and have worked in production with versions 6.5 – 2005 and used...
2010-01-28
672 reads
Jack Corbett
- Interests: Sports, books, Bible
SQLSaturday 32 – Tampa Recap
I had the privilege to attend and speak at SQLSaturday 32 – Tampa this past weekend. As I said in my...
2010-01-24
557 reads
SQLSaturday #32 – Tampa
Just a reminder that SQLSaturday #32 – Tampa is taking place this weekend (January 23rd). This will be my 5th SQLSaturday...
2010-01-21
336 reads
Three Events that Brought Me Here
Paul Randal started the latest community chain blog, What three events brought you here?, and I was tagged by Steve...
2010-01-19
637 reads
Accidental DBA?
It seems to me that over the last year or so that there has been an explosion in the use...
2010-01-18
648 reads
Broadcasting OPASS over Live Meeting
Well, on January 12th OPASS moved into the present by broadcasting our meeting over the internet using Live Meeting. Our...
2010-01-14
477 reads
January OPASS Meeting Tonight
Tonight is the January meeting for OPASS and we have a great schedule for the evening.
Robert Hurwitz a developer for...
2010-01-12
382 reads
Video Featured on SQLShare
I didn’t have a chance to blog this yesterday (January 11, 2010), but my most recent video, Dynamic SQL Using...
2010-01-12
477 reads
Would Third-party Product Driven/Vendor Sessions Benefit User Groups and Community Events?
In the the couple of years I have been involved in the SQL Server community I have noticed that there...
2010-01-12
786 reads
2010-01-12
667 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