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,402 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,402 reads
A few weeks ago I met a couple of my business partners in a moderately upscale restaurant in the Washington,...
2016-03-08
393 reads
For data warehouse professionals, data change detection is is a central part of what we do. Accurately detecting new, changed,...
2016-03-01
590 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,696 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,003 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,668 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,081 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,423 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
451 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,530 reads
By Arun Sirpal
Third part in my Ai series with databases. When building AI solutions within the...
By Steve Jones
This month we have a very interesting invitation from Koen Verbeeck. He has hosted...
It’s the second tuesday of the month, which means T-SQL Tuesday time! This month’s...
I have 13 restricted views in my EDW DB. 6 of them are created...
Hallo all! My problem is this: I have quite a bunch of TSQL scripts...
Comments posted to this topic are about the item Would You Retire Rather Than...
Does this run successfully on a SQL Server 2022, US English default installation?
DECLARE @YenAmount MONEY; SET @YenAmount = ¥1500; SELECT @YenAmount AS RawValue;See possible answers