The Non-Cluttered Index

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

24 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

19 reads

Why I Take Pictures at Conferences

• by Pam Mooney

• The Non-Cluttered Index

Why do I take pictures of screens at conferences? Let me count them up for you! Read on...

2019-07-05

91 reads

Gone Fishing…

• by Pam Mooney

• The Non-Cluttered Index

It's SQLIntersection time, and also time to meet a new member of the family. He's old enough for social media, though...

2019-06-07

9 reads

What is Service Broker, and Why Would We Use It?

• by Pam Mooney

• The Non-Cluttered Index

I was recently asked in a Service Broker class that I was teaching why we would use it. Good question! Read on....

2019-05-15 (first published: 2019-05-03)

953 reads

Drop It Like It’s Hot (Part 2 of the Rename/Drop Objects Process)

• by Pam Mooney

• The Non-Cluttered Index

Dread the drop no more! Part 2 of the rename/drop process.

2019-05-06 (first published: 2019-04-22)

420 reads

Find Occurrences of a String Anywhere on an Instance

• by Pam Mooney

• The Non-Cluttered Index

Oh, the dreaded string search (on an entire instance). What to do?

2019-04-11

14 reads

Automatically Drop a Login/User (and Solve the Schema Owner Problem)

• by Pam Mooney

• The Non-Cluttered Index

Ever tried to drop a user/login, only to find that they owned a schema? Here's how I do it...

2019-04-08

19 reads

That Awkward Moment When….

• by Pam Mooney

• The Non-Cluttered Index

Let's be honest - some of our best learning experiences come from our mistakes. Here's one of mine....

2019-04-05

6 reads

Isolation Levels in SQL Server

• by Pam Mooney

• The Non-Cluttered Index

Do your eyes start to cross whenever you think about isolation levels? Mine did, too. Here's how I keep it all straight.

2019-04-03

2 reads