-
Recent Posts
- 009 Postgres Command Line : psql : Altering the stated language – lets try Python
- 008 Postgres Command Line : psql : Another function example
- 007 Postgres Command Line : psql : Create a function that returns a single value
- 006 Postgres Command Line : psql : Identify definition of a Function
- 005 Postgres Command Line : psql : Create a User Defined Function and Identify its creation and then Drop it.
- 004 Postgres Command Line : psql : Create a spatially enabled table
- 003 Postgres Command Line : psql : List all databases in a Postgres Instance
- 002 Postgres Command Line : psql : Enabling extensions (PostGIS) to a database
- 001 Postgres Command Line : psql : Getting Started with Postgres
- 000 Postgres Command Line : psql : Useful RESOURCES Link to Github Cheat Sheet AND live on the web SQL excercises
Archives
- February 2019 (11)
- December 2018 (1)
- November 2018 (1)
- September 2018 (2)
- August 2018 (1)
- May 2018 (2)
- April 2018 (1)
- March 2018 (6)
- February 2018 (2)
- January 2018 (1)
- November 2017 (4)
- October 2017 (2)
- September 2017 (3)
- August 2017 (5)
- July 2017 (1)
- June 2017 (5)
- April 2017 (5)
- March 2017 (6)
- February 2017 (1)
- January 2017 (1)
- December 2016 (2)
- November 2016 (1)
- October 2016 (1)
- July 2016 (1)
- June 2016 (1)
- April 2016 (7)
- March 2016 (2)
- February 2016 (3)
- January 2016 (2)
- December 2015 (3)
- August 2015 (1)
- July 2015 (2)
- June 2015 (4)
- May 2015 (4)
- April 2015 (2)
- March 2015 (4)
- February 2015 (2)
- January 2015 (4)
- December 2014 (2)
- November 2014 (4)
- October 2014 (8)
- September 2014 (3)
- August 2014 (7)
- July 2014 (6)
- June 2014 (7)
- May 2014 (12)
- April 2014 (8)
- March 2014 (2)
- February 2014 (1)
- January 2014 (1)
- September 2000 (1)
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