As I wrote last month, I went through a period of feeling personally and professionally deadlocked, and flailed about for some time before I found the answer of making...
2021-04-28 (first published: 2020-02-21)
363 reads
When I launched The Noncluttered Index last year, it was with the intention of writing at least twice a week. For a while, that was very doable. Then, work...
2021-04-23 (first published: 2020-01-14)
586 reads
A letter to a past self from Pamela Mooney that might help a more junior DBA get up to speed quicker.
2020-09-22
2,907 reads
Do you ever get the Christmas card that features a beautiful picture of a family on the front, and a letter catching you up on their year on the...
2020-08-28 (first published: 2020-08-18)
204 reads
I was using LEN() to troubleshoot an issue I was having with a dynamically constructed string truncating while inserting into an NVARCHAR(MAX) column. Since I know that NVARCHAR(MAX) has...
2020-07-22 (first published: 2020-07-14)
808 reads
Hi All, While I haven’t been writing here, I have been writing. I have a new article that has just been published on Simple Talk, and I am developing...
2020-04-16
35 reads
Great news! I was accepted this weekend to speak at SQLSaturday Los Angeles! This officially counts as a level up for me for my deadlock resolution quest. The event...
2020-02-25
5 reads
An old proverb states, “Fire is a good servant but a bad master.” Put simply, it means that when controlled, fire is a life-sustaining element. We need it for...
2020-02-07
2 reads
My colleagues and I take schema ownership seriously. The owner (with few exceptions) should always be “dbo”. Certainly, it should not be a user. Why? Because if the user...
2020-02-03
31 reads
I don't normally drop users and logins in production, but when I do, and it goes wrong, I do this.
2019-09-20
7 reads
By Steve Jones
I was reminded this week that I needed to get registered for the Data...
By Steve Jones
Today’s coping tip is to choose to see your mistakes as steps to help...
By gbargsley
Good day reader. This post is coming to you from a busy week in...
We have change tracking enabled on one of our databases and I am looking...
I have two databases on the same server. I have a service account I...
Hi, I'm trying to run the below SQL code but I'm getting this error:...
Ask SSC