Logins

Audit Users logging in using "sa" or service accounts

  • Script

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 […]

2019-07-04 (first published: )

998 reads

Blogs

Basic JSON Queries–#SQLNewBlogger

By

Another post for me that is simple and hopefully serves as an example for...

Daily Coping 30 Nov 2020

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Building a Raspberry Pi cluster to run Azure SQL Edge on Kubernetes

By

A project I’ve been meaning to work on for a while has been to...

Read the latest Blogs

Forums

Performance and usage of system stored procedure sp_columns_100

By webrunner

Hello experts, I'm researching different ways to monitor SQL Server CPU usage by query....

Operand type clash: text is incompatible with datetime2

By AMCiti

Dear Group: I am not sure what is causing this, and having a terrible...

Can I clone a database across servers?

By SQL Guy 1

Hi all, I have a database that resides on server A and I need...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

The TUF File

See possible answers