Andy Novick

Andy Novick is a SQL Server Developer in the Boston area with 25 years of database and application development experience. His consulting practice focuses on building applications, including software products that use SQL Server's capabilities to the maximum. He has developed both OLTP and data warehouse databases with multi-terabytes scale. He has particular expertise in automating data management for such large databases. Other recent projects have included ETL, Security and SQL Injection prevention. Andy is the originator of the popular "SQL Server Loadfest" event held in Waltham, MA.
  • MSSQLTips Awards: Trendsetter (25+ tips) - 2014
Title Category Date
Using @@PROCID to return correct name of SQL Server procedures, functions and triggers Stored Procedures2026-06-27
Convert Implicit and the related performance issues with SQL Server Performance Tuning2026-06-27
Prevent multiple users running the same SQL Server Stored Procedure Locking and Blocking2026-06-27
Benchmarking SQL Server IO with SQLIO Hardware2026-06-27
Partition offset and allocation unit size of a disk for SQL Server Hardware2026-06-27
SQL Server Msg 2714 There is already an object named #temp TSQL2026-05-10
Using OPENROWSET to read large files into SQL Server Import and Export2020-04-21
What are the most useful open source SQL Server projects on GitHub? Tools2017-07-04
Lessons learned from SQL Server process that took over 3000 hours DBA Best Practices2016-06-15
Testing SQL Server Application with past or future dates Testing2014-07-22
Format drives with correct allocation and offset for maximum SQL Server performance Hardware2010-10-11
Performance Issue with large number of Virtual Log Files in SQL Server Transaction Log Database Administration2010-09-02
How to shrink the transaction log file in SQL Server Database Administration2010-08-19
Execute DOS command when xp_cmdshell is disabled in SQL Server Functions User Defined UDF2010-08-11
Issues with running DBCC SHRINKFILE on your SQL Server data files Performance Tuning2010-07-07
SQL Server User Defined Type To Store and Process Email Addresses User Defined Type UDT2010-06-01
Concat Aggregates SQL Server CLR Function Common Runtime Language2010-05-20
SQL Azure Migration Wizard Azure2010-04-21
SQLCLR function to return free space for all drives on a server Functions User Defined UDF2010-04-16
Requesting and researching SQL Server enhancements with Connect DBA Best Practices2009-02-26
SQL Server CLR function to concatenate values in a column Common Runtime Language2009-02-19
SQL Server function to validate email addresses Functions User Defined UDF2009-01-23
Writing to an operating system file using the SQL Server SQLCLR Common Runtime Language2009-01-09
Using the NOWAIT option with the SQL Server RAISERROR statement Error Handling2009-01-07
Getting a SQL Server RowCount Without doing a Table Scan Functions System2006-08-21