2020-07-24
87 reads
The Lighter Side
2020-02-21
752 reads
Unreliable Data Sensors
Steve doesn't like the idea of cars using data from cameras to update a display instead of a mirror.
2019-09-30
195 reads
NASA officially orders its first segment of a lunar space station
"This time when we go to the Moon, we're actually ...
2019-05-23
2019-05-10
Pop Quiz: SQL 2000 Bug or SQL 2017 Bug?
Brent Ozar asks if you can tell if each of these SQL Server bugs is brand-new, or almost 20 years old.
2019-05-03
Massachusetts offshore wind project gets green light at roughly 8.9 cents/kWh
The Vineyard Wind project will also commit $15 million to battery development.
2019-04-24
These are the best new vehicles of the 2019 New York International Auto Show
American auto shows are in decline, but we still found a few things to excite.
2019-04-22
The Porsche Panamera Turbo Sport Turismo—to hybrid or not to hybrid?
The Panamera Turbo comes in two flavors, and the more powerful one is a hybrid.
2019-04-11
T-SQL Tuesday #113: A year of marriage and boardgames
This week’s T-SQL Tuesday is about where you use databases in your personal life. And I have a database I don’t use any more that’s a little happy and...
2019-04-09
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