When the SQL Server Management Studio (SSMS) was first introduced in SQL Server 2005, it received mixed reviews. With the launch of SQL Server 2008, Microsoft has succeeded in transforming the SSMS into a much more useful tool set. This whitepaper will list and discuss each of these improvements of SSMS 2008. 

Optimizing SQL Server performance can be a daunting task, especially for an increasing number of reluctant DBAs faced with managing their organization’s SQL Server databases, despite little training. This white paper provides a high-level overview of core SQL Server performance concepts and an overview of essential SQL Server performance tools. 

Some consider SQL Server 2008 R2 a "business intelligence release" because the largest, most publicized changes cater to the BI functionality of the product. There are, however, many other new features and functionalities within SQL Server 2008 R2. In this expert e-guide, readers will learn more about these new features. 

Dynamic management views and functions were extraordinary additions to SQL 2005, and they have only improved in function and increased in number in SQL 2008. This white paper will explore a few of their capabilities and give examples as to how they can ease the workload of a database administrator. 

It isn't always easy to know when to upgrade to the latest hardware or software release. In the case of Microsoft SQL Server 2008, there are many compelling reasons to make the move, including: Enhanced business intelligence; improved business continuity features; better performance and better management capabilities. 

SQL Server performance management requires serious time, energy and patience! In this new white paper by Kevin Kline, discover detailed guidance on the issues you can relate to—from cache trashing to bad T-SQL that can return to haunt your applications.See how to maximize database scalability and efficiency with ease. Read the white paper today. 

Microsoft SQL Server has evolved over the years as a scalable, robust database management system and is now competing in the VLDB (Very Large Database) space with Oracle and IBM.  This white paper outlines some of theimportant fundamentals of Microsoft SQL Server that every DBA should know. 

This document focuses on each level of security, starting at the server level and working our way down to database objects such as Server Security, Database Security, Schema Security and Object Security. 

SQL Server 2008 R2 has been labeled a BI release because of its new features for business intelligence. In this interactive classroom, industry expert Don Jones explains the improvements made to existing SQL Server BI features like SSRS. Learn about the benefits of self-service BI and Master Data Services. Then take a quiz to test your knowledge. 

In this paper, learn how performance enhancements in SQL Server 2008 R2 make it easier and faster for end-users to generate, access, and analyze data. 

This Technical Report will discuss advanced operations and techniques on how to use Auto-Snapshot Manager / Microsoft Edition to protect SQL Server databases as well as enhance SQL Server operations in the datacenter. 

Business intelligence is a hot topic in 2010, especially with the upcoming release of Microsoft's SQL Server 2008 R2 being dubbed as the "BI release." In this e-zine, one SQL Server expert breaks down exactly what goes into self-service BI, where it works and where it falls short. 

Small and medium businesses need to support growth while wringing every ounce of value out of the investments they've already made. This paper looks at the benefits of virtualizing SQL Server databases, as well as how to get the most out of your virtual infrastructure.