Sorkin On Writing
I saw this write up about Aaron Sorkin and the writing on Newsroom just after posting Blogging-Write More and found...
2014-04-28
638 reads
SQLAndy
Another Question Of the Day
Yesterday I submitted a new question of the day based on the best idea generator you can find – something that...
2014-04-24
562 reads
Blogging-Write More
Blogging isn’t easy. You have to come up with a topic, write about it, and then release it for the...
2014-05-02 (first published: 2014-04-22)
1,492 reads
Notes From The April 2014 oPASS Meeting
Same room but different seating arrangement. Instead of separate table pushed some together, used the space better and more a...
2014-04-21
519 reads
oPASS Tonight! (April 17, 2014)
I’m presenting tonight at oPASS, two presentations worth! If you’re in Orlando I hope you’ll attend, details at http://orlando.sqlpass.org/.
2014-04-17
530 reads
Kevin Kline at MagicPASS Tonight (April 16, 2014)
Kevin Kline is speaking at MagicPASS tonight – on two topics! If you’re in the Orlando area I hope you’ll try...
2014-04-16
533 reads
Farewell Brook Ranne
For members of the SQL community in Orlando and Chicago you’ve probably heard that Brook Ranne died on March 29,...
2014-04-15
689 reads
SQLServerCentral Editorial: Doing What It Takes To Get The Job Done
I wrote Doing What It Takes To Get The Job Done about a conversation with my nephew working late to...
2014-04-15
438 reads
Writing a Question Of The Day–More Notes
Today I wrote another question based on an error message. I included the error message in the question this time...
2014-04-15
485 reads
It’s Not All About The Keys–Question Of The Day
My latest question is live today, called It’s Not All About The Keys. It’s a three pointer, if score matters...
2014-04-14
437 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