Brian Kelley

Brian Kelley is an author, columnist, and Microsoft SQL Server MVP focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress), Professional SQL Server 2008 Administration (Wrox), and Introduction to SQL Server (Texas Publishing). Brian currently serves as an infrastructure and security architect. He has also served as a senior Microsoft SQL Server DBA, database architect, developer, and incident response team lead.
  • Interests: Chess, Reading, Soccer (Football), Baseball, Animals, Theology

Blocking Users by IP

SQL Server MVP Brian Kelley brings us a great new article that solves a problem that might help your security. In this short piece, we learn how we can use logon triggers to block users based on their IP address.

4.69 (103)

2013-11-08 (first published: )

35,003 reads

Security Auditing Matching Up Logins And Users

I have been tasked with auditing security on my SQL Server. However, this needs to be a somewhat automated process as I don't want to have to rely on taking screenshots every month to satisfy our auditors. What tables and/or views should I be using and what's the best way to extract the information out of them?


3,618 reads


Daily Coping 5 Mar 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Microsoft Ignite Announcements 2021


Microsoft Ignite has always announced many new products and new product features, and this year...

Daily Coping 4 Mar 2021


I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs


Stories to Engage Us

By Grant Fritchey

Comments posted to this topic are about the item Stories to Engage Us

Loading large JSON file into a Data Table to Bulk Copy into SQL Server Table

By sadie

We have a JSON file with 10M records to bulk copy load into a...

Help with OPENJSON for Google Maps API data

By tacy.highland

Hello, I'm a newbie when it comes to JSON so when I started down...

Visit the forum


SQL Server Q&A from the SQLServerCentral community

Get answers