Synapse TSQL: variable assignment in SELECT statement cannot be included

When working with synapse as a TSQL developer, it does feel like you've gone in a time warp back to SQL 7.0 in terms of whats supported and whats not. Luckily most of the TSQL patterns not supported have some form of workaround. This one I'm looking at is the naughty practice of doing variable … Continue reading Synapse TSQL: variable assignment in SELECT statement cannot be included

Why I’m looking forward to Data Ceili–Dublin 2020

Coming off the tails of the hugely successful SQL Saturday Dublin events, Data Ceili – Dublin 2020 is shaping up to be Irelands largest Microsoft Data Platform event. We still have till then end of Jan 2020 for speaker submissions and we have over 180 submissions from about 60 Local and International speakers. A who’s … Continue reading Why I’m looking forward to Data Ceili–Dublin 2020