Steve Jones

My background is I have been working with computers since I was about 12. My first "career" job in this industry was with network administration where I became the local DBA by default. I have also spent lots of time administering Netware and NT networks, developing software, managing smaller IT groups, making lots of coffee, ordering pizza for late nights, etc., etc.

I currently am the editor of SQL Server Central and an advocate/architect at Redgate Software. I am also the President of SQL Saturday, maintain the T-SQL Tuesday monthly party, and remember our colleagues at sqlmemorial.org.

You can find out more about me on my blog (www.voiceofthedba.com) or LinkedIn (www.linkedin.com/in/way0utwest)
  • Interests: yoga, reading, biking, snowboarding, volleyball

All authors

SQLServerCentral Article

Auditing Your SQL Server Part 4 - Selective Auditing

It's been some time and he apologizes. This next part of this series from Steve Jones looks at selective auditing changes to data on the server using a combination of methods presented in previous articles in the series. Read on if you have problems tracking changes to data on some tables, but don't want to implement a solution that tracks every change.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2004-04-28

12,810 reads

All authors

Blogs

Can You See Table Valued Parameters in Extended Events?

By

I live for questions and this was an interesting one. Can you see Table...

Can an AI Help Me Find a Job?

By

I’m not looking for a job, but I ran across an article about using...

EightKB 2025

By

EightKB is back! The biggest online SQL Server internals conference is back in 2025…it’s...

Read the latest Blogs

Forums

Dynamic T-SQL Script Parameterization Using Python

By omu

Comments posted to this topic are about the item Dynamic T-SQL Script Parameterization Using...

Pitfalls to avoid while feeding events into CrowdStrike

By Pablo Echeverria

Comments posted to this topic are about the item Pitfalls to avoid while feeding...

Column Adds and Drops

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Column Adds and Drops

Visit the forum

Question of the Day

Column Adds and Drops

I run this batch on SQL Server 2022. What happens? 

ALTER TABLE dbo.Accounts
 ADD AccountAccessType INT
GO
ALTER TABLE dbo.Accounts
 DROP AccountAccessType
GO

See possible answers