• subscribe

Get Newsletters

  • Get the Latest News
  • Product Updates
  • Helpful Tricks
  • Programming Tips
subscribe to SQL Server Pro Newsletters

Download the latest SQL Server management and database administration, development, and business intelligence Essential Guides from SQL Server Pro. Find a quick reference guide on a specific IT topic.

The Essential Guide to Desktop Virtualization by Citrix

In this Essential Guide, you’ll learn how Desktop Virtualization provides a double win for the enterprise.

The Essential Guide to Lossless iSCSI by Brocade, Hitachi Data Systems

This essential guide will arm you with that knowledge and you’ll be well positioned to assess your current iSCSI infrastructure, evaluate lossless iSCSI products, and engineer an iSCSI SAN infrastructure that will make it possible to implement high-class benefits that are traditionally only available with its FC cousin.

The Essential Guide to Gathering SQL Server Knowledge by Red Gate

In this essential guide, sponsored by Redgate, the areas that are most important for monitoring SQL Server will be discussed in depth.

The Essential Guide to Successful SharePoint Implementation by EMC

This essential guide discusses what challenges may arise and how to overcome them to successfully plan and architect a SharePoint implementation.

The Essential Guide to Mission-Critical SQL Server Environments by EMC

This essential guide, sponsored by EMC will show you  how to optimally configure and manage SQL Server to meet business needs today can be tricky.

The Essential Guide to SQL Server 2008 R2 for the DBA by Microsoft

This essential guide covers the major changes in SQL Server 2008 R2 that DBAs need to know about.

The Essential Guide to Mission-Critical Microsoft SQL Server by EMC

Microsoft® SQL Server® is one of the leading RDBMS Enterprise software applications on the market regardless of database size or performance requirements.

A Guide to Migrating Public Folders to SharePoint by AvePoint

This guide to migrating public folders to SharePoint Server, brought to you by Windows IT Pro and AvePoint, will provide a general overview of the process that will help you plan, design, and carryout your migration with as few problems and pitfalls as possible.

The Essential Guide to SQL Server Consolidation by Unisys

In recent years, application consolidation has been a hot topic within many IT organizations. Why should customers consider database consolidation now? According to industry analysts, companies can typically realize cost savings in the range of 20% by consolidating their database environments.

The Essential Guide to High Performance SQL Server 2008 by Unisys

This guide will address the factors and challenges involved with implementing high performance SQL Server 2008 instances and databases.

The Essential Guide to SQL Server 2005 BI by Dell

In this Essential Guide, we look at how the tools available in Microsoft SQL Server 2005 support Integration Services, Analysis Services, and Reporting Services.

The Essential Guide to SQL Server 2005 and 2008 Failover Clustering with Windows Server 2008 by Dell

This article reviews frequently used Microsoft tool sets, then introduces you to Microsoft SQL Analysis Services -– a powerful, economical, and efficient way to format, display, and interpret your company’s business intelligence data.

The Essential Guide to Reporting Services Tips & Tricks by 90 Degree

Whether you are a developer tasked with report design or a business user who wants to create your own reports, here are some tips and tricks for easily and efficiently creating valuable, flexible reports that perform well, plus a sampling of some third-party tools you can use to extend SSRS's functionality.

The Essential Guide to SQL Server Backup and Recovery by Idera

SQL Server 2005 provides four high-availability technologies: failover clustering and database mirroring, both with supported automatic failover; and log shipping and replication, with either manual or custom-coded failover.

The Essential Guide to Jump Starting Your SQL Server Skills by Quest Software

An accessible guide that focuses on getting you up to speed on database design and hierarchy, with sections on Columns and Data Types, creating databases and tables, and using the Query Editor.

Special Report: Perspectives on SQL Server Sprawl by PolyServe

How many new SQL Servers and databases has your company put up in the last year? In the last two years? Don’t know? Can’t count, there are so many? Does it seem like your database inventory is spiraling out of control? Is containing costs becoming a serious challenge? You’re not alone. This Special Report takes a close look at how SQL Server sprawl affects various key people in every organization and provides best practices for preventing server sprawl.

The Essential Guide to SQL Server Skills for the Oracle DBA by AMD

You’ve been a database administrator (DBA) for a few years now. Your company has always been a dedicated Oracle shop. Recently, however, you’ve heard rumors of change. You know that the vendor walls are being breached when your boss calls you into his office and tells you that you’re going to need to learn how to manage a SQL Server database and no, there won’t be budget for training until next year. Now what? Where do you go to start learning about Microsoft SQL Server?

The Essential Guide to SQL Server Management Fundamentals by EMC

If you're new to managing Microsoft SQL Server 2005 you might feel somewhat lost in a world of tables, indexes, stored procedures, queries, and database backup. In this Essential Guide, I‘ll show you the tools you need to manage a SQL Server 2005 system, SQL Server security essentials, and database backup and recovery. With this article under your belt, you'll know enough about SQL Server to perform necessary administrative tasks on a SQL Server 2005 system.