Matteo Lorini

Matteo is currently a DBA for one of the largest global electronic payment service providers in the U.S. He has been working in IT since he graduated from college in 1993. Matteo has a Master's degree in Computer Science, and specializes in MSSQL with a good working knowledge of MySQL as well.
  • MSSQLTips Awards: Rising Star (50+ tips) - 2021 | Author Contender - 2020
Title Category Date
Trick to Optimize TOP clause in SQL Server Performance Tuning2021-04-01
sqldf in R Example for SQL Server R Language2021-02-09
Create SQL Server Graphics with ggplot2 and R Services R Language2020-12-30
Import Data from PDF to SQL Server R Language2020-12-14
Stored Procedure in SQL Server with R Code R Language2020-11-24
Create R Function for SQL Server R Language2020-11-04
R Functions and Operators Examples in SQL Server R Language2020-09-23
Valid Email Address Check with TSQL Functions User Defined UDF2020-08-18
Subset in R including List, Data Frame, Matrix and Vector R Language2020-08-06
Data Structures in R including Vector, Matrix, Array, List, and Data Frame R Language2020-07-23
Quick Start Guide for Data Science with SQL Server and R Services Install and Uninstall2020-07-06
How to Export Data from SQL Server to Excel Microsoft Excel Integration2020-05-22
Export SQL Server Tables to Excel Import and Export2020-04-14
Load Excel Data Into SQL Server Microsoft Excel Integration2020-02-28
Master Data Services Versions and Views for SQL Server Master Data Services2019-11-27
Import and Export Data between SQL Server and Cognos TM1 Cube Other Database Platforms2019-03-01
A closer look at CXPACKET wait type in SQL Server Performance Tuning2018-03-15
Using Source Control with SQL Server Management Studio DBA Best Practices2017-10-06
Getting started with source control for SQL Server DBA Best Practices2017-09-20
How to use a Project in SQL Server Management Studio SQL Server Management Studio2017-08-28
Standardize SQL Server T-SQL Code Formatting TSQL2017-05-30
Easy way to compare SQL Server table schemas Database Design2017-04-18
What MAXDOP setting should be used for SQL Server SQL Server Configurations2012-11-12
SQL Server Database Mirroring Breaks if Endpoint Owner is Deleted Database Mirroring2012-05-22
Steps to restore a database that has a SQL Server Audit defined Auditing and Compliance2011-12-26
SQL Server does not reclaim space used when inserts fail Database Administration2011-11-18
SQL Server Compressed Backups Disk Space Needs Compression2011-11-04
Perfmon Counters to Identify SQL Server Disk Bottlenecks Performance Tuning2011-09-15
Rebuilding SQL Server on different hardware after a failure Disaster Recovery2011-08-12
Internal SQL Server Certificates have expired is this an issue Policy Based Management2011-08-01
Performance Advantages of SQL Server Filtered Statistics Performance Tuning2011-04-29
Interesting example of statistics and index usage on a SQL Server computed column Performance Tuning2011-03-22
SQL Server separation of duties Security2011-02-11
Determine which version of SQL Server data access driver is used by an application SQL Server Configurations2011-01-05
Speed up SQL Server queries with PREFETCH Performance Tuning2010-12-08
How to create a SQL Server link server to IBM DB2 Linked Servers2010-10-21
Improving SQL Server performance when using table variables Performance Tuning2010-10-12
Troubleshooting SQL Distributed Transactions (Part 2 of 2) SQL Server Configurations2010-09-14
Troubleshooting SQL Server Distributed Transactions (Part 1 of 2) SQL Server Configurations2010-08-05
SQL snapshot replication fails when importing data from distributor Replication2010-07-16
How to create a SQL Server Clone Statistics Only Database Performance Tuning2010-05-05
SQL Server tempdb one or multiple data files System Databases2010-04-08
Custom Data Collections for SQL Server Data Management Warehouse Performance Data Warehouse2010-03-25
SQL Server 2008 64bit Query Optimization Trick Performance Tuning2010-03-04
SQL Server Lazy Writer Issue Warning No Free Buffers Found Database Administration2010-02-15
Using SQL Server sys.fn_PhysLocFormatter undocumented function Database Administration2010-01-21
Microsoft SQL Server vs. MySQL Other Database Platforms2010-01-13
Tool to help you analyze SQL Server SQLDIAG and PSSDIAG output Performance Tuning2009-12-11
How to simulate transparent data encryption TDE with SQL 2000 and 2005 Encryption2009-11-19
SQL Server Monitoring Scripts with the DMVs Dynamic Management Views and Functions2009-10-19
How to Recover from a SQL Server Service Pack 3 Install Error Upgrades and Migrations2009-09-15