Speaking about BIML at the SQL Server Days 2013
I’m very thrilled to be selected again as a speaker for the sixth edition of the SQL Server Days! The...
2013-10-15
416 reads
Blog Posts
SQL Server Diagnostic Information Queries for October 2013
I have made some minor updates and bug fixes for all of my SQL Server Diagnostic Information Queries for this...
2013-10-15
1,316 reads
SQL Server Performance Root Cause Analysis in 10 Minutes
This year I was honored to be selected by Dell Software to present a ten minute session in their booth...
2013-10-15
1,093 reads
What Queries are Causing My Waits?
In my last blog post, I showed you how I go about baselining wait statistics. Typically my next step once...
2013-10-15 (first published: 2013-10-10)
4,260 reads
Finding Top Offenders From Cache
When I start a SQL Server Performance Root Cause Analysis I like to find the top waits and then find...
2013-10-14
1,372 reads
Last Weeks Top “Reading” Links #53
Monday morning and it’s time for weekly round-up. If you follow me on twitter (@StrateSQL), you’ll know that throughout the day I tweet...
2013-10-14
759 reads
My PASS Summit Schedule this Week
Well, it is here folks. The PASSSummit 2013. If you have never been to a PASS Summit, please look in...
2013-10-14
609 reads
Networking Dinner at the 2013 PASS Summit–Tonight!
Tonight for the fourth year Steve Jones and I are hosting an informal networking dinner. We’ll be at Buffalo Wild...
2013-10-14
379 reads
PASS Summit 2013 Report #1
Yesterday we drove up from Charleston where I had attended SQLSaturday #227. It’s not a bad drive, about three hours....
2013-10-14
313 reads
SQL Server – Understanding Allocation Units – In Row Data, LOB Data & Row Overflow Data
Before we get started on this topic, here is a quick fact..in SQL Server 2000, there used to be hard...
2013-10-14
1,139 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