Time for a small recipe of what I needed to do, to get a SQL-Server Express 2014 instance, running on Windows 2012R2, accessible from a remote machine. On remote machine In SQL-Server Management studio 1. Enable remote connections (right click server instance: Properties -> Connections) 2…
Daniel Wertheim
This is a scary T-SQL post with some ugly code and unfriendly variables as the result of a quick hack to answer a StackOverflow question [http://stackoverflow.com/questions/13761768/how-to-find-column-and-table-name-using-columns-value-in-sql-server/13763701#13763701] : > In T-SQL, if just know…
Daniel Wertheim
I’ve been working with some simple spatial data lately. In one use-case, the user marks a polygon by using an iPad or iPhone in field and walks around storing points (coordinates), which after at least three points, forms an area (the first coordinates are also used as the last to close it). I’m usi…
Daniel Wertheim