Maintaining a Log of Database Changes - Part 1
This article looks at logging your database changes from a developer's perspective.
Microsoft SQL 2005 Maintenance Wizard Part 3
The Maintenance Plan Wizard is a graphical interface for creating a variety of database housekeeping tasks. This article focuses on using SQL Server 2005 Maintenance Plan Wizard for creating Database Backup operations.
Using Views to Enforce Business Rules
A view is most commonly thought of as a SELECT statement. Most developers will simply create a view to "group" complex SELECT statements for reuse within another view or stored procedures. It makes typing easier! But the really power of views is their ability to implement business rules.
SQL Server Profiler for Analysis Services
Use SQL Server Profiler to “look behind the scenes” within Analysis Services 2005. BI Architect Bill Pearson leads a hands-on introduction to determining resource utilization effectiveness for both processing and query performance with profiling.
SQL Server 2005 Maintenance Mayhem
Service Pack 2 for SQL Server 2005 has had a few issues and one of the big ones is maintenance plans. Longtime DBA and developer Robert Pearl, of Pearl Knowledge Solutions brings us a fix for your maintenance plans.
The Service Broker Alphabet Part 2
SQL Server MVP has been working extensively with SQL Server 2005 and one of the less well known features: Service Broker. In this short article, we continue definitions of the terminology you'll need to know to work with this subsystem.
The Service Broker Alphabet Part 1
SQL Server MVP has been working extensively with SQL Server 2005 and one of the less well known features: Service Broker. In this short article, we get an introduction to some of the terminology you'll need to know to work with this subsystem.
Dynamic Images and Databases
Should you store dynamically generated web-site graphics in a database or is the file system the better option? Dino illustrates how to make this decision in ASP.NET
Adventures With Service Broker
Service Broker is one of those new SQL Server 2005 features that doesn't get much press, but is extremely interesting from a software architect perspective. The much talked about service oriented architecture (SOA) can make use of Service Broker and new author Johan Bijnens brings us a look at this subsystem.
Post SP2 Fixes Explained
If you haven't seen it, I highly recommend all SQL Server administrators check out the post from Microsoft detailing the post-SP2 fixes.
Blogs
March 2026 SQL Server Security Updates
By Brian Kelley
On Patch Tuesday, in addition to OS and Office security patches, Microsoft also released...
How Fabric Mirroring Transformed with SQL Server 2025
When mirroring was first released for Azure SQL Database, it used Change Data Capture...
The DIY Cost of Masking Test Data For Smaller Organizations
By Steve Jones
One of the things I’ve tried hard to do in database development situations if...
Forums
XACT_ABORT being set to ON by web services
We have two "identical" instances of an ASP.NET web service (or so I have...
OPENQUERY Flexibility
Comments posted to this topic are about the item OPENQUERY Flexibility
A Full Shutdown
Comments posted to this topic are about the item A Full Shutdown
Question of the Day
OPENQUERY Flexibility
Which of these are valid OPENQUERY() uses?
See possible answers