C-R-U-D The Basics
C-R-U-D The Basics
What is CRUD? Well, there are a lot of things I can think of when I use the...
2014-10-09 (first published: 2014-10-01)
8,119 reads
Blog Posts
Fixing SCOM After a Hardware Upgrade
Quick note in case I need again some day. The team recently moved all the user databases for a monitoring...
2014-10-09 (first published: 2014-10-02)
6,009 reads
Speaker of the Month: October 2014
I saw a whole bunch of great sessions last month. I was all over the place from Las Vegas to...
2014-10-09
547 reads
SQL in the City 2014 – Two countries in two weeks
I have had a fairly busy travel schedule the last few years. While I don’t love sitting on airplanes and...
2014-10-09
702 reads
Temporary Post Used For Theme Detection (919ceef8-1031-4873-93f5-7a833585812f – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
This is a temporary post that was not deleted. Please delete this manually. (e5bad5db-3b7d-4641-ba91-15ab900e8f70 – 3bfe001a-32de-4114-a6b4-4005b770f6d7)
2014-10-09
417 reads
Common Table Expressions (CTE)
Common Table Expresseion (CTE)
A common table expression (CTE) is a derived table that is defined and only stored for the...
2014-10-08 (first published: 2014-10-03)
9,016 reads
Fill Factor vs Page Splits – Measure It..!!
I have been trying to solve the puzzle of “How to evaluate my current Fill Factor setting?”, and there have...
2014-10-08
1,324 reads
Learning About Journalism
One of my current projects is PASSWatch. Right now it’s mostly aggregation which I think has value, but I hope...
2014-10-08
874 reads
Notes on SQLSaturday Admin Tools
Introduction
One of the items I’ve had on my todo list for a while is to write up notes on the...
2014-10-08
745 reads
October 2014 Las Vegas UG Meeting
The Las Vegas User Group is happy to announce our monthly meeting. The meeting is available for in person and...
2014-10-08
626 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
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:...
Creating JSON III
Comments posted to this topic are about the item Creating JSON III
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