Configuring Kerberos Authentication

Longtime author Brian Kelley brings us a new article on security and Kerberos authentication in SQL Server.

Database Security

Security

Connecting to SQL Server with a Bad Logon Trigger

One of the things you need to aware of is that if you create a logon trigger and there is some bad code you are going to prevent everyone from logging into your SQL Server, even if you try as "sa" or a member of the sysadmin fixed server role. How do I log on to my SQL Server to fix this trigger?

How to Change all Table owner one in to another in sql server 2000?

we need change all user table db owners For selected database using T SQL we can easily use this method.

Reviewing SQL Server Permissions

Permissions on data are one of the most critical aspects of database administration.

Configuring Certificate-based Authentication in SQL Server Express' Distributed Service Broker Environment

Implementing a dialog between two services residing in a distributed environment requires the presence of an authentication mechanism. Windows-based Kerberos protocol limits the scope of systems participating in a Service Broker dialog to those residing in the same or trusted Active Directory domains. This article provides an overview of how to eliminate this limitation by employing certificates.

Encryption Alternatives

Databases often contain sensitive information and cell-level encryption is a very effective method to protect this information from those who should not have access to it. Although, encryption is not without its challenges.

Granting View Definition Permission to a User or Role

Instead of granting higher level permissions, is there a way to allow users that only have public access the ability to see object definitions?

Understanding and dealing with orphaned users in a SQL Server database

Attaching and restoring databases from one server instance to another are common tasks executed by a DBA. After attaching or restoring of a database, previously created and configured logins in that database do not provide access. This tip looks at how to deal with this.