The process of SQL "tuning" involves finding the absolute fastest route to answer your query. In this webcast, discover how SQL tuning brings down your CPU costs and lowers response and run times. Also find out answers to pressing SQL tuning questions including "how do you find the SQL to tune" and "which SQL must be tuned and why?" 

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. 

Double-Take Software provides organizations with a solution that offers distinct recovery and protection advantages over manual Microsoft SQL built-in replication capabilities: Double-Take Availability saves more data real-time and restores that data in a much faster manner. 

This white paper explains how to use Encrypting File System (EFS), a feature that is provided by default in the Windows® operating system, to protect data in Microsoft Dynamics CRM clients for Outlook Compatibility Update running on Windows XP Professional Service Pack 2 (SP2). 

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. 

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. 

Poor performing SQL code is costly in terms of dollars and customer satisfaction. Discovering performance bottlenecks once they're in production is costly. 

SharePoint has built-in features that allow site owners to create site maps without any custom coding at all. 

Solid state drives (SSD) are going to play everywhere in the enterprise—at the storage array level, at the server level and in users’ notebook computers. This webcast discusses the issues involved in integrating SSDs at these three junctions in enterprise storage environments. 

This white paper describes ways in which organizations can use Microsoft SQL Server 2008 to save time and money. 

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. 

In this technical brief, John Weathington, President and CEO of Excellent Management Systems, Inc.,explores Toad® Development Suite and Oracle's SQL Developer. He provides an honest look at both solutions, and helps you see how a simple side-by-side comparison isn't enough when choosing the right tool.