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.
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.
Build a Streaming Data Architecture with Apache Kafka and Zookeeper
In this article, we look at how to use Apache Kafka and Zookeeper to process and load streaming data.
Do As I Say, Not As I Do
Yesterday morning I sat down to start a new project. Before I got started, I knew I needed to put this in source control. Now, the project was going to be in AWS, but, AWS has shut down their flavor of Git, CodeCommit. I decided to use GitHub instead, no big deal. Well, until I […]
Blogs
Monday Monitor Tips: The Jobs Report
By Steve Jones
A customer wanted a report they could email to their boss about jobs, something...
Automating SQL Maintenance: How DevOps Principles Reduce Downtime
By Chris Yates
In the world of modern data infrastructure, SQL databases remain the backbone of enterprise...
From Couch-Potato to Triathlete – and What This Means for Your SQL Server
Do you know if your SQL Server is really running at its best? To...
Forums
Find Invalid Objects in SQL Server
Comments posted to this topic are about the item Find Invalid Objects in SQL...
Single User SQL Server on Linux
Comments posted to this topic are about the item Single User SQL Server on...
All the Costs of Downtime
Comments posted to this topic are about the item All the Costs of Downtime
Question of the Day
Single User SQL Server on Linux
How can I start SQL Server on Linux in single-user mode to restore the master database?
See possible answers