Book Review: SQL Server 2008 Query Performance Tuning Distilled
I recently finished reading the Apress book SQL Server 2008 Performance Tuning Distilled by Grant Fritchey and Sajal Dam. I...
2010-01-07
1,341 reads
Jack Corbett
- Interests: Sports, books, Bible
2010-01-04
757 reads
Final Recap – 2009 Goals
Well, I set 7 professional goals for 2009 and I did okay in meeting them, but I was not successful...
2009-12-31
1,385 reads
Presenting a Live Meeting vs. a Real Meeting
I recently had the opportunity to present, Nuggets Found by Mining the Default Trace, for SQLLunch. This was my first...
2009-12-28
342 reads
OT: What Christmas Means to Me
Merry Christmas to everyone. As many of you know, at least I hope you do, I am a born-again Christian...
2009-12-24
352 reads
Speaking at SQLSaturday #32 – Tampa
I just found out that I’ve been accepted to speak at SQLSaturday #32 – Tampa on January 23, 2010. My session...
2009-12-23
372 reads
SQLLunch Resources – Mining Nuggets from the Default Trace
I did my first SQLLunch today and it was fun. I don’t know how many attended, my last look was...
2009-12-21
351 reads
Have Lunch with Me
I know you all are clamoring for the opportunity to have lunch with me so I agreed to do a...
2009-12-18
340 reads
Where’d the Data Go?
The Reported Problem
A few weeks ago I was contacted by a former employer because an SSRS report I had written...
2009-12-17
404 reads
What is Your Biggest Weakness?
I was tagged by Ken Simmons (@kensimmons) in the blog chain started by David Stein (@made2mentor). Here’s Ken’s post and...
2009-12-14
506 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