• subscribe

Planning and Implementing a SQL Server Cluster

SQL Server Pro

The effort of creating and configuring a database cluster pales in comparison to the hours or days a restore can take. A failover cluster can reduce outages to only a few seconds.


Planning and Implementing a SQL Server Cluster

By Denny Cherry, 11/24/2008

Create a failover cluster to get SQL Server up and running quickly in the event of a hardware failure.

SQL Server 2008 Extended Events Manager

By Kevin Kline, 11/24/2008

Use this free tool to create and modify Extended Events sessions and metadata files.

SQL Server 2008 Change Data Capture

By Derek Comingore, 11/24/2008

The new, asynchronous CDC feature built into the SQL Server 2008 relational database engine replaces the need to create custom CDC solutions and provides better performance.

Don't Let Poison Messages Kill Processing in SQL Server 2005's Service Broker

By Dejan Nakarada-Kordic, 11/24/2008

Here's a solution you can use when you need to disable XML validation yet have Service Broker continue processing when it encounters a poison message.

Up in the Air over Cloud Computing

By Michael Otey, 11/24/2008

Do you want to run SQL Server and other mission-critical applications from the cloud?

Using the MapPoint Web Service to Fix a Bug in AdventureWorks2008

By Tyler Chessman, 11/24/2008

See how a new application uses geocoding to fix some AdventureWorks2008 spatial values

Integrating SQL Server 2008 Spatial Capabilities with Microsoft Virtual Earth

By Tyler Chessman, 11/24/2008

See how to put the SQL Server 2008 GEOGRAPHY and GEOMETRY data types to work in your applications.

Handling Arrays

By Itzik Ben-Gan, 11/24/2008

One way to use arrays as input for stored procedures is to employ dynamic SQL.

JavaScript Development

By Tyler Chessman, 11/24/2008

Learn about two solutions that make writing JavaScript easier

Top 20 SQL Server 2008 Enterprise Edition–Only Features

By Michael Otey, 11/24/2008

Not all SQL Server 2008 editions are created equal—check out 20 cool features that are found only in SQL Server 2008 Enterprise Edition.

New Products

By Editors, 11/24/2008

Check out new and improved SQL Server–related products from SiSense, Embarcadero Technologies, Fortinet, InstallAware, and xhoto.

Creating Mount Points

By Denny Cherry, 09/25/2008

If you have a very large SQL Server database and want to add drive space and I/O capacity to a drive, follow these instructions to creating a mount point within the drive.


Browse the Archive by:

advertisement