SQL Server Solution Database

Solution Search:
Inside SQL Server 2008: Management Studio Improvements by Global Knowledge
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...
Guide to Consolidating SQL Server 2000 and SQL Server 2005 Databases to SQL Server 2008 by Dell Inc., Microsoft and AMD
helping you consolidate your Microsoft® SQL Server® 2000 and SQL Server 2005 databases from multiple machines onto a single SQL Server 2008 server system.

Generally speaking, consolidation...
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-zine, you’ll...
Create Fault-Tolerant SQL Server 2008 Installations -- Rely on SQL Server 2008 Features to Protect Data by Dell, Inc. and Intel
to protect your SQL environment when running SQL Server on Dell PowerEdge servers.

Organizations relying on SQL Server databases need the databases to be available at all times. For SQL Server, this...
SQL Server virtualization: What's new and what's old by Dell Inc., Microsoft and AMD
SQL Server MVP Denny Cherry calls in to this podcast to discuss the usual challenges of virtualizing SQL Server, the benefits of working through such...
Reduce Your Server Footprint with SQL Server 2008 -- Rely on SQL Server 2008 to Consolidate Database Servers by Dell, Inc. and Intel
new unified management and auditing tools, SQL Server 2008 makes it easier to manage multiple instances on fewer servers. And by hosting these instances on Dell PowerEdge Servers powered by multi...
Microsoft SQL Server 2008: What's New with R2? by Global Knowledge
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.

Are you...
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, licensing and more.

...
eGuide: Mid-Market Guide to Architecting SQL Server for High Performance and 100% Uptime on a budget by Dell Inc., Microsoft and AMD
concepts that will help you architect your next SQL Server installation.

It was only a short time ago when organizations with fully dedicated SQL Server DBAs, redundant hardware, and reams of expertise...
E-Guide: Managing the Availability and Fault Tolerance of your SQL Server by Dell Inc., Microsoft and AMD
how to manage the complexity associated with SQL Server deployments. Learn how to develop optimal fault tolerance configurations for SQL Server and much more!

SQL Server installations that are both...
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 to you by...
Create Supported SQL Server 2008 Virtual Machines -- Rely on Server Virtualization to run SQL Server 2008 by Dell, Inc. and Intel
The support team for Microsoft SQL Server has published guidelines for virtualizing this database engine. Read this paper to learn how to move forward with the process and create...
Configuring Security in SQL Server by Global Knowledge
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 consequences of...
SQL Server Advanced Protection and Fast Recovery by Dell, Inc.
It is critical that SQL Server environments are well protected and maintain integrity. This white paper highlights how iSCSI SAN solutions can simplify management and...
Microsoft SQL Server in a VMware Environment on Dell PowerEdge Blades and Dell EqualLogic Storage by Dell and VMware
white paper provides an overview for deploying SQL Server in a virtualized environment for VMware ESX 3.5 Update 4 (U4) running on the latest PowerEdge M610 and M710 blade servers and EqualLogic PS6000XV...
SQL Admin Tips
using the November Community Technical Preview (CTP) of SQL Server 2008 R2. The configuration process may change between now and when the product is released in May 2010.

Master... More...

Mar 29, 2010
using the November Community Technical Preview (CTP) of SQL Server 2008 R2. The configuration process may change between now and when the product is released in May 2010.

Master... More...

Mar 28, 2010
SQL Server Articles
Search. These utilities are designed to simplify the process of searching for something in one of your SQL Server databases. The former searches both databases you?ve created and system databases... More...
Jun 1, 2010
data, which becomes the beginning 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

One of the biggest headaches ?reluctant DBAs? have to deal with involves supporting SQL Server when it?s being used to maintain someone else?s application. What can you safely do... More...

May 12, 2010
SQL Development Tips

Editor's note: This article was written using the November Community Technical Preview (CTP) of SQL Server 2008 R2. The configuration process may change... More...

Mar 29, 2010

Editor's note: This article was written using the November Community Technical Preview (CTP) of SQL Server 2008 R2. The configuration process may change... More...

Mar 28, 2010
SQL Server White Papers
Inside SQL Server 2008: Management Studio Improvements by Global Knowledge
When the SQL Server Management Studio (SSMS) was first introduced in SQL Server 2005, it received mixed reviews. With the launch...
Guide to Consolidating SQL Server 2000 and SQL Server 2005 Databases to SQL Server 2008 by Dell Inc., Microsoft and AMD
this paper for an informative guide to helping you consolidate your Microsoft® SQL Server® 2000 and SQL Server 2005 databases from multiple machines onto a single SQL Server 2008 server system.

...
Create Fault-Tolerant SQL Server 2008 Installations -- Rely on SQL Server 2008 Features to Protect Data by Dell, Inc. and Intel
Read this paper to determine how best to protect your SQL environment when running SQL Server on Dell PowerEdge servers.

Organizations relying on SQL Server databases need the databases to be...
Reduce Your Server Footprint with SQL Server 2008 -- Rely on SQL Server 2008 to Consolidate Database Servers by Dell, Inc. and Intel
With its new unified management and auditing tools, SQL Server 2008 makes it easier to manage multiple instances on fewer servers. And by hosting these instances on Dell...
Microsoft SQL Server 2008: What's New with R2? by Global Knowledge
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...
SQL Word Definitions
Yukon by Raghulan Rathnam
Yukon is the code name used for the beta version of Microsoft's SQL Server 2005. SQL Server 2005 is said to provide enhanced flexibility, scalability, reliability, and security to database... More...
Oct 25, 2004
Quiz: SQL Server 2000 by Jean Rynearson

DIRECTIONS: Match the SQL Server statement in the right-hand column with its description in the left-hand column.

How to take the quiz:
After reading the... More...

Sep 23, 2003