Data Lineage: The Next Generation
Bill Lewis describes the benefits of an application development environment in which all data dependencies begin and remain clearly, precisely and explicitly defined.
Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
Reporting Data Loss
How quickly should you report a loss of data? It's an interesting question in these security conscious times and Steve Jones talks about
How to use OUTPUT clause result in SSIS 2005 / 2008 (RC0)
The OUTPUT clause was a new feature in SQL Server 2005 that can prove very handy in many situations. New author Gennadiy Chornenkyy brings us a look at how you can add this code to your SSIS packages and retrieve ID values back from the database.
Solid State Replacements - Database Weekly (August, 18, 2008)
New SSD (Solid State Device) hard drives are infiltrating enterprise servers more and more, but are they a good fit for database instances? Steve Jones comments a bit on some news from this past week.
Telework Works
As a telecommuter Steve Jones has found it has increased his productivity, but he's not alone. Sun has examined their own telework program from the energy perspective.
Check your SQL Server using Windows PowerShell – Part 4
Earlier installments of this series illustrated how to ping the host, how to check all of the windows services related to SQL Server and how to check the hardware and operating system information. Part 4 of this series demonstrates how to get hard disk and network adapter information from the host machine.
Configure Filestream in SQL Server 2008
SQL Server 2008 offers a wide variety of features and FILESTREAM is one of the most anticipated. This article describes how to configure the FILESTREAM feature.
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