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.

Delivering Mobile BI Dashboards to Any Device via XAML & HTML5 by ComponentArt

Learn how you can leverage ComponentArt’s XAML and HTML5 technology to deliver rich, interactive and engaging mobile dashboards to any device: Apple iPad & iPhone, Windows 8 tablets & phones, Android tablets & phones, Blackberry Playbook & phones or any Windows or Mac OS computer.

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.

Best Practice: Log Management for Security and Compliance Initiatives by Ipswitch

Learn more about how your organization could implement an effective event log strategy by reading the white paper.

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.

In-Memory or Live Reporting: Which Is Better For SQL Server? by Tableau

Read this whitepaper to get a look at some scenarios where in-memory or live reporting might be preferable for a SQL Server environment.

Business Intelligence Requirements for IT: What every IT Manager Should Know about Users’ Real Need for BI by Tableau

Read this whitepaper to find out the requirements to consider when evaluating agile business intelligence.

5 Needs Excel Can’t Solve by Tableau

Read this paper to find out the five capabilities that stand out that you need to add to your toolbox to get the most out of your data.

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.