By Alexander Chigrik – Learn how to optimize SQL Server Performance using files and filegroups.

Who should read this bulletin: Database administrators using Microsoft® SQL Server™ or Microsoft SQL Server Desktop Engine (MSDE) 2000. Impact of vulnerability: Three new vulnerabilities, the most serious of which could run code of attacker’s choice on server.

By Chris Cubley – You are creating a payroll processing system. At the end of each pay cycle, the system must compute the payroll for that pay cycle based upon the records of the employees’ hours and various configuration tables such as taxes, deductions, etc. The data in the configuration tables wi

Learn how to avoid common problems that affect operations, including unexpected SQL Server outages, surprise capacity issues and data anomalies, during NetIQ’s FREE one-hour audiocast.NetIQ’s SQL Server management experts will cover how to implement the best practices of the Microsoft Operat

By Thomas C Greene – The inner workings of the undocumented pwdencrypt() hash function in Microsoft SQL Server have been revealed in a paper by security researcher David Litchfield of Next Generation Security Software (NGSS).

by Jay Schmelzer – The SQLXML Web releases provide several new features for interacting with a SQL Server 2000 database using XML technologies. SQLXML 3.0 continues to build on these features, adding the ability to expose SQL Server 2000 data using XML-based Web services. SQLXML 3.0 makes exposing S

By Paul Krill – MICROSOFT IS SEEKING candidates to test Beta 2 of its 64-bit SQL Server 2000 Enterprise database which is being optimized for Intel Itanium 2 hardware platform launched on Monday.

By Santosh Rao – I had one of my requirements in my application to store some custom SQL Queries into our System. These SQL Queries would be provided by the end user who is kind of well versed at least with SQL. Our system later would execute these queries to perform various aspects of the system.

Book by Denise Gosnell, Tony Bain, Jonathon Walsh – Many VB developers choose SQL Server 2000, a robust enterprise-level database system, to provide the data layer in their applications. The introduction of Microsoft’s .NET Framework brings us ADO.NET, the latest means of connecting to that data sou

This article describes how to change the location of the data and log files for any SQL Server 7.0 or SQL Server 2000 database.