Novick Software
SQL Server Consulting • Design • Programming • Tuning

  andy novick is a sql server mvp



SQL Server Loadfest R2

This year's event held September 24, 2010 at the Microsoft office in Waltham, MA was another big success.  Thank you to Ron Thibeau and John Ross of Boston User Groups, Dan Stoltz of Microsoft and our proctor/speakers  Sunil Kadimdiwan of Infotrove and Mike Walsh of StraightPathSQL.

You can download the slides in a zip here or the individual PDFs:

SQL Server Loadfest R2 Intro
SQL Server Loadfest R2 Lesson 1 - Overview "What is SQL Server"
SQL Server Loadfest R2 Lesson 2 - Before the install
SQL Server Loadfest R2 Lesson 3 - Hands-on install
SQL Server Loadfest R2 Lesson 4 - Completing the install
SQL Server Loadfest R2 Lesson 5 - Preparing for Production

See the pictures on here

Andy  Novick at the SQL Server 2008 R2 Loadfest

The sponsoring organizations are Boston User Groups and New England Visual Basic Professionals along with Microsoft and Edgewood Solutions.

Last year's event the SQL Server Loadfest in  March of 2009 was a big success.  There were more than 100 people in attendance and most of them installed SQL Server 2008 on their laptop and even one desktop. 

The slides from the original 2009 Loadfest are available:

Lesson 1 - What is SQL Server
Lesson 2 - Before the Install
Lesson 3 - Installing SQL Server 2008
Lesson 4 - Completing the Install
Lesson 5 - Preparing for Production

Thanks to our speakers and proctors for 2009: Sunil Kadimdiwan, Phil Denoncourt, Pete Tassmer, Adam Machanic, and Igor Moochnick.

Special thanks to Ron Thibeau for wiring all the desktops and for being one of the driving forces behind the Loadfest.  Also thanks to Dan Stolts of Microsoft and John Ross and the other members of the BUG Board of Directors.

During the session there was mention of this page:  on predeployment I/O best practices.  You might want to check this out before beginning an installation.  Also, a great directory to SQL Server Whitepapers can be found here:

There was only one code snippet, the Surface Area Configuration Snippet from the Security talk.


Please send any questions or comments to Andy Novick  anovick @

Andrew Novick is a developer/consultant with 25 years in the computer industry and a focus on SQL Server and Microsoft .Net.  His practice includes designing databases, query optimization, analysis of performance problems, and building business applications.  His writings include the books Transact-SQL User-Defined Functions and “SQL Server 2000 XML Distilled.  You can find additional articles on his web site:

SQL Server Loadfest

March 27th


SQL Server Loadfest R2

September 24, 2010




Personal Blog

New Tips:

Use dsinit to set the SQL Server instance for Windows Azure dev storage


Nov 7, '12
Loser: DB

Full Schedule