By Brian Moran – Avoid performance-tuning mistakes and design a database that can handle unpredictable future demands for extreme performance and scalability.

A SMALL COMPANY is about to go live with a big idea that you can greatly benefit from. The company is Descan.net, and the idea is to identify and halt the “script kiddies” who are infiltrating and subsequently attacking our computer networks.An example of the kind of attack I’m talkin

By Carl Federl – There are occasions when a random sample of a query’s rows are needed. A simple but non-functioning solution is to include the system random number generator function within the query. Unfortunately, a single random number is generated for the query when what is desired is a random

Use the System.Reflection namespace with SQL stored procedures to query rich metadata that describe data types.

By Anne Martinez – Microsoft recently announced plans to discontinue 10 of its certification exams on June 30, 2003. The retired exams cover Site Server 3.0; Exchange Server 5.5; SNA Server 4.0; Proxy Server 2.0; Windows 98; Designing and Implementing Solutions with Microsoft Office 2000; Microsoft

Book by Ken Henderson – Information, explanations, and advice you need to master Transact-SQL and develop the best possible Transact-SQL code. Covers Microsoft Transact-SQL. Softcover. CD-ROM included. Check it out and see some sample pages.

by Alexander Chigrik – Learn how to troubleshoot common full-text search problems.

An unchecked buffer in MDAC leaves SQL Server systems vulnerable to a buffer overrun attack. The latest security patch to MDAC fixes this problem for MDAC 2.5, 2.6, and 2.7.

By David Berlind – Like many pundits of handheld computing, Landry believes in the mobile mantra that “synch is everything.” In that context, “synch” refers to the solid, reliable, and accurate synchronization of desktop- and server-bound data to handheld devices. “The problem” Landry says, ”

By Vyas Kondreddi – This article explains how orphan users get created, and provides you with troubleshooting information. A bonus stored procedure called ShowOrphanUsers is included, that goes and searches all the databases and generates a complete list of orphan users.