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,688 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)
2,995 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,080 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
443 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,529 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
735 reads
Blogs
TempDB Internals – What’s New (SQL Server 2016 to 2022)
By Vinay Thakur
I wrote about TempDB Internals and understand that Tempdb plays very important role on...
AI: Blog a Day – Day 2: Generative AI, Multimodal Systems, and Agent AI
By Vinay Thakur
continuing from Day 1 where we covered the history of AI and GPT family,...
A Wellbeing Day at Redgate
By Steve Jones
It’s a day off for Redgate today. This is our annual wellbeing day, where...
Forums
A Quick Restore
Comments posted to this topic are about the item A Quick Restore
Guarding Against SQL Injection at the Database Layer (SQL Server)
Comments posted to this topic are about the item Guarding Against SQL Injection at...
Ola Hallengren Index Optimize Maintenance can we have data compression = page
I have a quick question on Ola Hallengren Index Optimize Maintenance . Do we...
Question of the Day
A Quick Restore
While doing some testing of an application, I wanted to reset my environment after doing some testing with this code:
USE DNRTest BACKUP DATABASE DNRTest TO DISK = 'dnrtest.bak' GO /* Bunch of stuff tested here */RESTORE DATABASE DNRTest FROM DISK = 'dnrtest.bak' WITH REPLACEWhat happens if this runs, assuming the "bunch of stuff" isn't anything affecting the instance. See possible answers