SQL Server 2005's EXECUTE AS statement

In SQL Server 2005, you can explicitly or implicitly define the execution context. As we all know, a session starts when a user logs on to SQLServer or a connection to SQLserver is made. All operations in that session use the logon credentials used for connecting to SQL Server. When an EXECUTE AS statement is run, the execution context of the session is switched to the specified login or user name.

SQL Server 2005 Upgrade Advisor

Have you started looking at what issues you might have migrating your existing applications to SQL Server 2005? If not then maybe as a first step, you should consider looking into what the SQL Server 2005 Upgrade Advisor can do for you. This article will discuss what the Upgrade Advisor is and how to use it.

You want to disable the trigger dEmployee on...

A .NET assembly running with UNSAFE permissions can...

What level of permissions does a user need...

Which optional SQL Server component must you install...

Implementing Data Security in a Report Model

The report models introduced in SQL Server 2005 feature a number of ways to customize the data visible to different users and groups: perspectives, model item security, security filters, and opaque expressions. This article describes when and how to use each of these features.

You are delegating permissions on your SQL Server...

You have a SQL Server 2005 cluster and...

Picking Service Accounts

It is something you do rarely, but with SQL Server 2005 and ten services, there are more decisions to make. Steve Jones gives some advice on which service accounts to choose and some common problems with others.