Connecting Streamlit to Upload Data to Snowflake
How to create a connection for StreamLit and Snowflake to upload data for visualization
Data Warehouse Considerations - SCD Type 2 vs Overwrite Dimension Tables
How we handle data warehousing updates to dimension tables is crucial and this article covers Slowly Changing Dimensions versus overwriting tables.
The ROI of SQL Prompt
Find your personal ROI in under 1 minute. And see how many working days you and your team could save in coding time with SQL Prompt!
Big Data or Small Data
Today Steve talks about big data sets and whether we really need them, or even enjoy working with them.
Level 4 of the Stairway to Synapse Analytics: Create and Use a Delta Lake
Introduction In Level 1 of this series, I discussed Synapse Analytics basics and the steps for creating the Synapse Workspace. In Level 2, we analyzed Data Lake files using the Serverless SQL Pool. In Level 3, we analyzed Data Lake files using the Spark Pool. In Levels 4 and level 5, I will discuss the Delta […]
Save the date for PASS Summit 2025!
PASS Data Community Summit will return to Seattle next year! Save the date for this incredible in-person event for global data professionals, which will take place at Summit, Seattle Convention Center, from November 17-21, 2025!
Why a Self-Join Requires Halloween Protection
I was asked recently why Halloween Protection was needed for data modification statements that include a self-join of the target table. This gives me a chance to explain, while also covering some interesting product bug history from the SQL Server 7 and 2000 days.
Feed SQL Server logs into SIEM
Keeping track of all the security related logs can be hard. Using your security team to shoulder some of the load can help. Learn how in this article.
Blogs
T-SQL Tuesday #182: Personal Integrity
By Steve Jones
It’s time for the first T-SQL Tuesday blog of 2025, with an invite from...
SQL Saturday Oregon & SW Washington 2024
By DataOnWheels
Wow I am so late in posting these notes! But this conference was amazing,...
Challenges Enterprises Face When Adopting AI
The post Challenges Enterprises Face When Adopting AI appeared first on Joyful Craftsmen.
Forums
Sparse Column Storage
Comments posted to this topic are about the item Sparse Column Storage
The Managed Cloud Database Options
Comments posted to this topic are about the item The Managed Cloud Database Options
Stairway to Snowflake Level 6 - Creating and Cloning Snowflake Databases
Comments posted to this topic are about the item Stairway to Snowflake Level 6...
Question of the Day
Sparse Column Storage
When does a column declared as SPARSE use no storage?
See possible answers