Join us March 28, 2024, as we discuss some of the most promising emerging cybersecurity technologies and how you can adopt them into your organizations.
Microsoft is looking for a few thousand good people to participate in the SQL Server 2000 Service Pack 2 (SP2) technical beta program. Last week, I talked with Microsoft's James Morris about the upcoming release of SQL Server 2000 SP2. Morris, a...
Good primary keys are essential to good database design. They let you query and modify each table row individually without changing other rows in the same table. When you evaluate candidates for a table's primary key, follow these rules...
We have an UPDATE trigger that occasionally triggers a lengthy batch process that's encapsulated in a stored procedure. The code works, but the process that issues the UPDATE statement can't continue until the trigger is complete. Can we return...
Most of us know that SQL Server 2000 ships with rich support for manipulating XML data, but many SQL Server professionals seem unaware that Microsoft initially distributed XML for SQL Server 2000 Web Release 1 (WR1) in January 2001. Microsoft...
Our company wants to move its Web site to a new host. Our database server uses SQL Server 7.0, but we lease the SQL Server license from the host. Our Web site receives roughly 1 million page views per day, and we want to buy our own SQL Server...