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
590 reads
Tim Mitchell
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,696 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,668 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,003 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,081 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,423 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
451 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,530 reads
PASS Summit 2015 Keynote – Day 2
Today is the second day of the SQL PASS Summit in Seattle, Washington. I’ll be live blogging today’s keynote address....
2015-10-29
941 reads
PASS Summit 2015 Keynote – Day 1
Today, I’ll be live blogging the SQL PASS 2015 keynote. Today is the third day of the PASS Summit, and...
2015-10-28
741 reads
Blogs
5 Starter Projects for Your AI and Data Engineering Portfolio
Reading tutorials is fine. Shipping something is better. If you are trying to break...
The Book of Redgate: Taking Breaks
By Steve Jones
We work hard at Redgate, though with a good work-life balance. One interesting observation...
Database AI Agents: The Read-Only Rule
By Arun Sirpal
Fourth in a series on Ai and databases. What Read-Only Advisory Actually Means A...
Forums
Liability for AI Errors
Comments posted to this topic are about the item Liability for AI Errors
Running a Parameter-Sensitive Stored Procedure on a Secondary Replica
Hello , I would like to run a stored procedure on a secondary replica...
Pro SQL Server Internals
Comments posted to this topic are about the item Pro SQL Server Internals
Question of the Day
Running SQLCMD II
I run this command to start SQLCMD:
sqlcmd -S localhost -E -c "proceed"At the prompt, I type this (the 1> and 2> are prompts):
1> select @@version 2> goWhat happens? See possible answers