Stairway to Snowflake Level 6 - Creating and Cloning Snowflake Databases
In this next level of the Stairway to Snowflake, learn about creating and dropping databases, with some options for cloning from different sources.
In this next level of the Stairway to Snowflake, learn about creating and dropping databases, with some options for cloning from different sources.
You have a number of options for moving your database to the cloud, but Steve has a few things you might want to consider before you do so.
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.
Learn how to avoid common pitfalls when using T-SQL trigonometric functions in SQL Server.
Choice is good, but too much choice can cause problems in both coffee shops and software teams, as Steve notes today.
Learn how to implement data partitioning within Microsoft Fabric to improve performance for Lakehouses, Warehouses, and Pipelines.
Yeah, I know, holidays are over. It snowed about four inches overnight here and it's still coming down a little. You'll forgive me for having that song running through my head. Yesterday morning, before the storm started, we did a check through the house to make sure we were ready for a couple of days […]
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.
There have been a number of changes to the T-SQL language that are very specialized. Steve asks if you use any in your code?
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.
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