SQL Server Magazine

Enabling Vista's Hibernation

Accessing SQL Server Data from PowerShell, Part 1

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

Dev Connections 2008: DotNetNuke

Joe Brinkman discusses the genesis and mission of DotNetNuke, an open source platform for creating websites built on the Microsoft .NET stack.

Dev Connections 2008: The Greening of SQL Server

Kathy Malone discusses the broad meaning of going green. It's not just virtualization or cloud computing, it includes all efficient uses of resources--people and machines.

Developer Tool Offers to Increase Productivity and Improve Code Quality

SoftTree Technologies' SQL programming productivity tool, SQL Assistant 4.0, is now available and offers many new features, including SQL IntelliSense+ features.

Moving from Command Shell scripting to PowerShell

Dev Connections 2008: Silverlight and SQL Server

Brian Goldfarb of the Microsoft Developer Platform team discusses the many uses of Silverlight, including as a front end for SQL Server.

Dev Connections: ASP.NET Chart Control Announced

Scott Guthrie, corporate vice president .NET Developer Platform at Microsoft, announced the out-of-band release of ASP.NET Chart Control for Microsoft .NET Framework 3.5.

Dev Connections: SQL Server 2008--What's in it for You?

This keynote outlines how SQL Server 2008 and Visual Studio Team System 2008 Database Edition GDR RC 1 give developers a comprehensive platform for building applications that manage data.

PDC 2008 News From Embarcadero

At the Microsoft PDC, Embarcadero Technologies (www.embarcadero.com) previewed Delphi Prism, which the company describes as "a next-generation .NET development solution."

Author Chat with Itzik Ben-Gan, Andrew Kelly, and Michael Otey

SQL Server Magazine invites you to participate in a live chat with SQL Server Magazine authors Itzik Ben-Gan, Andrew Kelly, and Michael Otey on Friday, November 7th, at 7:00pm EST/6:00pm CST.

Browser Wars Redux

The Google Chrome browser presents a challenge both Microsoft Internet Explorer (IE) and to SQL Server web application development.

Calculate Percentiles

Use T-SQL to implement statistical calculations such as percentile and percentile rank.

Efficient Data Binding with Windows Presentation Foundation and Visual Studio 2008

A free tool helps you use Visual Studio 2008 to automate wiring your SQL Server data with a Windows Presentation Foundation (WPF) front end.

LINQPad

This free LINQPad tool lets you interactively query SQL Server using LINQ.

Modify Words (and Not Strings) in Tables

Need to change the word "Bikes" to "Trucks" without modifying "SuperBikes" to "SuperTrucks" or perform another word-replacement operation? This user-defined function (UDF) will do the trick.

Modify Words (and Not Strings) in Tables

Quickly Find Your Worst-Performing T-SQL Statements

Here's a stored procedure that lets you quickly and easily produce customized reports showing the poorest-performing T-SQL statements that were run against your SQL Server 2008 and SQL Server 2005 databases.

RowGen 2.0

Use RowGen 2.0 to create referentially valid but random sample data that you can use in your test environment.

Three-In-One Database Maintenance Solution

MaintenanceSolution.sql lets you easily back up databases, check their integrity, and optimize indexes. This script is set up so that you can perform each task independently on the databases you specify.