Category Archives: SQL 08 R2

QGIS 2.8.1 Getting Shape Files into SQL Server 2008 Express R2

For digital mapping the shp extension is the equivalent of csv files – A significant amount of information is still held in shape files and even if it is not, nearly every GIS package can export to shape format. It’s … Continue reading

Posted in All, Geographical Information Systems, QGIS 2.8.1, SQL 08 R2, SQL Server, Win 8.1 | Comments Off on QGIS 2.8.1 Getting Shape Files into SQL Server 2008 Express R2

Setting up a Blank SQL Server Spatially enabled Table using Microsoft SQL Server Management Studio 2008R2 Express and displaying it in QGIS 2.8.1

Programs used; 1- SQL Server 2008R2 Express 2- SQL Server Management Studio 2008R2 Express 3- QGIS The example uses UK national grids coordinates to create a Triangle Polygon in a SQL Server Table I’ve previously written that while we’ve had … Continue reading

Posted in All, Configuration, Database Design, Dev Ops, QGIS General, SQL 08 R2, SSMS | Comments Off on Setting up a Blank SQL Server Spatially enabled Table using Microsoft SQL Server Management Studio 2008R2 Express and displaying it in QGIS 2.8.1

Spatially Enabling an existing Table – which has Eastings and Northing fields UK National Grid

The following TSQL will spatially enable a SQL Server Table called T1RainbowTable when it has two Fields called East and North with UK National Grid References. UPDATE T1RainbowTable SET Coordinates=geometry::Point([East],[North],27700)

Posted in All, Database Design, Dev Ops, QGIS General, SQL 08 R2, SQL Server, SSMS | Comments Off on Spatially Enabling an existing Table – which has Eastings and Northing fields UK National Grid

Enabling Geospatial integration in applications.

Despite the fact that spatially enabled databases have been around pretty much everywhere for quite sometime there’s still a heck a lot of enterprise applications out there that are not using the feature even though their backends support it. SQL … Continue reading

Posted in All, Database Design, Geographical Information Systems, SQL 08 R2, SQL Server | Comments Off on Enabling Geospatial integration in applications.

Attaching Databases to SQL Server 08R2 Express

It should be noted that the following although the easiest way to get a new database into an instance it should not be used in a production environment. In fact doing so may get you sacked. If experimenting though this … Continue reading

Posted in All, Configuration, Database Design, SQL 08 R2, SQL Server, SSMS | Comments Off on Attaching Databases to SQL Server 08R2 Express

SQL Saturday is coming to Edinburgh

Pretty lucky really some of the worlds most talented DBAs hosting an event about 1km up from my flat. More details can be obtained here. http://www.sqlsaturday.com/281/eventhome.aspx There is a waiting list but might be something for you to think about … Continue reading

Posted in All, Database Design, SQL 08 R2, SQL Server, SSMS, The future of software | Comments Off on SQL Saturday is coming to Edinburgh

Attaching an existing SQL data file to a new SQL Express Instance

Link for information http://technet.microsoft.com/en-us/library/ms165673(v=sql.105).aspx

Posted in All, Configuration, SQL 08 R2, SQL Server, SSMS | Comments Off on Attaching an existing SQL data file to a new SQL Express Instance

Stopping and Starting SQL Server Instance 08R2 Express

Simply within SSMS right click on the instance and hit STOP and To start an instance if you are still in SSMS you can simply right click and hit start Note if you stop a SQL Server instance from within … Continue reading

Posted in All, Configuration, SQL 08 R2, SQL Server, SSMS | Comments Off on Stopping and Starting SQL Server Instance 08R2 Express

Allowing sa login and altering password SSMS SQL 08 R2 Express

Recently I installed SQL Server 08 R2 Express. As part of the standard installation the sa login is disabled as default. Clearly although this is a useful security feature it is a bit awkward if you are wanting to undertake … Continue reading

Posted in All, Configuration, SQL 08 R2, SQL Server, SSMS | Comments Off on Allowing sa login and altering password SSMS SQL 08 R2 Express