Let’s get this out of the way right now: I am SO going to take advantage of this T-SQL Tuesday on aggregates to talk about OVER() and PARTITION BY. Aggregates and OVER go together like french fries and catsup…sure, you can have them apart, but together they’re just magical. Note: If you’re not at all familiar […]
Category: Tech and Learning
RTFM365, Weeks 8-9
I’m not gonna lie to you, Marge…I haven’t exactly been keeping up with the RTFM365. And when I have read, I haven’t noted down what I read. As it turns out, it’s really, really hard to do something every single day for a year. Or even, say, for two months, which is about how long […]
Top 10 SQL #Awesomesauce for 2010
Here at MidnightDBA.com, we’re all about you! And us! It’s just us, and you. Which is why I’ve put together the top 10 SQL Awesomesauce blogs of 2010 – by me, for you! (Note that I only put the hit counters in place sometime in July, so this is more like the top 10 for […]