Norman Chan

Norman is a SQL Server DBA that began his career over 12 years ago as a software developer working on multi-tiered systems serving hundreds of customers to large scale systems serving millions. Within a short few years he realized his passion for database administration, and has been a database admnistrator(DBA) ever since. He enjoys the complexity of working on databases trying to solve database problems from an application, hardware, and database level.

Articles: 4

Maintenance

Reduce Time for SQL Server Index Rebuilds and Update Statistics

We have been asked to reduce our maintenance window for the SQL Server off-line index rebuilds and updating statistics in order to keep our systems online longer. Is there a way to speed up off-line index rebuilds or updating statistics in SQL Server? Ch

Norman Chan
January 17, 2014

Express Edition

Centralizing SQL Server Express Job Scheduling

We're running multiple versions of SQL Server (SQL Server 2005, 2008, 2012 and Express Editions) in our Windows Domain. I'm interested in monitoring all my SQL Server backups, but for SQL Server Express we're currently using scheduled backups using Window

Norman Chan
May 13, 2013

SQL Server Management Studio

Where do I find the Performance Dashboard for SQL Server 2008?

I’ve downloaded and installed Performance Dashboard reports for SQL Server 2005 from Microsoft’s download site, but I can’t find Performance Dashboard for SQL Server 2008? How can I use this for SQL Server 2008 and 2008R2? In this tip we show you the wor

Norman Chan
February 28, 2013

Reporting Services Performance

Prevent SSRS Slow Startup

SQL Server Reporting Services 2008 (SSRS 2008) starts up slowly after a period of inactivity when I try to access the reports page. Sometimes it’s slow accessing it just half an hour later, sometimes hours later, or next day, but I can’t figure out why or

Norman Chan
September 7, 2012