SQL Server 2000 Reporting Services is becoming a more and more popular reporting option everyday. However, the disaster recovery plan for this add on is not a simple backup and restore since there are multiple pieces and servers usually involved. However the DBA may be responsible for the entire system. Mike Pearson brings us a look at some of the scenarios that you need to consider and what you might need to prepare for disaster recovery of SQL Server 2000 Reporting Services.

Dealing With Upper and Lower Case Data

by Additional Articles

SQLServerCentral

Advanced Querying

Gregory Larsen demonstrates several examples of how to deal with different situations related to the case of character strings.

Logical Functions: IsAncestor(): Conditional Logic within Calculations

by Additional Articles

SQLServerCentral

Use IsAncestor() to support conditional logic within calculations. BI Architect Bill Pearson introduces IsAncestor(), and then leads a hands-on practice session with this valuable MDX function.

Where Did The Women Go?

by Atieh

SQLServerCentral.com

Editorial

A guest editorial today from Atieh Jones wondering where are all the women in IT?

Why RAID is (usually) a Terrible Idea

by Additional Articles

Other

Miscellaneous

Your development system might be as valuable as your servers, but is it worth setting up with RAID? Read an interesting argument from one of the largest custom computer builder.

Would I encourage my daughter to pursue a career in IT?

by Lynda-Rab

SQLServerCentral.com

Editorial

A guest editorial today from Lynda Rab, PASS board member and new mother.

Pop Rivett and the Suspect Database

by Additional Articles

SimpleTalk

Administration

Pop Rivett tackles a torn page in a suspect database.

Technology: Where have all the women gone?

by Kathi Kellenberger

SQLServerCentral.com

Longtime author Kathi Kellenberger brings us a guest editorial today on what is happening with women in the technology world.

The Old Boys Club

by Steve Jones

SQLServerCentral.com

Editorial

Steve Jones looks at some of the issues with gender in the workplace and reminds everyone that they need to respect each other.

Hacking SQL Server

by Additional Articles

SQLServerCentral

Security

In this presentation at the Jacksonville SQL Server Users Group, Bayer White playS the part of a developer protecting his application and Brian Knight attempts to hack his application using SQL Injection and cross-site scripting. Then, Bayer will show you how to protect yourself from the hacker and then Brian tries again. Back and forth the chess match goes until someone wins!

Recovery Planning For SQL Reporting Services

Dealing With Upper and Lower Case Data

Logical Functions: IsAncestor(): Conditional Logic within Calculations

Where Did The Women Go?

Why RAID is (usually) a Terrible Idea

Would I encourage my daughter to pursue a career in IT?

Pop Rivett and the Suspect Database

Technology: Where have all the women gone?

The Old Boys Club

Hacking SQL Server

Blogs

Keeping Redshift System Table History Past 7 Days with S3 Tables

Updating the Data API Builder

T-SQL Tuesday #202 Invitation: That One SQL Server Outage You’ll Never Forget

Forums

advice on ssrs version control

Practical Ways to Approach SQL Server Problems and Case Studies

Measuring Productivity

Question of the Day

Tracking All the Queries