Reporting Services exposes web methods via XML web services to facilitate cross platform reports management and delivery. It's a simple SOAP based API makes it very easy to add full functionality of reporting services in your application. It provides a set of rendering and viewing functions as well as complete set of management routines. Reporting services web service is the one stop shop for subscription, management, publishing, scheduling and rendering reports.

How do you spell S-Q-L?

by Sean McCown

SQLServerCentral.com

Miscellaneous

We've spent quite some time investigating career issues for SQL Server DBAs lately. I've received quite a few emails from friends on their adventures in interviewing and now Sean McCown shares an experience he had interviewing a few prospective DBAs.

Powerchute 6.x User's Alert

by Steve Jones

SQLServerCentral.com

Rants

If you run PowerChute 6.x on any of your servers, be very careful of patching and rebooting them. You might end up with more downtime and problems than you expected.

Business Intelligence with SQL Server Reporting Services - Part 2

by Additional Articles

Other

Development

A look at Parameterized reports, stored procedures to retrieve data and the Report Viewer.

Jacksonville - 2005 Code Camp

by Press Release

SQLServerCentral.com

If you are near the Jacksonville, FL area on Saturday, August 27th, check out this code camp with our own Brian Knight. Get the chance to learn some great development from Brian and a few other experts.

The Basics of Cryptography Part 2

by Michael Coles

SQLServerCentral.com

Miscellaneous

Encryption in SQL Server is difficult to implement and manage, but it is being required more and more often. However understanding what encryption means is as important as being able to manage and implement it. Michael Coles brings us part 2 in his series on explaining the mysteries behind cryptography.

Performance Monitoring by Internal Fragmentation Measurement

by Koby Biller

SQLServerCentral.com

Performance Tuning

It has not been clear to what extent fragmentation, either internal or external, truly affects the performance of your SQL Server 2000 databases. New author Koby Biller discusses some of the impacts that it could have and has a free tool for download that can help you determine how fragmented your disk truly is.

Enabling Drillthrough in Analysis Services 2005

by Additional Articles

MSDN Communities

Analysis Services (SSAS)

Discover the new Analysis Services 2005 drillthrough architecture. See how to set up drillthrough in Analysis Services 2005 and get guidance on migrating drillthrough settings from Analysis Services 2000 databases.

Single Point of Administration

by Jonathan Stokes

SQLServerCentral.com

Miscellaneous

Whether you write TSQL code or front end VB code against your SQL Server, it pays to have some good development practices that make your life easier. Jonathan Stokes has written a good article showing some of the good practices you should use.

Using TRY/CATCH to Resolve Deadlocks in SQL Server 2005

by Additional Articles

MSDN Communities

Development

Deadlocks are unavoidable artifacts of today's RDBMS architecture–and all too common in high-volume OLTP environments. But thanks to .NET's Common Language Runtime (CLR), SQL Server 2005 provides developers with a new way to deal with error handling. In this month's column, Ron Talmage shows you how to harness TRY/CATCH to help resolve a deadlock.

Business Intelligence with SQL Server Reporting Services - Part 3

How do you spell S-Q-L?

Powerchute 6.x User's Alert

Business Intelligence with SQL Server Reporting Services - Part 2

Jacksonville - 2005 Code Camp

The Basics of Cryptography Part 2

Performance Monitoring by Internal Fragmentation Measurement

Enabling Drillthrough in Analysis Services 2005

Single Point of Administration

Using TRY/CATCH to Resolve Deadlocks in SQL Server 2005

Blogs

SQL Server Security: Always Encryption

SQL Server Security – TDE Encryption

A Las Vegas Break

Forums

The day-to-day pressures of a DBA team, and how we can work smarter with automation and AI

The Problem Isn't Always Your Query or Schema... Sometimes It's Hidden Assumptions

Identity Defaults

Question of the Day

Identity Defaults