Additional Articles

Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP

by Additional Articles

TechNet Blogs

Report Builder

This paper introduces Microsoft SQL Server 2005 Report Builder and demonstrates how to build an end-to-end ad hoc reporting solution for enterprise customers using Report Builder and Microsoft SQL Server 2005 Analysis Services OLAP. We also highlight a few product limitations, as well as enterprise considerations. It is based on a real-world implementation by Microsoft Business Intelligence Center of Excellence.

2008-01-14

3,580 reads

Evaluating How Filtering Options Affect T-SQL Performance

by Additional Articles

DevX

T-SQL

The many popular rules concerning T-SQL filtering operators can't be trusted implicitly; instead, you should evaluate your options explicitly.

2008-01-14

2,792 reads

SQL Server 2005 Deployment Guidance for Web Hosting Environments

by Additional Articles

TechNet Blogs

SQL Server 2005

SQL Server 2005 is an ideal database platform for use in shared and dedicated Web hosting environments. This paper provides best practices for configuring SQL Server 2005 to optimize security, tenant isolation, and the performance of your hosted SQL Server 2005 deployment. Sample scripts for provisioning users and databases for use in shared hosting are included.

2008-01-11

1,576 reads

SQL Server: Uncover Hidden Data to Optimize Application Performance

by Additional Articles

Microsoft MSDN

Performance Tuning

Many application performance problems can be traced to poorly performing database queries; however, there are many ways you can improve database performance. SQL ServerTM 2005 gathers a lot of information that you can use to identify the causes of such performance issues.

2008-01-11

3,144 reads

Custom VB.Net scripting in SQL Server Integration Services

by Additional Articles

SearchSQLServer

Integration Services (SSIS)

Add a Script component and custom Visual Basic.Net (VB.Net) scripting to SQL Server Integration Services (SSIS) packages to get the full power of .Net.

2008-01-10

3,122 reads

SQL Server 2005 - Hacking password Encryption

by Additional Articles

Database Journal

Encryption

Part 2 of this article discusses how to hack/de-cipher the data that has been encrypted by passphrase.

2008-01-10

4,751 reads

Basic SQL Server security principles you can't afford to miss

by Additional Articles

SearchSQLServer

Security

Learn how using basic SQL Server security practices of least privilege, delegated administration and separation of duties will protect SQL Server databases.

2008-01-09

3,806 reads

Test Data Generation with Data Dude

by Additional Articles

SQL Server Universe

Data Dude

The Visual Studio 2005 Team Edition for Database Professionals (a.k.a Data Dude) was released somewhere around December 2006 helping many Database Administrators and Database Developers. The release was huge for us, because it addresses many issues faced by us.

2008-01-09

3,641 reads

Disk Space Usage and SQL Server Performance

by Additional Articles

Database Journal

Monitoring

Every extra byte of space you waste in your database causes a performance hit to your application. This article looks at disk space usage and how it affects performance.

2008-01-08

7,011 reads

Measure TSQL Statement Performance

by Additional Articles

SQL Server Performance

Performance Tuning

Every developer needs to ensure that each TSQL statement is optimized. This article will give you a few different ideas on how to identify slow running queries and provide you with some tips on monitor your query performance while you make iterative changes to each query to try and improve performance.

2008-01-08

4,445 reads

All authors

Additional Articles

Building Ad-hoc Reporting Solutions with SQL Server 2005 Report Builder and Analysis Services OLAP

Evaluating How Filtering Options Affect T-SQL Performance

SQL Server 2005 Deployment Guidance for Web Hosting Environments

SQL Server: Uncover Hidden Data to Optimize Application Performance

Custom VB.Net scripting in SQL Server Integration Services

SQL Server 2005 - Hacking password Encryption

Basic SQL Server security principles you can't afford to miss

Test Data Generation with Data Dude

Disk Space Usage and SQL Server Performance

Measure TSQL Statement Performance

Blogs

A Broken Copilot Query

SQL Server Alerts

Prompt AI helping with Auditing

Forums

Create an HTML Report on the Status of SQL Server Agent Jobs

Building a RESTful API with FastAPI and PostgreSQL

The Journey to PostgreSQL (or anything)

Question of the Day

A Common Split