Haunting a Database Near You
Today, we have a special Halloween edition. For me, Halloween and computer geek go quite well together. And thinking about it, I wanted to try to better understand if...
2011-10-31
2 reads
Jason Brimhall
Haunting a Database Near You
Today, we have a special Halloween edition. For me, Halloween and computer geek go quite well together. And thinking about...
2011-10-31
1,918 reads
October 2011 LV UG Meeting Update
This is a republish due to a last minute change!!!
We had to reschedule the October meeting due to unforeseen circumstances....
2011-10-18
504 reads
October 2011 LV UG Meeting Update
This is a republish due to a last minute change!!! We had to reschedule the October meeting due to unforeseen circumstances. The only change is the date of the...
2011-10-18
5 reads
An Interesting Sort
I just came across a pretty peculiar sort requirement. The requirement made me sit and think a bit. Since it was somewhat peculiar, I decided I would share the...
2011-10-12
4 reads
An Interesting Sort
I just came across a pretty peculiar sort requirement. The requirement made me sit and think a bit. Since it...
2011-10-12
646 reads
Reach for the Select *s
Do you have your head in the clouds?
Have you wanted to take flight?
Have you been called “Space Case”
If you are...
2011-10-12
724 reads
Reach for the Select *s
Do you have your head in the clouds? Have you wanted to take flight? Have you been called “Space Case” If you are a DB Professional, then all of...
2011-10-12
5 reads
October 2011 LV UG Meeting
Boo! OK, so it really isn’t that scary. But it is that time of year and we happen to have something that could fix something that might be scary....
2011-10-11
4 reads
October 2011 LV UG Meeting
Boo!
OK, so it really isn’t that scary. But it is that time of year and we happen to have something...
2011-10-11
717 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