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 - 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 - 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 - This document focuses on each level of security, starting at the server level and working our way down to database objects such as Server Security, Database Security, Schema Security and Object Security.
Posted: February 10, 2009 | Published: February 10, 2009


Topics:  Authentication | Data Encryption | Data Entry | Databases | Security | SQL Server

WHITE PAPER - This article focuses on tools that are a part of the SQL Server application which after proper setup can prevent data loss on a record, table or database level.
Posted: January 23, 2009 | Published: January 23, 2009


Topics:  Backups | Database Administration | Disaster Planning | Disaster Recovery | Records Management | SQL Server

WHITE PAPER - The MCITP assures that anyone possessing Microsoft certification has a breadth of knowledge on various products and is concerned with the network architecture and design.
Posted: December 10, 2008 | Published: December 10, 2008


Topics:  Application Development | Business Intelligence | Certification Programs | IT Managers | LMS | Network Infrastructure | SQL Server | Training and Educational Services | Vendors

WHITE PAPER - This white paper explores how to change some of the default user experiences by customizing elements of both the Look and Feel and the site Navigation. Many additional "out of the box" customization elements are available.
Posted: December 10, 2008 | Published: December 10, 2008


Topics:  Best Practices | Databases | Enterprise | RSS | SQL | SQL Server

WHITE PAPER - Microsoft SQL Server 2008 has many great new features that will allow you to develop higher performing, more scalable next-generation applications using more than just relational data.
Posted: December 10, 2008 | Published: December 10, 2008


Topics:  Backups | Data Encryption | Database Management | Databases | Enterprise | SQL Server

WHITE PAPER - Microsoft Office SharePoint Server 2007 and other SharePoint technologies are excellent tools for a modern, web-based office environment. This white paper gives pointers on managing them.
Posted: December 10, 2008 | Published: October 11, 2008


Topics:  Business Intelligence | ERP | LAN | RAID | SQL Server | Storage Management | WAN

WHITE PAPER - This white paper explains how users, managers, and network administrators view and utilize SharePoint. It also explains how SharePoint works for both SharePoint users and architects.
Posted: December 10, 2008 | Published: October 11, 2008


Topics:  Active Directory | Document Management | Security Management | Server Management | Server Software | Spreadsheets | SQL Server | SSL