Looking Back: 2016 was Awesome!
With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit...
2017-01-05
429 reads
John Sterrett
Looking Back: 2016 was Awesome!
With 2017 starting this week I would like to take a moment and reflect on 2016. I have to admit that 2016 was a great year for many different...
2017-01-05
7 reads
Three Reasons Why I Am Attending PASS Member Summit 2016
Three reasons why I am attending PASS Member Summit in 2016
Over the past few weeks, I saw on social media...
2016-10-26
471 reads
Benchmark Azure SQL Database Wait Stats
Today, I want to focus on how we can monitor wait statistics in an Azure SQL Database. In the past,...
2016-08-30
1,019 reads
Calculating DTU in Azure SQL Database
A few months ago, I posted a question over on ask.sqlservercentral.com. In a nutshell, it was how do you measure...
2016-09-06 (first published: 2016-08-24)
2,565 reads
Azure SQL Database Live Migrations
Unfortunately, with Azure SQL Database you are not able to take an existing SQL Server Backup and restore it on...
2016-08-01 (first published: 2016-07-26)
2,260 reads
I am a Microsoft Data Platform MVP
My First Microsoft SQL Server MVP Award
Today, I have achieved an SQL Someday moment. I am excited to share some exciting...
2016-07-01
584 reads
Automatic Seeding Very Large Databases in SQL Server 2016
There are a lot of new features in SQL Server 2016. Availability Groups by itself got a lot of new...
2016-07-12 (first published: 2016-06-29)
3,328 reads
Automating Azure Resource Management Authentication
I love Azure and I love PowerShell. They are a perfect marriage. It’s amazing how much automation you can do...
2016-06-23
510 reads
3 Reasons to Attend SQL Saturday Austin on Jan 30th
The Austin SQL Server User Group will host its third SQL Saturday on Saturday,
SQL Saturday Austin on January 30th, 2016
January...
2016-01-12
470 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