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,404 reads
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,404 reads
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
For data warehouse professionals, data change detection is is a central part of what we do. Accurately detecting new, changed,...
2016-03-01
595 reads
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
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,009 reads
Recently, I wrote about how to get started with SQL Server change tracking, and I demonstrated a design pattern I...
2016-01-22
2,673 reads
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,083 reads
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
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
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,532 reads
Fabric deployment pipelines look like they solve CI/CD for Fabric content, especially for people...
By Steve Jones
We aren’t the only company that does this, but Redgate Software does try to...
By James Serra
Microsoft Fabric makes it wonderfully easy to put many analytics workloads on one platform....
Comments posted to this topic are about the item The New World Of AI...
Thanks in advance, I'm trying to avoid using IIF for performance reasons, but the...
Security has long been a problem for me. Every time I think I understand...
What does this return on SQL Server 2025?
select bit_count(null)See possible answers