Friday Followup For July 4, 2014
It’s Friday, time to look back at the most popular RealSQLGuy posts of the week. Because it’s Friday and you’re...
2014-07-04
367 reads
Blog Posts
Happy Birthday, America!
IN CONGRESS, July 4, 1776.
The unanimous Declaration of the thirteen united States of America,
When in the Course of human events,...
2014-07-04
643 reads
Happy Independence Day America and 10 Years Packt Publishing!
If you are in the USA, I hope you take some time today to enjoy your family and friends and...
2014-07-04
657 reads
Reblog: June 27 to July 3
Photo credit – JStove
Old posts are like unicorns. You might see them just once, but it’d sure be nice to have...
2014-07-04
889 reads
Speaking at SQL Server Days 2014
I am absolutely delighted to share the great news that I have been selected as one of the speakers for...
2014-07-04
626 reads
Community and Commitment
If it were not for the SQL Server community, I would not be where I am at with my career...
2014-07-03
738 reads
Executing scripts on multiple servers the easy way
Central Management Server and server groups provide a convenient way to manage multiple servers and databases in one place and at...
2014-07-03
2,376 reads
Feedback on My Abstracts
Here’s the raw feedback from my submissions for the Summit. To those who wrote the feedback for me (and all...
2014-07-03
702 reads
How Critical is a Demo?
Do you always need a demo?
Is a demo always needed?
One of my more popular presentations I have been doing as...
2014-07-03
667 reads
Iterating JSON data using Jquery
“JSON” (Javascript Object Notation) is Open standard to transmit data between endpoints. It is light weighted than XML, that’s why...
2014-07-03
3,465 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