Implementing ETL Logging on Lakehouse using Delta Lake's Time Travel capability
In this article I demonstrate how to use Delta Lake's time travel functionality for ETL logging along with steps to take to implement.
The VALUES clause or building tables out of nothing
The VALUES clause makes inserting literal values into a table simple and easy. In this article, Joe Celko explains how to use the VALUES clause.
Returning To An Employer
Leaving an employer on good terms is important, and Steve thinks employers ought to consider hiring former employees, even if they were let go in a layoff.
Stairway to Columnstore Indexes Level 2: Columnstore Storage
To fully appreciate just how different columnstore indexes are, and why work so well in reporting and online analytical processing (OLAP) workloads, but not for online transaction processing (OLTP), we must first look at the traditional “rowstore” indexes.
How to tell what SQL Server versions you are running
Check out this tip to easily find out what version of SQL Server you are running.
SQL Monitor: On-demand demo [Watch now]
Haven't seen SQL Monitor in a while? If you'd like to see how it enables you to always have the answers to the health of your estate, and proactively find potential problems before they impact your users, here's a 30 minute demo for you to watch whenever it suits you.
Security in MySQL: Part One
There are several tools available to keep a MySQL database secure. In this article Lukas Vileikis discuses access control and user privileges.
SQL Database Snapshots for Reporting, Auditing and Data Recovery
In this article we look at how to create a SQL Server database snapshot and how snapshots can be used for reporting, auditing and more.
Blogs
Claude AI Convinced Me Not to Build an iPad App
By Steve Jones
I coach volleyball and I do a lot of stat stuff on paper. I...
A New Word: Dolorblindness
By Steve Jones
dolorblindness – n. the frustration that you’ll never be able to understand another person’s...
Claude Code Helps Analyze Test Data Manager Log Files
By Steve Jones
I had a customer ask about analyzing their Test Data Manager (TDM) usage to...
Forums
Data Warehouse Toolkit meets Star Schema: The Complete Reference
Is there a good syllabus for reading these two together? (Yes, it's called the...
GPX distance and time analysis in SQL Server
Comments posted to this topic are about the item GPX distance and time analysis...
The DBA is Dead; Long Live the DBA
Comments posted to this topic are about the item The DBA is Dead; Long...
Question of the Day
Changing the AG Listener
In SQL Server 2025, if I want to remove an IP from a listener, what do I do?
See possible answers