October 2007
The prerequisite for an efficient, high-performance database is a database design. Using one of these nine design tools will make you more productive and the resulting database more efficient.
SQL Server Magazine
August 17, 2007
When shopping for a third-party Microsoft SQL Server database design tool, you need to understand the terminology vendors use. These definitions of 9 basic terms will get you started.
SQL Server Magazine
August 3, 2007
If you generate dates in VBScript or T-SQL code, check out two articles. One discusses how to generate ISO 8601-formatted dates in VBScript code. The other discusses how to use a custom function in T-SQL code to generate dates in the desired format.
Windows IT Pro
August 7, 2006
Here are some resources that you can use to learn how to write JScript, Perl, and T-SQL code.
Windows IT Pro
April 6, 2006
Windows Scripting Solutions' "Snippets to Go" and "Reader to Reader" columns are popular, so we want to devote more pages to them. Here's how you can help make these columns bigger and better.
Windows IT Pro
March 6, 2006
If your job includes wearing the DBA hat, you'll probably be interested in the first winner of the "Mighty Mini" contest. The winning script queries a table on a local or remote database server and displays that table's contents in a browser.
Windows IT Pro
Add these Headlines to your Website