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)
352 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)
527 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,860 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)
202 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)
710 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
18 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
2 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
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
29 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
5 reads
By todd-32417
The next batch of exciting updates to the block editor is live on WordPress.com....
By Steve Jones
One of the things that I’ve seen crop up at various points in my...
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Comments posted to this topic are about the item Deceptive Visualizations
Hi, I'm trying to modify my SSIS packages to use sftp and since it...
I have included the DDL to re-create the 2 tables in this examples. I...
Ask SSC