Among Giants
Since becoming a Database Administrator I’ve always looked at Microsoft MVP’s as the giants in our field. I never once...
2017-04-05
329 reads
SQLEspresso
Lone DBA Podcast
I recently had the pleasure of being a guest on a Podcast episode with the SQL Data Partners Carlos Chacon...
2017-04-03
351 reads
Trouble Shooting Little Jewel
I didn’t know about this little gem, so I shared it with my team and they didn’t know about it...
2017-03-29
703 reads
Ooops! Was that me? (Blog Challenge)
We have all made mistakes in our careers, I thought I’d share one of mine as a quick tip to...
2017-01-10
552 reads
Run Book, Run!!!
How many of you actually have a “Hit-by-the-Bus” handbook? What is that, you ask? It is a document that explains...
2016-12-21
1,225 reads
Hide and Group Columns in SSRS Using a Parameter
Ever had users come to you and request another version of a report just to add another field and group...
2016-12-09
605 reads
T-SQL Tuesday #84 – Helping New Speakers
Ok everyone; here goes my first crack at replying to a T-SQL Tuesday. For those that don’t know what it...
2016-11-08
202 reads
Challenge Accepted
My life for the last 2 years has been a constant battle of putting out fires with system performance; finally...
2016-09-14
296 reads
This Idera ACE Has Been Busy
This year has been a whirlwind so far, thanks to the Idera ACE program. For those that don’t know what...
2016-08-23
289 reads
Summit Submission Feedback Response
I’m It Survival Tips for the Lone DBA – Level 100
(Not Accepted: Higher rated session selected)
Track: Professional Development
As others have done I...
2016-06-28
218 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