Paul Mu

  • Interests: Travelling, Movies and Learning a Foreign Language

SQLServerCentral Article

Moving Your Database to a New Server

As DBAs we try our best to appropriately size a SQL Servers to match the anticipated load. But things change over time and we may find that some databases are overloading the server. When it's time to move your database to a new home on another server, Paul Mu brings us a technique for doing so.

2.5 (2)

You rated this post out of 5. Change rating


15,583 reads

SQLServerCentral Article

A Guide to Application Memory Tuning

Working with memory in SQL Server and tuning your server for optimum performance gets more complex all the time, especially with the availability of 64-bit platforms. New author Paul Mu brings us a short guide to using the /3GB and PAE switches along with their implications for your server.

You rated this post out of 5. Change rating


9,006 reads


What to Know about Power BI Theme Colors


Power BI reports have a theme that specifies the default colors, fonts, and visual...

A Global Team Meeting


The last few years at Redgate we’ve had the entire (or most) of the...

A New Word: sayfish


sayfish – n. a sincere emotion that seems to wither into mush as soon...

Read the latest Blogs



By ramana3327

We have about 30 databases in server A.  All of them need to migrate...

Add alarms to database when a query, stored procedure, SSIS package hangs

By Lord Slaagh

Hello SSC, I am a SQL Server developer that has some DBA skills. I...

Visit the forum

Question of the Day

The Secondary Database Name in an AG

I am setting up a SQL Server 2022 Availability Group and I am ready to restore the database on the secondary. The primary database is named Finance. However, we also use this instance for QA and already have a database named Finance. How do I configure the AG to use a different database as the secondary?

See possible answers