Armando Prato

• Purging MSDB Backup and Restore History from SQL Server (4/10/2009)

• Avoid Untrusted Constraints in SQL Server (7/14/2008)
• Enforcing business rules using SQL Server CHECK constraints (12/19/2008)
• Should I Use a UNIQUE Constraint or a Unique Index in SQL Server? (8/14/2008)
• Working with DEFAULT constraints in SQL Server (2/1/2008)

• Installing SQL Server 2005 Performance Dashboard Reports (8/1/2008)
• Killing a SPID and Checking Rollback progress in SQL Server (4/9/2008)
• Maintaining SQL Server database metadata to identify object changes (7/1/2008)
• Using SQLCMD to Execute Multiple SQL Server Scripts (7/18/2008)

• Use DBCC UPDATEUSAGE to get accurate SQL Server space allocation (10/24/2007)
• Using DBCC PAGE to Examine SQL Server Table and Index Data (9/8/2008)

• Best practices for taking on the SQL Server DBA role as a developer (12/23/2008)

• Using the CASE expression instead of dynamic SQL in SQL Server (3/14/2008)

• Auto Grow, Auto Shrink and Physical File Fragmentation in SQL Server (4/21/2008)
• Efficiently Rebuild SQL Server Clustered Indexes with DROP_EXISTING (10/30/2007)

• Auto generated SQL Server keys with the uniqueidentifier or IDENTITY (10/8/2008)
• Generating On Demand Sequential Values in SQL Server (7/25/2007)
• Properly Capturing Identity Values in a SQL Server Database (1/2/2008)

• Avoid Index Redundancy in SQL Server Tables (3/6/2008)

• Optimistic Locking in SQL Server using the ROWVERSION Data Type (5/19/2008)
• Processing Data Queues in SQL Server with READPAST and UPDLOCK (6/4/2007)

• Are Your SQL Server Application Queries Wasting Memory (11/21/2008)

• How to use a SQL Server Plan Guide to Tune Queries (11/19/2008)

• Foreign Key vs. Trigger Referential Integrity in SQL Server (5/29/2008)
• The Importance of SQL Server Foreign Keys (7/30/2007)

• Automatically Running Stored Procedures at SQL Server Startup (9/2/2008)

• Creating Your Own SQL Server System Stored Procedures (10/24/2008)
• Table changes not automatically reflected in a SQL Server View (2/5/2008)

• Forcing Trigger Firing Order in SQL Server (1/10/2008)

• SQL Server Function to Determine a Leap Year (6/25/2008)

• Abstract Data with SQL Server Views, Stored Procedures and Functions (8/22/2007)