Two big events this week captured Steve Jones' attention. A little MySQL and Apple commentary to break up the week.

Server Side Paging using SQL Server 2005

by Additional Articles

SQLTeam.com

T-SQL

A common activity in applications is to page results or record sets from a database. This is usually done on the client using the client's paging functionality or on the server through a variety of methods. In SQL Server 2000 those server side methods typically used dynamic SQL or nested TOP clauses and weren't very efficient. Using Common Table Expressions in SQL Server 2005 we have a better way to page record sets on the server.

Testing - iPod

by Steve Jones

SQLServerCentral.com

Editorial - iPod

We get tested in a variety of ways before we take a job, but what should be open for examination besides our technical skills? Answer this week's poll with your opinion.

Testing - MP3

by Steve Jones

SQLServerCentral.com

We get tested in a variety of ways before we take a job, but what should be open for examination besides our technical skills? Answer this week's poll with your opinion.

Testing - WMV

by Steve Jones

SQLServerCentral.com

Editorial - WMV

We get tested in a variety of ways before we take a job, but what should be open for examination besides our technical skills? Answer this week's poll with your opinion.

The Data Stewardship Approach to Data Governance: Chapter 1

by Additional Articles

TDAN

The definitions of data governance and data stewardship that I use have changed, albeit slightly, over the years of providing data governance and stewardship solutions.

Using Report Parameters in SQL Server Reporting Services

by Additional Articles

SQL Server Performance

Reporting Services (SSRS)

Report parameters assist in narrowing down a report for better analysis.

Putting Unit Tests to Work

by Grant Fritchey

SQLServerCentral.com

System Development Life Cycle

Testing is an important part of any software development process, but it's a part that many of us skimp on or ignore because of the tedious nature of testing. Longtime author Grant Fritchey has been working with Visual Studio Team Edition for Database Professionals and has written us an article on how you can make your unit testing easier.