Edwin Sarmiento

Edwin M. Sarmiento is the Managing Director of 15C, a consulting and training company that specializes on designing, implementing and supporting SQL Server infrastructures. He is a Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures running on the Microsoft server technology stack ranging from Active Directory to SharePoint and anything in between. He is very passionate about technology but has interests in music, professional and organizational development, and leadership and management matters when not working with databases. Edwin lives up to his primary mission statement: "To help people and organizations grow and develop their full potential."
  • MSSQLTips Awards: Champion Award (100+ tips) - 2017 | Author of the Year Contender - 2020, 2017
Title Category Date
Step-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster – Part 1 Clustering2026-05-20
Automate SQL Server Database Mirroring Failover Database Mirroring2026-05-10
Switch SQL Stored Procedure Execution Context using REVERT Stored Procedures2026-05-10
Clustering SQL Server 2019 Step by Step Clustering2026-05-02
PostgreSQL High Availability Options PostgreSQL2025-08-07
Windows Server 2022 Failover Cluster Step by Step for SQL Server 2022 Clustering2025-03-12
Identify CPU Intensive SQL Queries from Implicit Conversions Performance Tuning2025-01-22
SQL Server Query Store for Query Performance History Query Store2024-10-30
Identify CPU Intensive SQL Queries with SQL Server Query Store Query Store2024-06-28
Troubleshoot SQL Server Always On Availability Groups with AGDiag Availability Groups2024-05-14
Troubleshoot SQL Always On Availability Groups with SQL LogScout Availability Groups2024-04-25
Add Nodes to SQL Server 2022 and Windows Server 2022 Failover Cluster Clustering2024-02-06
Install SQL Server 2022 on Windows Server 2022 Failover Cluster WSFC Clustering2024-01-10
PowerShell Commands to Administer Virtual Machines on Amazon AWS Amazon AWS2023-11-15
AWS Tools for PowerShell to Administer Virtual Machines Amazon AWS2023-07-12
SQL Server Best Practices Check to Assess your SQL Servers Database Administration2023-02-16
SQL Server Contained Availability Groups Configuration Availability Groups2023-01-10
Microsoft Assessment and Planning Toolkit to Inventory SQL Servers Database Administration2022-10-13
Migrate SQL Server Databases to Different Active Directory Domain Availability Groups2022-06-13
Distributed Availability Groups to Migrate SQL Server Databases – Part 2 Availability Groups2022-05-26
Distributed Availability Groups to Migrate SQL Server Databases – Part 1 Availability Groups2022-05-17
Perform Maintenance on SQL Server Availability Groups Availability Groups2021-10-19
Recursive Queries using Common Table Expressions (CTE) in SQL Server Common Table Expressions2021-10-06
Distributed Availability Groups for SQL Server Disaster Recovery Availability Groups2021-10-01
Read-Scale Always On Availability Group to Offloading Reporting Availability Groups2021-07-29
SQL Server Read-Scale Always On Availability Groups Availability Groups2021-07-01
SQL Server 2019 Cluster Setup Adding a Node Clustering2020-11-11
SQL Server 2019 Installation on Windows Server 2019 Failover Cluster Clustering2020-10-07
Configure Log Shipping for SQL Server on Linux Log Shipping2020-09-14
Introduction to PowerShell Core on Linux for the SQL Server DBA – Part 3 SQL Server on Linux2020-08-12
SQL Server 2017 Unattended Install on FCI via Command Line – Part 2 Clustering2020-08-03
SQL Server 2017 Unattended Install on FCI via Command Line – Part 1 Clustering2020-07-28
Install SQL Server 2017 on Windows Server 2016 Failover Cluster – Part 2 Clustering2020-07-13
Install SQL Server 2017 on Windows Server 2016 Failover Cluster – Part 1 Clustering2020-06-30
Slipstream Installation of Service Packs and Cumulative Updates on SQL Server 2016 and Higher Database Administration2020-06-24
Manual Failover of SQL Server Always On Distributed Availability Group for Disaster Recovery Testing Availability Groups2020-05-28
Learning PowerShell Core on Linux for the SQL Server DBA Part 2 SQL Server on Linux2020-03-24
Introduction to PowerShell Core on Linux for the SQL Server DBA Part 1 SQL Server on Linux2020-03-11
Install a Specific SQL Server Version on Linux Step by Step SQL Server on Linux2020-02-27
Update SQL Server 2017 on Linux Container Containers2020-01-30
Create SQL Server on Windows Docker Container – Part 6 Containers2019-04-11
Create SQL Server on Linux Docker Container using Dockerfile – Part 5 Containers2019-04-02
Docker Container Names, Internals and Storage for SQL Server – Part 4 Containers2019-03-20
Docker Commands with Examples for SQL Server DBAs – Part 3 Containers2019-03-07
Getting Started with Linux Containers for SQL Server – Part 2 Containers2019-02-27
Getting Started with Windows Containers for SQL Server – Part 1 Containers2019-02-14
Dedicated Network for Always On Distributed Availability Groups Data Availability Groups2018-11-30
Upgrade SQL Server FCI Using Same Virtual Network Name and Virtual IP Clustering2018-11-19
Automate SQL Server Express Backups and Deletion of Older Backup Files Express Edition2018-06-02
Check for full SQL Server database backups before creating other backups Backup2018-06-02
Install and Configure SQL Server 2017 Availability Groups on Linux – Part 5 Availability Groups2018-05-01
Install and Configure SQL Server 2017 Availability Groups on Linux – Part 4 Availability Groups2018-04-06
Install and Configure SQL Server 2017 Availability Groups on Linux – Part 3 Availability Groups2018-01-17
Install and Configure SQL Server 2017 Availability Groups on Linux – Part 2 Availability Groups2018-01-08
SQL Server 2016 on Windows 2016 FCI without Shared Storage – Part 3 Clustering2018-01-02
SQL Server 2016 on Windows 2016 FCI without Shared Storage – Part 2 Clustering2017-12-08
Configure Cloud Witness for Windows Server 2016 Failover Clusters Clustering2017-11-30
Install and Configure SQL Server 2017 Availability Groups on Linux – Part 1 Availability Groups2017-11-22
SQL Server 2016 on Windows 2016 FCI without Shared Storage – Part 1 Clustering2017-11-08
Configure Dedicated Network for SQL Always On Availability Groups Availability Groups2017-09-21
Setup SQL Server 2016 Always On Distributed Availability Groups Availability Groups2017-08-29
Create and Configure SQL Server 2016 Always On Availability Groups using Windows PowerShell Availability Groups2017-08-08
Setup SQL Server Always On Basic Availability Groups Availability Groups2017-08-01
Implement SQL 2016 Availability Group without Active Directory Part 2 Availability Groups2017-07-27
Implement SQL 2016 Availability Group without Active Directory Part 1 Availability Groups2017-07-19
Deploy a Windows Server 2016 Failover Cluster without Active Directory – Part 2 Clustering2017-07-05
Deploy Windows Server Failover Cluster without Active Directory Part 1 Clustering2017-06-27
Configure Network Binding Order for a Windows Server 2016 Failover Cluster Clustering2017-06-14
Introduction to Azure PowerShell Modules for the SQL Server DBA Part 4 Azure2017-05-04
Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster – Part 4 Clustering2017-04-26
Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster – Part 3 Clustering2017-04-20
Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster – Part 2 Clustering2017-04-13
Introduction to Azure PowerShell Modules for the SQL Server DBA Part 3 Azure2017-04-03
Install SQL Server 2016 on Windows Server 2016 Failover Cluster Clustering2017-03-21
Introduction to PolyBase in SQL Server 2016 – Part 2 Big Data2017-03-09
Introduction to PolyBase in SQL Server 2016 – Part 1 Big Data2015-11-02
Troubleshooting Common SSAS Connectivity Issues Analysis Services Administration2015-08-25
Clustering SSAS Part 2 Analysis Services Administration2015-08-19
Clustering SSAS Part 1 Clustering2015-08-07
Determine Minimum Possible Size to Shrink SQL Transaction Log File PowerShell2015-02-04
Introduction to Azure PowerShell Modules for the SQL Server DBA Part 2 Azure2015-01-21
Modify SSRS Rendering Format In SharePoint-Integrated Mode Reporting Services Configuration2014-10-28
Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 4 Clustering2014-09-23
Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 3 Clustering2014-09-15
Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 2 Clustering2014-09-04
Introduction to Azure PowerShell Modules for the SQL Server DBA Part 1 Azure2014-08-27
Force Start a Windows Server Failover Cluster Without a Quorum Clustering2014-08-22
SQL Server Networking High Availability and Disaster Recovery Best Practices Webcast Q and A High Availability2014-07-28
Configuring TDE for SQL Server Always On Availability Groups Availability Groups2013-12-31
Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 1 Clustering2013-07-17
Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell Database Configurations2013-06-10
Check DBCC CHECKDB Last Execution using PowerShell Database Console Commands DBCCs2013-05-02
Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell Availability Groups2013-03-27
Configure SQL Server Always On Availability Groups Read-Only Routing Availability Groups2013-01-29
Disable or Enable SQL Server Agent Jobs using PowerShell PowerShell2012-10-17
Check SQL Server Virtual Log Files Using PowerShell PowerShell2012-10-09
SQL Server 2012 Multi-Subnet Cluster Part 4 Clustering2012-09-06
SQL Server 2012 Multi-Subnet Cluster Part 3 Clustering2012-08-13
SQL Server 2012 Multi-Subnet Cluster Part 2 Clustering2012-07-26
SQL Server 2012 Multi-Subnet Cluster Part 1 Clustering2012-07-11
Installing SQL Server 2012 on Windows Server Core Part 3 SQL Server Configurations2012-06-28
Installing SQL Server 2012 on Windows Server Core Using PowerShell SQL Server Configurations2012-05-24
Installing SQL Server 2012 on Windows Server Core Part 1 SQL Server Configurations2012-03-27
Enable SQL Server 2012 AlwaysOn Availability Groups with PowerShell Availability Groups2012-02-20
Configuring Volume Mountpoints on a SQL Server 2008 Failover Cluster running on Windows Server 2008 Clustering2012-02-14
Fix SQL Server Agent on Windows Failover Cluster Clustering2012-01-19
Highly Available, Scale-Out SQL Server 2008 R2 Reporting Services Farm Reporting Services Performance2011-11-15
Building a Scale Out SSRS 2008 R2 Farm using Windows NLB Part 4 Reporting Services Network Load Balancing2011-11-08
Scale Out SQL 2008 R2 Reporting Services Farm using Windows NLB Part 3 Reporting Services Network Load Balancing2011-11-01
Introduction to PowerPivot for Excel and SQL Server Microsoft Excel Integration2011-06-27
Scale Out SSRS R2 Farm using Windows Network Load Balancing Part 2 Reporting Services Network Load Balancing2011-03-28
Scale Out SQL Server 2008 R2 Reporting Services Farm using NLB Part 1 Reporting Services Network Load Balancing2011-03-24
Find SQL Server Instances Across Your Network Using Windows PowerShell PowerShell2010-05-20
Retrieve Default SQL Server Backup Folder using PowerShell PowerShell2010-04-15
Connect to SQL Server with PowerShell and SQL Server Authentication PowerShell2010-02-22
Install SSRS 32 bit on a 64 bit Windows Server Reporting Services Installation2009-11-13
Backup SQL Server Databases with a Windows PowerShell Script PowerShell2009-10-20
Generating SQL Scripts using Windows PowerShell PowerShell2009-09-22
Creating LINQ to SQL Object Models using SqlMetal Language Integrated Query LINQ2009-08-27
Checking SQL Server Agent jobs using Windows PowerShell PowerShell2009-07-21
Check the Last SQL Server Backup Date using Windows PowerShell PowerShell2009-07-01
Retrieve List of SQL Server Databases and Properties with PowerShell PowerShell2009-05-26
Using PowerShell with SQL Server Management Objects (SMO) PowerShell2009-05-06
Install SQL Server 2008 on a Windows Server 2008 Cluster Part 4 Clustering2009-04-02
Install SQL Server 2008 on a Windows Server 2008 Cluster Part 3 Clustering2009-03-17
Implementing Database Mirroring in SQL Server 2005 across domains Database Mirroring2009-03-11
Introduction to Windows PowerShell for the SQL Server DBA Part 2 PowerShell2009-03-09
Install SQL Server 2008 on a Windows Server 2008 Cluster Part 2 Clustering2009-03-02
Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1 Clustering2009-02-13
Introduction to Windows PowerShell for the SQL Server DBA Part 1 PowerShell2009-02-04
Using the SQL Server Surface Area Configuration Command Line Tool Surface Area Configuration Manager2009-01-29
Extend the REVERT statement using the WITH COOKIE clause in SQL Server Security2009-01-06
SQL Server 2008 TSQL Auditing Commands for SELECT statements Auditing and Compliance2008-12-30
Page Level Restore as a Disaster Recovery Procedure in SQL Server Disaster Recovery2008-12-12
An alternative to SQL Server email alerts Database Mail2008-11-12
SQL Server Partitioned Tables with Multiple Filegroups for HA Disaster Recovery2008-11-06
Isolating Critical Objects for SQL Server Disaster Recovery Procedures Disaster Recovery2008-10-27
Disaster Recovery Procedures in SQL Server 2005 Disaster Recovery2008-10-01
Implementing Data Compression in SQL Server 2008 Compression2008-09-12
Administering your Windows Internal Database MICROSOFT##SSEE instance Database Administration2008-09-05
Configuring Windows Instant File Initialization for SQL Server 2005 Database Administration2008-08-28
Using the EventData() Function with DDL triggers in SQL Server 2005 Triggers2008-08-27
SQL Server backup and restore of the Resource database Backup2008-07-21
Using Stored Procedures with LINQ to SQL Language Integrated Query LINQ2008-07-17
Querying SQL Server databases using LINQ to SQL Language Integrated Query LINQ2008-07-07
Reading XML documents using LINQ to XML Language Integrated Query LINQ2008-06-24
Automate Restoration of Log Shipping Databases for Failover in SQL Server Log Shipping2008-06-10
Exploring Database Backup Compression in SQL Server 2008 Compression2008-06-05
Implementing Transparent Data Encryption in SQL Server 2008 Encryption2008-05-28
Introduction to Language Integrated Query (LINQ) Language Integrated Query LINQ2008-05-20
Evaluate and Implement Policies in Multiple SQL Server Instances Policy Based Management2008-05-07