New & Notable
Microsoft SQL Server 2008 News
March 07, 2014
Following a request from some SQL Server MVPs, Microsoft has announced that SQL Server 2012 SP2 will come out sometime later this year.
November 11, 2010
Microsoft gave PASS Summit 2010 attendees a walk-through of its Denali SQL Server release, demoing its AlwaysOn, FileTable and expanded SQL Server Integration Services features.
July 16, 2010
In addition to the usual updates and hotfixes, SQL Server 2008 SP2 will take better advantage of R2’s multi-server management and DAC capabilities.
October 28, 2009
Consolidation still has its fair share of challenges, but improvements to SQL Server 2008 could actually make it easier than ever before.
Microsoft SQL Server 2008 Get Started
Bring yourself up to speed with our introductory content
SQL Server Management Studio (SSMS) is an integrated environment for managing a SQL Server infrastructure. Continue Reading
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
An application server is a server program in a computer in a distributed network that provides the business logic for an application program. Continue Reading
Evaluate Microsoft SQL Server 2008 Vendors & Products
Weigh the pros and cons of technologies, products and projects you are considering.
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
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
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
Manage Microsoft SQL Server 2008
Learn to apply best practices and optimize your operations.
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
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
SQL Server 2008 has many compelling features, but not all are worth an upgrade. Before making the move, see what's a good fit for your enterprise right now -- and what can wait. Continue Reading
Problem Solve Microsoft SQL Server 2008 Issues
We’ve gathered up expert advice and tips from professionals like you so that the answers you need are always available.
With the excitement over the cloud, it’s easy to forget that Microsoft’s cloud database, SQL Azure, is not for everyone. Learn the five major differences between SQL Azure and SQL Server. Continue Reading
Microsoft is forever tinkering with SQL Server stored procedures to give queries more thrust. Find out what’s new in SQL Server 2008, 2008 R2 and the next-generation 2012 release. Continue Reading
SQL Server information schema views let you access metadata about database objects such tables and columns. Learn how you can access the views to retrieve relevant information. Continue Reading