Join us on May 2nd, as we discuss preparing for DDoS attacks, building resiliency, overcoming obstacles and key preparations to make now before ransomware attacks.
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...