Presenting at Global Azure Virtual Day 2020 Omaha
I’m thrilled to be presenting along side of some industry greats at the upcoming Global Azure Virtual Day on April 25th as part of the Omaha users group. The...
2020-04-16
10 reads
Blog Posts
Tech Chat with a Microsoft MVP Data Platform
I figured it would be nice to start up a weekly chat while everyone is on lock down. If it goes well I’m up to make this a regular...
2020-04-16
30 reads
A Smattering of Thoughts About Applying Site Reliability Engineering principles
What's This about
I figured I'd go ahead and take this article which I've gutted several times and share some thoughts, even if it's not an authority on the topic....
2020-04-15 (first published: 2020-04-05)
295 reads
Daily Coping 15 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-15
15 reads
Remember this if you want to use sp_
Erik Darling, of Erik Darling Data (blog | Twitter) recently posted a very interesting video (my YouTube playlist is all Erik Darling Data videos and Honest Trailers). In this...
2020-04-15
20 reads
SSMS 18.5 Fixes from Redgate
I wrote yesterday about the issues with SSMS 18.5 and some of the add-ins from Redgate. I posted the release of the SQL Prompt fix (here: ). The teams...
2020-04-15 (first published: 2020-04-09)
1,777 reads
A culture of testing : T-SQL Tuesday #125
Happy T-SQL Tuesday again! Number 125. I can’t believe how long this thing has been running. In case you weren’t ... Continue reading
2020-04-14
16 reads
Daily Coping 14 Apr 2020
I’ve started to add a daily coping tip to the SQLServerCentral newsletter, which is helping me deal with the issues in the world. I’m adding my responses for each...
2020-04-14
40 reads
Disks performance in Azure
In our earliest post, we have discussed in detail about the factors that affect the disk performance and different types of disk offerings in the AWS platform. In this...
2020-04-14 (first published: 2020-04-05)
1,955 reads
Importance of Basics
Riding a bicycle
Imagine riding a bicycle and having zero knowledge how the handlebars are used for direction, how the brakes are applied for friction, how the pedals are used...
2020-04-14
42 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