Finding a Break
A year of remote work has made life hard, and harder to get a break from the same environment you are in most of the time.
2021-04-16
82 reads
Editorials
2021-04-15
182 reads
2021-04-14
58 reads
2021-04-13
182 reads
Easing Back to the Office
Companies are starting to bring people back to the office. Microsoft has announced their policy, and Steve wonders if more will follow.
2021-04-12
123 reads
2021-04-10
123 reads
2021-04-09
142 reads
2021-04-08
232 reads
Growing Outside of the English World
The world is bigger than one country, and Steve is trying to remember that.
2021-04-07
82 reads
Removing SA from Azure SQL Database
Azure SQL Database is getting the ability to turn off SQL authentication.
2021-04-06 (first published: 2021-03-23)
833 reads
Blogs
SQL Server Journey till 2025 (brief)
By Vinay Thakur
Quick Summary for Microsoft SQL Server till 2025, I am fortunate to be part...
Building Power BI Reports: Desktop vs Fabric
By James Serra
Why this comparison feels confusing If you’re a Power BI report author who’s just...
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...
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