FlamesNAshes


Technical Article

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

1,549 reads

Blogs

Daily Coping 7 Dec 2022

By

Today’s coping tip is to stop for a minute when you walk outside and...

Encryption and Data Protection Regulation

By

One of the reasons you may be considering encryption is due to the relevant...

Types of data consulting engagements and what you can expect from them

By

There are multiple ways organizations can engage with a data (DBA/analytics/data architect/ML/etc.) consultant. The...

Read the latest Blogs

Forums

Blocking

By sqlguru

We were getting constant blocking on the db server. However, after stopping the process...

record loading

By Bruin

I have a table from a Linked Server that I'm pulling data and would...

Either/ Or Query

By dec_obrien

Hi, I have a table containing some columns and some simple data. I want...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers