ETL Logging
If you were to poll data professionals on which tasks they enjoy working on the most, ETL logging would probably...
2016-03-22 (first published: 2016-03-14)
2,405 reads
Tim Mitchell
- Interests: SQL Server, Data Warehousing, ETL, Data Architecture, Python, Dbt
- Website: https://www.TimMitchell.net
- Bluesky: tmitch.net
Polishing The Silverware
A few weeks ago I met a couple of my business partners in a moderately upscale restaurant in the Washington,...
2016-03-08
394 reads
Change Tracking for Data Warehouse Loads (Webinar)
For data warehouse professionals, data change detection is is a central part of what we do. Accurately detecting new, changed,...
2016-03-01
596 reads
Using Custom File Delimiters in SSIS
File-based ETL is usually dull. Most systems generate (or expect to consume) files that are delimited, with a common field...
2016-02-16 (first published: 2016-02-05)
2,700 reads
Using SQL Server Change Tracking for Incremental Loads
Earlier this week I wrote about the basics of change tracking in SQL Server, and showed how to get started...
2016-01-28 (first published: 2016-01-20)
3,013 reads
Using Change Tracking in SSIS
Recently, I wrote about how to get started with SQL Server change tracking, and I demonstrated a design pattern I...
2016-01-22
2,674 reads
Getting Started with Change Tracking in SQL Server
Change tracking for SQL Server is a flexible and easy-to-use technology for monitoring tables for inserts, updates, and deletes. In...
2016-01-18
1,085 reads
New Gear: Lenovo Yoga 900
For several months I’ve been eyeing a replacement for my aging Surface Pro 2. Although I’ve been pretty happy with...
2016-01-11 (first published: 2016-01-06)
2,427 reads
Technical Dogma
Humans are creatures of habit, and I suspect that engineering/technical types are even more so. We find something that works...
2016-01-04
453 reads
The Discomfort Zone
Over the Thanksgiving holiday, I read a book entitled The Phoenix Project. This book has been in my Kindle library...
2015-12-04 (first published: 2015-12-01)
1,534 reads
Blogs
T-SQL Snapshot Backups on Availability Group Secondary Replicas
One of my favourite features of SQL Server 2022 was the T-SQL Snapshot Backups....
The Book of Redgate: Hours
By Steve Jones
I have said and written this many times: Redgate Software is the type of...
How to Check TDE Progress and Elapsed Time in SQL Server
By SQLPals
How to Check TDE Progress and Elapsed Time in SQL Server ...
Forums
Squared Values
Comments posted to this topic are about the item Squared Values
I Don't Want To Do XX
Comments posted to this topic are about the item I Don't Want To Do...
Managing Feature Flags with GET_BIT() and SET_BIT() in SQL Server
Comments posted to this topic are about the item Managing Feature Flags with GET_BIT()...
Question of the Day
Squared Values
What happens when I run this code in SQL Server 2022?
SELECT SQUARE('12') See possible answers