Novick Software is the New England based consulting company
of
Andrew
Novick. Over the last 22 years I've been managing projects,
consulting, writing, teaching, and programming to create software
applications for both operations and analysis. The most important thing that
I can do for my clients is to understand what drives their business. Only by
understanding what their problem is or what they're trying to achieve can an
effective solution be found.
Much of this site is devoted to technology. I've specialized in the Microsoft Windows environment and the Microsoft tool
set, in particular, SQL Server, Visual Basic, XML, ASP and now Dot Net. Here
there is a variety of material about my work including articles about
SQL
Server,IIS, XML, VB.Net, Visual Basic, ASP, and security. This work has
been for the Financial Services, Retail, Transportation, Manufacturing, Telecommunications, and
Real Estate industries.
Newsletter: The Transact-SQL User-Defined Function of the Week
This newsletter brings you a new T-SQL UDF
every week.
SQL Server 2000 Service Pack 3 includes a new system UDF, fn_get_sql.
This article show you how it works and demonstrates how to use it as an
aid in diagnosing a blocking situation. You can also
see a video of me executing the
demonstration scripts
Indexed views can radically improve the query
performance of your database. This article tells you what you need
to know to get started creating and using indexed views. The UDF
referred to by the article can be found in the
March 11th edition of the T-SQL UDF of the Week newsletter.
The SQL Sapphire Worm prompted many SQL Server 2000
sites to do a quick upgrade to Service Pack 3. One site that I
work with did the upgrade and found that a few features of the
application stopped working. This article describes the problem
and the fix. You might also want to take a look at the
February 11th edition of the T-SQL UDF of the Week newsletter which
describes the UDF that I used to locate all uses of xp_cmdshell.
A typical data driven web site has plenty of pages with tables
of data made from database content. This article discusses using
the Inline Table Valued User-Defined Function to retrieve the minimal
amount of data for each page.
Discusses the issues faced when using SQL Server in a
web application. It covers the vulnerabilities, the attacks, goals
for security, written security policies, securing the Windows server,
network topology, and security logs.
Whether your application is a software package, built
in-house, or you're an Application Service provider, the end users
rely on their IT department to enforce corporate security requirements.
This article is about how to work with the IT department to implement
security in a web application. It covers working on the
requirements check list to insure compliance with Infrastructure
requirements and application behavior requirements.
Microsoft provides the Upsizing Wizard for converting
Access databases to SQL Server. But it's only part of the
conversion process. This article takes you through the process of
using the Upsizing Wizard and they through all the additional steps it
takes to complete the conversion.
