(Ofer Maor and Amichai Shulman) In the past few years, SQL injection attacks have been on the rise. The increase in the number of database based applications, together with various publications that explain the problem and how it can be exploited (in both electronic and printed formats), have led to

(Peter Pyungchul Kim) This article discusses: –How to automate classification of text-based data –How to use SQL Server 2005 components to perform manual and automatic text classification –Performing term extraction and data preparation –Mining model development and refinement

(Jesse Smith) SQL Server 2000 includes many useful counters for looking at access methods, buffering, databases, caching, memory, backup, replication, and more. Knowing which counters to look at is important for determining how SQL Server is taxing system resources. This article helps you find out w

(Allan Mitchell) Let’s face it, in SQL Server 2000 Data transformation Services (DTS) it was a bit of a hack to be able to loop over files of a given type in a certain directory and import them into your destination. It involved a lot of “Glue Code” and a certain amount of fooling the package into g

(Don Schlichting) This article will explore various options for obtaining SQL 2005 metadata information.

(Andrew Novick) When you pick a name for a SQL object what are you trying to do? When I name an object I want several things to happen. I want the programmer who sees the object to know: –The type of object. –That the object is a user object as opposed to a system object. –Something a

(Eric N. Hanson and Lubor Kollar) Microsoft SQL Server 2005 collects statistical information about indexes and column data stored in the database. These statistics are used by the SQL Server query optimizer to choose the most efficient plan for retrieving or updating data. This paper describes w

(Hilary Cotter) Like the weather, SQL developers and database administrators talk about version control, but most of them don’t do anything about it. Version control means managing the versions of the objects created and deployed in their SQL Server environments. Typically, this involves develop

(Muthusamy Anantha Kumar) Occasionally, SQL Server database administrators are requested to provide a list of development SQL Servers, production SQL Servers and so on. Many articles, such as “Monitor Disk Space on Multiple SQL Servers” and “Inventorying hardware and OS information on all SQL Server

(Serdar Yegulalp) Montreal-based SQL Server programmer Igor Nikiforov has written a number of useful Transact-SQL custom string manipulation functions that can be put to work in a variety of database projects. Many of these functions would normally be performed by business logic (for instance, in an