-
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…
-
Simplest way to make a query faster
Read more: Simplest way to make a query fasterThis week, I want to sell you on two ideas. First, that you can make any query faster with: This change I will guarantee will make your queries screamingly faster. Never will your customer’s wait on query results again. You will have no blocking, no latch waits, no waiting whatsoever. Before I tell you the…
-
T-SQL Tuesday #201 – Temp Tables, Friend, Foe, None, or All of the Above?
Read more: T-SQL Tuesday #201 – Temp Tables, Friend, Foe, None, or All of the Above?This month’s T-SQL Tuesday invitation from Jeff Taylor is probably the easiest one for me ever, mostly because my answer is the same as Jeff said: Reaching for a temp table should be the exception, not the reflex. Temp tables fit into my query writing process as one of those last ditch efforts to make…
-
Is it bad that I don’t want to dive deep into AI? Or is it that I actually can’t?
Read more: Is it bad that I don’t want to dive deep into AI? Or is it that I actually can’t?But AI is a different beast. And it requires a lot of the skills I have never quite grokked (like networking, for example; and non-database security too.) When you get some (ok, a lot of) experience, you tend to get to a point where you know what you know. This leads to a fear of…
Fediverse reactions
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
