In SQL Server, the database can be stored in different files and filegroups. If your database is small (100 MB or less), you do not need to worry too much about files and filegroups. But if you have a ...

In addition, there isn’t a need for point-in-time or up-to-the-minute restores.For more information on recovery models review chapter 3, “Administering SQL Server 2005 Database Engine” on my SQL ...

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

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

Microsoft Corp.s long-awaited SQL Server 2005 represents significant change for administrators—the database server includes several new features that add capability and improve performance, but they ...

Early discussions on SQL Server 2008 seemed to suggest that it would really only be a point release, quite unlike what occurred with SQL Server 2005. Anyone looking at the new and upgraded features in ...

— Today at the 2004 Professional Association for SQL Server (PASS) Community Summit in Orlando, Fla., Microsoft Corp. extended its comprehensive data platform by demonstrating new business ...