SQLServerCentral / Discuss Content Posted by Brian Kelley / Article Discussions / Article Discussions by Author

Configuring Kerberos Authentication

K. Brian Kelley — Wed, 10 Dec 2008 23:16:52 GMT

Comments posted to this topic are about the item [B]Configuring Kerberos Authentication[/B]

Using the Service Audit Object in SQL Server 2008

K. Brian Kelley — Thu, 18 Dec 2008 01:23:17 GMT

Comments posted to this topic are about the item [B]Using the Service Audit Object in SQL Server 2008[/B]

Blocking Users by IP

K. Brian Kelley — Mon, 09 Mar 2009 00:07:04 GMT

Comments posted to this topic are about the item [B]Blocking Users by IP[/B]

Implementing Encrypting File System (EFS) with SQL Server

K. Brian Kelley — Sat, 07 Dec 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/implementing_efs.asp

SQL Server 2005 Logins

K. Brian Kelley — Thu, 22 Jun 2006 13:48:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/sqlserver2005logins.asp

Restricting SecurityAdmin on SQL Server 2005/2008

K. Brian Kelley — Wed, 01 Sep 2010 20:10:35 GMT

Comments posted to this topic are about the item [B]Restricting SecurityAdmin on SQL Server 2005/2008[/B]

SQL Server Security: Security Admins

K. Brian Kelley — Fri, 13 Jun 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritysecurityadmins.asp

Should DBAs have local administrator rights?

K. Brian Kelley — Fri, 29 Jan 2010 19:29:16 GMT

Comments posted to this topic are about the item [B]Should DBAs have local administrator rights?[/B]

Sql sever 2005-Database Users

Damodaram KS — Tue, 05 Jan 2010 02:24:20 GMT

Required information about how to create a database user with the restricted permissions.The user has to Perform only DML commands and he should be restricted from the other all operations on the database.

Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express

K. Brian Kelley — Wed, 21 Oct 2009 00:28:13 GMT

Comments posted to this topic are about the item [B]Enabling the Dedicated Administrator Connection (DAC) in SQL Server Express[/B]

SQL Server Security: The db_executor Role

K. Brian Kelley — Sat, 10 May 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/sqlserversecuritythedb_executorrole.asp

Windows Logon vs SQL Server 'SA' Logon

waynejps1 — Tue, 23 Jun 2009 14:03:29 GMT

How can I eliminate SQL SERVER 2005 from authenticating users through WINDOWS LOGON and simply use SQL SERVER 'SA' username and password or other such defined users?

SQL Response Review - New SQL Server Monitoring Tool

K. Brian Kelley — Tue, 07 Oct 2008 20:42:32 GMT

Comments posted to this topic are about the item [B]SQL Response Review - New SQL Server Monitoring Tool[/B]

SQL Server Security: Fixed Database Roles

K. Brian Kelley — Fri, 05 Dec 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/sqlserversecurityfixeddatabaseroles.asp

Does DB_DataWriter intrinsically have all the permissions of DB_DataReader?

kamoskim — Tue, 02 Jun 2009 05:59:00 GMT

If one wants a user to have both "select access to all user tables and views" and "insert, update, delete access to all user tables and views", then must one put the user into both the DB_DataReader and the DB_DataWriter roles? Or, does DB_DataWriter intrinsically have all permissions that DB_DataReader has? Or, what?

how to check the authentication method in SQL 2000 server

Edward Sun — Mon, 23 Feb 2009 23:52:17 GMT

Great article Brian. I have a question. The following query you presented only works in SQL2005 server. I have several SQL2000 server installations in my shop. How can I check the authentication method in SQL2000 server then? Thanks.SELECT s.session_id , c.connect_time , s.login_time , s.login_name , c.protocol_type , c.auth_scheme , s.HOST_NAME , s.program_name FROM sys.dm_exec_sessions s JOIN sys.dm_exec_connections c ON s.session_id = c.session_id

You Must Trust Someone

K. Brian Kelley — Sat, 21 Feb 2009 13:10:18 GMT

Comments posted to this topic are about the item [B]You Must Trust Someone[/B]

Another Reason to Avoid Cross-Database Ownership Chaining

