SQL Server Solution Database

Solution Search:
Forrester Research: Total Economic Impact of SQL Server 2008 Upgrade by Microsoft
of upgrading from a previous version of SQL Server to SQL Server 2008. Forrester's aim is to show all related costs to best give readers a complete understanding of the costs their organizations...
Idera SQL safe backup - High performance backup and recovery for SQL Server by Idera
becomes a major headache. Product Type: SQL Server backup and recovery

Target User: Database Administrator

IT Problem:
A robust backup and recovery solution is arguably the most important...
Idera SQL diagnostic manager - SQL Server performance monitoring and alerting by Idera
Degradation in SQL Server performance has a noticeable and immediate impact on business productivity. Database administrators need to proactively manage their SQL...
Migrating SQL 2000 to SQL 2008- a Dell Deployment Guide by Dell, Inc.
for a tested and validated migration of SQL Server 2000 databases to SQL Server 2008 on the Dell PowerEdge R900 server and Microsoft Windows Server 2008 Enterprise. The Dell PowerEdge R900 is an...
eGuide: Performance tuning SQL Server via queries, indexes and more by Microsoft
of tips and expert guidance will have your SQL Server environment running at peak performance. All database administrators, whether new to the profession or seasoned pros, recognize the...
eGuide: Why Migrate to SQL Server 2008: Considerations Before Making the Move by Dell, Inc.
key considerations before making the move to SQL Server 2008. Find out if upgrading to SQL Server 2008 is right for your business as well as some key security and compliance features. SQL server has...
eGuide: Performing a Successful Migration to SQL Server 2008 by Dell, Inc.
Dell, learn how to get started with a migration to SQL Server 2008, including testing your SQL Server environment before an upgrade. Gain insight into what to keep in mind during the migration, as well as...
eGuide: SQL Server Consolidation by Hewlett-Packard Company
challenges of consolidation. Gain insight into SQL Server consolidation strategies and best practices and learn how to develop a testing environment. There are several benefits to consolidating...
Inside SQL Server 2008: Exploring High Availability and Scalability Enhancements by Global Knowledge
failover clustering from earlier versions. SQL Server 2008 has built on the earlier SQL 2005 architecture and added some interesting new features. Microsoft is targeting close to zero downtime...
Microsoft SQL Server in a VMware Environment on Dell PowerEdge Blades and Dell EqualLogic Storage by Dell, Inc.
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...
Leaping Forward: SQL Server 2008 Compared to Oracle Database 11g by Microsoft
Microsoft® SQL Server® 2008 outperforms Oracle in the areas that matter to your business. This paper covers some of the business-critical areas in which SQL Server...
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...
Leveraging four-socket servers for your SQL 2000 to SQL 2008 consolidation by Dell, Inc.
one-third the power, and one-eighth the number of SQL Server licenses. Server consolidation allows organizations to save money by reducing hardware, software, and operational costs. To help quantify the...
Tools for SQL Server Heros by AppAssure Software
Please join this webcast with Brian Oliver, SQL Server Expert - specializing in backup and disaster recovery strategies. He discusses the challenge's that SQL Server database administrators face...
Deploying SQL Server 2008 on Windows Server 2008 using Dell PowerEdge servers - a Dell Deployment Guide by Dell, Inc.
and take advantage of new features in SQL Server 2008 Enterprise Edition. This Deployment Guide reviews the approach that Dell and Principled Technologies recommend for implementing a...
SQL Admin Tips
times each and the execution statistics were captured by SQL Profiler. Here is the code:

--  Truncate the table
truncate table ExpandDB
go
--  Truncate the T-Log
backup... More...
Jun 25, 2009
system outside of the backup solution. If you are running SQL Server 2008, you can use the Full Database Encryption option that encrypts the data in the database, so that it's already... More...
Jun 22, 2009
SQL Server Articles

The next version of SQL Server will be getting a new name, added logical processor support and a bevy of new data... More...

May 11, 2009
ease of use and manageability, functionality, value and support.

Quest Software's LiteSpeed for SQL Server 4.6 was the Gold Award winner in the Backup and Recovery category, while Tableau... More...

Jan 15, 2007
placed in the database. They did that because the general consensus after the first generation of client-server development was that stored procedures did not scale and led to vendor lock in. A lot... More...
Aug 16, 2006
SQL Development Tips
to 1MB; In the second step, autogrowth was set to 10MB.

The two steps were executed three times each and the execution statistics were captured by SQL Profiler. Here is the code:

--  Truncate the table
... More...
Jun 25, 2009
backup system doesn't support encryption, then you'll need to look into an encryption system outside of the backup solution. If you are running SQL Server 2008, you can use the Full Database Encryption... More...
Jun 22, 2009
has continued its commitment to server virtualization by releasing new software products that are optimized for just that. This is the case for SQL Server 2008 among other Microsoft products.

When... More...

Jun 15, 2009
SQL Server White Papers
Migrating SQL 2000 to SQL 2008- a Dell Deployment Guide by Dell, Inc.
that Dell and Principled Technologies recommend for a tested and validated migration of SQL Server 2000 databases to SQL Server 2008 on the Dell PowerEdge R900 server and Microsoft Windows Server 2008...
Microsoft SQL Server in a VMware Environment on Dell PowerEdge Blades and Dell EqualLogic Storage by Dell, Inc.
This 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...
Leaping Forward: SQL Server 2008 Compared to Oracle Database 11g by Microsoft
Microsoft® SQL Server® 2008 outperforms Oracle in the areas that matter to your business. This paper covers some of the...
Inside SQL Server 2008: Exploring High Availability and Scalability Enhancements by Global Knowledge
such as database mirroring and improved failover clustering from earlier versions. SQL Server 2008 has built on the earlier SQL 2005 architecture and added some interesting new features. Microsoft is...
Configuring Security in SQL Server by Global Knowledge
44; Database Security, 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...
SQL Word Definitions
Database: Glossary
programmer responsible for developing the conceptual framework for the relational database and SQL.

HOLAP - hybrid online analytical processing, a combination of ROLAP and MOLAP.

Java Data Objects - an API that enables a Java... More...

Oct 27, 2003
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