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.
  • MSSQLTips Awards: Trendsetter (25+tips) - 2017 | Author of the Year Contender - 2016, 2017
Title Category Date
What is SQL Server AlwaysOn? Availability Groups2025-06-16
Optimize SQL LIKE Wildcard Searches TSQL2025-01-15
Understanding the COLLATE DATABASE_DEFAULT clause in SQL Server Database Configurations2025-01-08
SQL Server 2022 TempDB Contention Enhancements Performance Tuning2024-06-19
SQL Server Filtered Index Essentials Guide Indexing2024-04-03
SQL Server Lock Pages in Memory, AWE API and Windows Task Manager SQL Server Configurations2021-02-12
SQL Server Max Memory Setting with Lock Pages in Memory SQL Server Configurations2020-11-30
Memory Perfmon Counters in SQL Server – Target vs Total and Max SQL Server Configurations2020-09-24
SQL Server sys.dm_exec_query_plan Query Plan is NULL Query Plans2020-03-31
Get SQL Server Delayed Durability Advantages Without Configuration Changes Performance Tuning2020-02-13
Different Ways to Write a Cursor in SQL Server TSQL2020-02-05
SQL Server Query Performance for INSERT SELECT vs INSERT EXEC TSQL2018-12-21
How to Perform an Online Page Level Restore in SQL Server Restore2018-10-19
Create SQL Server database corruption using DBCC WRITEPAGE Database Console Commands DBCCs2018-09-28
Convert SQL Server Base64 Encoded Text to Images TSQL2018-09-05
SQL Database Corruption and CHECKDB repair with allow data loss Database Console Commands DBCCs2018-08-24
How to Quickly Copy Data Using SQL Server Data Tool (SSDT) Azure Data Studio2018-08-15
Undetected SQL Server Data Corruption with Database Page Verify option set to NONE Database Console Commands DBCCs2017-11-29
SQL Server Page Verify CHECKSUM vs NONE Performance Database Configurations2017-10-06
Updating an expired SQL Server TDE certificate Encryption2017-08-08
Does SQL Server TDE still work with an expired certificate Encryption2017-07-25
SQL Server AlwaysOn Availability Group Backup Preference Setting Availability Groups2017-07-14
Recover WSFC using Forced Quorum for SQL Server AlwaysOn Availability Group Availability Groups2017-06-15
SQL Server Proportional Fill Algorithm Example Database Configurations2017-05-26
Tempdb size resets after a SQL Server service restart System Databases2017-04-26
Refactor SQL Server scalar UDF to inline TVF to improve performance Functions User Defined UDF2017-03-22
Understand the Performance Behavior of SQL Server Scalar User Defined Functions Functions User Defined UDF2017-02-09
Long Running Transactions Cause SQL Server Transaction Log to Grow Transactions2017-01-20
In-Memory OLTP: Using Memory-Optimized Tables to Replace SQL Server Temporary Tables In Memory OLTP2017-01-12
Importance of Performing DBCC CHECKDB on all SQL Server Databases System Databases2016-12-28
SQL Server 2016 COMPRESS and DECOMPRESS functions Compression2016-12-21
Access is denied error when attaching a SQL Server database Database Administration2016-12-05
SQL Server 2016 Availability Group Automatic Seeding Availability Groups2016-11-23
Migrate SQL Server Master Data Services (MDS) model objects and data Master Data Services2016-11-07
Backup Compression Performance Enhancements for SQL Server 2016 TDE Enabled Databases Backup2016-10-31
SQL Server Enterprise Advanced Scan aka Merry-Go-Round Scan Performance Tuning2016-10-05
SQL Server COUNT() Function Performance Comparison Functions System2016-09-19
Understand How Dynamic Witness Works for a SQL Server WFSC Clustering2016-09-09
Dynamic Quorum for Windows Server 2012 R2 Cluster to Support SQL Server AlwaysOn Clustering2016-08-30
SQL Server Temporary Table Caching System Databases2016-08-12
Execute SQL Server DBCC SHRINKFILE Without Causing Index Fragmentation Database Console Commands DBCCs2016-07-20
Differences between SQL Server 2012 Enterprise Edition – Server CAL and Per Core Licensing Licensing2016-06-09
Windows Server Power Management Effect on SQL Server Performance Tuning2014-11-06
Understanding SQL Server Log Sequence Numbers for Backups Restore2014-04-22
Different Ways to Restore a SQL Server Database Restore2013-10-29
How to hot-add a vCPU to a virtual SQL Server SQL Server Configurations2013-10-04
SQL Performance Issue for Single Row Delete or Update Operations Indexing2013-08-16