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

802 reads

Blogs

Goal Progress–November 2020

By

This is my report, which continues on from the Oct report. It’s getting near...

Azure Synapse Analytics is GA!

By

(Note: I will give a demo on Azure Synapse Analytics this Saturday Dec 5th...

5 Things You Should Know About Azure SQL

By

Azure SQL offers up a world of benefits that can be captured by consumers...

Read the latest Blogs

Forums

Get data from last line and merge into data stream before removing

By Bruin

This script reads thru a file and removes the last line, but before it...

Firewall access for Availability Group listeners

By webrunner

Hello experts, I have a noob question as I never feel like I understand...

conversion of excel formula to case statement in tsql

By Abhas

Hi  all, need your help on conversion of excel formula into case statement. i...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers