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

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...

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.
Related Posts:

Summiting that Technical Challenge January 9, 2018

T-SQL...

Summiting that Technical Challenge Part II

Conquering Challenges

Months ago, I posted an article about some of the challenges encountered while migrating from one service level to...

Use SSMS with a Different Windows Account – Back to Basics

One of the tasks I find myself doing on a fairly regular basis is running SSMS as a different Windows...

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...

Single User Mode – Back to Basics

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...

Single User Mode – Back to Basics

In a recent article, I took you on a trip through how to hack (ethically) a SQL Server to regain...

Lost that SQL Server Access?

As a data professional can you recall the last time you needed to support a SQL Server instance for which...

Lost that SQL Server Access?

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...