Tag Archives: administration

Monday Monitor Tip: Compliance Checking for Old Versions

A customer recently wanted to know if any of their instances were too old and out of support. This was for a compliance purpose, and they had the need to show a report to management of when instances were out … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Monday Monitor Tips–Finding CUs for My Instance

How can I quickly get a CU patch for a system that’s out of date? I’ll discuss that situation. You might think you get to patch every instance every few months, and you may be able to. But most of … Continue reading

Posted in Blog | Tagged , , , | 1 Comment

Saving Emergency Space on my Laptop

With my new laptop, one of the things I realized I’d forgotten to do in setup is reserve some space. I wrote about this years ago, but I wanted to ensure I always had space in the event of an … Continue reading

Posted in Blog | Tagged , | Comments Off on Saving Emergency Space on my Laptop

Fixing DBCC CloneDatabase Dup Key error in sys.sysschobjs

This was an interesting error, and I was able to duplicate it, so I decided to write a post on how to find the problem and fix it. The error after running DBCC CLONEDATABASE is: NO_STATISTICS and NO_QUERYSTORE options turned … Continue reading

Posted in Blog | Tagged | 3 Comments