In this SearchSQLServer.com E-Guide, you will discover the unique advantages offered by a SQL Server 2008 migration. 

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. 

In this expert e-guide, find out how to optimize SQL Server with the right choices for hardware, storage devices, and virtualization. Inside, find articles on: what not to do when purchasing hardware; if solid-state storage devices are worth the cost; hardware and risk considerations for an inevitable virtualization initiative. 

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. 

This white paper takes a look at how Dell EqualLogic XVS can be implemented to help solve some of the storage problems associated with the adoption of SQL Server. 

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. 

To run secure, compressed, blazing-fast backups, you need the right tool – and that’s LiteSpeed for SQL Server. In this new technical brief, discover six LiteSpeed features every DBA should know, and how LiteSpeed for SQL Server can make every DBA’s job easier. Read it today. 

This white paper discusses the information security and compliance issues associated with Microsoft SQL Server database systems. Whether you’re a CSO, IT manager, internal auditor or database administrator, you'll learn about the database security threat, how compliance fits into the overall scheme and what you should do to minimize your risks. 

This white paper guides you through troubleshooting using some of SQL 2005's built-in features to diagnose issues with your database. 

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. 

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. 

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.