K. Brian Kelley

Brian Kelley is an author, columnist, Certified Information Systems Auditor (CISA), and former Microsoft Data Platform (SQL Server) MVP (2009-2016) focusing primarily on SQL Server and Windows security. Brian currently serves as a data architect as well as an independent infrastructure/security architect concentrating on Active Directory, SQL Server, and Windows Server. He has served in a myriad of other positions including senior database administrator, data warehouse architect, web developer, incident response team lead, and project manager. Brian has spoken at 24 Hours of PASS, IT/Dev Connections, SQLConnections, the Techno Security and Forensics Investigation Conference, the IT GRC Forum, SyntaxCon, and at various SQL Saturdays, Code Camps, and user groups.

2017 Awards   

2015 Awards   

2014 Awards   

2013 Awards   

2011 Awards   

2009 Awards   

Category	Tip Title
Auditing and Compliance	Audit SQL Server Logins without filling up the Error Log
Auditing and Compliance	Auditing Failed Logins in SQL Server
Auditing and Compliance	Auditing SELECT statements in SQL Server 2008
Auditing and Compliance	Auditing SQL Server 2012 Server Roles
Auditing and Compliance	Auditing SQL Server Password Age
Auditing and Compliance	Auditing SQL Server Permissions and Roles for the Server
Auditing and Compliance	Auditing SQL Server User and Role Permissions for Databases
Auditing and Compliance	Auditing sysadmin on multiple servers using PowerShell
Auditing and Compliance	Automate collection and saving of failed logins for SQL Server
Auditing and Compliance	How to Audit Login Changes on a SQL Server
Auditing and Compliance	Identifying What Runs at Startup on SQL Server
Auditing and Compliance	SQL Server Encryption To Block DBAs Data Access
Auditing and Compliance	SQL Server Security Auditing to Match Logins And Users
Auditing and Compliance	Tables and Views for Auditing SQL Server Logins
Auditing and Compliance	Using a Backup to Find SQL Server Security Changes
Auditing and Compliance	What to Audit at the SQL Server Instance Level
Auditing and Compliance	What Windows Server Groups Should I Audit on my SQL Servers?
Backup	How to Identify and Backup the Latest SQL Server Database in a Series
Backup	The Statement Backup Log is Not Allowed for a SQL Server Transaction Log Backup
Clustering	Understanding why there is still downtime for SQL Server with Microsoft Clustering
Contained Databases	How to Audit for SQL Server Users in Contained Databases
Data Types	SQL Server Implicit Conversions Performance Issues
Database Administration	Determining Drive Letters in Use by SQL Server Databases
Database Administration	How to move a SQL Server database within the same instance without losing settings
Database Configurations	Verify Connectivity to SQL Server
Database Design	Data Modeling: Understanding First Normal Form in SQL Server
Database Design	Dealing with a No NULL Requirement for Data Modeling in SQL Server
Database Design	Understanding First Normal Form in SQL Server
Disaster Recovery	Disaster Recovery Planning for Microsoft SQL Server - Getting Backups and Restores Right
Disaster Recovery	Retrieving SQL Server Server Roles for Disaster Recovery
Disaster Recovery	Scripting SQL Server Database Owners for Disaster Recovery
Dynamic Management Views and Functions	Return SQL Server Connections Information Using sys.dm_exec_connections
Dynamic Management Views and Functions	SQL Server Case Sensitive Collations and DMVs
Encryption	Finding Encrypted Data in a SQL Server Database
Encryption	SQL Server Encryption Symmetric vs. Asymmetric Keys
Encryption	Using authenticators with SQL Server encryption
Encryption	Where Does SQL Server Store Its Certificates
Functions System	Understanding and Using SQL Server sys.dm_exec_requests
Functions System	Understanding and Using sys.dm_exec_sessions in SQL Server
Import and Export	Export data to an earlier SQL Server version
Linked Servers	On demand creation and destruction of a SQL Server Linked Server
Linked Servers	On Demand Linked Server Creation with a SQL Server Login
Monitoring	SQL Server Forensics Analysis Based on Database Backup Size
Performance Tuning	Best-of-class SQL Server Performance Monitoring and Alerting
Policy Based Management	SQL Server Policy Management to Enforce Database Settings in Development
PowerShell	Parsing all the files in a directory using PowerShell
Profiler and Trace	Using the Default Trace in SQL Server
Reporting Services Dynamic Reports	Getting started with report filters in SQL Server Reporting Services
Restore	How to Automate SQL Server Restores for a Test Server
Restore	Recovering a SQL Server TDE Encrypted Database Successfully
Restore	Why Can't I Restore a Database to an Older Version of SQL Server?
Scripts	Script SQL Server Logins for Disaster Recovery
Security	Add a Salt with the SQL Server HASHBYTES Function
Security	Application Database Security Design - Part 1 - Authentication for SQL Server
Security	Application Database Security Design Part 2 - Multiple Levels of Access to SQL Server
Security	Auditing Critical Windows Files and Folders for SQL Server
Security	Automated way to get all port information for SQL Server instances
Security	Best Practices to Secure the SQL Server sa Account
Security	Blocking SQL Server db_datareader, db_datawriter, and db_owner Permissions
Security	Breaking ownership chaining within a schema in SQL Server
Security	Can I stop a System Admin from enabling SQL Server xp_cmdshell?
Security	Cannot make a role a member of itself error in SQL Server
Security	Database level permissions for SQL Server 2005 and 2008
Security	Determining Permission Issues for a SQL Server Object
Security	Dynamic SQL and Ownership Chaining in SQL Server
Security	Filtering Columns in SQL Server Using Views
Security	Filtering SQL Server Columns Using Column Level Permissions
Security	Get Back into SQL Server After You've Locked Yourself Out
Security	Grant limited permissions to create SQL Server views in another schema Part 1
Security	Grant limited permissions to create SQL Server views in another schema Part 2
Security	How come I can create SQL Server objects but not access these objects
Security	How to Clone a SQL Server Login, Part 1 of 3
Security	How to Clone a SQL Server Login, Part 2 of 3
Security	How to Clone a SQL Server Login, Part 3 of 3
Security	How to configure password enforcement options for standard SQL Server logins
Security	How to Connect to a SQL Server Named Instance
Security	How to Create Secure SQL Server Service Accounts
Security	How to Enable Secondary Decryption of SQL Server Symmetric Keys
Security	How to Setup Row Level Security for SQL Server
Security	How to Unlock a SQL Login Without Resetting the Password
Security	Identify Local Administrators on a SQL Server box using PowerShell
Security	Identifying the Tie Between Logins and Users
Security	Implementing SQL Server Security with Stored Procedures and Views
Security	Implicit Permissions Due to Ownership Chaining or Scopes in SQL Server
Security	Implicit Permissions Due to SQL Server Database Roles
Security	Is disabling xp_cmdshell in SQL Server really secure?
Security	Issues Determining an Individual SQL Server User's Permissions
Security	Migrate the Correct Logins with a SQL Server Database
Security	Nesting Database Roles in SQL Server
Security	Network communications mechanisms for SQL Server
Security	New Security Catalog Views in SQL Server 2005 and SQL 2008
Security	Ownership chaining in SQL Server security feature or security risk
Security	Potential Security Exploit Using CONTROL SERVER Permissions in SQL Server
Security	Practice of Using Privileged Accounts to Access SQL Server
Security	Protecting SQL Server from Ransomware
Security	Protecting the SQL Server Backup folder
Security	Quickly Find Failed SQL Server Logins Using the Windows Event Log
Security	Replace xp_cmdshell command line use with SQL Server Agent
Security	Retrieving SQL Server Fixed Database Roles for Disaster Recovery
Security	Retrieving SQL Server Permissions for Disaster Recovery
Security	Server level permissions for SQL Server 2005 and SQL Server 2008
Security	Skip-2.0 Malware Impacts SQL Server - Should I Be Worried?
Security	SQL Server nested securable permissions
Security	SQL Server Permissions Granted to All Users By Default
Security	SQL Server Security Community Questions on Windows, Server Level, Database, Roles and more
Security	SQL Server Static Data Masking with DataVeil
Security	The Power of the SQL Server Database Owner
Security	Unable to see a SQL Server table
Security	Understanding Cross Database Ownership Chaining in SQL Server
Security	Understanding GRANT, DENY, and REVOKE in SQL Server
Security	Understanding How A User Gets Database Access in SQL Server
Security	Understanding how SQL Server handles Service Isolation
Security	Understanding SQL Server fixed database roles
Security	Understanding SQL Server fixed server roles
Security	Understanding SQL Server Ownership Chaining
Security	Understanding the importance of key length with the SQL Server asymmetric encryption algorithms
Security	Understanding the SQL Server HASHBYTES hashing algorithms
Security	Understanding the SQL Server Symmetric Encryption Algorithms
Security	Understanding When SQL Server Kerberos Delegation is Needed
Security	Using nmap to scan for SQL Servers on a network
Security	Using PowerShell to Audit for Blank SA Passwords
Security	Using Views to Expose Encrypted Data in SQL Server
Security	Why Can't I Set a Default SQL Server Schema for My Windows Group Login?
Security	Why System Account is a bad idea for SQL Server Service Account
SQL Injection	Using Triggers to Mitigate Some SQL Injection Effects
SQL Server Agent	Auditing for New SQL Server Agent Jobs
SQL Server Agent	Configuring Critical SQL Server Alerts
SQL Server Agent	Script to find failed SQL Server Backups and validate re-running code was successful
SQL Server Agent	SQL Server Agent Job Email Notifications via PowerShell
SQL Server Agent	Suppressing SQL Server Alerts to Reduce Emails
SQL Server Agent	Understanding how SQL Server Agent Jobs can share schedules
SQL Server Configurations	Catalog SQL Server Services Installed on Servers
SQL Server Configurations	How to setup and use a SQL Server alias
SQL Server Configurations	How to setup security features for SQL Server
SQL Server Configurations	Understanding the SQL Server SELECT @@VERSION command
SQL Server Configurations	Using Friendly Names for SQL Servers via DNS
SQL Server Configurations	Why listing all of your SQL Servers does not always work
Surface Area Configuration Manager	SQL Server security settings using the Surface Area Configuration tool
Surface Area Configuration Manager	SQL Server Surface Area Configuration for Features Option Selection
Triggers	Connecting to SQL Server with a Bad Logon Trigger
Triggers	SQL Server 2005 SysAdmin Login Auditing
Triggers	Understanding SQL Server inserted and deleted tables for DML triggers
TSQL	Minimum Permissions for SQL Server TRUNCATE TABLE
Views	Why You Should Avoid SELECT * in SQL Server T-SQL Code
Virtualization	Viewing VMware Counters in PerfMon for SQL Server

