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
MSSQLTips award

Application Development

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)

Backup

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

Constraints

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)

Data Types

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

Database Administration

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)

Database Console Commands DBCCs

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)

Dates

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

DBA Best Practices

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

Dynamic SQL

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

Fragmentation and Index Maintenance

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)

Identities

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)

Indexing

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

Locking and Blocking

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)

Monitoring

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

Query Optimization

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

Query Plans

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

SQL Server Management Studio

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

Stored Procedures

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)

T-SQL

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

Triggers

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

Views

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)

Tutorials DBA Dev BI Career Categories Webcasts Scripts Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Armando Prato

More SQL Server Solutions