Author: JP Chen

Practice Leader of SQL Server Services

JP Chen

JP has over 13 years of experience in the IT industry specializing in web development, data analysis, and database administration. He has worked on supporting enterprise level corporations in the financial, retailing, pharmaceutical, aerospace, fashion, and education industries as a DBA and Tech Lead. He has initiated, designed, and developed comprehensive solutions on database documentation, monitoring and alerting, stabilization, and continuous improvements with performance monitoring and tuning. He enjoys sharing his new findings, knowledge, and practical hands-on experiences on SQL Server via his two blogs: www.handsonsqlserver.com and www.handsontsql.com.

Articles Written by JP Chen

How do you migrate on-premise SQL Server databases over to Azure SQL Database server? In this blog, we will quickly explore two of the most popular migration options.

Read More

An overview of Microsoft Azure SQL Database and how to get started on a free trial.

Read More

As part of the migration project steps, you need to create a report to show the restore details such as the restore option, recovery options, restore start time, source file, and where the file was restored.

Read More

In this blog, we will explore the required steps to query the existing logical and physical file name, rename a database, rename the logical file names, and rename the physical file names.

Read More

In this blog, we will look into how we can generate the TSQL restore scripts automatically and then execute them to perform the restores.

Read More

As a DBA, you can develop your own toolbox and be a master in the craft of administering and managing databases.

Read More

In this blog, we will explore the option to stripe the backup files into four by first running the database backups using one file and then stripe them into four files. We will then compare the backup durations.

Read More

In this blog, we will explore the required system tables, functions, and the techniques to create a backup history report.

Read More

SQL Server Agent is a Windows service that executes the scheduled administrative jobs. In this blog, we will explore and share with you on how can we quick stop, start, and run a script to check the SQL Server Agent status.

Read More

We compare Amazon RDS and Microsoft Azure SQL Databases. Cloud-based computing holds promise for businesses that no longer need to own and maintain costly fixed-hardware assets.

Read More