SQL Server Reports

WHITE PAPER: This paper focuses on the SQL Server I/O subsystem and the role it plays in a SharePoint environment. The lessons learned in this paper will help IT Managers build more efficient and effective SharePoint environments on an SQL back-end.

Posted: 08 Oct 2010 | Published: 24 Aug 2010

WHITE PAPER: This paper outlines different considerations for separating decision support systems (DSS) from Transaction Processing (OLTP) environments and touches upon technical procedures for achieving the same, as well as examines data warehouse solutions, different storage topologies, storage interface optimizations and much more.

Posted: 08 Oct 2010 | Published: 29 Jul 2009

WHITE PAPER: New IBM DB2 features make compatibility easy. In this guide, you’ll learn about native support for PL/SQL, new data types, scalar functions, improved concurrency, built-in packages, OCI, SQL*Plus, data movement tools, best practices and more—all designed to improve your ability to run applications on both DB2 and Oracle platforms

Posted: 01 Sep 2010 | Published: 01 Sep 2010

WHITE PAPER: This article overviews the new PL/SQL compatibility features in IBM DB2 software version 9.7, making it easier to adopt and allowing you to take advantage of its autonomic and high-performance characteristics. 

Posted: 01 Sep 2010 | Published: 01 Sep 2010

EZINE: Volume 3 of the SQL Server Insider E-zine offers tips for the SQL Server pro. This volume covers the following topics: "Are We There Yet? The Slow Road to SQL Azure," "Finding Your BI Niche in the Cloud," and "The Three Sides of DACPAC with SQL Server 2008 R2."

Posted: 04 Aug 2010 | Published: 03 Aug 2010

PRODUCT DEMO: Watch this video demonstration to see exactly how FalconStor Continuous Data Protector is used to protect and recover your Microsoft SQL Server data.

Posted: 21 Jul 2010 | Premiered: 21 Jul 2010

CASE STUDY: Online dieting website SparkPeople.com sought to eliminate its storage I/O bottleneck to give customers fast, simplified access to their information from its database-powered Web site, and ensure that the next busy season would pose no scalability problems. Learn how they achieved their goals with Dell and Dell/EMC solutions.

Posted: 13 Jul 2010 | Published: 01 Apr 2010

WHITE PAPER: Read this paper for a description of the benefits and performance of the latest Dell™ PowerEdge™ R810 running Microsoft® SQL Server® in VMware® vSphere™ 4.0 Update 1 (U1) and EqualLogic™ PS6000XV iSCSI storage arrays.

Posted: 12 Jul 2010 | Published: 23 Apr 2010

WHITE PAPER: Read this paper for a discussion of the Community Technology Preview (CTP) process, and the CTP5 incarnation specifically. This paper examines mission-critical features, enterprise management features, database data and programmability, and new business intelligence features.

Posted: 12 Jul 2010 | Published: 15 Jan 2008

WHITE PAPER: Read this paper for an informative guide to helping you consolidate your Microsoft® SQL Server® 2000 and SQL Server 2005 databases from multiple machines onto a single SQL Server 2008 server system.

Posted: 12 Jul 2010 | Published: 30 Oct 2008

WHITE PAPER: This white paper describes the benefits and performance of the latest Dell PowerEdge R810 running Microsoft SQL Server in VMware vSphere 4.0 Update 1 (U1) and EqualLogic PS6000XV iSCSI storage arrays.

Posted: 12 Jul 2010 | Published: 12 Jul 2010

WHITE PAPER: This Quick Reference Guide is for people who need to understand the basics of how Microsoft SQL Server 2008 R2 is licensed and sold. This guide does not supersede or replace any of the legal documentation covering SQL Server use rights.

Posted: 12 Jul 2010 | Published: 12 Jul 2010

WHITE PAPER: Consolidating and/or virtualizing SQL Server databases can improve data center efficiency and enable you to tackle database sprawl, achieve high availability, and boost agility. Beginning with the value 4 processor (4P) capabilities of the AMD Opteron™ 6000 Series platform, the AMD/Dell/Microsoft combination can help produce substantial savings.

