Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Guest Columnist: Mike Pearson profile

   Items 1 to 6 of 6   

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.   Read more...
By Mike Pearson 2007/02/16 (first published: 2005/01/06) | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 28,767 reads

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.   Read more...
By Mike Pearson 2004/09/06 | Source: | Category: product reviews
Rating: |  Discuss |   Briefcase | 5,786 reads

Reporting Services!

Mike takes a good first look at Reporting Services. We're trying to add some coverage of this interesting new product. This gives a good overview from a real user perspective.   Read more...
By Mike Pearson 2004/03/09 | Source:
Rating: |  Discuss |   Briefcase | 10,496 reads

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.   Read more...
By Mike Pearson 2004/03/12 | Source:
Rating: |  Discuss |   Briefcase | 4,788 reads

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.   Read more...
By Mike Pearson 2003/05/26 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 12,609 reads

Auto Close and Auto Shrink - Just Don't

New author! Mike Pearson discusses how auto close was at the root of a performance problem he was troubleshooting, how you can check your servers easily, and discusses why both auto close and auto shrink are bad ideas in a production environment.   Read more...
By Mike Pearson 2003/05/05 | Source: | Category: administration
Rating: |  Discuss |   Briefcase | 19,981 reads
   Items 1 to 6 of 6