-
T-SQL Tuesday #204 – Are blogs still relevant?
Read more: T-SQL Tuesday #204 – Are blogs still relevant?Having been on a packed vacation from invitation to post day, I still wanted to put my two cents worth in on Jeff Iannucci’s question in his TSQL Tuesday Invite: “are blogs still relevant?” I will keep this as short as I have ever written: I clearly hope so. Thank you Jeff for such an…
-
Writing new conference sessions
Read more: Writing new conference sessionsI am returning from vacation this week after a week of (hopefully) ignoring the timelines and schedules coming up. If I know me, I have taken a number of notes on my phone when my mind won’t shut up until I do, but hopefully most of my brain is being used to enjoy friends and…
-
Tech is Math
Read more: Tech is MathWhen you work on a Computer Science degree (at least 30 years ago this was the case, but I think this is still true), you have to take a lot of math. One of those requirements was a year of Calculus. Let’s call that a fact. The other fact is, almost every CS degree wielding…
-
The magical (temporary) power of duct tape
Read more: The magical (temporary) power of duct tapeMy great friend Joe Webb had this post a while back: “Don’t use duct tape and WD-40 on your SQL Server. “ And I want to basically amen the bigger point here, but note one thing. Duct tape and WD-40 are essential tools for anyone to master if they are going to fix things around…
-
Windowing part 2 – GROUP BY Totals, Tips, and Quirks
Read more: Windowing part 2 – GROUP BY Totals, Tips, and QuirksWhen I split the GROUP BY content into two posts (first part here), I was wary that it would make 2 posts. And then with examples this post is longer than the last! The first thing one typically wants to do after they write their first query using GROUP BY is to get a aggregate…
-
Getting burned is bad, but worse if nothing was learned
Read more: Getting burned is bad, but worse if nothing was learnedI love music, so I listen to a pretty large variety of it, but I will admit, most of it comes from a pretty narrow set of artists/time range. Part of this is because my favorite artists are also sort of philosophers. From time to time, I hear a lyric that piques my mind about…
-
T-SQL Tuesday #203 – The most important database decision
Read more: T-SQL Tuesday #203 – The most important database decisionThis month, the wonderful Pat Wright has provided the invitation for T-SQL Tuesday and he entitled it Risk vs Reward. His question was “Risk vs Reward” and covered a lot of things like designing indexes or choosing where to store a column, or even whether you should put new data in an existing database or…
-
Do you care if someone can do the job well in the age of AI?
Read more: Do you care if someone can do the job well in the age of AI?The other day, there was a post I read on LinkedIn that started out, “I’ve stopped caring how well a candidate writes SQL.” It continued “Anyone worth interviewing can write the query. If they can’t, a model will, in four seconds” I will just let that clear diss on on my chosen profession that “Anyone…
-
Feedly Friday – Feeds I Read #15 – Hugo Kornelis
Read more: Feedly Friday – Feeds I Read #15 – Hugo KornelisWelcome to my continuing series of posts where I am going to highlight one or two feeds I follow in Feedly. Technology feeds only, though I keep up with other things like theme park news in there too. It has been a while, but there are feeds that feel necessary to mention! Feedly is an…
-
Grouping data in T-SQL – Conceptualizing groups with GROUP BY
Read more: Grouping data in T-SQL – Conceptualizing groups with GROUP BYFor a while now, I really have wanted to learn the Windowing Functions in great detail. I know them well enough to make it through a lot of needs, but there are a lot of intricacies that are hard to remember. As I noted in my very first Blogging for Programmers post, writing for your…
Fediverse reactions
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
