The Coding-in-SQL Newsletter Launched

January 4, 2005 - For Immediate Release

The Coding-in-SQL Newsletter launches on January 4th, 2005.  Previously named the T-SQL UDF of the Week, the new name reflects a change in focus and content.  User-Defined Functions (UDFs) will still be included, but won't have the near exclusive coverage that they did in the first two volumes.  Instead you'll see expanded coverage of stored procedures, DTS scripts, and soon .Net CLR programming in C# and VB.Net.

This new coverage reflects the impending changes in SQL Server as we transition from SQL Server 2000 to SQL Server 2005, code name Yukon.    The most important of these changes include the ability to code in .Net CLR languages such as C# and VB.Net.  Along with the new capability to code stored procedures and user-defined functions in CLR languages there are new types of code available in the new version:

• User-Defined Types
• User-Defined Aggregates
• .Net DTS scripts

The Coding-in-SQL Newsletter will be covering these new developments as well as more traditional Transact-SQL (T-SQL) code.  And the emphasis is on the code.  Each newsletter issue has some code that's either useful or illustrates a point.  This might be  a script, a stored procedure or a user-defined function.  Along with the code comes an explanation and some examples showing how to use the code.

The Coding-for-SQL Newsletter is written by Andrew Novick and distributed free of charge by Novick Software.

Andrew Novick is a software consultant, trainer, manager, and author with expertise in the construction of business applications using the Microsoft tools including VB.Net, C#, SQL Server and ASP.Net.  He's the author of Transact-SQL User-Defined Functions, published last fall by Wordware of Plano, Texas and co-author of SQL Server 2000 XML Distilled, now published by Apress.  In addition he's author of many articles about SQL Server and VB.Net programming.  He can be contacted at anovick@novicksoftware.com.