WHITE PAPER - Microsoft SQL Server has evolved over the years as a scalable, robust database management system and is now competing in the VLDB (Very Large Database) space with Oracle and IBM.  This white paper outlines some of theimportant fundamentals of Microsoft SQL Server that every DBA should know.
Posted: March 17, 2010 | Published: March 17, 2010


Topics:  Backups | Data Recovery | Data Security | Database Administrators | Database Management | Database Performance Management | SQL | SQL Server

WHITE PAPER - EnterpriseDB's Postgres Plus Advanced Server builds on the rock-solid PostgreSQL foundation to deliver significant value-added features not available in the community edition.
Posted: March 2, 2010 | Published: March 2, 2010


Topics:  Database Administration | Database Administrators | Database Management | Database Management Software | Database Performance Management | Databases | Open Source | Open Source Software | PostgreSQL | SQL

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

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: February 16, 2010 | Published: February 16, 2010


Topics:  Business Intelligence | Business Intelligence Software | Cost Benefit Analysis | Database Administration | Database Management | Master Data Management | Reporting Software | Self-Service Applications Software | SQL | SQL Server

WHITE PAPER - SQL Server is the world’s most widely used database for small and medium businesses due to its power, speed and affordability. Yet users often face challenges in producing the BI needed to gain crucial insight into their businesses. This paper can help those using Microsoft for business intelligence evaluate their situation and alternatives.
Posted: February 15, 2010 | Published: February 12, 2010


Topics:  Business Intelligence | Business Intelligence Software | Cloud Computing | Dashboards | Databases | OLAP | Open Source | Reporting Software | Small Businesses | Software as a Service | SQL | TCO

CASE STUDY - Constellation Energy is the largest wholesale power seller in the United States. When they needed a granular, full fidelity data migration from WSSv2 to WSSv3 platforms, they turned to DocAve SharePoint Migrator. Read this case study to learn how AvePoint's migration solution helped them to achieve their migration goals.
Posted: February 3, 2010 | Published: February 3, 2010


Topics:  Collaboration | Collaborative Applications Software | Data Migration | Database Management | Database Performance Management | Microsoft Office | Software Migration | SQL

TRIAL SOFTWARE - The Attunity Oracle-CDC for SSIS product simplifies & accelerates CDC implementation while enabling efficient, real-time data integration in low latency. It leverages existing SQL Server investments to reduce resources and costs.
Posted: January 14, 2010 | Published: January 14, 2010


Topics:  Data Integration | Data Management | Data Management Software | Data Migration | Data Replication | Data Warehouse Software | ETL (Software) | Integration Server Software | Oracle (Product) | SQL | SQL Server

WHITE PAPER - Read this paper to learn what the key differences between workflow engines and BPM suites are and how BPM suites can provide benefits to your organization that workflow engines can’t.
Posted: December 18, 2009 | Published: December 18, 2009


Topics:  Business Process Automation | Business Process Management | Business Process Management Software | Business Processes | SOA | SQL | Web Services | Web Services Management | Workflow Software

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 - The ever present demand to maximise the value delivered by business-critical applications requires that we optimise the use of all the resources that execute and manage them. BMC Software is one of the major vendors offering such support and has a highly regarded set of solutions collectively called BMC SQL Performance for DB2.
Posted: November 20, 2009 | Published: November 20, 2009


Topics:  Database Administration | Database Management | DB2 | Midrange Server Hardware | SQL | z/OS

WHITE PAPER - This white paper discusses how Real Application Testing — with Oracle Database 11g Release 2 — allows businesses to quickly adopt new technologies while eliminating the risks associated with change.
Posted: September 25, 2009 | Published: August 1, 2009


Topics:  Application Development | Application Infrastructure | Application Performance Management | Data Management | SOA | SQL | Test Results

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)

TRIAL SOFTWARE - IT needs tools that help their database and application developers produce high quality SQL code faster. To meet the demands of the business they need to accelerate application devlopment cycles and improve team collaboration and resource sharing.
Posted: September 10, 2009 | Published: September 10, 2009


Topics:  Application Development | Collaboration | Database Administration | Database Management | Debugging | Object Management Group | Project Management | Scripting | SQL | SQL Server

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 - DBA's have always been faced with the difficult task of maintaining a successful database environment, but recently new trends have come along to further challenge them.
Posted: September 10, 2009 | Published: September 10, 2009


Topics:  Capacity Planning | Database Administration | Database Architectures | Database Performance Management Software | DB2 | High Availability | SQL | Storage Capacity | Storage Management | Workload Automation