SQL Database Design

Solution Search:
Forrester Research: Total Economic Impact of SQL Server 2008 Upgrade by Microsoft
their organization 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...
eGuide: Performance tuning SQL Server via queries, indexes and more by Microsoft
indexes, utilize database storage methods and solve common SQL errors. This collection of tips and expert guidance will have your SQL Server environment running at peak performance. All...
SQL 2000 to 2008 consolidation made easy with two-socket servers by Dell, Inc.
costs. To help quantify the potential savings of SQL Database consolidation within your organization, Dell has partnered with Principled Technologies to bring you this consolidation...
Performance Tuning for Mission-Critical Database Applications by Quest Software
Quest SQL Optimizer for Oracle maximizes PeopleSoft's performance by focusing on the factors responsible for database inefficiencies...
Leveraging Virtualization for Application Assurance by AppAssure Software
of every staff person in your organization are e-mail and SQL databases. They need reliable and consistent access to those applications in order to communicate with work peers, customers, and...
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...
Idera SQL safe backup - High performance backup and recovery for SQL Server by Idera
multiple servers 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...
Faster SQL Profiling for Better Database Performance by Embarcadero Technologies, Inc.
153; can help you to quickly discover and fix problematic SQL statements that can cause performance bottlenecks in your database. DB Optimizer™ gives you the flexibility of using a single...
Migrating SQL 2000 to SQL 2008- a Dell Deployment Guide by Dell, Inc.
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 Enterprise. The Dell...
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...
Sun Fire™ X4170 Server: Ultimate in enterprise performance for database management or Web applications by Sun Microsystems, Inc. and Microsoft
Your business is under increasing pressure to deliver more services and to support more users with a shrinking IT budget. To help meet those increasing demands...
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...
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...
Embarcadero® DB Optimizer™ by Embarcadero Technologies, Inc.
Poor performing SQL code is costly in terms of dollars and customer satisfaction. Discovering performance bottlenecks once they're in production...
Database Encryption for Microsoft SQL Server 2008 by Thales
Join database security expert Rob Walters for an overview of encryption technology as part of Microsoft SQL Server 2008. This webcast features...
Wipro Study: Microsoft SQL Server Migration Pays Big Dividends for SAP/ERP Customers by Microsoft
who had migrated from a competitive platform to Microsoft SQL Server. Read this study and learn how Wipro consultants collected data from 68 companies running SAP on a variety of hardware and...
SQL Server Database Backup and Restore Planning by AppAssure Software
backups, especially when this data is stored offsite.

With a SQL Server, DBAs should also be concerned with the OS, the applications that the server runs and finally the databases. In other words, the...
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...
Deploying SQL Server 2008 on Windows Server 2008 using Dell PowerEdge servers - a Dell Deployment Guide by Dell, Inc.
simplify operations 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...
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...
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...
Slashing Data Warehouse Costs with the Vertica® Analytic Database by Vertica Systems
Vertica® Analytic database cuts the high data warehousing costs of high-end hardware and DBA personnel overhead for performance tuning. Vertica is the only...
8 Steps to Holistic Database Security by Guardium
to safeguarding databases and achieving compliance. SQL injection attacks, malfeasance by insiders and regulatory requirements are driving organizations to find new ways to secure...
10 Essential Steps to Oracle & MS-SQL Security & Compliance by Guardium
Download an essential chapter from "Implementing Database Security and Auditing" (Elsevier Digital Press), authored by database security expert and Guardium CTO Ron Bennatan, Ph. D. Securing...
Oracle Compatibility Developers Guide for Postgres Plus Advanced Server by EnterpriseDB Corporation
contains a rich set of features that enables development of database applications for PostgreSQL or Oracle. This guide focuses solely on the features that are compatible with Oracle. To learn about...
SQL Server Resource Center
Performance implications of transaction log autogrowth in SQL Server
see people create maintenance plans or customized jobs that shrink the database files (data and/or transaction log) periodically.

In my previous article on ... More...

Jun 25, 2009
The keys to database backup protection for SQL Server
you've read all the articles and blog posts detailing the importance of database backups and set them up accordingly. You are now finished, right? Wrong.

Backing up... More...

Jun 22, 2009
Maintaining high availability of SQL Server virtual machines
software products that are optimized for just that. This is the case for SQL Server 2008 among other Microsoft products.

When previously discussing fault... More...

Jun 15, 2009
The short course on how SQL Server really works

Face it, you never intended to become a SQL Server expert, but the proliferation of this database engine – and its many... More...

Jun 10, 2009
SQL Related Articles
Microsoft renames SQL Server release, adds data services by Barbara Darrow, Senior News Director

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

At TechEd, Microsoft... More...

May 11, 2009
Top products named for SQL Server by SearchSQLServer.com staff
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 Software's Tableau v2.0 took the top spot in the... More...

Jan 15, 2007