Merry Christmas and Happy New Year!

The holidays are approaching and the end of this year with hopefully a long, nice break. We will have dba's on site throughout the weekend so please let us know if you need any help.

Next year is the SQL Pass Nordic http://www.sqlpass.org/sqlrally/2015/nordic in Copenhagen 2-4 March. The previous ones have been really good so don't miss it!

I would like to take this opportunity to thank everyone, both customers and colleagues!

Merry Christmas and Happy New Year!

/Björn

PS. For a real SQL Christmas run the below script in SSMS and check the results tab for spartial data.

SELECT geometry::STGeomFromText('GEOMETRYCOLLECTION(
POLYGON((-140 50, -60 170, 60 170, 140 50, -140 50)),
POLYGON((-100 180, -40 280, 40 280, 100 180, -100 180)),
POLYGON((-60 290, 0 370, 60 290, -60 290))
)', 0) AS [Merry Christmas from AddPro DBA]
UNION ALL
SELECT geometry::STGeomFromText('GEOMETRYCOLLECTION(
POLYGON((0 375,-20 357.5,-10 385,-25 400,-7.5 400,0 420, 7.5 400, 25 400,10 385,20 357.5,0 375)),
LINESTRING (-50 305, 20 345),
LINESTRING (-50 305, 20 345),
LINESTRING (-95 190, 42 275),
LINESTRING (-95 190, 42 275),
LINESTRING (-132 60, 70 158),
LINESTRING (-132 60, 70 158)
)', 0)
UNION ALL
SELECT geometry::STGeomFromText('GEOMETRYCOLLECTION(
POLYGON((-10 0, -10 40, 10 40, 10 0, -10 0))
)', 0)
UNION ALL
SELECT geometry::Point(x, y, 0).STBuffer(5) As sig
FROM ( VALUES (60, 210), (-40, 265), (-85, 175), (10, 325), (-20, 150), (-70, 85), (60, 45), (90, 100)
) AS Coordinates(x, y)