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
  

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

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

• 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)
  

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

• 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)
  

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

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

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

• Export SQL Server Tables to Excel (last update: 4/14/2020)
  

• Quick Start Guide for Data Science with SQL Server and R Services (last update: 7/6/2020)
  

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

• Master Data Services Versions and Views for SQL Server (last update: 11/26/2019)
  

• 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)
  

• 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)
  

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

• 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)
  

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

• 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)
  

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

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

• 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)
  

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

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

• 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)
  

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

• Valid Email Address Check with TSQL (last update: 8/18/2020)