Mike Pearson

SQLServerCentral Article

Recovery Planning For SQL Reporting Services

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.

5 (4)

You rated this post out of 5. Change rating

2007-10-02 (first published: )

29,226 reads

SQLServerCentral Article

Review: SQL Auditor

How solid is your SQL Server database design? Will it perform well in practice? SSW has a product, SQL Auditor, that compares your design against a number of well known design rules and gives you reports based on how well your design does. Read Mike Pearson's review of this product.

5 (1)

You rated this post out of 5. Change rating


5,792 reads

SQLServerCentral Article

Review of ApexSQL Report v4.3

We had Mike take a look at this product recently and he found a lot to like. He also had some suggestions about ways the product could be improved - interesting since you get free upgrades for life with this product. This is a very good walk through of the product.

You rated this post out of 5. Change rating


4,799 reads

SQLServerCentral Article

Changing Rogue Database Collations

Collations hard to sort out (I know, bad joke)? Mike did what a good DBA gets paid to do, figure out an easy way to fix something and remove the chance of a user mistake at the same time. Good explanation and a couple scripts show how to handle column level collations.

You rated this post out of 5. Change rating


12,734 reads


Using Flyway with Feature Flags


There is a nice article at Harness.io on their use of feature flags and...

Microsoft Build event announcements on Fabric


There were a number of Microsoft Fabric announcements at Microsoft Build yesterday that I wanted to...

6 Can’t-Miss Basic SQL Courses to Learn in 2024: Your Fast Track to Data Mastery


Ready to dive into the world of SQL? Whether you're dreaming of a lucrative...

Read the latest Blogs


Monitoring if something is deleted in DB

By Martass

Hello, I have long-term task, which came one year ago, and just now I...

LOGON Trigger Count

By Steve Jones - SSC Editor

Comments posted to this topic are about the item LOGON Trigger Count

Invisible Downtime

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Invisible Downtime

Visit the forum

Question of the Day

LOGON Trigger Count

I have the need in SQL Server 2022 to create a complex set of checks for logins. I want to use Longon triggers, but I'd like to separate out logic. How many Logon Triggers can I create?

See possible answers