2022-10-14
167 reads
Editorials
Code Supply Chain Security
Building software is becoming harder as new attacks try to inject malicious code into products.
2022-10-12
121 reads
Things I've Learned About the Cloud
Steve shares a few things he's learned from customers trying to migrate their systems to cloud computing platforms.
2022-10-10
235 reads
Learning New Technology Is Challenging
On nights and weekends, I've been playing with Arduino controllers. I have a couple of projects I'm working through (building a robot that can roll around with "eyes" to avoid obstacles). I've also been trying to work with STM32 controllers, because in a lot of ways, they're more powerful than an Arduino. However, I've hit […]
2022-10-08
154 reads
Assembling Your Own Toolbox
Building a toolbox of useful scripts and code is important for any technology professional.
2022-10-07
269 reads
The Value of Seniority
Some people might seem like they are from the future, but their experience is just shining through.
2022-10-05
172 reads
The Growth of IQP
Steve talks about some of the Intelligent Query Processing improvements in SQL Server 2022.
2022-10-03
259 reads
How Important is Software?
The user experience from our software is important. Maybe more than many developers realize.
2022-10-01
61 reads
Cloud Databases
There are advantages of cloud databases when your workload requirements grow. Steve thinks it's useful to learn a bit about the options out there.
2022-09-30
544 reads
The Right Connection
Making a connection to the wrong database had disastrous results for Travis-CI.
2022-09-28 (first published: 2018-04-19)
233 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