CDC and Data Warehouse
The following article shows how Change Data Capture can be used to capture incremental data changes and use them in an ETL Process
2008-11-10
3,814 reads
Additional Articles
Reviewing SQL Server Permissions
Permissions on data are one of the most critical aspects of database administration.
2008-11-10
3,072 reads
Auto generate restore scripts after each backup completes
There are a lot of scripts out there that will allow you to use the msdb to auto-generate restore scripts, but what if you cannot access the msdb database. What is the easiest way to make sure I have the proper restore scripts on hand without relying on the msdb database?
2008-11-07
3,562 reads
Migrating DTS Packages to Integration Services
In this whitepaper, you will see the benefits of migrating your SQL Server 2000 Data Transformation Services (DTS) packages to Integration Services by using two proven methods. You will also see how you can run and manage your current DTS packages inside of the SQL Server 2005 and 2008 management tools.
2008-11-07
5,110 reads
Exploring SQL 2005’s Ranking Functions – NTILE() and ROW_NUMBER()
Part 20 of the "SqlCredit – Developing a Complete SQL Server OLTP Database Project" examines SQL 2005’s NTILE() and ROW_NUMBER() Ranking Functions.
2008-11-06
4,328 reads
Operations Manager: A Big Tinker Set
To illustrate the great possibilities of Systems Center Operations Manager 2007, Thomas shows how to create a Custom Monitor for SQL Agent Jobs, and concludes that Operations Manager is nothing more than a big tinker set.
2008-11-06
2,392 reads
SQL Server Schema Binding and Indexed Views
How do you handle this error? "Cannot create index on view, because the view is not schema bound".
2008-11-05
3,263 reads
Super Sizing Columns in SQL Server
This article describes how to work with large objects in SQL Server using the MAX Specifier
2008-11-05
2,455 reads
GIS and SQL Server 2008: Making Maps with your Data
When Microsoft introduced GIS into SQL Server with SQL Server 2008, it opened up a whole range of new applications that were previously impossible to do with SQL Server. So what can you do with GIS Data? We asked an expert!
2008-11-04
4,121 reads
Using Powershell to Generate Table-Creation Scripts
For all of us who learn best by trying out examples, Bob Sheldon produces a PowerShell script file for SQL Server that can be used in either SQL Server 2005 or 2008, has error handling and prompts for user-input, is easily extended and, does something useful. He then explains how to run it and what each line does.
2008-11-04
2,834 reads
Blogs
Resetting on the AI hype train
By Brian Kelley
There's a great article from MIT Technology Review about resetting on the hype of...
A New Word: Etherness
By Steve Jones
etherness – n. the wistful feeling of looking around a gathering of loved ones,...
Vibe Coding a Login Tracking System
By Steve Jones
A customer was asking about tracking logins and logouts in Redgate Monitor. We don’t...
Forums
The Microsoft SQL Year in Review
Comments posted to this topic are about the item The Microsoft SQL Year in...
T-SQL in SQL Server 2025: The || Operator
Comments posted to this topic are about the item T-SQL in SQL Server 2025:...
Your Value from a Conference
Comments posted to this topic are about the item Your Value from a Conference
Question of the Day
UNISTR Basics
What does this code return in SQL Server 2025+? (assume the database has an appropriate collation)
SELECT UNISTR('Hello 4E16754C') AS 'A Classic';
A: 
B: 
See possible answers