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. 

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. 

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. 

Database administrators can quickly setup realistic SQL Server testing and development environments. PS Series arrays advanced data protection with quick recovery, online scalability and remote replication make it the ideal storage platform for SQL Server environments that require maximum availability. 

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. 

The goal of this paper is to describe best practices for deploying Decision Support System (DSS) or Data Warehousing (DW) solutions based on Microsoft SQL Server 2008 using Dell EqualLogic storage. Download now and learn more. 

This Technical Report describes using EqualLogic Auto-Snapshot Manager / Microsoft Edition to perform online Smart Copy protection and recovery for SQL Server 

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. 

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. 

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.