SQL Agent Job Automated Change Capture Process
Build a process that captures your SQL Agent job history and changes across time.
2026-07-24
1,705 reads
James Greaves
- Interests: Motorcycles, SQL Server
SSIS object search using T-SQL
Easily determining what objects are located in all your SSIS packages can be a challenging endeavor. James Greaves brings us a technique that can help you determine which packages might need to be changed based on objects you alter in your database.
2010-05-13
12,804 reads
Clustered SQL Server 2005/2008 Installation Using Mount Points
If you are in a clustered environment, check out this article from James Greaves. Here we learn how to deal with the clustered disk space and mount points.
2009-03-19
6,198 reads
Monitoring and Recording DDL changes on SQL 2005 (NARC)
Auditing activities on your database servers becomes more important all the time. But ensuring that schema changes do not occur without your knowledge may be more important for a stable system. James Greaves brings us a great technique using DDL triggers for doing this.
2008-02-29
7,516 reads
Handling Zero Byte Files in DTS
SQL Server 2005 has substantially enhanced its ETL capabilities, but many people will still be working with DTS in SQL Server 2000 for many years. New author James Greaves brings us a technique for working with imports and handling files that might not have any data.
2006-03-27
6,831 reads
Blogs
Don’t Fear the Technology
By Brian Kelley
The concern that a particular technology is going to destroy the world seems to...
Creating a Custom SQL Server Security Checklist Using the DoD STIG
The STIG is detailed, which is a good thing, but I found myself wanting...
Creating a Local Model Chatbot on Windows
By Steve Jones
After my session at VSLive last week, I had a few questions from the...
Forums
RegEx Functions III
Comments posted to this topic are about the item RegEx Functions III
Optimized Locking in SQL Server 2025: Fewer Locks, Less Blocking, and the Cases It Cannot Fix
Comments posted to this topic are about the item Optimized Locking in SQL Server...
Finely Tuned Models
Comments posted to this topic are about the item Finely Tuned Models
Question of the Day
RegEx Functions III
If I run the REGEXP_LIKE() function, does it match values in a case-sensitive fashion, or a case-insensitive fashion by default.
See possible answers