SQL Server

Virtual Earth and SQL Server 2008 – A Match Made in Heaven?

May 1, 2008

Johannes Kebeck has an interesting post showing how to get the benefits of the MapPoint Web Service method, FindNearRoute, through the use of SQL Server 2008. He uses a newly-added feature of the Virtual Earth API that allows developers to gain access to a complete returned route-geometry when performing a route. This new feature, however, [...]

Read the full article →

Microsoft SQL Server 2008 November CTP

November 19, 2007

Those of you who use Microsoft SQL Server will be interested to hear that the SQL Server team has just released the November Community Technology Preview of SQL Server 2008 “Katmai”. Of special note for us GIS types is that this is the first publicly available release that includes support for the new spatial data [...]

Read the full article →

Preparing a SQL Server Database for ASP.NET

August 1, 2006

A quick and easy way to prepare a SQL Server database for use in an ASP.NET application: Browse to and execute aspnet_reqsql.exe, which is located at: C:\Windows\Microsoft.NET\Framework\VersionOf.NETFramework\. Choose to “Configure SQL Server for application services” when prompted. Specify the server, instance name, database name, and the username and password of a database user with the [...]

Read the full article →

Connecting ASP.NET to a Named SQL Server Instance

July 19, 2006

This may be obvious to most, but being new to ASP.NET – and relatively new to programming in general – I found it difficult to connect my ASP.NET application to a SQL Server instance. Looking at the available documentation, connecting should be easy. You simply create a connectionStrings element in your application’s web.config file and [...]

Read the full article →