FlamesNAshes

Getting more info about who or what connect to your SQL Server

A couple of days ago I was playing with my small SQL Server enviroment (test) and auditting login events. I went ahead and created the audit for FAILED_LOGIN_GROUP and SUCCESSFULL_LOGIN_GROUP (let it run for a while). USE [master] GO CREATE SERVER AUDIT [Audit_LoginEvents] TO FILE ( FILEPATH = N'<PathToStoreData>' ,MAXSIZE = 100 MB ,MAX_FILES = […]

2020-06-03 (first published: )

604 reads

Blogs

Everything I Never Wanted to Know About Collation (14 minute video/podcast episode)

By

I'm not an expert on collation in SQL Server, but there are a few...

Do More, With Less

By

Next week, July 22 and 23, I’ll be presenting at Redgate Summit. Summt is...

Daily Coping 16 Jul 2020

By

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

Read the latest Blogs

Forums

Backup server

By Admingod

We will have backup server maintenance with the outage between 15mins to 1 hr....

Is SQL developer edition exactly the same as enterprise edition?

By tommiwan

Hey all, Regarding licensing of SQL server, we are considering the possibility of running...

Logging (auditing) in the table vs. having a logging (auditing) table

By Rod at work

I really like Steve Jones' editorial today, Carefully Giving Normal Users Security Permissions. I've...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers