Novick Software SQL Server Consulting Design Programming Training  

  sql server mvp

 

 

SQL Server Performance Consulting

SQL Sever Performance Analysis and Tuning

Think your database is slowing down your web site or client/server application?

Start by finding out with the Analysis Solution:

  • Architecture Review - Edition, Disks, CPU, Memory

  • Configuration Review - Backups, Replication, Database Settings

  • Performance Analysis - Slow SQL, Blocking Problems, Procedure Recompiles

  • Recommendations - Hardware, Configuration, Operational Changes. Code Changes

Continue on to improving your site:

  • Configuration changes

  • SQL Tuning - Index Tuning

  • Operational improvements - Backup, defragmentation

  • Schema upgrades

I use Microsoft's analysis methodologies such as PSS Read80Trace along with some home grown tools.  Most importantly, I use my 25 years of programming experience to locate the root cause of the problem and provide relief. 

If you're looking for this type of help, please call Andrew Novick at 978-440-8126 or email anovick @ novicksoftware.com

Look here for information on other Novick Software projects.

 

Technologies:

SQL Server 2000
SQL Server 2005
SQL Server 2008
Reporting Services
SSIS
Data Layer
C#
VB 6
VB.Net
ASP.Net
Compact Framework
Web Services
ASP
XML
XML DOM
XMLHTTP
SQL XML
HTTP
TCP/IP
HTML
Project Management
SourceSafe
IIS
IIS Admin
URLSCAN
T-SQL
ADO
ADO.Net
InterDev
Web Design
n-Tier
Fat Client
Database Administration
SQL Server 7
.Net
.Net Framework
.Net Security
dot Net
Encryption
Remoting
Structured Design
Structured Analysis
Entity-Relationship Diagrams
Data-Dictionary
State Diagrams
Object Design
UML Modeling
Use-Case Analysis

Locations:

Boston, MA
Nashua, NH
Cambridge, MA
Lexington, MA
Salem, MA
Gloucester, MA
Beverly, MA
Peabody, MA
Burlington, MA
Concord, MA
Belmont, MA
Arlington, MA
Woburn, MA
Reading, MA
Wakefield, MA
Lynn, MA
Somerville, MA
Charlestown, MA
Medford, MA
Watertown, MA
Nashua, NH
Manchester, NH
Boston
New Hampshire
Natick, MA
Framingham, MA
Wayland, MA
Maynard, MA
Acton, MA
Bedford, MA
Waltham, MA
Newton, MA
Needham, MA
Wellesley, MA
Weston, MA
Lincoln, MA
Marlborough, MA
Stow, MA
Berlin, MA
Bolton, MA
Littleton, MA
Chelmsford, MA
Hopkinton, MA
Ashland, MA
Franklin, MA
Worcester, MA

 

 

 

   


RSS as HTML

information about novick software site

Personal Blog

Photos

New Tips:

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

Upcoming
Presentations:

SQL PASS
Nov 7, '12
Biggest
Loser: DB
Edition


Full Schedule

 

 

Available Now

Transact-SQL
User-Defined Functions

Get it wtih the Bonus 100 UDF Library

Latest News

Novick Software Celebrates 10 Years in Business