SQL Server Magazine November 2008
[Features]
Use T-SQL to implement statistical calculations such as percentile and percentile rank.
By Itzik Ben-Gan
A free tool helps you use Visual Studio 2008 to automate wiring your SQL Server data with a Windows Presentation Foundation (WPF) front end.
By Ken Spencer
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.
By Robert Sheldon
[Editorial]
The Google Chrome browser presents a challenge both Microsoft Internet Explorer (IE) and to SQL Server web application development.
By Michael Otey
[Reader to Reader]
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.
By Christian Mercure
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.
By Greg A. Larsen
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.
By Ola Hallengren
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.
By Shaunt Khaldtiance
[New Products]
If you want affordable, basic database-monitoring capabilities, the dbWatch 8.1 tool will meet your needs.
By John Green
Check out new and improved SQL Server–related products from Embarcadero, Sybase, Tableau Software, and Microsoft.
By Editors
[SELECT TOP(X)]
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.
By Michael Otey
[Tool Time with Kevin Kline]
Use SQLScripter to automate database schema scripting tasks.
By Kevin Kline
[Review]
Use RowGen 2.0 to create referentially valid but random sample data that you can use in your test environment.
By William Sheldon
[SQL Server Product Review]
This free LINQPad tool lets you interactively query SQL Server using LINQ.
By Dan Hanan
[PTO for the Rest of Us]
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.
By Andrew J. Kelly
[Sqlmag.com Community Dialog]
SQL Server Magazine readers are sharing their expertise and helping their peers in the comments section on online articles.
By Anne Grubb
|
