Auditing

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

527 reads

Azure SQL Database Auditing

  • Article

While a diminished level of control is certainly a factor to consider when contemplating migration of on-premises systems to Microsoft Azure, especially when dealing with PaaS resources such as Azure SQL Database, you have a range of techniques at your disposal that allow you to control and monitor both the status of and access to your Azure-resident services. One of these techniques is SQL Database auditing.

2015-01-22

9,981 reads

Blogs

Azure Service Logging in the Modern Data Warehouse

By

[read this post on Mr. Fox SQL blog] The “modern data platform” architecture is...

Power Platform Conference – 7/23-24/2019

By

Pragmatic Works is hosting a 2-day Power Platform online conference. If you are unable...

Learning more Kubernetes

By

I’ve been slowly working my way through the 50 days of Kubernetes (K8s). As...

Read the latest Blogs

Forums

The AI Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI Manager

SSIS Scale-out Manager don´t show status of any Workers

By Jenda

Why does my SSIS Scale-out manager on my master server not show the status...

Dynamic count of days between start and end in MDX

By TroelsHJ

Hi Guys! Long time reader – first timer poster. Hoping someone can aid me...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers