-
SSMS Updating and a new Grid Export Feature
Read more: SSMS Updating and a new Grid Export FeatureDuring the Erin Stellato and Makena Barickman session the other day at SQLCon, there was a question asked. “Why don’t we upgrade SSMS?” There were people in the crowd still on SSMS 17. According to this post that was in 2017. I would like to say this was an outlier, but I honestly didn’t upgrade…
-
Expert in one thing, dunce in another
Read more: Expert in one thing, dunce in anotherOne of the most interesting things that every expert at what they do should realize is that there are many things that they are NOT an expert in. In fact, they could be complete and utter garbage at it. Of course, I hate the term “expert” in almost every case because I know experts in…
-
Datatype precedence and performance in SQL Server
Read more: Datatype precedence and performance in SQL ServerIf you have ever done any performance tuning of queries in SQL Server, no doubt one of the first thing you have heard is that your search argument data types need to match the columns that you are querying. Not one thing in this blog is going to dispute that. Again, the BEST case is…
-
T-SQL Tuesday #196: What Risks Have You Taken in Your Career?
Read more: T-SQL Tuesday #196: What Risks Have You Taken in Your Career?This week’s host is James Serra, and he continued the stream of super hard questions from a personal standpoint that I and then Pat Wright started this year off with, as he asks what risks we have taken in our careers? Of all the topics in the world, I may be sort of the worst…
-
Data Tune 2026 Roundup
Read more: Data Tune 2026 RoundupAs I write this, it is the Sunday after the DataTune Conference in Nashville, TN, led by Ed Pearson and a host of other folks who were all donning yellow shirts yesterday. It is a bleak day, and I am sitting in Einstein Bagels in Franklin, sipping my latte, finishing a first draft to put…
-
Datatype precedence and finding the datatype of an expression
Read more: Datatype precedence and finding the datatype of an expressionThere is one topic in query and equation writing that is constantly a minor issue for SQL programmers: implicit data type conversions. Whenever you don’t specifically state the datatype of an expression, like when you write SELECT 1;, it can feel a bit of a mystery what the datatypes of your literal values are. Like…
-
Heading to Atlanta for a pair of conferences
Read more: Heading to Atlanta for a pair of conferencesIn just over a week, I will be spending eight days in Atlanta at a couple of conferences. I look forward to seeing so many people I haven’t seen in quite a long time, having a little fun, and of course, learning some things too. Atlanta has never been a favorite city of mine (it…
-
The goal of naming standards
Read more: The goal of naming standardsI am starting a new, huge project soon, using some different tools than I have used before. So the first thing we need to do in this project is to come up with new standards for these new tools, right? No. Understanding the overall scope and desired results, requirements are first, then a high-level design…
-
Creating data from literal values in SQL Server
Read more: Creating data from literal values in SQL ServerNote: This is a post from the past being updated. The original post is here: 2008: Initializing Table Data with Row Constructors.. The code used here is the code I reference in this post on Redgate’s Product learning site: SQL Prompt AI Versus Smart Quotes, since the original post is rife with smart quotes! Row…
-
Speaking at DataTune 2026
Read more: Speaking at DataTune 2026Coming up on March 6 and 7, 2026, is a conference that I missed the inaugural event, even though I was in the city it is located in, and not even working that weekend: DataTune. When the first event occurred, I was sitting in a rehab center, just a few weeks out from hip replacement.…
Fediverse reactions
Hello,
I’m Louis
I have been at this database thing for a very long time, with no plans to stop.
