Immersion in Internals
Paul Randal (Blog | Twitter) and Kimberly Tripp (Blog | Twitter) of SQLSkills are hosting an Immersions training event in Dallas. This is not...
2011-01-26
972 reads
Jason Brimhall
SQL Confessions 02 SSRS Encryption
In December 2010, I started a little series called SQL Confessions. The idea of this series is as a learning exercise when I come across something that I either...
2011-01-25
9 reads
SQL Confessions 02 SSRS Encryption
In December 2010, I started a little series called SQL Confessions. The idea of this series is as a learning...
2011-01-25
651 reads
The Lost Hero – A review
With what looks to be five books planned in a new series by Rick Riordan, people have some good fantasy ahead of them. I just finished the first installment...
2011-01-25
4 reads
The Lost Hero – A review
With what looks to be five books planned in a new series by Rick Riordan, people have some good fantasy...
2011-01-25
544 reads
January 2011 Meeting Recap
One week ago today the Las Vegas User group held our monthly meeting. One week ago today, at that meeting, we had our best attendance in over a year....
2011-01-20
6 reads
January 2011 Meeting Recap
One week ago today the Las Vegas User group held our monthly meeting. One week ago today, at that meeting,...
2011-01-20
513 reads
January ’11 Meeting Reminder
If you saw my blog post the other day, you know that S3OLV has a meeting this Thursday (Jan 13, 2010) at 6:30 PM PST. If not, then you...
2011-01-13
5 reads
January ’11 Meeting Reminder
If you saw my blog post the other day, you know that S3OLV has a meeting this Thursday (Jan 13,...
2011-01-13
468 reads
January 2011 S3OLV
Tis the calm before the storm. At least it feels like that. The invites have all been sent. The presenter lined up. Reminders have been sent and now we...
2011-01-11
4 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