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.
2020 Awards
2013 Awards
2020 Awards

2013 Awards

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)
Import and Export
- Export SQL Server Tables to Excel (last update: 4/14/2020)
Install and Uninstall
- Quick Start Guide for Data Science with SQL Server and R Services (last update: 7/6/2020)
Linked Servers
- How to create a SQL Server link server to IBM DB2 (last update: 10/21/2010)
Master Data Services
- Master Data Services Versions and Views for SQL Server (last update: 11/26/2019)
Microsoft Excel Integration
- How to Export Data from SQL Server to Excel (last update: 5/22/2020)
- Load Excel Data Into SQL Server (last update: 2/28/2020)
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)
R Language
- Create SQL Server Graphics with ggplot2 and R Services (last update: 12/30/2020)
- Data Structures in R including Vector, Matrix, Array, List, and Data Frame (last update: 7/23/2020)
- How to Create a R Function in SQL Server (last update: 11/4/2020)
- Import Data from PDF to SQL Server (last update: 12/14/2020)
- R Functions and Operators in SQL Server (last update: 9/23/2020)
- Stored Procedure in SQL Server with R Code (last update: 11/24/2020)
- Subset in R including List, Data Frame, Matrix and Vector (last update: 8/6/2020)
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)
User Defined Functions
- Valid Email Address Check with TSQL (last update: 8/18/2020)