Integrate SQL 2005, ASP.NET, Reporting Service and Analysis Services to rapidly develop and deploy a survey application for data entry and results analysis.

The Google Way

by Steve Jones

SQLServerCentral.com

Editorial

Who's on top in this war of the giant software companies?

Brad McGehee On Being a Better DBA!

by Additional Articles

Other

Career Growth

Brad McGehee discusses the career path of a professional database administrator. Often the DBA role is thrust upon an IT professional or developer without much in the way of specific training. Growing into the role is largely a self-motivated exercise. Brad talks about the habits that successful DBAs have, focused on on-going education and working to protect their organizations data.

Calculate Percentiles with SQL Server 2005

by Additional Articles

DevX

SQL Server 2005

Learn one of the techniques for calculating percentiles with SQL Server 2005 using the new SQL Server Common Table Expression and the latest ROW_NUMBER function.

Incommunicado

by Steve Jones

SQLServerCentral.com

Editorial

Communication is important, and it's a real problem when people can't reach you. Read about an interesting phone accident the some hints for better communication.

TSQL Lab I - Playing around with ROW_NUMBER

by Jacob Sebastian

SQLServerCentral.com

T-SQL

Real world solutions are key and having different techniques can sometimes help you code quicker. Longtime author Jacob Sebastian shows us how to solve a few problems with different techniques.

Populating Dimension Tables with the SCD Task

by Additional Articles

SQL Server Universe

Integration Services (SSIS)

ETLing dimensions through SQL Server 2000 DTS, has more or less been quite a hassle, what with the lengthy ActiveX scripts and lookups that have to be performed. Enter SQL Server 2005 Integration Services: The Slowly Changing Dimension task has made it much simpler.