SQL Server Magazine

Accessing SQL Server Data from PowerShell, Part 2

Because PowerShell is integrated with the.NET framework, you can leverage the .NET object model within PowerShell scripts and build ADO.NET objects that retrieve SQL Server data; learn how to use ADO.NET to insert, update, and delete SQL Server data.

Accessing SQL Server Data from PowerShell, Part 1

Learn how to use ADO.NET to retrieve SQL Server data through PowerShell scripts.

Integrate MySQL and SQL Server

Need to retrieve MySQL data and insert it into a SQL Server database? SQL Server Integration Services and MySQL connectors let you do so fairly easily.

Data Manipulation with ADO

ActiveX Data Objects (ADO) let you access, filter, sort, and retrieve data from Microsoft SQL Server and Microsoft Access databases using VBScript and other scripting languages. Here are some of the most common uses of ADO for databases.

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