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,362 reads

Blogs

State of Database DevOps Survey

By

Maybe you’re using DevOps within your database development and deployment. Maybe you’re not. Maybe...

HP is the 2019 Laptop Winner

By

This is for me, not necessarily for you, but I decided to go with...

Data Lake Architecture using Delta Lake, Databricks and ADLS Gen2 Part 4

By

This is the fourth and final post in a series about modern Data Lake...

Read the latest Blogs

Forums

Developing SSIS packages in VS 2019 and running them on SQL Server 2014 and 2016

By dndaughtery

If I develop ssis packages in VS2019 will they be able to run on...

Developing SSIS packages in VS 2019 and running them on SQL Server 2014 and 2016

By dndaughtery

If I develop ssis packages in VS2019 will the be able to run on...

Snapshot Isolation and DMVs

By chris.o.smith

I recently noticed that DMVs, or at least sys.dm_db_partition_stats, does not respect snapshot isolation. ...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers