Dear Past Me on My First Day as a DBA
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,760 reads
Pam Mooney
My August Christmas Card
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)
198 reads
The Length Limitations of LEN()?
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)
672 reads
New Article For Simple Talk!
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
17 reads
Level Up!
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
My Deadlock Resolution Progress Report
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...
2020-02-21
3 reads
How Do You Decide When Can Doesn't Mean Should?
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
Discover and Clean Up Schema Ownership
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
When the DBA is Deadlocked
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...
2020-01-14
2 reads
Dropping Database Users and Logins: How it Can Go So Very Wrong, and How You Can Easily Fix It
I don't normally drop users and logins in production, but when I do, and it goes wrong, I do this.
2019-09-20
3 reads
Blogs
Daily Coping 3 Dec 2020
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
SQL Homework – December 2020 – Participate in the Advent of Code.
Christmas. Depending on where you live it’s a big deal even if you aren’t...
[Video] Azure SQL Database – Import a Database
By Arun Sirpal
Quick Video showing you have to use a BACPAC to “import” a database into...
Forums
How can I exclude records from this table?
How do I exclude the "Appointments" that are not adjacent to a "Discharge"? This...
Disable Package Expression
Hi SSC, I've got 2 Project Variables which I use to control wether a...
Inflow / outflow report per day
Hello, I have two simple tables: Invoices InvoiceID Date Value and PaymentsReceived PaymentID Date...
Ask SSC