Mike Pearson

All authors

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,274 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

2004-09-06

5,801 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

2004-03-12

4,807 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

2003-05-26

12,768 reads

All authors

Blogs

The Evolution of Data: From Databases to Spark to Lakebases

By

The circle cylinder of life Maybe you’ve noticed all the twenty somethings tight rolling...

Why Microsoft Fabric Signals the Next Wave of Data Strategy

By

In today’s data-driven economy, organizations are no longer asking if they should invest in...

PostgreSQL Timeline: History and Evolution

By

PostgreSQL, often referred to as Postgres, is a powerful, open-source object-relational database system that...

Read the latest Blogs

Forums

How a Legacy Logic Choked SQL Server in a 30-Year-Old Factory

By Chandan Shukla

Comments posted to this topic are about the item How a Legacy Logic Choked...

How to fix transactional replication latency

By coolchaitu

Good Morning All, We are facing replication latency issue. I checked for blocking, long...

Life's Little Frustrations

By Grant Fritchey

Comments posted to this topic are about the item Life's Little Frustrations

Visit the forum

Question of the Day

The Updated Columns List

I have this table in SQL Server 2022: 

CREATE TABLE CustomerLarge
  (CustomerID               INT NOT NULL IDENTITY(1, 1) CONSTRAINT CustomerLargePK PRIMARY KEY CLUSTERED
 , CustomerName             VARCHAR(20)
 , CustomerContactFirstName VARCHAR(40)
 , CustomerContactLastName  VARCHAR(40)
 , Address                  VARCHAR(20)
 , Address2                 VARCHAR(20)
 , City                     VARCHAR(20)
 , CountryCode              CHAR(3)
 , Postal                   VARCHAR(20)
)
GO
If I check the columns_updated() function return in a trigger, what is the data returned?

See possible answers