When Have You Used MOT Tables? T-SQL Tuesday #117
Steve Jones (b/t) is our host for T-SQL Tuesday and in case you didn’t know has taken over running T-SQL ... Continue reading
2019-08-13
224 reads
Blog Posts
Announcing a New Book: Query Store for SQL Server 2019
I’m pleased as punch to be able to share with you the fact that I helped Tracy Boggiano write a whole new book on Query Store. It will be...
2019-08-12
32 reads
Azure SQL Database Script for Size
Sometimes you may not want to flip over to the Azure portal to grab the database size, such as the used space below. So here is a handy script...
2019-08-12
25 reads
Execution Plans: Statistics
Watch this week’s Statistics video on YouTube. Last week we looked at what execution plans are and how you can view them. This week I want to discuss what data...
2019-08-12 (first published: 2019-07-30)
687 reads
Information Measurement with SQL Server Part 4.6: The Jaccard Distance and Its Relatives
By Steve Bolton …………Over the course of this inexpert exploration of the distance measures used for such data mining applications as clustering, we’ve gradually introduced a system of classification...
2019-08-12 (first published: 2019-07-29)
580 reads
sp_RestoreScript 1.5 Release
We’ve released sp_RestoreScript 1.5. This is only a minor release but adds the type of the backup file to the output. You can grab the latest version from our...
2019-08-12
16 reads
Azure SQL Database Elastic Scale Part 1 - What is Sharding?
Azure SQL Database Elastic Scale Part 1 - What is Sharding?MARCH 19, 2015
This week, Microsoft introduced an update to Azure SQL...
2019-08-09 (first published: 2015-03-19)
15,590 reads
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the Shards
Azure SQL Database Elastic Scale Part 3 - Setting up and Querying the ShardsMAY 28, 2015
For those of you who have...
2019-08-09 (first published: 2015-05-28)
4,112 reads
Dynamic Data Masking
Dynamic Data MaskingFEBRUARY 26, 2015
Have you ever wanted to only show parts of a field to certain sets of users...
2019-08-09 (first published: 2015-02-26)
8,870 reads
Fantasy Football - A League of Our Own - Want to Play?
It feels daft me saying the football season is only 9 days away, when in fact The Ashes cricket series is only starting today at Edgbaston. The Ashes are...
2019-08-09 (first published: 2019-08-01)
338 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