Tutorials
DBA
Dev
BI
Career
Categories
Webcasts
Scripts
Today's Tip
Join
Tutorials
DBA
Dev
BI
Categories
Webcasts
DBA
Dev
BI
Categories
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
(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)
More SQL Server Solutions
