---

[Features]

---

Calculate Percentiles
Use T-SQL to implement statistical calculations such as percentile and percentile rank.
 — Itzik Ben-Gan


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.
 — Ken Spencer


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.
 — Robert Sheldon

---

[Editorial]

---

Browser Wars Redux
The Google Chrome browser presents a challenge both Microsoft Internet Explorer (IE) and to SQL Server web application development.
 — Michael Otey

---

[Reader to Reader]

---

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.
 — Christian Mercure


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.
 — Greg A. Larsen


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.
 — Ola Hallengren


Track Database Disk-Space Usage on a Granular Level
The SpaceUsedAnalyzer stored procedure provides detailed information on how much space is being used by tables and their indexes so that you can manage disk space more efficiently.
 — Shaunt Khaldtiance

---

[New Products]

---

dbWatch Version 8.1
If you want affordable, basic database-monitoring capabilities, the dbWatch 8.1 tool will meet your needs.
 — John Green

New Products
Check out new and improved SQL Server–related products from Embarcadero, Sybase, Tableau Software, and Microsoft.
 — Editors

---

[SELECT TOP(X)]

---

SQL Server 2008 Editions
SQL Server 2008 editions come in many flavors, from Enterprise to Web to Workgroup and beyond. Get the lowdown on features, support, and how much each will impact your budget.
 — Michael Otey

---

[Tool Time with Kevin Kline]

---

SQLScripter
Use SQLScripter to automate database schema scripting tasks.
 — Kevin Kline

---

[Review]

---

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

---

[SQL Server Product Review]

---

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

---

[PTO for the Rest of Us]

---

Finding Your Top 10 SQL Server Queries
Need to parse server-side trace information so that you can aggregate the data to find your worst-performing and most-called queries? The user-defined SQL_Signature function should do the trick.
 — Andrew J. Kelly

---

[Sqlmag.com Community Dialog]

---

The Wisdom of SQL Mag Readers
SQL Server Magazine readers are sharing their expertise and helping their peers in the comments section on online articles.
 — Anne Grubb