Articles

Throughout our series of articles dedicated to SQL Server 2005 Integration Services, we have been working mainly with packages using the Business Intelligence Development Studio interface (although more recently, we also discussed SSIS-related functionality available in SQL Server Management Studio). Even though, as part of our exercises, we have worked with a number of packages, we have not yet explored the various options related to their storage. We will cover them in this article

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-04-18

2,787 reads

Discuss

SQL Server 2005 Logon Triggers

by Frederik Vandeputte

SQLServerCentral.com

SQL Server Central

One thing that many people tried to implement in SQL Server 2000 is the auditing of logins. However getting this to work was a complex process. In SQL Server 2005, however, there are a few ways you can handle this and new author Frederik Vandeputte brings us a method using Service Broker for handling this.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(14)

You rated this post out of 5. Change rating

2006-04-17

25,534 reads

Discuss

SQL Server 2005's EXECUTE AS statement

by Additional Articles

SQLServerCentral

Administration

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.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-04-17

2,799 reads

Discuss

Beginning SQL Server - Limit Your Queries

by Steve Jones

SQLServerCentral.com

Administration

Part 2 of Steve Jones' series on beginning SQL Server from the perspective of a system administrator or someone not used to working with SQL Server. If you've been designated the new administrator, take a look at this series for some help in coming up to speed on this product.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

You rated this post out of 5. Change rating

2006-04-14 (first published: 2004-08-19)

36,239 reads

Discuss

SQL Server 2005 Upgrade Advisor

by Additional Articles

SQLServerCentral

Administration

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 rated this post out of 5. Change rating

2006-04-14

2,172 reads

Discuss

Stored procedure: Determine last database backup

by Additional Articles

Other

Backup and restore

You have many SQL Servers to administer and you just want to know when the last backup was taken for each database on each instance. This stored procedure will help.

2006-04-13

4,271 reads

Discuss

Generating a Range

by David Poole

SQLServerCentral.com

Advanced Querying

What is the most efficient way of generating a range of values? SQL Server guru David Poole takes a look at a few different methods, both procedural and set based, and gives you some performance results.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(2)

You rated this post out of 5. Change rating

2006-04-12

10,531 reads

Discuss

Keep Bad Guys at Bay with the Advanced Security Features in SQL Server

by Additional Articles

SQLServerCentral

Security

Learn about SQL Server security techniques including the principle of least privilege, controlling metadata visibility, separation of users and schemas, and more.