Additional Articles

Tuning the Performance of Backup Compression in SQL Server 2008

by Additional Articles

MSDN Communities

Backup and restore

ckup compression is a new feature in SQL Server 2008 that can help provide smaller sized backups and reduce backup time. This document provides guidance related to tuning options for backup performance. All of the information and test results presented here were done specifically by using the backup compression feature of SQL Server 2008; however, they apply broadly to any backup scenario whether backup compression is used or not

2008-05-12

2,214 reads

Scalability and Goal Testing for Developers

by Additional Articles

DevX

Scalability

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.

2008-05-09

2,508 reads

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.

2008-05-08

8,233 reads

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.

2008-05-08

4,526 reads

Constructing XML using 'FOR XML'

by Additional Articles

SQL Server Universe

Over the past few years, software developers have used various kinds of technologies to retrieve data from relational databases. SQL Server 2000 is the first Microsoft DBMS to fully support XML. In this article the author concentrates on the FOR XML clause in SQL Server versions, 2000 and 2005. Click on title for more

2008-05-07

2,498 reads

Slowly Changing Dimensions in SQL Server 2005

by Additional Articles

SQL Server Performance

Analysis Services (SSAS)

This article explores the options available in SQL Server 2005 for Slowly Changing Dimensions.

2008-05-07

3,048 reads

Simplify SQL Server 2005 queries with a Dates table

by Additional Articles

Builder.com

SQL Server 2005

Learn what a Dates table is and how to create one, and then try it out for yourself

2008-05-06

5,831 reads

SQL Server source code analysis and management adds database security

by Additional Articles

SearchSQLServer

System Development Life Cycle

SQL Server source code analysis and management add database security by debugging and testing SQL applications. Learn about SQL source code analysis.

2008-05-06

2,617 reads

SQL Server 2008 (Katmai) Reporting Services Performance: Two Steps Forward, One Step Back?

by Additional Articles

DevX

Reporting Services (SSRS)

In this article, David Leibowitz compares the performance of the prerelease of Microsoft's SQL Server 2008 Reporting Services to SSRS 2005. While it is clear performance improvements have been made for report automation, developers might have differing opinions on the new Report Designer.

2008-05-05

4,012 reads