Matteo Lorini

My name is Matteo and I am currently a DBA for one of the largest global electronic payment service providers in the US. I have been working in IT since I graduate from college back in 1993. I have a masters degree in Computer Science, and I am specialized in MSSQL, and have a good working knowledge of MySQL as well.

2013 Awards
MSSQLTips award

Auditing and Compliance

Steps to restore a database that has a SQL Server Audit defined (last update: 12/26/2011)

Compression

SQL Server Compressed Backups Disk Space Needs (last update: 11/4/2011)

Database Administration

How to use the SQL Server sys.fn_PhysLocFormatter undocumented function (last update: 1/21/2010)
SQL Server does not reclaim space used when inserts fail (last update: 11/18/2011)
SQL Server Lazy Writer Issue Warning No Free Buffers Found (last update: 2/15/2010)

Database Mirroring

SQL Server Database Mirroring Breaks if Endpoint Owner is Deleted (last update: 5/22/2012)

DBA Best Practices

Getting started with source control for SQL Server (last update: 9/20/2017)
Using Source Control with SQL Server Management Studio (last update: 10/6/2017)

Disaster Recovery

Rebuilding SQL Server on different hardware after a failure (last update: 8/12/2011)

Dynamic Management Views and Functions

SQL Server Monitoring Scripts with the DMVs (last update: 10/19/2009)

Encryption

How to simulate transparent data encryption TDE with SQL 2000 and 2005 (last update: 11/19/2009)

Linked Servers

How to create a SQL Server link server to IBM DB2 (last update: 10/21/2010)

Other Database Platforms

Import and Export Data between SQL Server and Cognos TM1 Cube (last update: 3/1/2019)
Microsoft SQL Server vs. MySQL (last update: 1/13/2010)

Performance Data Warehouse

Create Custom Data Collections for SQL Server Data Management Warehouse (last update: 3/25/2010)

Performance Tuning

A closer look at CXPACKET wait type in SQL Server (last update: 3/15/2018)
How to create a SQL Server Clone Statistics Only Database (last update: 5/5/2010)
Improving SQL Server performance when using table variables (last update: 10/12/2010)
Interesting example of statistics and index usage on a SQL Server computed column (last update: 3/22/2011)
Perfmon Counters to Identify SQL Server Disk Bottlenecks (last update: 9/15/2011)
Performance Advantages of SQL Server Filtered Statistics (last update: 4/29/2011)
Speed up SQL Server queries with PREFETCH (last update: 12/8/2010)
SQL Server 2008 64bit Query Optimization Trick (last update: 3/4/2010)
Tool to help you analyze SQL Server SQLDIAG and PSSDIAG output (last update: 12/11/2009)
Trick to Optimize TOP clause in SQL Server (last update: 7/2/2010)

Policy Based Management

Internal SQL Server Certificates have expired is this an issue (last update: 8/1/2011)

Replication

SQL Server snapshot replication fails when importing data from the distributor (last update: 7/16/2010)

Security

SQL Server separation of duties (last update: 2/11/2011)

SQL Server Configurations

Determine which version of SQL Server data access driver is used by an application (last update: 1/5/2011)
Troubleshooting SQL Distributed Transactions (Part 2 of 2) (last update: 9/14/2010)
Troubleshooting SQL Server Distributed Transactions (Part 1 of 2) (last update: 8/5/2010)
What MAXDOP setting should be used for SQL Server (last update: 11/12/2012)

SQL Server Management Studio

How to use a Project in SQL Server Management Studio (last update: 8/28/2017)

System Databases

SQL Server tempdb one or multiple data files (last update: 4/8/2010)

T-SQL

Easy way to compare SQL Server table schemas (last update: 4/18/2017)
Standardize SQL Server T-SQL Code Formatting (last update: 5/30/2017)

Upgrades and Migrations

How to Recover from a SQL Server Service Pack 3 Install Error (last update: 9/15/2009)

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

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Matteo Lorini

More SQL Server Solutions