(Steve Jones) My server isn’t fast enough. Actually it’s neither fast enough, nor big enough. Well, let’s be totally open here. My server is a smoking, high end, rather expensive piece of hardware that I admire. However my users, have a different opinion. (R)

(Graz) In it’s simplest form an identity column creates a numeric sequence for you. You can specify a column as an identity in the CREATE TABLE statement: CREATE TABLE Yaks ( YakID smallint identity(7,2), YakName char(20) ) Find out more about Identity columns in this article.

(Cesar Cerrudo) This paper will not cover basic SQL syntax or SQL Injection. It is assumed that the reader has a strong understanding of these topics already. This paper will focus on advanced techniques that can be used in an attack on a (web) application utilizing Microsoft SQL Server as a bac

(Jeremy Bostron and Doug Rothaus) The success of a database-driven international Web site depends on how well the code and localized content work together with the software on the client and server. Localizing a dynamic Web site is more complicated than localizing a static one. The use of HTML a

This two-day seminar provides students with the knowledge and skills to author, deploy, and manage reports using Microsoft Reporting Services. Attendees leave the seminar with a good understanding of how to apply reporting services to problems within a business context. Optionally, bring your lapto

(Samuel Cromer) This how-to article describes how to create a basic Flash MX login interface that utilizes ASP.NET and SQL Server 2000.

(Brian Moran) Performance tuning is my favorite topic and what I spend most of my professional time doing. I have a good sense of the performance-tuning techniques available, so it’s rare that I run across practical performance-tuning information that I’ve never seen or thought about before. However

When you try to remove Microsoft SQL Server 2000 Desktop Engine or Microsoft SQL Server 2000 Desktop Engine (Windows) from your computer, the Setup program may fail, and you may receive the following error messages. Error message 1 Unable to determine system default collation. Error message

(Roman Rehak) Regular maintenance is essential for the smooth, successful operation of your databases. This maintenance includes making backups to protect against data loss, performing consistency and integrity checks to ensure your data and indexes aren’t corrupted, and regularly rebuilding indexes

(Darren Green) The DTS Bulk Export Task was originally conceived in response to a problem with the OLE-DB provider for text files. For more details see DataPump truncates delimited fields to 255 characters. Whilst this problem can be fixed quite easily the Bulk Export Task still offers some benefits