SQL Server Magazine

Restoring Files by Using SharePoint Content Databases

Check out these SharePoint file-restore approaches that use the SharePoint content databases within Microsoft SQL Server.

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.

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

Home-Brewed Hardware Inventory

Use this two-pronged solution to create rich, verbose hardware inventory reports.

How the Inventory Agent Works

Get information about how HrdWrInv.vbs collects hardware inventory data.

How the Report Agent Works

Get information about how BuildReport.vbs creates an inventory report.