Simon Liew

Simon Liew is an independent SQL Server Consultant in Sydney, Australia. He is a Microsoft Certified Master for SQL Server 2008 and holds a Master’s Degree in Distributed Computing.

2017 Awards
MSSQLTips award

2016 Awards
MSSQLTips award

Availability Groups

Recover WSFC using Forced Quorum for SQL Server AlwaysOn Availability Group (last update: 6/15/2017)
SQL Server 2016 Availability Group Automatic Seeding (last update: 11/23/2016)
SQL Server AlwaysOn Availability Group Backup Preference Setting (last update: 7/14/2017)
What is SQL Server AlwaysOn? (last update: 2/20/2017)

Backup

Backup Compression Performance Enhancements for SQL Server 2016 TDE Enabled Databases (last update: 10/31/2016)

Clustering

Dynamic Quorum for Windows Server 2012 R2 Cluster to Support SQL Server AlwaysOn (last update: 8/30/2016)
Understand How Dynamic Witness Works for a SQL Server WFSC (last update: 9/9/2016)

Compression

SQL Server 2016 COMPRESS and DECOMPRESS functions (last update: 12/21/2016)

Database Administration

Access is denied error when attaching a SQL Server database (last update: 12/5/2016)

Database Configurations

SQL Server Page Verify CHECKSUM vs NONE Performance (last update: 10/6/2017)
SQL Server Proportional Fill Algorithm Example (last update: 5/26/2017)
Understanding the COLLATE DATABASE_DEFAULT clause in SQL Server (last update: 8/3/2016)

Database Console Commands DBCCs

Execute SQL Server DBCC SHRINKFILE Without Causing Index Fragmentation (last update: 7/20/2016)
SQL Server Database Corruption and Impact of running CHECKDB repair with allow data loss (last update: 8/24/2018)
Undetected SQL Server Data Corruption with Database Page Verify option set to NONE (last update: 11/29/2017)
Using undocumented DBCC WRITEPAGE to instigate SQL Server database corruption (last update: 9/28/2018)

Encryption

Does SQL Server TDE still work with an expired certificate (last update: 7/25/2017)
Updating an expired SQL Server TDE certificate (last update: 8/8/2017)

Functions - System

SQL Server COUNT() Function Performance Comparison (last update: 9/19/2016)

Functions - User Defined UDF

Refactor SQL Server scalar UDF to inline TVF to improve performance (last update: 3/22/2017)
Understand the Performance Behavior of SQL Server Scalar User Defined Functions (last update: 2/9/2017)

In-Memory OLTP

In-Memory OLTP: Using Memory-Optimized Tables to Replace SQL Server Temporary Tables (last update: 1/12/2017)

Indexing

SQL Server Performance Issue for Single Row Delete or Update Operations (last update: 8/16/2013)

Licensing

Differences between SQL Server 2012 Enterprise Edition - Server CAL and Per Core Licensing (last update: 6/9/2016)

Master Data Services

Migrate SQL Server Master Data Services (MDS) model objects and data (last update: 11/7/2016)

Other Database Platforms

How to Quickly Copy Data Using SQL Server Data Tool (SSDT) (last update: 8/15/2018)

Performance Tuning

SQL Server Enterprise Advanced Scan aka Merry-Go-Round Scan (last update: 10/5/2016)
Windows Server Power Management Effect on SQL Server (last update: 11/6/2014)

Restore

Different Ways to Restore a SQL Server Database (last update: 10/29/2013)
How to Perform an Online Page Level Restore in SQL Server (last update: 10/19/2018)
Understanding SQL Server Log Sequence Numbers for Backups (last update: 4/22/2014)

SQL Server Configurations

How to hot-add a vCPU to a virtual SQL Server (last update: 10/4/2013)

System Databases

Importance of Performing DBCC CHECKDB on all SQL Server Databases (last update: 12/28/2016)
SQL Server Temporary Table Caching (last update: 8/12/2016)
Tempdb size resets after a SQL Server service restart (last update: 4/26/2017)

T-SQL

Convert SQL Server Base64 Encoded Text to Images (last update: 9/5/2018)
SQL Server Query Performance for INSERT SELECT vs INSERT EXEC (last update: 12/21/2018)

Transactions

Long Running Transactions Cause SQL Server Transaction Log to Grow (last update: 1/20/2017)

Simon Liew

More SQL Server Solutions