The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
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.
By Michael Otey
Not all SQL Server 2008 editions are created equal—check out 20 cool features that are found only in SQL Server 2008 Enterprise Edition.
By Tyler Chessman
See how to put the SQL Server 2008 GEOGRAPHY and GEOMETRY data types to work in your applications.
Learn about two solutions that make writing JavaScript easier
See how a new application uses geocoding to fix some AdventureWorks2008 spatial values
By Denny Cherry
Create a failover cluster to get SQL Server up and running quickly in the event of a hardware failure.
Do you want to run SQL Server and other mission-critical applications from the cloud?
By
Check out new and improved SQL Server–related products from SiSense, Embarcadero Technologies, Fortinet, InstallAware, and xhoto.
By Dejan Nakarada-Kordic
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.
By Itzik Ben-Gan
One way to use arrays as input for stored procedures is to employ dynamic SQL.
By Kevin Kline
Use this free tool to create and modify Extended Events sessions and metadata files.
By Derek Comingore
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.
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.
advertisement