SQL RNNR

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.

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.

Migrating a wordpress blog comes with its various set of challeneges. This installment covers magically changing percent symbols during that migration.

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.

Starting SQL Server in single-user mode should be a tool every data professional holds in the bag. This is an essential tool that can be used in multiple scenarios and ensure you are able to fully maintain and control your server. This article will show how to start in single-user mode via two methods.

Losing access to a SQL instance is never a desirable situation – for the DBA. When the people that are supposed to have access, lose that access, all hope is not lost. There are plenty of methods available to regain the requisite access to manage the server. Today, I shared one such method that I view as being extremely easy. If you lose access, I would recommend taking the steps shown in this article to regain that access.

This is my diatribe about service and giving back to the community. When done properly, there is a natural born effect of enhancing one’s personal life equal in some way to the amount of effort given towards the community.

Every now and again we have to deal with a sudden requirements change. When that happens, we sometimes just need to take a step back and evaluate the entire situation to ensure we are proceeding down the right path. It is better to be pensive about the course of action rather than to knee jerk into the course of action. Do you want to spend 5 minutes on the solution or 30-40 minutes doing the same thing? Changing collation can be an easy change, or it can be one met with a bit of pain doing a reinstall (more painful if more user databases are present). Keep that in mind and keep cool when you need to make a sudden change.

What are the tools you love to use? What are the tools that maybe need a little sharpening? What tools do you have that maybe you wish were the same caliber as somebody else’s tools? And lastly, which tools do you not possess that you wish you possessed?

SQL Server comes with a default SQL agent job installed (for most installations) to help manage the collection of system health data. I would dare say this job is ignored by most people and few probably even know it exists. This job is the syspolicy_purge_history job.

It would be no more dangerous in this case than to use sp_update_job. I wouldn't classify the job related tables…

I generate, and optionally execute, a script that uses sp_update_job to change the owner. Isn't it rather dangerous to…

What a great script! I've got it running along side sp_Blitz with it's @OutputServerName which can also utilize linked…

Good insight. Thanks for the info.

I noticed on my Windows 10 system that "Run as different user" was not available on my Start menu, even…

Useful article - thank you. I've often used a much lighter client such as "Query ExPlus" (https://sourceforge.net/projects/queryexplus/)…

Another option is using Windows Credential Manager. You can run one instance of SSMS, and connect to different servers with…

The risks of publishing a post such as that one. It is live again!

I had to delay my response to that problem. It was removed intentionally (by request) but is live again. The…

Thanks for the feedback. I will look into the order by issue.