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
2016 Awards
2017 Awards


2016 Awards

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
- Get SQL Server Delayed Durability Advantages Without Configuration Changes (last update: 2/13/2020)
- 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)
Query Plans
- SQL Server sys.dm_exec_query_plan Query Plan is NULL (last update: 3/31/2020)
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)
- SQL Server Max Memory Setting with Lock Pages in Memory (last update: 11/30/2020)
- SQL Server Perfmon Counters - Target vs Total Memory and Max Memory (last update: 9/24/2020)
- Understanding SQL Server Lock Pages in Memory, AWE API and Windows Task Manager (last update: 2/12/2021)
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)
- Different Ways to Write a Cursor in SQL Server (last update: 2/5/2020)
- 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)