Armando Prato

 

Armando is a database architect and developer who has been working with SQL Server since version 6.5. He has close to 30 years of industry experience.and he has architected database solutions across a wide variety of industry verticals including manufacturing, education, consumer, security, and retail. In his spare time, he enjoys sports and volunteering.

2013 Awards
  

• SQL Server Data Tools (SSDT) SQL Project Tutorial (last update: 8/6/2014)
  
• Visual Studio 2010 and SQL Server Tutorial (last update: 10/8/2012)
  

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

• Avoid Untrusted Constraints in SQL Server (last update: 7/14/2008)
  
• Enforcing business rules using SQL Server CHECK constraints (last update: 12/19/2008)
  
• Foreign Key vs. Trigger Referential Integrity in SQL Server (last update: 5/29/2008)
  
• Should I Use a UNIQUE Constraint or a Unique Index in SQL Server? (last update: 8/14/2008)
  
• The Importance of SQL Server Foreign Keys (last update: 7/30/2007)
  
• Working with DEFAULT constraints in SQL Server (last update: 2/1/2008)
  

• SQL Server Data Type Precedence (last update: 8/15/2012)
  

• Maintaining SQL Server database metadata to identify object changes (last update: 11/4/2014)
  
• Using SQLCMD to Execute Multiple SQL Server Scripts (last update: 7/18/2008)
  

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

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

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

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

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

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

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

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

• Killing a SPID and Checking Rollback progress in SQL Server (last update: 4/9/2008)
  

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

• How to use a SQL Server Plan Guide to Tune Queries (last update: 6/2/2018)
  

• Installing SQL Server 2005 Performance Dashboard Reports (last update: 8/1/2008)
  

• Automatically Running Stored Procedures at SQL Server Startup (last update: 9/2/2008)
  
• Creating Your Own SQL Server System Stored Procedures (last update: 8/30/2018)
  

• New SQL Server Database Development Tutorial (last update: 9/27/2012)
  

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

• Abstract Data with SQL Server Views, Stored Procedures and Functions (last update: 8/22/2007)
  
• Table changes not automatically reflected in a SQL Server View (last update: 2/5/2008)