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

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Armando Prato

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

MSSQLTips award

Application Development

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

Backup

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

Constraints

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

Data Types

SQL Server Data Type Precedence (8/15/2012)

Database Administration

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

Database Consistency Checks DBCCs

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)

Dates

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

DBA Best Practices

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

Dynamic SQL

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

Fragmentation and Index Maintenance

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)

Identities

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)

Indexing

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

Locking and Blocking

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)

Monitoring

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

Query Optimization

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

Query Plans

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

SQL Server Management Studio

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

Stored Procedures

Automatically Running Stored Procedures at SQL Server Startup (9/2/2008)
Creating Your Own SQL Server System Stored Procedures (10/24/2008)

T-SQL

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

Triggers

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

Views

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

More SQL Server Solutions