(Christoffer Hedgate) I am sure most DBAs and developers have heard of SQL injection (at least I would hope so) and may quite possibly have taken adequate steps to secure themselves against it. However, I do know that there are still a lot of vulnerable sites out there, and when I lately was contact

(Muthusamy Anantha Kumar) Collation refers to a set of rules that determine how data is sorted and compared. Character data is sorted using rules that define the correct character sequence, with options for specifying case-sensitivity, accent marks, kana character types and character width.

(Michael Otey) SQL Server 2000 Reporting Services is one of the best late Christmas gifts you’ll ever receive. Reporting Services—an add-on for SQL Server 2000 that delivers report authoring, management, and delivery capabilities—fills the one big hole that still exists in SQL Server: the inability

(kgayda) Function to allow for checking if an IP address is a private IP address. Will convert the IP to a bigint equivalent if within the private range, otherwise it will return null if IP is a public address. (R)(script)

(Vinod Kumar) There are tons of new features that are getting introduced in the next version of SQL Server codenamed Yukon. And this is the first in the series of articles, I would explore T-SQL enhancements we are presented with this new version. In this article we will explore how the TOP operator

This is in continuation from the previous article on performance counters for SQL Server. In this article we will look at some of the useful .NET Performance counters we need to monitor. Use these as the baseline counters. This is NOT the exhaustive list. But surely a basic top 25 to keep a watch on

(William Pearson) This is the first of several articles of a new series, MSSQL Server 2000 Reporting Services. The series is designed to introduce MSSQL Server 2000 Reporting Services (“Reporting Services”), with the objective of giving a preview of its features, as well as sharing my conviction in

(Jason Bohanon) This procedure will generate a delete stored procedure against a provided table and column name in your database. The script searches for foriegn key constraints and then creates a delete statement for each one found in the database. (script)

(Andy Warren) If you haven’t already, you might want to look at the two previous articles I’ve written recently on replication (Snapshot Replication and Getting Ready to Replicate) that set the stage for this one. This week I’m going to return to snapshot replication, discussing how to do a basic im

Using the Microsoft OLEDB Provider for SQL Server (SQLOLEDB) that comes with Microsoft Data Access Components (MDAC) version 2.6 or 2.6 SP1, when you set the value of the SSPROP_ENABLEFASTLOAD property to true in the SQLSERVERDATASOURCE property set, and then attempt to create an accessor with the D