Download the latest SQL Server management and database administration, development, and business intelligence white papers, research studies, best practices, and case studies from SQL Server Pro. Keep up to date with the latest technology and IT trends.

A Usability Comparison of the Top 3 Modeling Tools by CA/ERwin

This review will compare CA ERwin Data Modeler r8 (CA ERwin), newly released in February 2011, with two other popular modeling tools Sybase‘s PowerDesigner v15.3.0 (PowerDesigner) and Embarcadero Technologies‘ ER/Studio Data Architect 9.0.1 (ER/Studio). All three tests involved modeling for a Microsoft SQL Server 2008 environment.

The Benefits of Data Modeling in Business Intelligence by CA/ERwin

This white paper discusses the role of data modeling in documenting, explaining, and clarifying the output of the various components of BI.

Ten Things to Avoid in a Data Model by CA/ERwin

In this white paper, industry expert Michael Blaha covers the Top 10 pitfalls to avoid — from both the strategy and detail perspective.

Best Practices for Moving to the Cloud using Data Models in the DaaS Lifecycle by CA/ERwin

In this paper, we propose guidelines that affect all aspects of Cloud DaaS services: security, performance, connections, and the security life cycle to govern what is really important in migrating to on-demand hosted applications, and managing this data in the Cloud.

The SQL Server Security Threat – It’s Closer Than You Think by Idera

This whitepaper discusses the information security and compliance issues associated with Microsoft SQL Server database systems.

Why Cloud and How to Choose a Cloud Vendor by Autonomy

This white paper explores the benefits of cloud-based storage and offers tips for choosing the correct cloud vendor.

Best Practices for SP Development and Customization by Quest Software

In this Quest Software white paper, discover best practices for empowering SharePoint users to customize their own sites with less “hands-on” developer assistance. See how to create a flexible, powerful SharePoint change solution – so you can focus on the rest of your day! Read it today.

Migration Performance and Speed Considerations for SharePoint 2010 by Metalogix

This white paper focuses on directly addressing the performance aspects of a SharePoint migration using third-party solutions. It discusses migration techniques as well as changes to back-end server architecture that can be used to greatly improve the overall speed of content migration.

Enterprise CloudSystem Solution Brief - The most complete hybrid cloud solution for infrastructure and application provisioning by HP

This paper introduces a hybrid cloud solution that can help you build and manage services across a cloud environment. Read on and learn how to turn your hybrid cloud vision into a reality.

Unlocking the Minds of Storage Users by EMC

The study surveys end users to chart emerging trends and to capture end-user acceptance of emerging technologies and market offerings.

Top SQL Server Backup Mistakes and How to Avoid Them by Idera

This paper outlines several common mistakes that should be avoided when creating and implementing a backup solution.

Top 6 LiteSpeed Features DBAs Should Know About by Quest Software

Check out this tech brief to see 10 little-known LiteSpeed features you could benefit from right now.

Killing Administrator: Solving Three Problems by Eliminating Administrative Rights by ScriptLogic

Eliminating “the Administrator” from administrator rights solves three big problems that have plagued Windows administration for years.

Amplify Data Center Efficiencies by Solving Key Challenges that Impact Costs, Performance, and Growth by HP

This white paper reveals the top data center challenges and explains how to conquer them.

A Comprehensive Framework for Securing Virtualized Data Centers by HP

In this seminar, you will learn the real need for security solutions that can address the reality of expanding virtualization. You will also learn how HP TippingPoint’s secure virtualization framework allows organizations to gain control of the virtual environment by introducing in-line security policy enforcement.

Building Mission Critical Data Centers by HP

This white paper unveils a solution that streamlines the design of next-generation data centers to ensure the superior resiliency, performance, and agility that enterprise networks now require.

7 Tips for Achieving Active Directory Compliance by Quest Software

In this paper, we provide tips and tricks to make the best use of native Active Directory auditing, as well as guidelines on what auditors and compliance officers look for when it comes to keeping an eye on what’s going on within your Active Directory environ­ment.

Office 365 – Bringing Enterprise-Class Cloud Email Capabilities to the Masses by Quest Software

In this white paper, we’ll look at Office 365 and how you might benefit from a cloud-based or hybrid email solu­tion in terms of functionality, availability, and cost savings.

Myth Busted: Affordable, Easy to Manage Virtualization with High-Availability is a Reality by Stratus

In this white paper, Dan Kusnetzky takes a deep look at all of the virtualization benefits as well as a number of issues SMBs face, including the requirement to use automated systems to address operational issues, reducing virtualization complexity and maintaining availability.

High Performance Solid-state SAN Storage by Kaminario

This paper examines how storage performance impacts system performance, reliability, availability, and agility, and reviews what an ideal solution would be.

Don’t Let Your Active Directory Forest Burn Around You: The Essential Planning Guide for AD Forest Recovery by Quest Software

In this white paper, we look at a number of scenarios that might necessitate a full recovery of an AD forest.

Ten Reasons to Modernize the Desktop by VMware

This white paper provides 10 reasons IT departments should embark on a desktop modernization strategy.

Data Cross Currents: 2011 Survey on Cross-Platform Database Administration by Quest Software

In this Unisphere Research survey, sponsored by Quest Software, see how a strong cross-platform database management administration – including cloud management – saves your company money.

IDC Whitepaper: Five Steps to Successful Integrated Cloud Management by HP

This IDC paper explains 5 steps to integrating Cloud and offers recommendations on how-to start your cloud journey.

Protecting the Enterprise Network against Emerging Internet Threats by EdgeWave

In this white paper, you’ll learn how to counteract the full spectrum of Web threats and educate executive management on the value of investing in an industry leading, cost-effective Web gateway filtering solution.

6 Important Steps to Evaluating a Web Filtering Solution by EdgeWave

This brief outlines a concise list of steps that will help you achieve the best return on your Web filtering dollar.

Application Control and Whitelisting for Endpoints by Avecto

This paper explores the application control landscape and the recommend strategies for adoption.

Applying the Principle of Least Privilege to Windows 7 by Avecto

This paper introduces the application of least privilege on Windows 7 (which applies equally to Windows Vista).

Regulatory Compliance and Least Privilege Security by Avecto

This whitepaper discusses the concept of least privilege security for personal computers, why it’s needed to meet requirements set out by regulatory bodies and how to overcome problems in its implementation.

Implementing Windows Security with Group Policy by Avecto

One area that standard Microsoft tools and Group Policy does not solve is that of least privilege. This paper introduces a solution to this omission by Microsoft, which is to leverage the extensibility of Group Policy with Privilege Guard by Avecto.

How to Overcome the Most Common Power-Related Headaches by Eaton

This white paper discusses eight power-related challenges, and shows how a new generation of intelligent, logical and complete power management solutions can help data center managers tackle each of them effectively and efficiently.

Reduce Energy, Cabling and Cooling Costs While Increasing Efficiency for Your Data Center by Eaton

This paper shows how the latest advancements in power distribution products can reduce energy, cabling, and cooling costs for your data center.

10 Underutilized Best Practices for Building and Maintaining Your Data Center Power Infrastructure by Eaton

This white paper discusses 10 underutilized best practices for building and maintaining a highly available data center power infrastructure.

Virtualizing Your Data Center – Are You Ready? by Eaton

The power and cooling infrastructure—which may have been quite sufficient for pre-virtualization needs—could easily become inadequate when data center performance patterns are radically altered. This paper looks at some of the power-related challenges and the readily available technologies to address them.

Building a Secure and Compliant Windows Desktop by Beyond Trust

This paper presents the benefits or removing administrator rights from end users, the combination of technologies needed for effective implementation of this level of security, and how to best remove the local Administrator account, while maintaining the users’ access to all applications.

Least Privilege Application Compatibility for Windows 7 Migrations by Beyond Trust

This paper will give you an overview of the new technologies built into Windows 7 and how those technologies can help you in your migration.

Extending the Value of Group Policy Securely & Effectively by Beyond Trust

In this white paper, we will cover areas related to Group Policy and security configuration management.

Windows 7 and Desktop Lockdown with Privilege Management by Viewfinity

This whitepaper highlights some of the key benefits to an organization when the users do not have local administrator rights.

HP CloudSystem Matrix: Managing at a Higher Level by HP

This white paper helps you understand how to think about IT infrastructure in a systematic, holistic way and how HP’s CloudSystem Matrix can make that possible.

HP CloudSystem Matrix: Building a Private Cloud by HP

This white paper offers a look at the private cloud, how it works and the best approach for implementing it.

HP Cloud Service Automation: Intelligent automation for building, managing, and securing cloud services by HP

This solution brief explains the HP Cloud Service Automation - a unique blend of software and services, providing a flexible cloud solution to deliver infrastructure and applications as a service.

HP 3PAR Utility Storage: Next-Generation Storage for Virtual and Cloud Data Centers by HP

This white paper helps you learn how to deliver massive scalability, secure multi-tenancy, high performance, and high availability to fuel enterprise-class virtual data centers and cloud computing environments to meet even rapidly changing business demands.

HP CloudSystem: An integrated platform for private, public, and hybrid clouds by HP

This solution brief offers a view into HP CloudSystem and what it can do for your organization.

HP CloudSystem Matrix: Benefits of Private Cloud and Infrastructure as a Service Today by HP

This solution brief will help you understand the benefits of the HP CloudSystem Matrix which provides a unified solution for physical and virtual environments that’s perfectly suited as an IT consolidation platform.

Are Privileged Passwords Your Weakest Link? by Thycotic Software

This whitepaper helps explain the role of Password Management as it pertains to a larger Identity Access management strategy. The concepts presented in the paper serve as an overview of potential security vulnerabilities and implementation challenges that an IT Pro might face while attempting to manage privileged passwords. Also, the paper highlights ineffective and potentially dangerous password management strategies while outlining the key concepts of a more successful model.

Maximizing Windows Endpoint Management by Promisec

This white paper describes the best approach to maintain effective management control of Windows endpoint systems.

Catching an Edge - On the Trail to Microsoft Certified Master by Mountain View Systems

This April, James Carrion with Mountain View Systems, embarked on a personal quest for the esteemed Microsoft Certified Master (MCM) designation. Get the whole adventure here!

Destroying Performance Bottlenecks Across Diverse VM Environments by Quest Software

This technical brief explores the primary attributes of a solution that not only detects, diagnoses, and resolves performance bottlenecks in virtualized infrastructures quickly and efficiently, but also reduces risk and improves performance, uptime, and efficiency.

How to Virtualize with Confidence by Quest Software

In this technical brief, You’ll learn what you need to overcome virtualization challenges, and how one powerful solution provides the most extensive set of capabilities on the market, yet is easy to use.