The Smart Guide to Building World-Class Applications
Browse By: Author | Issue
Discover real-world solutions for maintaining databases, modifying words in tables, finding the worst-performing T-SQL statements, and determining how much space is being used by tables and their indexes.
By William Sheldon
Use RowGen 2.0 to create referentially valid but random sample data that you can use in your test environment.
By Dan Hanan
This free LINQPad tool lets you interactively query SQL Server using LINQ.
By Robert Sheldon
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 Anne Grubb
SQL Server Magazine readers are sharing their expertise and helping their peers in the comments section on online articles.
By Greg A. Larsen
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 Andrew J. Kelly
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 Itzik Ben-Gan
Use T-SQL to implement statistical calculations such as percentile and percentile rank.
By Michael Otey
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
Check out new and improved SQL Server–related products from Embarcadero, Sybase, Tableau Software, and Microsoft.
The Google Chrome browser presents a challenge both Microsoft Internet Explorer (IE) and to SQL Server web application development.
By John Green
If you want affordable, basic database-monitoring capabilities, the dbWatch 8.1 tool will meet your needs.
By Ken Spencer
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 Kevin Kline
Use SQLScripter to automate database schema scripting tasks.
To turn around a failing project try building more automation into the development process
By Ola Hallengren
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 Shaunt Khaldtiance
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 Christian Mercure
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.
advertisement