Building Business Intelligence Data Warehouses

• by Tom Osoba

• SQLServerCentral.com

• Miscellaneous

New author! Tom publishes his first article with us by writing about how business intelligence and data warehouses work together at a high level. Interesting stuff.

New Product - Equivalent Script

• by Additional Articles

• Other

• Unknown

At Last! No need to convert SQL Scripts from one dialect to another. Although SQL is a simple language, it can be tedious, inaccurate and frustrating when developing equivalent SQL scripts for multiple database servers. This product handles the conversion for you. (Not Reviewed)

The Best of SQLServerCentral.com 2002 - Follow Up

• by Andy Warren

• SQLServerCentral.com

Hopefully you've heard by now that we're publishing a book consisting of our best content from 2002. Sign up for the book is going well, but we could still use a few more. This update answers some of the questions we've received so far.

UDF as Computed Column Part 2

• by Dinesh Priyankara

• SQLServerCentral.com

• User Defined Function (UDF)

Dinesh is back with another article on user defined functions, giving some more great examples. If you haven't read the first one, definitely go back and read it first.

More Templates for Lockwood Tech Proc Blaster

• by Additional Articles

• Other

• Unknown

Need more templates for Proc Blaster? LockwoodTech Software has partnered with Harjai Software Consultants to develop templates for Proc-Blaster, a development tool for ASP Code Generation.

Review: AppDetective Helps You Be a Nosy DBA

• by Brian Knight

• SQLServerCentral.com

• Security

So how many servers do you have in your environment? In this review of AppDetective by Brian Knight, he shows you how AppDetective helped him find SQL Servers he didn't even know about in his environment.

SQL Bible

• by Additional Articles

• Other

• Administration

Here, in one definitive volume, is all the information you need to understand and use SQL and its implementations in accordance with the established SQL99 standard. Whether you want to learn database programming from scratch, you’d like to sharpen your SQL skills, or you need to know more about programming for a heterogeneous database environment, this book provides the complete menu. (Not Reviewed)

Network Computing - Is It Simply a Different Form of Client/Server?

• by Dale Elizabeth Corey

• SQLServerCentral.com

New author! Dale discusses the differences between network computing and client server. Do you know where SQL fits into that? It's good reading, covers the topic at a high level.

SQL Agent Problem

• by Andy Warren

• SQLServerCentral.com

• Administration

Andy takes us through a recent troubleshooting session that includes a call to PSS. Ever run agent from the command line? Have a good idea of what justifies a call to PSS? Read this to learn more.

Review of SQL Stripes

• by Christoffer Hedgate

• SQLServerCentral.com

• Administration

We asked Chris to take a look at SQL Stripes, and here are the results!