Wednesday, May 25, 2022

SQL Stars twitter list

 Here's a link to a twitter list I made for data or SQL obsessed folks called "SQL Stars".


https://twitter.com/i/lists/1236006145996673024


Many of these people are so smart it actually scares me. I'l have to check on it sometimes to make sure no one is just advertising stuff or started selling crypto - but these aer mostly regualr data folks who sometimes post about data. I will not remove someone for non-data posts especially if they post cats or dogs.  I tweet here, to be fair, I mostly just retweet; https://twitter.com/jerryritcey

What's new in SQL Syntax in SQL Server 2022

 Found a neat article on new syntax in 2022 by Aaron Betrand



Most exciting one might be DATE_BUCKET, which may eliminate the need to roll your own magic dates to find things like first of this month, first of last month, five minute intervals, into one command.  One quote of a useful feature combining two new commands; "

BONUS

We can combine DATE_BUCKET and GENERATE_SERIES to build a contiguous series of date/time values. I often see people struggle to build a full data set when they are reporting on intervals where not all intervals are populated. For example, I want hourly sales figures across a day but, if we're selling something like cars, not every hour will always contain a sale"