SQL Server Magazine

Accessing Database Data with ADO

PowerShell Makes Security Log Access Easy

Security event logs contain valuable information about attempted system assaults and account and Group Policy modifications. PowerShell gets you access to the security logs and allows you to shape the data to match your needs.

Scripting Data Flow in SQL Server Integration Services

Use the Script component to create a custom script that extends your SSIS package.

Scripting Control Flow in SQL Server Integration Services

When SSIS’s predefined tasks aren’t enough, use the Script task’s rich environment to create custom code within the control flow of an SSIS package.

Rem, August 2006

This month, Rem answers a question about the various ways to build T-SQL statements in SQL Server 2005 and Visual Studio 2005.

Creating T-SQL Statements in SQL Server 2005 and Visual Studio 2005

SQL Server 2005 and Visual Studio 2005 provide query-building interfaces for creating, editing, and testing T-SQL statements that access data in a SQL Server database.

Enabling .NET on SQL Server

Use this code to enable .NET on SQL Server.

Using XQuery Expressions to Create Computed Columns

To create a computed column in SQL Server 2005, you can use an XQuery expression, but you must invoke an XML data type method. However, SQL Server doesn’t allow XML methods in computed-column definitions. Here’s how to get around this conundrum.

Logging DDL Events

The simplest way to log DDL events is to take advantage of the new DDL trigger feature in SQL Server 2005. You can create triggers that fire when specified DDL events occur, such as modifying column definitions or dropping login accounts.

Rem

This month, Rem answers questions about the simplest way to log DDL events in SQL Server 2005 and what improvements Microsoft made to ASP.NET client-side scripting with the release of Windows .NET Framework 2.0.

New SQL Server 2005 Functions Rank High

Get a quick tutorial for using the ROW_NUMBER, RANK, DENSE_RANK, and NTILE ranking functions.

Rem