Archives

Categories

Containers & DevOps

Community & Talks

High Availability

Performance & Tuning

Troubleshooting

Backup & Recovery

Administration & Tools

T-SQL & Scripts

Administration & Tools

Backup & Recovery

Community & Talks

Containers & DevOps

Performance & Tuning

T-SQL & Scripts

2026

How to add PMM monitoring to ProxySQL on Kubernetes

Argo CD said Synced and Healthy for 57 hours while nothing deployed

Simon's SQL is back — now on Hugo

2021

PASS Data Community Summit 2021 - Speaker

AG Monitoring query

2019

PASS Summit 2019 - Database CICD (Simon Cho)

[StepByStep] SQL Server on Container? What is Kubernetes? - SQL Saturday 4/13

[StepByStep] SQL Server on Container? What is Kubernetes? - SQL LA

CNFC Landscape

2018

SQLSaturday #740 - Orange County - [StepbyStep] SQL server Index operation for beginner to expert

Indexed View can’t create online in the beginning.

SQL Saturday #696 - Redmond

An existing connection was forcibly closed by the remote host

Meltdown and Spectre update for SQL 2012 and SQL 2014

Meltdown and Spectre

SQL Compression backup with TDE

2017

Update statistics blocking issue(Part 1)

WMI broken FCI or SQL Server

Cannot connect to WMI provider. You do not have permission or the server is unreachable. Note that you can only manage SQL Server 2005 and later servers with SQL Server Configuration Manager.

Auto DB Deployment basic - SQL Angeles

SQLSaturday in Los Angeles 6/10

SQL Saturday #613 - Redmond Presentation

SQL Saturday #611 - Orange County Presentation

SSMS 2016 Release tracking

Start SQL Server in Single-User Mode

sys.sysobjvalues

SQL Angeles Meeting 2/14 - Los Angeles

Delayed Durability

parameter sniffing recompile options

SQLCMD mode in SSMS

Source Control in SQL Server Management Studio (SSMS)

SQL Server Column store row group investigation

2016

SQLAngeles presentation - 12/6/2016

AG Listener setting

Memory troubleshooting

SQL server 2016 -T1117 and -T1118

SOS_SCHEDULER_YIELD due to SpinLock issue.

[LA DB 스터디] 2016-11-15 LA 한인 SQL Angeles 스터디 모임

Global ErrorLog SP example

SQL Saturday Session #563 - Dallas 9/24/2016

Service Broker may not work after Failover in AG.

Service Master Key issue on AG

Saturday Night SQL VC 9/10 - Build ETL efficiently (10x) with Minimal Logging

SQL Saturday - oklahoma city

Bulk recovery model - Concerning about Point-in-time recovery.

7/23/2016 SQL Saturday at Sacramento

SQL.LA presentation file 7/21.

SSIS Catalog Execution with T-SQL

I’m going to Speak at South Florida, 6/18 - Update Download link

SQL Server 2016 installation

“Myths and Truths about SQL Server Transaction” at Saturday Night SQL, 5/7 6:00 PM PST.

Recommended updates and configuration options for SQL Server 2012 and SQL Server 2014 with high-performance workloads

4/9 Silicon Valley to speak on SQL Saturday.

checkDB detail

understading status column of sysfiles and sysaltfiles view

2015

Between 4096 and 512 sector size issue.

Speak at Huntington Beach 4/11/2015

SSIS package unexpected Termination

AlwaysOn AG group status check

SQL 2014 service pack for SP1 or CU7?

Parallelism

misaligned log ios which required falling back to synchronous io between 4096 and 512e

SQL Saturday Presentation file - 9/20/2014

SQL.la Presentation file - Transaction 1/15/2015

2014

SQL Saturday - Presentation(Transaction) - San Diego 9/20

Introduce Desired State Configuration in Windows Server 2012

Basic powershell function call

DBCC help(‘?’) want to see all hidden DBCC command

DBCC SHRINKFILE isn’t working even simple recovery mode.

SQL Agent Job server.(Centralized job server)

Drop certain query plan

Alert email sending

Selecting Rows Randomly from a Large Table

SQL Server Job Agent - Invoke job sequence.

OpenXML parentID

Token-based server access validation failed with an infrastructure error, Error: 18456

2013

sp_rename will not change sys.syscomments table definition.

Excel import using XML and T-SQL

TempDB Misconceptions around TF 1118

Bulk load data conversion error (overflow) SQLINT (BCP)

Paging file for SQL server

BACKUP DATABASE TO DISK = N‘NUL’

uniqueidentifier : GUID in SQL

2012

Contact information

Cross-Database Access

Backup chain is broken due to Veeam Backup configuration improperly.

Snapshot and Synonyms

Dedicated Administrator Connection

DeadLock handling

Errorhandling

RAISERROR : Database Engine Error Severities

Could not continue scan with NOLOCK due to data movement

Useful SQL Server Management Studio Keyboard Shortcuts

server information include port #

Backup Size check including compression backup

Remote Replication(Long distance Replication)

Replication in Non-Trusted Domains

Quest LiteSpeed Compressed Backup T-SQL

Disk IO Response time In SQL

Array to table for multi dimensional

SSMS tool pack and other useful free tools

Find out sql job start time and end time

XACT_STATE or @@Trancount (To control Nested Transaction)

Index rebuild vs. Statistics update

Index operation

distributed transaction insert exec error

[replication] all articles and server information

Size 1 day backup size

Replication performance tuning

Master rebuild and change check list

An error occurred during decryption

SQL Server - Undelete a Table and Restore a Single Table from Backup

Converting from hex string to varbinary and vice versa

LSN Convert

fn_dump_dblog

2011

All about MCM

Minimal logging operation with Traceflag 610

permission test.(impersonate)

SQL 2000 linked server error from x64 machine(Cannot obtain the schema rowset “DBSCHEMA_TABLES_INFO”)

vmware tech pdf files.

Diagnosing Transaction Log Performance Issues and Limits of the Log Manager

SQL Job Migration(powershall script)

sys.dm_exec_requests error for “blocking_session_id”

Replication status check

Available File group size

object size each table and index (update for partitioning table)

Disk IO response time check.

sp_now : rewrite sp_who2

check object list and size in filegroup

Network Monitor

How to troubleshoot the “Cannot generate SSPI context” error message

Understanding Kerberos and NTLM authentication in SQL Server Connections

How to make sure that you are using Kerberos authentication when you create a remote connection to an instance of SQL Server 2005

Kerberos error event logging

SQL Nexus for SQL 2008 R2 x64

SQL Server Trace Flags

Get SQL server version + port #

article bug fixed when you editing SQL Agent Job

Performance issue with Data collection

concatenate string value in SQL

MSDN Technical Articles for SQL servers.

all information about SQL “Memory To Leave” area (also called MTL or “Memory To Reserve”).

First article