-
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…
-
Interesting things about T-SQL in a Fabric Data Warehouse: Schema Locks and Time Travel (Part 5 )
Read more: Interesting things about T-SQL in a Fabric Data Warehouse: Schema Locks and Time Travel (Part 5 )When reading that title, you probably want to get to concept of time travel first, because if you could really do that, you wouldn’t have any more backup and recovery problems. The time travel I will cover is about getting to past versions of data in your data warehouse tables. This is done in a…
-
Interesting things about T-SQL in a Fabric Data Warehouse: Atomicity and Isolation (Part 4)
Read more: Interesting things about T-SQL in a Fabric Data Warehouse: Atomicity and Isolation (Part 4)When I arrived in this land made of the finest fabric that Microsoft could find, I had a LOT of assumptions. I assumed that some things would work the same, and these were errors I bumped into regularly. I have written on creating tables, identity and sequences, and metadata and temp tables. None of these…
-
The Stages of My Layoff Grief – Part 3 – Beyond Grief
Read more: The Stages of My Layoff Grief – Part 3 – Beyond GriefThe finale to a series of posts that I last touched a year ago. I have been away from my dream job for just over a year now, and am back at my previous dream job again just over a year too. I had previously written a few posts about job loss grief, and it…
-
Interesting things about T-SQL in a Fabric Data Warehouse: Metadata and Temp Tables (Part 3)
Read more: Interesting things about T-SQL in a Fabric Data Warehouse: Metadata and Temp Tables (Part 3)When we decided to use T-SQL and a Fabric Data Warehouse for our ETL, I started thinking about generating the code with the metadata in the system catalog views or the INFORMATION_SCHEMA. Having done this sort of thing before in SQL Server over the years, it seemed really straightforward. And it kind of is, until…
-
Is all this “AI Slop” deliberate?
Read more: Is all this “AI Slop” deliberate?After I replied to yet another “SQL executes this way” post, which should truly be called a “SQL execution doesn’t work this way” post, I wondered, what would happen if I went to my friendly neighborhood ChatGPT client and asked it to write me a simple post. I don’t pay for it, I just use…
-
Interesting things about T-SQL in a Fabric Data Warehouse: Surrogate Key values (Part2)
Read more: Interesting things about T-SQL in a Fabric Data Warehouse: Surrogate Key values (Part2)In Part 1 I wrote about one of the most basic topic, datatypes, along with constraints. Creating the simplest of tables, the first thing I start thinking about is making sure that the data is going to be protected from the user. Users (including myself on my own projects when I have my user hat…
-
My new love of markdown
Read more: My new love of markdownWhen I started as an editor at Simple-Talk, I had never heard of markdown. I had a couple of writers send me material with these weird formatting marks that I spent quite a bit of time clearing up. So it looked like this: I had no idea what the three tick marks “` meant until…
Fediverse reactions
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
