The Non-Cluttered Index

Level Up!

• by Pam Mooney

• The Non-Cluttered Index

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

My Deadlock Resolution Progress Report

• by Pam Mooney

• The Non-Cluttered Index

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

How Do You Decide When Can Doesn't Mean Should?

• by Pam Mooney

• The Non-Cluttered Index

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

• by Pam Mooney

• The Non-Cluttered Index

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

26 reads

When the DBA is Deadlocked

• by Pam Mooney

• The Non-Cluttered Index

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

Dropping Database Users and Logins: How it Can Go So Very Wrong, and How You Can Easily Fix It

• by Pam Mooney

• The Non-Cluttered Index

I don't normally drop users and logins in production, but when I do, and it goes wrong, I do this.

2019-09-20

Validating Replication (All or Just One Article)

• by Pam Mooney

• The Non-Cluttered Index

You may sometimes have reports or other processes that are dependent on transactional replication being current.  If that is the case, you will probably need a mechanism to check...

2019-08-09

Automating Replication On Your Server

• by Pam Mooney

• The Non-Cluttered Index

If you use replication, you have had the situation occur where you had to restore a replicated database.  You’ve have doubtless been paged to restore a replicated database. You...

2019-07-31

Find Things Pointing at Production

• by Pam Mooney

• The Non-Cluttered Index

Step AWAY from the Production servers! Read on...

2019-07-22

1 reads

One Way to Find Broken Code on Your Server

• by Pam Mooney

• The Non-Cluttered Index

Before we approached our last major SQL Server upgrade, I was curious about what might break.  Yes, I had used the DEA to check our code against deprecated or...

2019-07-19

21 reads