S3OLV update and Reminder
We are now just a few days away from our first meeting of 2012. We have some good content lined...
2012-01-09
640 reads
SQL RNNR
S3OLV update and Reminder
We are now just a few days away from our first meeting of 2012. We have some good content lined up. Check it out here. I am looking forward...
2012-01-09
6 reads
Meme Monday January 2012
Meme Monday was pushed back this month to the second Monday of the month. That is a good thing or...
2012-01-09
562 reads
Meme Monday January 2012
Meme Monday was pushed back this month to the second Monday of the month. That is a good thing or maybe a bad thing or maybe a non-discussion at...
2012-01-09
3 reads
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a...
2012-01-04
900 reads
Daemon
At the recommendation of Jorge Segarra (Blog | Twitter), I got the book Daemon. Well, I actually got that about a year ago as a gift – but it...
2012-01-04
7 reads
Thoughts on SSSOLV December Meeting
This is very late – I know. The meeting was held on December 8, 2011 and I haven’t yet shared my...
2011-12-30
1,474 reads
Thoughts on SSSOLV December Meeting
This is very late – I know. The meeting was held on December 8, 2011 and I haven’t yet shared my recap/thoughts about the meeting. We hold the SQL...
2011-12-30
3 reads
January 2012 Las Vegas SQL UG
This month I am attempting to get a jump on things a bit. I am hoping to get the info...
2011-12-30
1,690 reads
January 2012 Las Vegas SQL UG
This month I am attempting to get a jump on things a bit. I am hoping to get the info out in a more timely fashion throughout this new...
2011-12-30
5 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