T-SQL Tuesday #62 - Achieving Healthy SQL with MDW
Today:
Tuesday, January 13, 2015 is the 62nd entry and first T-SQL Tuesday
of the year 2015, and I am honored to...
2018-03-27 (first published: 2015-01-13)
8,754 reads
Blog Posts
Women in Technology - All are welcome!
I was at SQL Saturday 723 in Rochester, NY last weekend. I was selected to deliver 2 sessions, and I...
2018-03-27
201 reads
Azure SQL Database and Cost Threshold for Parallelism
We all know that the magic figure for cost threshold for parallelism is 5 by default, meaning if the estimated...
2018-03-26 (first published: 2018-03-16)
2,328 reads
Backup and Restore Options for Azure SQL DB
I have decided to do a summary blog post on backup and recovery options for Azure SQL Database. If you...
2018-03-26
580 reads
Introducing The Blame Game
Introducing the Blame Game! Someone has messed up the new anatomy application’s (Mr. Body) performance and no one is willing...
2018-03-26
288 reads
Is the traditional data warehouse dead? webinar
As a follow-up to my blog Is the traditional data warehouse dead?, I will be doing a webinar on that very...
2018-03-26
536 reads
Is the traditional data warehouse dead? webinar
As a follow-up to my blog Is the traditional data warehouse dead?, I will be doing a webinar on that very...
2018-03-26
72 reads
Notes on SQLSaturday Tampa 2018
Quick notes:
Same location as previous years, good!Parking was same place, but it was confused by a pay-to-park event on the...
2018-03-26
282 reads
PROJECT LIFE LESSONS - # Not The GDPR News
PROJECT LIFE LESSONS - # Not The GDPR News
Mark Williams and myself will delivering a seminar called #Not the GDPR news in Cardiff on...
2018-03-26
319 reads
Query Store and Automated Cleanup
Query Store has mechanisms for automatically cleaning your data. It is possible to cause them to break down. While presenting...
2018-03-26
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