Category Archives: SQL Server

Upload Shape Files into SQL Azure using OGR2OGR – Explanation of SQL Azure Connection String to be placed within OGR2OGR Command Line

Lets say you have a SQL Azure Server with the following parameters SQL Azure Instance : azureinstance1 Database name within Instance : TouristDB1 Your User Name is : tom Password is : Edinburgh The SQLAzure connection string would be MSSQL:Server=tcp:azureinstance1.database.windows.net;Database=TouristDB1; … Continue reading

Posted in All, SQL Azure, SQL Server, SSMS | Comments Off on Upload Shape Files into SQL Azure using OGR2OGR – Explanation of SQL Azure Connection String to be placed within OGR2OGR Command Line

VBA Function to Create Table of Import strings using OGR2OGR targeting a SQL Server

Do you have many shape files you wish to import into a local SQL Server Database so that you can display them in QGIS or serve them on Geoserver? Here’s a short function I wrote that will take a table … Continue reading

Posted in All, MS Access, QGIS General, SQL Azure, SQL Server, VBA Code MS Access | Comments Off on VBA Function to Create Table of Import strings using OGR2OGR targeting a SQL Server

SQL Azure to MS Access – Using VBA to Dump Azure Tables into MS Access Tables

The first thing you need to get sorted when moving to SQL Azure is having the ability to get your information out and safe if needs be. When experimenting with MS Azure and for applications that don’t have sensitive information … Continue reading

Posted in All, MS Access, Productivity, Programming, SQL Azure, SQL MS Access, SQL Server, VBA Code MS Access | Comments Off on SQL Azure to MS Access – Using VBA to Dump Azure Tables into MS Access Tables

MS Access front end – SQL Azure back end Link to Configuration Set UP FMS Group

This is an excellent article on linking MS Access to SQL Azure – which is just great if you are wanting to use your VBA skills direct on your SQL Database. FMS Professional Solutions Group – Luke Chung MVP article … Continue reading

Posted in All, SQL Azure, SQL MS Access, SQL Server | Comments Off on MS Access front end – SQL Azure back end Link to Configuration Set UP FMS Group

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

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

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

SQL Saturday coming to Edinburgh again 13 June 2015

SQL Saturday is coming to Edinburgh again Saturday 13 June 2015 I hope to attend. I have attended the two previous events I highly recommend it. Thanks must go to Jennifer Stirrup and others for taking time out to organise … Continue reading

Posted in Continual Professional Development, SQL Server | Comments Off on SQL Saturday coming to Edinburgh again 13 June 2015

Access Connection Strings – Link

Some notes on using SQL Server connection strings both using the default ODBC client drivers and also the native SQL Server driver. Juan Soto of Access Experts explains connection strings from MS Access to SQL Server Additionally I am hearing … Continue reading

Posted in All, Configuration, MS Access, SQL Server | Comments Off on Access Connection Strings – Link

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.

Connecting to SQL Server – authentication and QGIS

Within QGIS when you set up a connection to a MS SQL Server instance you are presented with two options. Here’s a bit of clarification on what the two options entail. * Trusted connection – this is the same thing … Continue reading

Posted in All, Configuration, QGIS General, SQL Server | Comments Off on Connecting to SQL Server – authentication and QGIS

Summary and Links for Microsoft MCSE Data Platform Solutions Expert

Microsoft MCSE Data Platform Some notes on the syllabus for this – thinking of taking it. https://www.microsoft.com/learning/en-gb/mcse-sql-data-platform.aspx Earning an MCSE : Data Platform certification will qualify you for jobs such as database analyst and database designer 1 : Querying Microsoft … Continue reading

Posted in All, Learning, Personal Development, SQL Server | Comments Off on Summary and Links for Microsoft MCSE Data Platform Solutions Expert

Complex Event Processing (How Cool)

As part of my timing software solution I had been interested in seeing if there was a better solution to the constant pulling of information from the timing boxes. It would for instance be far better to have some sort … Continue reading

Posted in All, Problem Solving, Programming, SQL Server, The future of software | Comments Off on Complex Event Processing (How Cool)

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

Attach DSN Less Connection to Link MS Access to SQL Server

This code is generally available all over the tinternet nonetheless I list it here for my own personal use. I use an autoexec macro to trigger the code on open With a Run Code action to trigger the AttachDSNLessTable… So … Continue reading

Posted in All, MS Access, SQL Server, VBA Code MS Access | Comments Off on Attach DSN Less Connection to Link MS Access to SQL Server