No Records Found

Category	Topic
Application Development	Writing efficient code for SQL Server Based Applications
Auditing and Compliance	Preparing Your SQL Servers for an Audit
Auditing and Compliance	SQL Server Data Security and Compliance
Database Administration	What a DBA Needs to Know about SQL Server Administration
Database Design	Building Better Data Models
Database Design	Principles of Data Modeling
High Availability	WHOLE-ISTIC Protection of SQL Server in Azure
Log Shipping	SQL Server Disaster Recovery with Log Shipping
Performance Tuning	Why Are My SQL Server Queries So Slow?
Security	Building a Proper SQL Server Database Security Model
Security	How to Secure SQL Server - End to End Security

CategoryGroup	Category (articles)
Analysis Services	Analysis Services Administration (33)
Analysis Services	Analysis Services Development (95)
Analysis Services	Analysis Services Dimensions (16)
Analysis Services	Analysis Services Measure Groups (7)
Analysis Services	Analysis Services Performance (14)
Analysis Services	Analysis Services Security (7)
Analysis Services	Analysis Services Tutorials (6)
Business Intelligence	Artificial Intelligence (34)
Business Intelligence	Big Data (25)
Business Intelligence	Data Science (3)
Business Intelligence	Data Warehousing (8)
Business Intelligence	Import and Export (80)
Business Intelligence	R Language (11)
Business Intelligence	Snowflake (28)
Cloud	Amazon AWS (38)
Cloud	Amazon AWS RDS (22)
Cloud	Azure (154)
Cloud	Azure Backup and Restore (25)
Cloud	Azure Cosmos DB (15)
Cloud	Azure Functions (7)
Cloud	Azure SQL Database (52)
Cloud	Azure SQL Managed Instance (7)
Cloud	Cloud Strategy (31)
Cloud	Google Cloud (10)
Cloud Analytics	Apache Spark (13)
Cloud Analytics	Azure Data Factory (73)
Cloud Analytics	Azure Databricks (40)
Cloud Analytics	Azure Integration Services (14)
Cloud Analytics	Azure Synapse Analytics (43)
Cloud Analytics	Microsoft Fabric (36)
Data Quality	Data Cleansing for Validation (5)
Data Quality	Data Quality Services (10)
Data Quality	Master Data Services (41)
Database Administration	Central Management Servers (10)
Database Administration	Comparison Data and Objects (15)
Database Administration	Database Administration (213)
Database Administration	DBA Best Practices (39)
Database Administration	Dedicated Administrator Connection (4)
Database Administration	Scripts (35)
Database Administration	System Databases (31)
Database Configuration	Compression (22)
Database Configuration	Database Configurations (20)
Database Configuration	Database Mail (19)
Database Configuration	FILESTREAM (9)
Database Configuration	Full Text Search (21)
Database Configuration	In Memory OLTP (32)
Database Configuration	Linked Servers (18)
Database Configuration	Policy Based Management (29)
Database Configuration	Recovery Models (4)
Database Configuration	Resource Governor (5)
Database Configuration	SQL Server Configurations (75)
Database Design	Constraints (20)
Database Design	Data Types (22)
Database Design	Database Design (95)
Database Design	Identities (17)
Database Design	JOIN Tables (23)
Database Design	Synonyms (5)
Database Design	Table Valued Parameters (4)
Database Design	Temp Tables (16)
Database Design	Temporal Tables (13)
Database Design	User Defined Type UDT (3)
Database Design	Views (17)
Database Development	Application Development (53)
Database Development	Common Runtime Language (13)
Database Development	Debugging (4)
Database Development	DevOps (40)
Database Development	Entity Framework (13)
Database Development	Language Integrated Query LINQ (7)
Database Development	Paging (5)
Database Development	Referential Integrity (5)
Database Development	Service Broker (11)
Database Development	Testing (32)
Database Development	XML (15)
Database Maintenance	Database Console Commands DBCCs (25)
Database Maintenance	Fragmentation and Index Maintenance (28)
Database Maintenance	Maintenance (34)
Disaster Recovery / High Availability	Availability Groups (81)
Disaster Recovery / High Availability	Backup (81)
Disaster Recovery / High Availability	Clustering (77)
Disaster Recovery / High Availability	Database Mirroring (33)
Disaster Recovery / High Availability	Disaster Recovery (23)
Disaster Recovery / High Availability	High Availability (3)
Disaster Recovery / High Availability	Log Shipping (18)
Disaster Recovery / High Availability	Replication (78)
Disaster Recovery / High Availability	Restore (42)
Functions	Dates (56)
Functions	Functions System (99)
Functions	Functions User Defined UDF (41)
Infrastructure	Contained Databases (4)
Infrastructure	Containers (13)
Infrastructure	Hardware (13)
Infrastructure	Spatial Data Storage (9)
Infrastructure	Virtualization (25)
Integration Services Admin	Integration Services Administration (10)
Integration Services Admin	Integration Services Best Practices (12)
Integration Services Admin	Integration Services Configuration Options (22)
Integration Services Admin	Integration Services Performance (12)
Integration Services Admin	Integration Services Security (7)
Integration Services Admin	Integration Services Upgrade (4)
Integration Services Development	Data Transformation Services (6)
Integration Services Development	Integration Services Analysis Services Tasks (5)
Integration Services Development	Integration Services Connection Managers (5)
Integration Services Development	Integration Services Control Flow Transformations (14)
Integration Services Development	Integration Services Data Flow Transformations (19)
Integration Services Development	Integration Services Development (118)
Integration Services Development	Integration Services Error Handling (8)
Integration Services Development	Integration Services Excel (14)
Integration Services Development	Integration Services Execute Package Options (8)
Integration Services Development	Integration Services Oracle (4)
Microsoft Office	Microsoft Access Integration (8)
Microsoft Office	Microsoft Excel Integration (46)
Microsoft Office	Microsoft Flow (1)
Other RDBMS	Other Database Platforms (16)
Other RDBMS	PostgreSQL (16)
Other RDBMS	SQL Server and Oracle Comparison (30)
Other RDBMS	SQL Server on Linux (78)
Other RDBMS	SQL Server vs Oracle vs PostgreSQL Comparison (20)
Performance	Dynamic Management Views and Functions (34)
Performance	Error Logs (12)
Performance	Extended Events (22)
Performance	Indexing (97)
Performance	Locking and Blocking (44)
Performance	Monitoring (110)
Performance	Partitioning (17)
Performance	Performance Data Warehouse (4)
Performance	Performance Tuning (129)
Performance	Profiler and Trace (20)
Performance	Query Optimization (15)
Performance	Query Plans (20)
Performance	Query Store (9)
Power Platform	Power Apps (20)
Power Platform	Power BI (180)
Power Platform	Power BI Charts (59)
Power Platform	Power BI Formatting (17)
Professional Development	Professional Development Branding (16)
Professional Development	Professional Development Career (18)
Professional Development	Professional Development Career Planning (21)
Professional Development	Professional Development Certifications (64)
Professional Development	Professional Development Community (16)
Professional Development	Professional Development Interview Questions BI (18)
Professional Development	Professional Development Interview Questions DBA (23)
Professional Development	Professional Development Interview Questions Developer (9)
Professional Development	Professional Development Interviewing (40)
Professional Development	Professional Development Job Search (24)
Professional Development	Professional Development Management (14)
Professional Development	Professional Development Resume (13)
Professional Development	Professional Development Skills Development (18)
Python	Python (99)
Reporting Services Admin	Reporting Services Administration (21)
Reporting Services Admin	Reporting Services Best Practices (6)
Reporting Services Admin	Reporting Services Configuration (10)
Reporting Services Admin	Reporting Services Installation (10)
Reporting Services Admin	Reporting Services Migration (5)
Reporting Services Admin	Reporting Services Monitoring (5)
Reporting Services Admin	Reporting Services Network Load Balancing (4)
Reporting Services Admin	Reporting Services Performance (6)
Reporting Services Admin	Reporting Services Security (9)
Reporting Services Development	Reporting Services Analysis Services (4)
Reporting Services Development	Reporting Services Charts (25)
Reporting Services Development	Reporting Services Data Sources (10)
Reporting Services Development	Reporting Services Development (68)
Reporting Services Development	Reporting Services Dynamic Reports (11)
Reporting Services Development	Reporting Services Formatting (26)
Reporting Services Development	Reporting Services KPI (5)
Reporting Services Development	Reporting Services Overview (6)
Reporting Services Development	Reporting Services Parameters (15)
Reporting Services Development	Reporting Services Report Builder (9)
Security	Auditing and Compliance (48)
Security	Encryption (35)
Security	Security (201)
Security	SQL Injection (5)
Security	Surface Area Configuration Manager (4)
SharePoint	SharePoint (131)
SharePoint	SharePoint Administration (45)
SharePoint	SharePoint Configuration (27)
SharePoint	Sharepoint Design (46)
SharePoint	SharePoint Document Management (20)
SQL Coding	Change Data Capture (16)
SQL Coding	Common Table Expressions (5)
SQL Coding	Dynamic SQL (7)
SQL Coding	Error Handling (13)
SQL Coding	Stored Procedures (32)
SQL Coding	Transactions (10)
SQL Coding	Triggers (44)
SQL Coding	TSQL (355)
Tools	Azure Data Studio (18)
Tools	PowerShell (131)
Tools	SQL Operations Studio (11)
Tools	SQL Server Agent (96)
Tools	SQL Server Management Objects SMO (3)
Tools	SQL Server Management Studio (79)
Tools	SQL Server Management Studio Configuration (22)
Tools	SQL Server Management Studio Shortcuts (10)
Tools	Tools (35)
Versions	Deprecated Features (6)
Versions	Express Edition (16)
Versions	Install and Uninstall (33)
Versions	Licensing (4)
Versions	SQL Server 2016 (96)
Versions	SQL Server 2017 (44)
Versions	SQL Server 2019 (20)
Versions	SQL Server 2022 (21)
Versions	Upgrades and Migrations (54)