-
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…
-
This isn’t relative to the job I am interviewing for (is it?)
Read more: This isn’t relative to the job I am interviewing for (is it?)Sometimes I take the bait and I read some form of rage post talking about the interviewing process. There is always one thread that kills me. Recently I saw a post that was basically “This isn’t relative to the job I am interviewing for, why are they wasting my time?” Now I expect there are…
-
Is a broken clock really right twice a day?
Read more: Is a broken clock really right twice a day?This proverb is one of the age old classics. “Even a broken clock is right twice a day.” But is it? What does “right” truly mean? I started pondering this question because I recently heard it in a discussion about something (I don’t remember where), but I don’t think they were insulting me at the…
-
Interesting things about T-SQL in a Fabric Data Warehouse: A bit each of clustering and performance information (Part 7)
Read more: Interesting things about T-SQL in a Fabric Data Warehouse: A bit each of clustering and performance information (Part 7)As I come to the end of this initial salvo of material about Fabric T-SQL (more to come as I dig deeper), I wanted to do a final posts about getting information about how your queries execute beyond the query plan. The one simple way I have found to show differences in performance has been…
-
Lack of confidence is my super power
Read more: Lack of confidence is my super powerI read a lot of social media posts, and they mostly entertain me. Whether they are somehow teaching me something, or basically are trying to make me dumber (or engage their dumbness for money), there is something fun about it. Yes, some people say addicting, but if this is addicting, the Traitors TV show probably…
-
Interesting things about T-SQL in a Fabric Data Warehouse: Query Plan and Statistics Tools (Part 6)
Read more: Interesting things about T-SQL in a Fabric Data Warehouse: Query Plan and Statistics Tools (Part 6)So in this next entry in this series, I want to start to cover a topic that every nerdy SQL programmer is going to want to know. “How do I make a query faster?” If you have worked with relational databases, you know the simple answer is to… check the estimated query plan, run the…
-
Is a broken clock really right twice a day?
Read more: Is a broken clock really right twice a day?This metaphor is one of the age old classics. “Even a broken clock is right twice a day.” But is it? What does right really mean? I started pondering this question because I recently heard it in a discussion about something I don’t remember where, but I don’t think they were insulting me at the…
Fediverse reactions
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
