I’ve had lots of wish lists over the years, from Ladybug to Connect to UserVoice, and very few of my dreams ever come true. Still, it’s fun every once in a while, to be whimsical about the way I wished SQL Server worked. Especially in January because, you know, new beginnings.
2025-01-15
Learn how to avoid common pitfalls when using T-SQL trigonometric functions in SQL Server.
2025-01-13
2,777 reads
Learn how to implement data partitioning within Microsoft Fabric to improve performance for Lakehouses, Warehouses, and Pipelines.
2025-01-13
Learn how to resolve access denied errors when attaching databases in SQL Server. This guide explores file permission settings, focusing on the differences between Windows and SQL logins, and provides a step-by-step solution to prevent common attachment issues.
2025-01-10
814 reads
Recently, my skills were put to the test when I needed to compare hundreds of Active Directory and SharePoint Groups to find similarities in their memberships.
2025-01-10
In this next level, learn how you can load data from Amazon S3 in Fabric.
2025-01-08
3,087 reads
Learn about SQL Server OPTION RECOMPILE and if used on simple, frequently executed queries if it causes excessive CPU usage.
2025-01-08
Learn about the differences and challenges with implicit and explicit measures in Power BI.
2025-01-06
2,885 reads
What can be so difficult in creating a sensible standard for Structured Data Documents? To understand why they tend to get improved into unusable complexity, I’ll need to explain a bit of background.
2025-01-06
Learn the basics of the T-SQL STUFF command.
2025-01-03
2,931 reads
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
By DataOnWheels
Wow I am so late in posting these notes! But this conference was amazing,...
The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.
Comments posted to this topic are about the item Sparse Column Storage
Comments posted to this topic are about the item The Managed Cloud Database Options
Comments posted to this topic are about the item Stairway to Snowflake Level 6...
When does a column declared as SPARSE use no storage?
See possible answers