Posted: 06 Jul 2010 | Published: 06 Jul 2010

WHITE PAPER: Consolidating and/or virtualizing SQL Server databases can improve data center efficiency and enable you to tackle database sprawl, achieve high availability, and boost agility. Beginning with the value 4 processor (4P) capabilities of the AMD Opteron™ 6000 Series platform, the AMD/Dell/Microsoft combination can help produce substantial savings.

Posted: 25 Jun 2010 | Published: 25 Jun 2010

EBOOK: Learn about all of the exciting enhancements and new capabilities engineered into SQL Server 2008 R2 that will have a positive impact on your applications, ranging from improvements in operation to those in management.

Posted: 25 Jun 2010 | Published: 25 Jun 2010

WHITE PAPER: This guide outlines the common steps that people go through when they are interested in evaluating an open source database (e.g. one or both of the Postgres Plus products). This guide will also provide links to other documents/collateral that will help you accomplish each step. Read on to learn about these common steps in evaluation in more detail.

Posted: 16 Jun 2010 | Published: 15 Jun 2010

PRESENTATION TRANSCRIPT: Confused about BI? This presentation transcript breaks down the basics of business intelligence and outlines the key features for Microsoft SQL Server. Discover the advantages of BI and find out how to get started with a business intelligence strategy to enhance your organization.

Posted: 19 May 2010 | Published: 19 May 2010

WHITE PAPER: This paper describes game-changing innovations in SQL Server® 2008 R2, including self-service business intelligence (BI), server manageability, complex event processing (CEP), and Master Data Services. 

Posted: 10 May 2010 | Published: 04 May 2010

WHITE PAPER: The Total Data Quality Integration Toolkit is an affordable, full-featured enterprise data integration platform and rich development environment for creating and managing data assets that can be leveraged specifically for MDM applications. TDQ-IT leverages SSIS to provide a flexible, effective solution for data quality and MDM initiatives.

Posted: 20 Apr 2010 | Published: 20 Apr 2010

EZINE: Business intelligence is a hot topic in 2010, especially with the upcoming release of Microsoft's SQL Server 2008 R2 being dubbed as the "BI release." In this e-zine, one SQL Server expert breaks down exactly what goes into self-service BI, where it works and where it falls short.

Posted: 16 Feb 2010 | Published: 16 Feb 2010

EBOOK: Database consolidation can take many forms, but getting the most out of your available resources is always the goal. Read this E-Book to learn about your SQL Server consolidation options.

Posted: 08 Feb 2010 | Published: 08 Feb 2010

CASE STUDY: Greenbrier needed a fast, stable, and scalable SharePoint data protection solution capable of backing up directly to disk, and able to seamlessly integrate with both their existing and intended IT infrastructure. Learn why they turned to AvePoint's DocAve solution for its reliability and modular architecture.

Posted: 04 Feb 2010 | Published: 04 Feb 2010

WHITE PAPER: This paper discusses how and why to design SQL that will reduce the number of times calls are made to DB2. We'll look at how to write SMART applications rather than writing applications that act like generic I/O modules to DB2, properly tune SMART SQL, and how to exploit SQL and application features in DB2 on z/OS version 8 and 9.

Posted: 30 Nov 2009 | Published: 30 Nov 2009

PRESENTATION TRANSCRIPT: In this transcript of the "Data Warehousing Basics for SQL Server Analysis Services" webcast, learn how to build your data warehouse for your SQL Server environment. Discover the necessary steps involved and learn about major concepts, including relational data warehousing and supported SQL Server Analysis Services (SSAS) storage formats.

Posted: 25 Nov 2009 | Published: 25 Nov 2009

EBOOK: SQL Server 2008 has many compelling features, but not all of them are necessary. See what's a good fit for your enterprise and what can wait.

Posted: 24 Nov 2009 | Published: 23 Nov 2009