Merry Christmas and Happy New Year!
Wow, it goes fast when you're having fun! Christmas is just around the corner and with it some time off (not for all of us some work on during the holidays so let me know if you need any help).
The big next year looks to be the release of SQL Server 2016 and there is a new CTP to download and test for those who have time to spare at the weekends. Rumour first had it that SQL Server 2016 would be out in late 2015 but that doesn't seem to be the case. Looking back at recent releases it should be March-April but you never know. As we've mentioned before there will be a lot of new stuff in it so next year looks exciting!
- SQL Server 2016 - 2016-??-??
- SQL Server 2014 - 2014-04-01
- SQL Server 2012 - 2012-03-06
- SQL Server 2008 R2 - 2010-04-21
I would like to take this opportunity to thank everyone, both customers and colleagues!
Merry Christmas and Happy New Year!
/Björn
Got requests for a SQL Christmas this year too. Run below script in SSMS with the result as text.
-- Cut down the tree
;WITH Christmas tree AS (
SELECT
t.Number,
CASE
WHEN t.Number = 1 THEN REPLICATE(' ', MAX(t.Number) OVER() - 3) + '¤'
WHEN t.Number < 4 THEN REPLICATE(' ', MAX(t.Number) OVER() - 3) + '|'
WHEN t.Number % 2 > 0 THEN REPLICATE(' ', MAX(t.Number) OVER() - 3) + '|'
WHEN MAX(t.Number) OVER() - t.Number > 1 THEN
REPLICATE(' ', MAX(t.Number) OVER() - 2 - t.Number) + REPLICATE('x',t.Number) + REPLICATE('x',t.Number-1)
ELSE REPLICATE(' ', MAX(t.Number) OVER() - 3) + '|'
END tree
FROM master.dbo.spt_values t
WHERE t.type='P'
AND t.Number BETWEEN 1 AND 14
)
-- Pynta den
SELECT CASE
WHEN Number % 2 = 0 AND Number > 3 AND (Number < MAX(Number) OVER()-1) THEN
ISULL(REVERSE(
-- Put in candles
STUFF(
-- and bullets
STUFF(
REVERSE(tree)
,ABS(CHECKSUM(NewId())) % (Number*2),1,'l')
,ABS(CHECKSUM(NewId())) % (Number*2),1,'o')
), tree)
ELSE tree
END AS [God Jul! wishes AddPro DBA]
FROM julgran
