-
Interesting things about T-SQL in a Fabric Data Warehouse: Dataypes and Constraints (Part 1)
Read more: Interesting things about T-SQL in a Fabric Data Warehouse: Dataypes and Constraints (Part 1)There are three major “engines” in Fabric that I have seen that use T-SQL. There is the SQL Azure Fabric engine, the Lakehouse, and the Data Warehouse. Having this capability to manipulate data is wonderful, but there are some things you need to understand before you start writing code (unless you want to learn them…
-
Changing mindset when using the same tools
Read more: Changing mindset when using the same toolsPretty much everyone has a drawer full of tools somewhere in their house. In that drawer are some tools you pull out for use when you need to do something. You might have 2 screwdrivers, or 50. I have 50: My father, who passed away 30 year ago this year, had been a master mechanic…
-
Interesting things about Optimized Locking in SQL Server 2025
Read more: Interesting things about Optimized Locking in SQL Server 2025A feature I have been trying to find time to write about since it arrived is Optimized Locking, which first shipped in SQL Server 2025. This is a feature that changes the way SQL Server locks manages concurrency in a very interesting number of ways. Most of which, as I start writing this blog, I…
-
Music City Data User Group Roundup
Read more: Music City Data User Group RoundupLast Wednesday I went up to Nashville to hang out with my good friend Jason Romains (aka The Dax Shepherd) to be the second speaker at the Music City Data User Group. Honestly, it was a great group of people, of whom I knew several people from various other places, including Sven Aelterman who was…
-
I have had it with blogging and social media
Read more: I have had it with blogging and social mediaI am realizing more and more that I am never going to be provacative enough to make a bit splash on social media. But to be fair, it isn’t that I can’t be provocative, it is just that I don’t want to be. Hence the title that is a prime example. Only the title is…
-
What you find in the weeds
Read more: What you find in the weedsThere is this old saying when people are getting off track that states “we are getting in the weeds”. The thrust of this statement is to get people back on the bit picture path that they want to discuss and to stay out of the messy bits of a conversation, but let’s take this metaphor…
-
Speaking at Music City Data User Group Next Week
Read more: Speaking at Music City Data User Group Next WeekOn July 22, I will be heading over to Nashville, TN to be the second speaker at the newly formed Music City Data User group. The group was started by Jason Romans with help from Kevin Kline (and I may have voiced a few opinions to my coworker/friend Jason as well. Looking forward to crossing…
-
A short myth to look at: subqueries in the SELECT clause
Read more: A short myth to look at: subqueries in the SELECT clauseThis past week, I was sick and so I didn’t hang around social media much. But as I got better, I found more and more of the types of posts that just scream “I don’t know what I am talking about” from the poster. This was a pretty easy topic for the day, so I…
-
The best laid plans of mice and bloggers
Read more: The best laid plans of mice and bloggersAs I write this post, my birth time has just passed. I am starting another rotation around the sun along with everyone reading this. It wasn’t my best birthday as I am still fighting a cold that started last weekend as I was traveling again after a vacation. It wasn’t terrible, as I spent it…
-
T-SQL Tuesday #200 – Concerning query traits
Read more: T-SQL Tuesday #200 – Concerning query traitsSo while I was on vacation last week, I saw Brent Ozar’s invitation post for the 200th episode of T-SQL Tuesday. And fittingly this was a T-SQL topic. No need to bring out any of my gushy feelings about past events or mistakes or whatever. Just “When I’m looking at a query, I bet it’s…
Fediverse reactions
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
