Free Subscriptions to Visual Studio Magazine
First time I've noticed this being offered, saw it posted on the Orlando .Net Users Group (ONETUG) site. Sign up...
2008-01-21
1,443 reads
SQLAndy
Learning to Blog via Books
I was chatting with a friend recently and in the course of 'what are you up to lately' I mentioned...
2008-01-20
485 reads
Connecting to a Reporting Services Model
There's always been some confusion about models in Reporting Services, many people ignore them thinking that they are only for...
2008-01-18
1,558 reads
Free Ebook Chapter(Book) - Introducing SQL Server 2008
Saw it mentioned in the recent MSPress newsletter, Peter DeBetta is writing Introducing SQL Server 2008 and right now Chapter...
2008-01-18
860 reads
MS Making .Net Framework Source Code Available
Scott Guthrie posted the announcement on his blog today. It's a 'read only' license with a few other limitations, but...
2008-01-17
757 reads
Partitioning Part 4 Posted on SSC
Partitioning Part 4 concludes the series with a look at 'real' partitioning in SQL 2005 Enterprise Edition. Overall the series...
2008-01-17
558 reads
Sun Acquires MySQL
Just posted on Jonathan Schartz's blog. They've definitely been playing more in the open source arena, now they've got a...
2008-01-16
641 reads
Upcoming Presentations
I'll be attending the South Florida Code Camp on Feb 2 and also SQLSaturday Tampa on Feb 16th. For both...
2008-01-16
522 reads
E-Readers, Will They Ever Take Off?
I was discussing the Kindle recently with business partner Steve Jones and while we both like the idea of having...
2008-01-14
484 reads
Evaluating Speakers at Events
Speakers tend to live for the evals. Hopefully it's a validation of work done well after a lot of time...
2008-01-09
912 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