Andrew Novick develops applications as consultant, project manager, trainer, author, and Principal of Novick Software. His firm specializes in implementing solutions using the Microsoft tool set: SQL Server, ASP, ASP.Net, Visual Basic and VB.Net. 2003 marks his 32nd year of computer programming, starting in High School with a PDP-8 and moving on a degree in Computer Science, an MBA, and then programming mainframes, minicomputers and for the last 16 years PCs.
In addition to writing articles for Database Journal, Andrew is author of the book SQL Server User Defined functions, which will be published by Wordware in the fall of 2003. He co-authored SQL Server 2000 XML Distilled, published by Curlingstone in October of 2002. He also writes the free T-SQL User-Defined Function of the Week newsletter.
When not programming he enjoys coaching Little League baseball, woodworking, mowing the lawn, and the occasional movie with his wife. He can be found on the web at www.NovickSoftware.com or by e-mail at anovick@NovickSoftware.com.
- Implementing CRUD Operations Using Stored Procedures: Part 2
- Implementing CRUD Operations Using Stored Procedures: Part 1
- Creating a SQL Server User Interface with InfoPath
- Examining SQL Server's I/O Statistics
- Scripting Traces for Performance Monitoring on SQL Server
- Minimizing SQL Server Stored Procedure Recompiles
- Identifying Stored Procedure Recompilation Problems in SQL Server 2000
- Find Out What They're Doing with fn_get_sql
- Indexed Views Basics in SQL Server 2000
- SQL Server 2000 SP3 and xp_cmdshell Woes
- Securing SQL Server for Web Applications