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 ...

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 ...

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 ...

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 ...

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 ...

Super-fast performance, robust toolset and better security options make Microsoft's latest database management system a must for most shops. It's easy to be overwhelmed by the raft of new features in ...

On Monday, Microsoft announced availability of the much-anticipated beta two version of Visual Studio 2005 and the .Net Compact Framework 2.0, as well as a community technology preview of SQL Server ...

Brien M. Posey is a freelance technical writer who has contributed to dozens of books and is a six-time Microsoft MVP award winner. SQL Server 2005 reaches its end-of-life milestone on April 12, the ...