Often developers are tasked with not only developing functional code, but also with ensuring that the code they develop scales well and performs in the application environment.

Planes, Trains, and Cows?

by Steve Jones

SQLServerCentral.com

Editorial

New technologies often bring with them lots of new data. Steve Jones talks about some changes that we might see with new RFID technology being deployed in some industries.

The Differences Between SQL Server 2000 and 2005

by Steve Jones

SQLServerCentral.com

Administration

What are the differences between SQL Server 2000 and 2005? It's a question that DBAs are often asked by those who don't work with SQL Server on a daily basis. Steve Jones begins a short series on the differences by examining some of the core administrative differences.

Using XML to pass Multi-Select parameters from SSRS to SQL Server

by Wayne Sheffield

SQLServerCentral.com

Reporting Services (SSRS)

How to use XML to pass Multi-Select parameters from Reporting Services to SQL Server.

Best Practices for Troubleshooting Slow Running Queries

by Additional Articles

SQL Community

Performance Tuning

In this article we will share some of the common reasons for slow-running queries and what your approach should be for identifying and fixing them.

Testing SQL Stored Procedures Using LINQ

by Additional Articles

Microsoft MSDN

System Development Life Cycle

The need to test a program that accesses and manipulates a back-end SQL Server® database is very common. In many such cases, the application interacts with the back-end data through the use of SQL stored procedures. In this type of scenario, you can think of the stored procedures as auxiliary methods of the system under test; and they must therefore be tested just like any other module in the system.