SQL Database Design

Solution Search:
Police Academy of the Netherlands Utilizes DocAve® to Replicate and Protect Mission Critical SharePoint® Data by AvePoint, Inc.
not tolerate the time required to restore their entire SQL database in order to recover just the needed document.

In search of a solution, The Academy’s administrators tested several products...
Comcast Revolutionizes Network Performance Data Analysis by Vertica Systems
Analytic Database 2.0, as it is a high-speed, relational SQL database management system.

Read how Comcast, the largest cable communications company in the U.S., is able to quickly collect and analyze data...
SQL Anywhere v11.0.1 Developer Edition by Sybase, Inc.
Mobile data sync. Mobile application development. Mobile database.

Target User: Mobile Application Developer

IT Problem: Addresses need for high reliability and data sync to multiple device...
Predicting Oracle Performance Issues by Quest Software
Although the database plays a less central role today than it did in the client-server era, database performance is still critical for application...
Inside SQL Server 2008: Exploring High Availability and Scalability Enhancements by Global Knowledge
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...
Edison Group, Comparative Management Costs Study: Oracle Database 11g vs. Microsoft SQL Server 2008 by Oracle Corporation
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...
Benefits of the Intel® Xeon® Processor 7500 Series and Microsoft® Windows Server® 2008 R2 for Mission-Critical Applications by Intel
system and the latest version of Microsoft® SQL Server® can provide the levels of reliability, availability, serviceability, and scalability you've come to expect, at a fraction...
E-Guide: Creating, Deploying, and Managing SQL Server Virtual Appliances by Dell Inc., Microsoft and AMD
Deploying SQL Server virtual appliances for Microsoft Hyper-V is often perceived as a complex and costly process. In this expert E-Guide, brought...
Microsoft SharePoint 2007 and 2010 Storage and Virtualization Best Practices  by EMC Corporation
how to virtualize all of the SharePoint roles including SQL databases

• Gain a fuller understanding of how each component of SharePoint infrastructures relates to each other
Top Ten Things Every DBA Should Know About SQL Server by Global Knowledge
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...
Configuring Security in SQL Server by Global Knowledge
Schema Security and Object Security.

Configuring access to SQL Server data and features is an important part of every DBA's job, but one that we all know must be handled carefully. The unintended...
SQL Server 2008 Upgrade Series: Availability & Disaster Recovery by Dell, Inc. and Intel
With Microsoft SQL Server 2008, small and mid-sized businesses have a variety of options for creating state-ofthe art strategies for ensuring high...
SQL Server 2008 Dynamic Duo: Management Views and Functions by Global Knowledge
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...
SQL Server Insider E-zine - Volume 2: Selling a SQL Server 2008 R2 Upgrade by SearchSQLServer.com
When proposing an upgrade to SQL Server 2008 R2 to management, you need to focus more on ROI than its cool, new features. In the second volume of the SQL Server Insider e...
Presentation Transcript: What's New in SQL Server 2008 R2 by Dell Inc., Microsoft and AMD
Considering a move to SQL Server 2008 R2? This presentation transcript outlines the features you absolutely need to know about, with details on changes for...
SQL Server 2008 R2: What's new and what it means to you by Dell Inc., Microsoft and AMD
Considering a move to SQL Server 2008 R2? This webcast outlines the features you absolutely need to know about, with details on changes for BI, virtualization...
Disaster Recovery Techniques for SQL Server by Global Knowledge
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.

The tools available to...
SQL Server 2008 Upgrade Series: Performance by Dell, Inc. and Intel
of their databases — and their businesses — by upgrading to SQL Server 2008. SQL Server 2008 offers small and mid-sized businesses a wide range of performance enhancements, including: Greater...
Databases and ERP Selection: Oracle vs SQL Server by IFS
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...
8 Steps to Holistic Database Security by Guardium, an IBM Company
Most of the world's sensitive data is stored in commercial database systems, which makes them an increasingly attractive target for criminals. This white paper discusses 8 essential best practices...
Consolidate SQL Server 2008 on Dell 4 Socket - Multi-Core Servers - Using Hyper-V by Dell Inc., Microsoft and AMD
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...
SQL Server Insider E-zine - Volume 3: Tips for the SQL Server Pro by Dell Inc., Microsoft and AMD
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 Server Resource Center
SQL Server tools take the time out of database searches
160;

Two of the better programs I?ve come across are part of the Idera SQL admin toolset: SQL Search and SQL Object Search. These utilities are designed to... More...

Jun 1, 2010
Weighing visual output options for SQL Server business intelligence
A business intelligence solution can present data in a variety of ways, such as dashboards, scorecards and reports, but each form has... More...
May 25, 2010
Weighing visual output options for SQL Server business intelligence
of an interactive data mining session.

Data visualization with SQL Server Reporting Services

Report Builder 3.0 with SSRS 2008 R2 includes... More...

May 25, 2010
Pros and cons of the DACPAC with SQL Server 2008 R2
This means that developers can work against their development database for all their coding, and then package up all the changes into a single DACPAC for... More...
May 17, 2010
SQL Related Articles
SQL Server tools take the time out of database searches by Serdar Yegulalp, Contributor
160;

Two of the better programs I?ve come across are part of the Idera SQL admin toolset: SQL Search and SQL Object Search. These utilities are designed to simplify the process of searching for something in... More...

Jun 1, 2010
Weighing visual output options for SQL Server business intelligence by Don Jones, Contributor
of an interactive data mining session.

Data visualization with SQL Server Reporting Services

Report Builder 3.0 with SSRS 2008 R2 includes several new visualization features for BI reports... More...

May 25, 2010