Frederik Vandeputte

SQL Server 2005 Logon Triggers

One thing that many people tried to implement in SQL Server 2000 is the auditing of logins. However getting this to work was a complex process. In SQL Server 2005, however, there are a few ways you can handle this and new author Frederik Vandeputte brings us a method using Service Broker for handling this.

4.71 (14)

2006-04-17

24,354 reads

Blogs

DBA Myths: The system sessions are the ones with a session_id 50 or less

By

Anecdotally any session_id that’s 50 or less is going to be a system session...

SQL Undercover TV – Encrypting SQL Backups

By

In this episode, David looks at how we can encrypt our SQL Server backup...

Using volumes in SQL Server 2019 non-root containers

By

I’ve seen a few people online asking how to use docker named volumes with...

Read the latest Blogs

Forums

Numeric and Decimal

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Numeric and Decimal, which is...

Issue with processing dimensions

By richardmgreen1

Hi all   I've got a weird one here. We have a multi-dimensional cube...

Maintenance Window for SQL Server Critical Alerts

By WebTechie

Hello, We had some sql server have issues on some production servers.  We actually...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers

Question of the Day

Leaving SQLCMD

See possible answers