MartinT


Technical Article

Audit Users logging in using "sa" or service accounts

Security is probably one of a production DBA's most important tasks and if developers use application or service accounts to run queries in your production environment you need to identify then and prohibit it. I notice some unwanted activity after staring a new job and decided to create a script that notifies me via email when […]

You rated this post out of 5. Change rating

2019-07-04 (first published: )

2,148 reads

Blogs

T-SQL Tuesday #186–Agent Jobs

By

It’s that time of the month again, when the T-SQL Tuesday blog party takes...

SQL Saturday NYC Recap 2025

By

My first time at SQL Saturday New York City was an absolute blast! Thank...

SSMS 21

By

Just a quick one this morning. I’m on the road and haven’t worked up...

Read the latest Blogs

Forums

SSIS Automatically Coverting a NULL to a Blank Space

By cpiacente

Hello, I was wondering if anyone knew how to prevent this issue I am...

Problem creating a Linked Server to MS Access 97 database from SQL Server 2019

By Weegee71

Hi there I need help on creating a Linked Server to an MS Access...

SSPI handshake failed error code 0x80090311

By jamesstirling01

Hi, I have a workstation with SQL Express 2019 installed and I have a...

Visit the forum

Question of the Day

Removing Log Shipping

If I want to delete a log shipping secondary server where only one database is used to restore the logs, what should I do?

See possible answers