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

You rated this post out of 5. Change rating

2020-06-03 (first published: )

1,892 reads

Blogs

Focus on Core Skills

By

Core skills depends on the position, but the point is that ensuring you have...

A New Word: Zverism

By

zverism – n.  the wish that people could suspend their civility and indulge in...

SQL Server Source Control on a $0 Budget

By

The Source Control Dilemma Every DBA has been there. Trying to keep track of...

Read the latest Blogs

Forums

Is GenAI Coming Faster Than You Think?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is GenAI Coming Faster Than...

Local Storage Options

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Local Storage Options

DeepSeek: What is new with this AI technology?

By Daniel Calbimonte

Comments posted to this topic are about the item DeepSeek: What is new with...

Visit the forum

Question of the Day

Local Storage Options

I'm setting up a SQL Server 2019 instance and we are planning on using SMB storage for our database files. However, the file share isn't ready, so the idea is to use the \127.0.0.1dbfile as the location to start and then move these files to the remote server. Can I do this?

See possible answers