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.

Getting the “Business” into Business-Oriented Data Modeling – Practical Techniques and Examples by CA/ERwin

This white paper will show you techniques to great data modeling accomplished by providing specific guidelines and a business-oriented approach.

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 data model 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.

Kaminario® Performance Analysis on Microsoft® SQL Server® by Kaminario

This example report is a detailed analysis performed by Kaminario of an application environment with Microsoft SQL Server as the database. Read more to learn how this analysisidentified several I/O related problems within the production environment which the Kaminario K2 can resolve.

Kaminario® K2 DataProtect™: High Availability and Data Protection for High Performance SSD SANs by Kaminario

This white paper discusses DataProtect capabilities and how it optimizes SSD-based backup and disaster recovery environments.

Demystify TempDB Performance and Manageability by Idera

In this white paper, Robert L. Davis demystifies the best practices that work some of the time, but not all of the time, when it comes to TempDB.

Scaling and Optimizing Microsoft SQL Server by Citrix

This white paper looks at a database load balancing feature with which enterprises can tackle the challenges of an ever-growing sprawl of database servers. You’ll learn how you can simplify database management and scaling, resulting in greater availability, performance, and security.

Scaling the Data Tier with Intelligent Load Balancing by Citrix

This white paper discusses a native SQL data load balancing solution, the first ADC (application delivery controller) to extend the benefits of scalability, availability, and security for the web tier to the data tier.

How to Use SQL Server’s Extended Events and Notifications to Proactively Resolve Performance Issues by Quest Software

In this new white paper, discover how event notifications and extended events can help you proactively monitor your databases. You’ll see how notifications can automate issue response, how events give you the power to drill down into SQL Server, and much more.

Handling a Full SQL Server Transaction Log by Red Gate

This whitepaper: • Describes the correct way to respond to log errors • Reviews the danger of some of the courses of action suggested on various community sites and forum • And offers advice on how to best to avoid the occurrence of this problem

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

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

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.

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

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.