K. Brian Kelley — Wed, 18 Feb 2009 07:23:44 GMT

Comments posted to this topic are about the item [B]Another Reason to Avoid Cross-Database Ownership Chaining[/B]

Kerberos on SQL Server 2k Cluster

Chris L. Otte-459380 — Thu, 11 Dec 2008 09:02:49 GMT

Are there any special considerations for enabling Kerberos on SQL Server 2k Clusters or SQL Server Cluster in general?Also, what would be the ramifications of removing named pipes? Sounds like this is a security gap and not a good practice...Thanks,Noobcakes!

Getting the Most Out of SQL Server 2000's Query Analyzer, Part II

K. Brian Kelley — Sun, 03 Mar 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/qa2k_2_1.asp

SQL Server Security: Pros and Cons of Application Roles

K. Brian Kelley — Sun, 24 Aug 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/sqlserversecurityprosandconsofapplicationroles.asp

Getting the Most Out of SQL Server 2000's Query Analyzer, Part III

K. Brian Kelley — Wed, 17 Jul 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/qa2k_3_1.asp

how to insert xml file into sql server 2006 database structure using visual c#

Raymond-710502 — Mon, 14 Apr 2008 04:00:54 GMT

i need help : i want to insert xml file into sql server2005 database table using c# such that i can access the file from c# console application

Triggers in SQL Server 7.0 and 2000 - The Common Ground

K. Brian Kelley — Sun, 29 Jul 2001 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/triggers_1.asp

Database Role in SQL 2005

Kash — Mon, 25 Feb 2008 14:46:32 GMT

Hi there,I have a developer database role that needs to be included in db_ddladmin fixed db role. This used to be a lot simple in 2000. I can't seem to figure it out in 2005. Any help would be much appreciated!.Kash:)

Getting the Most out of SQL Server 2000's Query Analyzer, Part I

K. Brian Kelley — Fri, 15 Feb 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/qa2k_1.asp

Creadentials insql server 2005

varun-jha — Mon, 22 Oct 2007 03:06:55 GMT

hey any one tell me how to use credentials in sql server 2005.plz. provide help with graphics if posible.tell me the conditions and other requirement to use credential....

how to connect sqlserver2005 from one xp system to another xp system

isqdotnet — Sun, 21 Oct 2007 05:03:00 GMT

how to connect sqlserver2005 from one xp system to another xp system

Report Locking on Specific Database

K. Brian Kelley — Sun, 23 Sep 2007 02:27:25 GMT

Comments posted to this topic are about the item [B]Report Locking on Specific Database[/B]

SQL Server Security: Fixed Roles

K. Brian Kelley — Sat, 18 Oct 2003 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/sqlserversecurityfixedroles.asp

Auditing with SQL Profiler

K. Brian Kelley — Wed, 04 Aug 2004 14:14:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/

Citrix MetaFrame, SQL Server, and the DBA

K. Brian Kelley — Sat, 11 May 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/citrix_metaframe.asp

A Review of Typhon III

K. Brian Kelley — Wed, 24 Jan 2007 17:31:00 GMT

Comments posted here are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/2827.asp

Connecting With Perl Using Win32 : ODBC

K. Brian Kelley — Sat, 30 Nov 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/connectingtosqlserverusingperlwin32odbc.asp

Services for SQL Server 2000

K. Brian Kelley — Sun, 30 Dec 2001 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/services.asp

PromptSQL

K. Brian Kelley — Mon, 02 Jan 2006 17:43:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/promptsql.asp

P Review

K. Brian Kelley — Mon, 02 Jan 2006 17:52:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/preview.asp

Stored Procedures and Caching

K. Brian Kelley — Sun, 27 Jan 2002 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/procedurecache.asp

Triggers in SQL Server 7.0 and 2000 - What's New

K. Brian Kelley — Sun, 02 Sep 2001 00:00:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/triggersinsqlserver7.0and2000-what'snew.asp

Securing SQL Backups

K. Brian Kelley — Tue, 08 Mar 2005 22:40:00 GMT

Comments posted to this topic are about the content posted at http://www.sqlservercentral.com/columnists/bkelley/securingsqlbackups.asp