Category Archives: SSMS

Upload XLS information to a specific table or new table within an SQL Azure Database

I have started experimenting with Microsoft Azure if you haven’t already you can get a free experimentation account here; Microsoft Azure Trial account with £125 credit This gets your registered on Microsoft’s cloud and after a free trial period you … Continue reading

Posted in All, Dev Ops, SQL Azure, SQL Server, SSMS | Comments Off on Upload XLS information to a specific table or new table within an SQL Azure Database

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

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