Cannot use the special principal ‘dbo’. This error message can be misleading. This article will take you on a journey of common mis-steps along with the appropriate fix for this error.
Cannot Use the Special Principal – Back to Basics
Quickly Change SQL Job Owners
It is not unusual to find a server where some random user created a bunch of jobs to be run by SQL Agent. Sometimes, the user creating the job(s) sets themself as the owner of the job. Learn how to efficiently manage the proper change of such job owners.
T-SQL Tuesday #104: Just Can’t Cut That Cord
We all have our favorite scripts, tools or utilities. Those are the things that help make our jobs easier. In this article, I share with you a poor mans audit solution to help catch unwanted permissions changes.
Summiting that Technical Challenge Part II
Migrating a wordpress blog comes with its various set of challeneges. This installment covers magically changing percent symbols during that migration.
Use SSMS with a Different Windows Account – Back to Basics
Runas should be a very common tool in the toolbox of all IT professionals – not just Data Professionals. Learning how to test different accounts is essential to being an effective and efficient professional that can provide solid results.