- Quickly Change SQL Job Owners by Jason Brimhall
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 Ca… by Jason Brimhall
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 Ch… by Jason Brimhall
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 W… by Jason Brimhall
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.
- Single User Mode – Ba… by Jason Brimhall
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.
- Lost that SQL Server Access? by Jason Brimhall
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.
- T-SQL Tuesday #102: Giving Back by Jason Brimhall
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.
- Change SQL Server Collation… by Jason Brimhall
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.
- T-SQL Tuesday #101: Essential Tools by Jason Brimhall
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?
- Syspolicy Phantom Health Records by Jason Brimhall
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.
- Jason Brimhall about Quickly Change SQL Job OwnersIt would be no more dangerous in this case than to use sp_update_job. I wouldn't classify the job related tables…
- ScottPletcher about Quickly Change SQL Job OwnersI generate, and optionally execute, a script that uses sp_update_job to change the owner. Isn't it rather dangerous to…
- Kevin Karns about T-SQL Tuesday #104: Just Ca…What a great script! I've got it running along side sp_Blitz with it's @OutputServerName which can also utilize linked…
- Jason Brimhall about Use SSMS with a Different W…Good insight. Thanks for the info.
- Larry Husingh about Use SSMS with a Different W…I noticed on my Windows 10 system that "Run as different user" was not available on my Start menu, even…
- Dave Boltman about Use SSMS with a Different W…Useful article - thank you. I've often used a much lighter client such as "Query ExPlus" (https://sourceforge.net/projects/queryexplus/)…
- Jason about Use SSMS with a Different W…Another option is using Windows Credential Manager. You can run one instance of SSMS, and connect to different servers with…
- Jason Brimhall about Single User Mode – Ba…The risks of publishing a post such as that one. It is live again!
- Jason Brimhall about Single User Mode – Ba…I had to delay my response to that problem. It was removed intentionally (by request) but is live again. The…
- Jason Brimhall about Easily Shred Event DataThanks for the feedback. I will look into the order by issue.