-
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…
-
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…
Fediverse reactions
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
