Author: Xiaowei Cao

Xiaowei Cao

Xiaowei Cao has a masters degree in Software Systems. She has been working in supporting SQL Server and database applications for 15+ years mostly in state government and school districts. Recently she has been working with both SQL Server and Oracle environments supporting enterprise systems, with tasks such as performance tuning, high availability, security, backup and restore, disaster recovery, data analysis, writing store procedures, script automation, SSIS ETL/ELT development and more.

Title	Category	Date
Upgrade and Migrate SSIS Catalog and SSISDB to a New Server	Integration Services Upgrade	2025-01-28
Side by Side SSRS Install and Upgrade to Minimize Downtime	Reporting Services Migration	2021-03-12

MSSQLTips.com delivers SQL Server resources to solve real world problems for DBAs, Architects, DevOps Engineers, Developers, Analysts, Cloud and Business Intelligence Pros – all for free. The content we serve is all human written and based on our authors’ real-world experience. Check out tips, articles, scripts, videos, tutorials, live events and more all related to SQL Server on-premises and in the cloud.

Resources

Community

Subscribe

Be a better SQL Server Professional – Join MSSQLTips.com

Author: Xiaowei Cao

Xiaowei Cao

Categories

Recent Articles

Install SQL Server 2025 Standard Developer Edition for Linux on AWS EC2

Rolling up multiple rows into a single row and column for SQL Server

T-SQL in One Hour

XML Data Extraction from SQL Server 2025

Simple Way to Calculate Running Totals in SQL Server

Resources

Community

Subscribe