Microsoft SQL Server 2008

Microsoft SQL Server 2008 Get Started

Bring yourself up to speed with our introductory content

• Seven reasons to upgrade to SQL Server 2012

  Support for early versions of SQL Server has ended. But rather than upgrade to SQL Server 2014, companies are turning to SQL Server 2012. Here is why. Continue Reading

• Microsoft SQL Server Management Studio (SSMS)

  SQL Server Management Studio (SSMS) is an integrated environment for managing a SQL Server infrastructure. Continue Reading

• Microsoft SQL Server 2008 Learning Guide

  This guide provides an in-depth look at SQL Server 2008, with information on upgrading, overviews of the most important new features, and details on future releases. Continue Reading

Evaluate Microsoft SQL Server 2008 Vendors & Products

Weigh the pros and cons of technologies, products and projects you are considering.

• The best new features in SQL Server 2008

  Some new SQL Server 2008 features could make an upgrade more appealing. Get the details on the enhanced data engine, Reporting Services improvements and more. Continue Reading

• New replication features in SQL Server 2008 and what they mean to you

  SQL Server 2008 features several replication improvements, and some are more compelling than others. Here you'll learn what's new with snapshot delivery, peer-to-peer topologies, merge replication and more. Continue Reading

• Migrating to SQL Server 2008 and leveraging new features

  New features in SQL Server 2008, including the FILESTREAM data type and Policy-Based Management offer clear performance enhancements that may make the decision to migrate to SQL Server 2008 a no-brainer. Continue Reading

Product Reviews

• Running long and complicated queries could make the software crash, but it allowed to me make all kinds of important reports easily.

  Powered by IT Central Station

  Valuable Features: The ability to browse table structures and re-design it easily. • Improvements to My Organization: It improved the...Continue Reading

  Rating:

• For a free product, it has a relatively fast load. However, the Enterprise Edition is too expensive for something that won't replace our Oracle DWH database.

  Powered by IT Central Station

  Valuable Features: The high compression and the relatively fast load for a free product. • Use of Solution: I used the Community...Continue Reading

  Rating:

• We're able to create an end-to-end automated BI platform, but we'd prefer hosting multidimensional OLAP instances with Tabular rather than the either/or installation.

  Powered by IT Central Station

  Valuable Features: Business intelligence platform Analysis services (multidimensional and tabular) Relational database features Data...Continue Reading

  Rating:

Manage Microsoft SQL Server 2008

Learn to apply best practices and optimize your operations.

• On the server level with SQL Server dynamic management views

  The pantheon of dynamic management views (DMVs) extends beyond the database-related views covered in the first of two articles focusing on this SQL Server feature. Learn about DMVs that operate at the server level and provide information about a SQL... Continue Reading

• Gain insight with SQL Server dynamic management views

  Dynamic management views, a feature in SQL Server 2005 and newer, let users say goodbye to complex queries for retrieving database information. In the first of this two-part series, have a look at a sampling of SQL Server DMVs and the database info ... Continue Reading

• Upgrading and installing SQL Server 2008

  Carefully planning a SQL Server 2008 upgrade will minimize downtime, prevent data loss and ensure a successful overall experience. Continue Reading