Microsoft is targeting close to zero downtime with SQL 2008 with availability and recovery features that only used to be available via third-party solutions. This white paper discusses the evolution of High-availability from SQL 2005 to SQL 2008, and the tools available to minimize downtime in the Enterprise. 

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. 

Are you ready to upgrade to Microsoft SQL 11? Access this exclusive resource to learn how Microsoft improves on SQL Server 2008, and check out the underlying themes emphasized in the new features in Microsoft SQL 11 and how they work. 

The security of SQL Server database servers has become a top priority for database administrators. This article examines best practices that can be employed to secure Microsoft SQL Server 2000 databases. It provides an overview of the security model in SQL Server 2000 and discusses best practices you can employ to secure yours. 

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. 

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. 

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. 

In this e-guide, explore the pros and cons of virtualizing your applications. Discover what essential questions you should ask before virtualizing mission-critical applications and servers, such as SQL Server, Microsoft Exchange Server, Sharepoint and more. 

In this paper you’ll learn how Snapshots use a copy-on-write operation that minimizes the drive space required for each snapshot. Unless there are changes in the original database, the snapshots will remain empty. Queries to the snapshot for un­changed records will automatically be redirected to the original database. 

Read this white paper to get a comparison of data modeling tools. 

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. 

As IT budgets continue to slump, you'll need to develop a solid case for the SQL Server upgrade. Inside this e-Book, learn about the features that will get the management buy-in. 

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.