Can You Dig It? – The Plan Cache
She can dig it!
D Sharon PruittIn this new series of posts, I plan to investigate the SQL Server plan...
2010-12-08
830 reads
StrateSQL
December PASSMN Meeting
Getting SQL Server for
Christmas! Happy holidays and seasons greetings!
True to fashion, the Minnesota SQL Server User Group (PASSMN) is...
2010-12-06
351 reads
SQLRally Call for Presenters
Go SQL! Go SQL! I haven’t blogged about it until now. If you weren’t aware, there’s a new conference in...
2010-12-06
375 reads
The Next 24 Hours of PASS
Calling for Presenters!PASS has announced the next 24 Hours of PASS and it will be on March 15 and 16. ...
2010-12-02
286 reads
Blog Round-up – What Are You Thankful For?
Last week I suggested to others that we institute a little idea theft and put together a few blog posts...
2010-11-29
2,199 reads
Do You Protect Your Passwords?
Protect Your Password! As a consultant, I am frequently receiving new passwords at clients and becoming aware of the password...
2010-11-26
678 reads
What Am I Thankful For
Earlier this week, I suggested that we share a message of thanks on our blogs. Since I suggested we put...
2010-11-26
966 reads
XQuery for the Non-Expert – Resources
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
Learning XQuery...
2010-11-24
1,602 reads
XQuery for the Non-Expert – Exist
Follow the rest of this series at the XQuery for the Non-Expert – X-Query Resources introduction post.
Talk to the Experts
In the...
2010-11-23
2,137 reads
Cry, Baby, Cry! Failing the MCM Test
Two things happened to me this morning. First, I woke up and took the written test for the SQL Server...
2010-11-22
759 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