MSSQLTips Author Profile - K. Brian Kelley


Today's Site Sponsor

	SQL Compare quickly and easily compares and synchronizes SQL Server database schemas

Today's Tip Tips By Category Latest Tips Top 10 Tips Suggest a Tip Search By Tip ID

Tools Tutorials Webcasts Whitepapers Blogs Forums Forums - Active Forums - Unanswered RSS Feeds

Join MSSQLTips Authors Contribute Giveaways Feedback User Groups Follow us on Twitter Follow us on LinkedIn

About Us Advertise Copyright Disclaimer Feedback Privacy Statement

Search By Tip ID Search By Category

Author - K. Brian Kelley

Brian is a SQL Server author and columnist focusing primarily on SQL Server security. He is a contributing author for How to Cheat at Securing SQL Server 2005 (Syngress) and Professional SQL Server 2008 Administration (Wrox). Brian currently serves as a systems and security architect for AgFirst Farm Credit Bank where he works on Active Directory, Windows security, VMware, Citrix, and of course, SQL Server. In the technical community, Brian is part of the Midlands PASS Chapter, an official chapter of PASS, where he currently serves as president and director of communications. Brian is also a junior high youth minister at Spears Creek Baptist Church in Elgin, SC.

Auditing and Compliance

SQL Server Security Auditing to Match Logins And Users (8/13/2010)

Clustering

Understanding why there is still downtime for SQL Server with Microsoft Clustering (11/17/2009)

Database Administration

How to move a SQL Server database within the same instance without losing settings (2/16/2009)

DDL Trigger

Connecting to SQL Server with a Bad Logon Trigger (11/20/2008)
SQL Server 2005 SysAdmin Login Auditing (11/14/2008)

Encryption

SQL Server Encryption Symmetric vs. Asymmetric Keys (11/23/2009)
Using authenticators with SQL Server encryption (5/27/2009)

Linked Servers

On demand creation and destruction of a SQL Server Linked Server (9/25/2009)
On Demand Linked Server Creation with a SQL Server Login (10/14/2009)

Policy Based Management

Using SQL Server Policy Management to Enforce Database Settings in Development (7/15/2010)

Profiler / Trace

Using the Default Trace in SQL Server 2005 and SQL Server 2008 (4/28/2009)

Reporting Services

Getting started with report filters in SQL Server Reporting Services (SSRS) (12/23/2009)

Security

Auditing Failed Logins in SQL Server (4/22/2009)
Auditing SQL Server Permissions and Roles (6/29/2010)
Automate collection and saving of failed logins for SQL Server (5/13/2009)
Breaking ownership chaining within a schema in SQL Server (8/11/2009)
Cannot make a role a member of itself error in SQL Server (8/30/2010)
Database level permissions for SQL Server 2005 and 2008 (3/30/2009)
Dynamic SQL and Ownership Chaining in SQL Server (8/24/2009)
Granting limited permissions to create views in another schema in SQL Server (7/20/2009)
Granting limited permissions to create views in another schema in SQL Server - Part 2 (7/27/2009)
How to configure password enforcement options for standard SQL Server logins (12/28/2009)
Nesting Database Roles in SQL Server (4/7/2010)
New Security Catalog Views in SQL Server 2005/2008 (12/24/2008)
Ownership chaining in SQL Server security feature or security risk (6/23/2009)
Replace xp_cmdshell command line use with SQL Server Agent (5/19/2010)
Server level permissions for SQL Server 2005 and SQL Server 2008 (3/24/2009)
SQL Server nested securable permissions (4/13/2010)
Tables and Views for Auditing SQL Server Logins (5/24/2010)
Understanding Cross Database Ownership Chaining in SQL Server (6/29/2009)
Understanding How A User Gets Database Access in SQL Server (6/14/2010)
Understanding SQL Server fixed database roles (12/14/2009)
Understanding SQL Server fixed server roles (11/24/2009)

SQL Server 2008

Auditing SELECT statements in SQL Server 2008 (12/18/2008)

SQL Server Configurations

How to setup and use a SQL Server alias (11/5/2008)
How to setup security features for SQL Server (1/15/2009)
Why listing all of your SQL Servers doesn't always work (7/9/2010)

Surface Area Configuration Manager

Sponsor Information

Free SQL Server performance monitoring dashboard – Idera SQL check

Try Red Gate SQL Backup Pro for smaller, more robust SQL Server backups. Download a free trial now!

You don't know, what you don't know about SQL Server... Customized Consulting and Training

Interested in SharePoint? Love the tips? Check this out...

Valuable SQL Server web casts on Performance Tuning, Development, Administration, Disaster Recovery, Replication and more...

Idera - SQL defrag manager

SQL defrag manager is a one-of-a-kind solution that automates the time-consuming process of finding and fixing database index fragmentation issues across multiple SQL Servers. SQL defrag manager improves server performance by analyzing database index fragmentation levels, pinpointing fragmentation “hot spots” and taking action to defragment automatically, or at your command.

Download now!

More SQL Server Tools

SQL comparison toolset

SQL secure

SQL defrag manager

SQL safe backup

SQL Prompt