SQL Server 2016 T-SQL updates

Looking through the T-SQL updates for SQL Server 2016 this one caught my eye DROP IF EXISTS.
So when you normally drop a table for example you use IF OBJECT_ID:
IF OBJECT_ID(N'dbo.MyTable') IS NOT NULL

DROP TABLE dbo.MyTable
now you can use:
DROP TABLE IF EXISTS dbo.MyTable
It’s not just for tables you can use it for object such as:
AGGREGATE
ASSEMBLY
DATABASE
DEFAULT
FUNCTION
INDEX
PROCEDURE
ROLE
RULE
SCHEMA
SECURITY
SEQUENCE
SYNONYM
TABLE
TRIGGER
TYPE
USER
VIEW
Not in the SQL Server Blog Post that announced this update but you can also drop COLUMN and CONSTRAINT

Be Colour aware



As I’m required to create visually creative and stunning dashboards and reports, and sometimes don’t have access to the Ridgian resident Lead Creative, and also sometimes the customer doesn’t have a defined corporate colour palette  (or Color to our across the pond friends) I have to throw one together, if the standard out of the box items doesn’t quite fit the bill. One drawback to this I’m ridiculously colour-blind, Red/Green Blue/Purple and many more it seems. One of my stock websites to go to is the Adobe colour wheel, with colour rules, like shades, complementary etc.
Great for those, “mmmh what goes with lime green?” moments. (Note: nothing goes with lime green).
Another great link is the W3 schools one, good for getting those Hex colour values that SSRS & Power BI likes.

Random Interactions




I was in London the other week, working away from home for a few days, and at the end of a busy day with a client I was catching up on my e-mails in a local coffee shop. It was quite busy and I sat in a space at a bench table arrangement, as it seemed more chic/trendy/cool not to have chairs, and when I looked up I noticed that I was the only PC laptop. The person next to me caught my slightly confused gaze and I remarked ‘What’s with all the Mac books?’ they replied ‘Mac books are more productive’ with a slight sneer at my good old reliable Dell. ‘Really?’ using the word with an inflection that only the British can do, ‘Mac’s are more productive?’ I replied ‘I can’t help but noticing that you are using Microsoft Word, that sort of defeats the point of your argument’. Checkmate!