After many sleepless nights, our editors have compiled the best products of 2008 in 12 categories, including Product of the Year. Find out who earned the highest honors in our annual Editors' Best awards.
In this instructional video, Randy Dyess discusses the database mirroring feature found in SQL Server 2008.
Randy walks you through database mirroring architecture and how this feature has changed since its release in SQL Server 2005. Throughout the video you will be offered insights into how you can best use database mirroring to achieve high availability and data protection.
In this instructional video, Randy Dyess discusses security in SQL Server 2008. You will learn the fundamentals of SQL Server 2008 data security and how you can use this security in your database environments.
Randy also discusses security starting from the server to the database and then finally to the data itself. This video will cover both security permissions and data encryption.
SQL Server Magazine gives you information about database-related hardware, software, and services in every issue. In our second annual Editors' Choice Awards, we honor the best of the best from all the products we've covered in the past year.
Recently, I've been working with a consulting client to help them tame CPU usage. Typically, they're clocking over 20,000 queries and operations per second on their e-commerce SQL Server, but ran into an issue where CPU started spiking up above 90 percent for sustained periods of time....More
What should most database administrators be doing on a regular basis? Here's a comprehensive list from Michael K. Campbell of many of the things DBAs typically do on a daily, weekly, monthly, and yearly basis....More