XML in SQL Server

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 their...
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...
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 most...
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...
eGuide: Performance tuning SQL Server via queries, indexes and more by Microsoft
This collection 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...
eGuide: Why Migrate to SQL Server 2008: Considerations Before Making the Move by Dell, Inc.
you about the benefits of the new replication features in SQL Server 2008 as well as cover topics such as:

  • How SQL Server 2008 security and compliance capabilities reduce risks:
  • Is it really secure out
...
eGuide: Performing a Successful Migration to SQL Server 2008 by Dell, Inc.
com and 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...
eGuide: SQL Server Consolidation by Hewlett-Packard Company
about the 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...
Inside SQL Server 2008: Exploring High Availability and Scalability Enhancements by Global Knowledge
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 targeting close to zero...
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 blade servers and...
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...
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...
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...
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...
Leveraging four-socket servers for your SQL 2000 to SQL 2008 consolidation by Dell, Inc.
rack space, 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...
Enhance SQL Reporting Services with Double-Take® by Double-Take Software
into their important business data stored in Microsoft SQL Server. This white paper provides an overview of how Double-Take can greatly increase your production server's performance by offloading...
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 database...
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 entire...
SQL Server 2008: What to Expect by Global Knowledge
Microsoft SQL Server 2008 has many great new features that will allow you to develop higher performing, more scalable next-generation...
Hitchcock Schools Protects SQL Servers and Data with Replay AppImage by AppAssure Software
AppImage. The Hitchcock Independent School District in Hitchcock, Texas serves 1,200 students in grades K - 12 through 4 schools with a new elementary school on the way. The IT group at...
Performance Tuning for Mission-Critical Database Applications by Quest Software
the generic fashion that PeopleSoft's apps are developed in (in order to work on multiple vendor databases like Oracle, Sybase, Microsoft SQL Server and DB2), the SQL statements that data retrieval...
Getting Started with LINQ to XML by Global Knowledge
to all in-memory information.

When you program with XML, your primary focus is usually on XML elements and perhaps on attributes. In LINQ to XML, you can work directly with XML elements...
Database Encryption for Microsoft SQL Server 2008 by Thales
an overview of encryption technology as part of Microsoft SQL Server 2008. This webcast features experiences with Transparent Data Encryption, implementation tips, and benefits to data security and...
SQL 2000 to 2008 consolidation made easy with two-socket servers by Dell, Inc.
less than one-fourth the power, and one-eighth the number of SQL Server licenses. Consolidating multiple database servers into a single server makes it possible for an organization save hardware...
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...
SQL Server Resource Center
Performance implications of transaction log autogrowth in SQL Server
shrink the database files (data and/or transaction log) periodically.

In my previous article on shrinking your database to death, I tested and proved that... More...

Jun 25, 2009
The keys to database backup protection for SQL Server
an encryption 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... 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-tolerant... More...

Jun 15, 2009
The short course on how SQL Server really works
of course. Now think about this important fact -- EVERYTHING that happens in SQL Server occurs only through the transaction log, and SQL Server can re-read the log to repeat... More...
Jun 10, 2009
SQL Related Articles
Microsoft renames SQL Server release, adds data services by Barbara Darrow, Senior News Director
he said. Microsoft has also upped the number of logical processors in SQL Server from the expected 64 to 256, to take advantage of multicore processors. He would not comment on how that capability will be packaged... 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