Business Intelligence Network - The Vision for BI and Beyond

WHITE PAPER - Are you ready for Microsoft SQL Server 2008 R2? This white paper highlights some of the major features included in SQL Server 2008 R2 due to be released in the first half of 2010.
Posted: March 1, 2010 | Published: March 1, 2010


Topics:  Applications Management | Applications Management Software | Data Warehouse Software | Data Warehouses | Database Administration | Network Monitoring | Server Management | SQL | SQL Server | Windows

WHITE PAPER - Businesses, especially finance departments, are challenged to be more effective at acting upon key performance indicators (KPIs). Flexible, yet powerful analytical tools can increase visibility to operational drivers. Read this paper to learn about technology solutions that can remove the responsibility of powerful performance management from IT.
Posted: January 1, 2010 | Published: December 29, 2009


Topics:  Business Intelligence | Business Intelligence Software | Collaboration | Collaborative Master Data Management | Data Integration | Data Management | Data Management Software | ODBC | OLAP | Platform as a service | SQL Server

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: November 30, 2009 | Published: November 30, 2009


Topics:  Code Management | Data Centers | Database Design | Database Performance Management | DB2 | Network Performance | SQL | SQL Server | z/OS

WHITE PAPER - Through a series of test scenarios that are representative of SQL Server application fundamentals, this document provides best practice recommendations on running SQL Server in Windows Hyper-V environment.
Posted: November 23, 2009 | Published: October 1, 2008


Topics:  Best Practices | Data Center Consolidation | Microsoft Hyper-V | QOS | Server Consolidation | SQL Server | TCO

WHITE PAPER - This technical guide for database administrators and IT security experts demonstrates how you can protect your sensitive data with the native database encryption functions of Microsoft SQL Server 2008, such as cell-level encryption and Transparent Data Encryption, and manage and protect encryption keys with hardware security modules (HSMs).
Posted: October 21, 2009 | Published: October 21, 2009


Topics:  Data Encryption | Data Security | Database Administration | Database Administrators | Database Security | Security | Security Hardware | SQL Server | Windows Server Software

WHITE PAPER - Dynamic management views and functions were extraordinary additions to SQL 2005, and they have only improved in function and increased in number in SQL 2008. This white paper will explore a few of their capabilities and give examples as to how they can ease the workload of a database administrator.
Posted: September 22, 2009 | Published: September 22, 2009


Topics:  Database Administration | Database Administrators | Database Management Software | Indexing Software | MySQL | Relational Database Management Software | Reporting Software | SQL | SQL Server | Sybase (Product)

WHITE PAPER - This document covers the key overall concepts and procedures you need to setup and configure your Hyper-V platform. It reviews in detail the approach that PT and Dell recommend for a tested and validated installation of Windows Server 2008 and Hyper-V.
Posted: September 10, 2009 | Published: September 10, 2009


Topics:  Data Center Consolidation | Data Center Management | Databases | Microsoft Hyper-V | Server Consolidation | Server Management | SQL Server | Storage Consolidation

WHITE PAPER - This Guide is a companion to How to Guide: Consolidating multiple SQL Server systems onto Dell PowerEdge Servers using Microsoft’s Hyper-V. In this Guide, we use the Dell PowerEdge R900 and PowerEdge R905 as target servers.
Posted: September 10, 2009 | Published: September 10, 2009


Topics:  Business Intelligence | Databases | Microsoft Hyper-V | Server Consolidation | Server Management | SQL Server | Storage Consolidation

WHITE PAPER - This white paper documents the performance of Microsoft SQL Server 2008 Business Intelligence and Data Warehouse solutions deployed on Dell PowerEdge servers with Dell PowerVault storage. Using the knowledge gained through joint development this white paper illustrates the cost-effective performance of Dell Solutions for SQL Server 2008.
Posted: September 10, 2009 | Published: November 1, 2008


Topics:  Data Storage | Data Warehouse Software | Data Warehouses | Server Management | SQL | SQL Server

WHITE PAPER - In this whitepaper presented by the Edison Group, reveals how Oracle Database widens the manageability lead over Microsoft SQL Server 2008. The study shows how Oracle Database can save 43% in time and 41% in database management costs over Microsoft SQL Server 2008.
Posted: September 9, 2009 | Published: July 15, 2009


Topics:  Data Warehouses | Database Management | Database Performance Management | Database Security | Databases | Oracle (Product) | SQL | SQL Server

WHITE PAPER - When the SQL Server Management Studio (SSMS) was first introduced in SQL Server 2005, it received mixed reviews. With the launch of SQL Server 2008, Microsoft has succeeded in transforming the SSMS into a much more useful tool set. This whitepaper will list and discuss each of these improvements of SSMS 2008.
Posted: July 27, 2009 | Published: July 27, 2009


Topics:  Database Administration | Database Management | Database Performance Management Software | Debugging | Query Tools | Reporting Software | Server Management | Server Software | SQL | SQL Server

WHITE PAPER - Change data capture (CDC) technology has become a strategic component of many data warehouse and business intelligence (BI) architectures. Read this paper and learn how to use change date capture technology with Microsoft SQL server intergration services in real time.
Posted: July 8, 2009 | Published: July 2, 2008


Topics:  Business Intelligence | Change Management | Data Integration | Data Management | Data Warehouses | Database Administrators | Database Management | Server Management | SQL | SQL Server

WHITE PAPER - How do Oracle and Microsoft SQL Server database platforms compare on reliability, scalability and cost when run under enterprise software? Download this white paper for details.
Posted: June 19, 2009 | Published: June 19, 2009


Topics:  Database Management | Database Performance Management | Oracle (Product) | Server Management | Server Software | Server Virtualization | SQL | SQL Server

WHITE PAPER - Microsoft is targeting close to zero downtime with SQL 2008 with availability and recovery features that only used to be available via third-party solutions. This white paper discusses the evolution of High-availability from SQL 2005 to SQL 2008, and the tools available to minimize downtime in the Enterprise.
Posted: May 26, 2009 | Published: May 1, 2009


Topics:  Data Mirroring | Database Administrators | Database Management | Database Performance Management | Databases | Disaster Recovery | High Availability | SQL | SQL Server

WHITE PAPER - Safeguarding personally identifiable information (PII) and remaining in compliance with government regulations is a difficult challenge made easier with database tools from Embarcadero Technologies.
Posted: March 27, 2009 | Published: March 27, 2009


Topics:  Change Management | Database Management | Database Management Software | Database Security | Documentation | Personal Information Management Software | Regulatory Compliance | Security Standards | SQL Server | Storage Best Practices | Storage Management Software