N S

Novick Software Management • Design • Programming • Training • Consulting

   
novick software sql server and .net consulting
Building on the .Net Framework
Articles
Coding in SQL server newsletter
Tips and Tricks
Downloads
Book Reviews of .net and sql server books
Presentations on sql server and .net topics
SQL Server and .Net Consulting

 

 

 

 

SQL Server Consultant
SQL Server Programmer
WinForms Programmer
Compact Framework

VB.Net Consultant

ASP.Net Consultant

SQL Problem Solver

 

 

 

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.

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

Look here for information on other Novick Software projects.

 

Technologies:

SQL Server 2000
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

New Tips:

Loading SQL Profiler trace (.trc) files with fn_trace_gettrace

Upcoming
Presentations:

Big Data:
Working with Terabytes
in SQL Server

July 9 '08


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