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
  

• 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 Compression Performance Enhancements for SQL Server 2016 TDE Enabled Databases (last update: 10/31/2016)
  

• 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)
  

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

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

• 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)
  

• 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)
  

• 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)
  

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

• 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: Using Memory-Optimized Tables to Replace SQL Server Temporary Tables (last update: 1/12/2017)
  

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

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

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

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

• 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)
  

• SQL Server sys.dm_exec_query_plan Query Plan is NULL (last update: 3/31/2020)
  

• 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)
  

• 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)
  

• 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)
  

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

• 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)