Audit Configuration Changes
Do you know the last time a Server Property was changed on your instances of SQL Server? Are you wondering when the setting for max degree of parallelism was...
2013-01-24
7 reads
Jason Brimhall
Last Time CheckDB was Run
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of a database. You can read that story here. This...
2013-01-17
4 reads
Last Time CheckDB was Run
Back in November 2012, I shared a story about checking the last known good checkdb in the boot page of...
2013-01-17
1,232 reads
T-SQL Tuesday #38 Recap
This is the wrap up for TSQL Tuesday #38. We had a good turnout this month with some new faces...
2013-01-15
998 reads
T-SQL Tuesday #38 Recap
This is the wrap up for TSQL Tuesday #38. We had a good turnout this month with some new faces and with some regulars. In total, we had 22...
2013-01-15
6 reads
January S3OLV 2013
I hope you are ready for some free SQL learning. Coming up on Thursday January 10th at 6:30 PM Pacific (GMT – 8 ) we will have a stellar...
2013-01-09
2 reads
January S3OLV 2013
I hope you are ready for some free SQL learning. Coming up on Thursday January 10th at 6:30 PM Pacific...
2013-01-09
840 reads
A Firm Foundation
Last week I sent out an invite for the monthly TSQL Tuesday party.
The theme for the party is a take...
2013-01-08
1,144 reads
A Firm Foundation
Last week I sent out an invite for the monthly TSQL Tuesday party. The theme for the party is a take on the words resolve or resolution. I was...
2013-01-08
7 reads
Fast Starts
We are barely under way with the New Year and it is shaping up to be a busier year already. Not quite as busy as has been published by...
2013-01-08
1 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