Get the lowdown on SP-1's added features, including fully supported database mirroring, bug fixes, and add-ons for SQL Express. What's more, SP1 not only contains bug fixes, but also delivers ...

When working with my customers on SQL Server security, I constantly get the same question, “What are some best practices for hardening my SQL Server implementation?” Over the years, I have come up ...

Arthur Fuller recounts his less-than-smooth installation of SQL Server 2005 Express Edition and offers a few suggestions based on what he learned along the way. Like thousands of developers, I eagerly ...

If you still have SQL Server 2005 anywhere in your firm, you now have four months to get a migration program going before Microsoft pulls the plug on support for the aging database. April 12 will be ...

Yesterday, Microsoft released a patch for a flaw in SQL Server 2005 SP2 that affected both existing and new maintenance plans and Integration Services packages. Although not every SQL Server 2005 ...

It appears that the long wait for SQL Server 2005—the successor to Microsoft's renowned SQL Server 2000—will be well worth it. SQL 2005 promises to be a polished, powerful product with significant new ...