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

Availability Groups

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

Backup

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

Clustering

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

Compression

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

Database Administration

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

Database Configurations

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

Database Consistency Checks DBCCs

Execute SQL Server DBCC SHRINKFILE Without Causing Index Fragmentation (7/20/2016)

Encryption

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

Functions - System

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

Functions - User Defined UDF

In-Memory OLTP

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

Indexing

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

Licensing

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

Master Data Services

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

Performance Tuning

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

Restore

Different Ways to Restore a SQL Server Database (10/29/2013)
Understanding SQL Server Log Sequence Numbers for Backups (4/22/2014)

SQL Server Configurations

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

System Databases

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

Transactions

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

Tutorials DBA Dev BI Career Categories Webcasts Whitepapers Today's Tip Join

Tutorials DBA Dev BI Categories Webcasts

DBA Dev BI Categories

Simon Liew

More SQL Server Solutions