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

90 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)

949 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)

418 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

13 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

Distributed Replay Utility – The Search for the Cure

• by Pam Mooney

• The Non-Cluttered Index

The Complaint(s) When I was young, I went to nursing school.  In school, we were taught that in order to come up with a proper diagnosis, the doctor first...

2019-04-01

16 reads