Redmond

SQL Server Design: No Code Necessary

In the growing landscape of database management, SQL Server stands as a pillar for enterprises, bustling with robust features and functionalities. For database designers, understanding SQL Server's ...

[Introduction to DB Design & Tuning] Thinking Methods and Approaches for Blazing-Fast Optimization of 'Heavy Databases' Learned in the Field

When operating web applications or business systems for many years, the 'database (DB) performance degradation problem' is something that cannot be avoided.Many engineers and web managers have likely ...
Network World

Review: Microsoft SQL Server 2008 R2

SQL Server 2008 R2, which ships this month, allows end users to tap into the powerful business intelligence features of SQL Server via tight integration with popular Microsoft applications like Excel.
Redmond

Restoring a Database to an Older Version of SQL Server

SQL Server backups cannot be restored to older versions directly. Use Export and Import Data-Tier Application for cross-version database migration. Reconfigure permissions, logins, and connection ...