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."
2020 Awards
2017 Awards
2014 Awards
2013 Awards
2009 Awards
Analysis Services Administration
- Clustering SQL Server Analysis Services Part 2 (last update: 8/19/2015)
- Troubleshooting Common SQL Server Analysis Services Connectivity Issues (last update: 8/25/2015)
Auditing and Compliance
- SQL Server 2008 TSQL Auditing Commands for SELECT statements (last update: 12/30/2008)
Availability Groups
- Configure a Dedicated Network Adapter for SQL Server Always On Distributed Availability Groups Data Replication Traffic (last update: 11/30/2018)
- Configure a Read-Scale Always On Availability Group on Windows for Offloading Reporting and Analytical Workloads (last update: 7/29/2021)
- Configure Distributed Availability Groups for SQL Server Disaster Recovery with Failover Clustering (last update: 10/1/2021)
- Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell (last update: 3/27/2013)
- Configure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using T-SQL (last update: 1/29/2013)
- Configuring a Dedicated Network for SQL Server Always On Availability Groups Data Replication Traffic (last update: 9/21/2017)
- Configuring Transparent Data Encryption with SQL Server 2012 AlwaysOn Availability Groups (last update: 12/31/2013)
- Create and Configure SQL Server 2016 Always On Availability Groups using Windows PowerShell (last update: 8/8/2017)
- Enable SQL Server 2012 AlwaysOn Availability Groups Using Windows PowerShell (last update: 2/20/2012)
- Implement a SQL Server 2016 Availability Group without Active Directory Part 1 (last update: 7/19/2017)
- Implement a SQL Server 2016 Availability Group without Active Directory Part 2 (last update: 7/27/2017)
- Install and Configure SQL Server 2017 Availability Groups on Linux - Part 1 (last update: 11/22/2017)
- Install and Configure SQL Server 2017 Availability Groups on Linux - Part 2 (last update: 1/8/2018)
- Install and Configure SQL Server 2017 Availability Groups on Linux - Part 3 (last update: 1/17/2018)
- Install and Configure SQL Server 2017 Availability Groups on Linux - Part 4 (last update: 4/6/2018)
- Install and Configure SQL Server 2017 Availability Groups on Linux - Part 5 (last update: 5/1/2018)
- Manual Failover of SQL Server Always On Distributed Availability Group for Disaster Recovery Testing (last update: 5/28/2020)
- Setup and Implement SQL Server 2016 Always On Basic Availability Groups (last update: 8/1/2017)
- Setup and Implement SQL Server 2016 Always On Distributed Availability Groups (last update: 8/29/2017)
- SQL Server Availability Group Maintenance with Distributed Availability Groups (last update: 10/19/2021)
- Step-by-step Configuration of SQL Server Read-Scale Always On Availability Group on Windows for Disaster Recovery (last update: 7/1/2021)
Azure
- Introduction to Azure PowerShell Modules for the SQL Server DBA Part 1 (last update: 8/27/2014)
- Introduction to Azure PowerShell Modules for the SQL Server DBA Part 2 (last update: 1/21/2015)
- Introduction to Azure PowerShell Modules for the SQL Server DBA Part 3 (last update: 4/3/2017)
- Introduction to Azure PowerShell Modules for the SQL Server DBA Part 4 (last update: 5/4/2017)
Backup
- Check for full SQL Server database backups before creating other backups (last update: 6/2/2018)
- SQL Server backup and restore of the Resource database (last update: 7/21/2008)
Big Data
- Introduction to PolyBase in SQL Server 2016 - Part 1 (last update: 11/2/2015)
- Introduction to PolyBase in SQL Server 2016 - Part 2 (last update: 3/9/2017)
Clustering
- Clustering SQL Server Analysis Services Part 1 (last update: 8/7/2015)
- Configure Cloud Witness for Windows Server 2016 Failover Clusters (last update: 11/30/2017)
- Configure Network Binding Order for a Windows Server 2016 Failover Cluster (last update: 6/14/2017)
- Configuring Volume Mountpoints on a SQL Server 2008 Failover Cluster running on Windows Server 2008 (last update: 2/14/2012)
- Deploy a Windows Server 2016 Failover Cluster without Active Directory - Part 1 (last update: 6/27/2017)
- Deploy a Windows Server 2016 Failover Cluster without Active Directory - Part 2 (last update: 7/5/2017)
- Fix SQL Server Agent on Windows Failover Cluster (last update: 1/19/2012)
- Force Start a Windows Server Failover Cluster without a Quorum to bring a SQL Server Failover Clustered Instance Online (last update: 8/22/2014)
- Install SQL Server 2008 on a Windows Server 2008 Cluster Part 1 (last update: 2/13/2009)
- Install SQL Server 2008 on a Windows Server 2008 Cluster Part 2 (last update: 3/2/2009)
- Install SQL Server 2008 on a Windows Server 2008 Cluster Part 3 (last update: 3/17/2009)
- Install SQL Server 2008 on a Windows Server 2008 Cluster Part 4 (last update: 4/2/2009)
- Install SQL Server 2017 on Windows Server 2016 Failover Cluster - Part 1 (last update: 6/30/2020)
- Install SQL Server 2017 on Windows Server 2016 Failover Cluster - Part 2 (last update: 7/13/2020)
- Installing SQL Server 2016 on a Windows Server 2016 Failover Cluster without Shared Storage - Part 1 (last update: 11/8/2017)
- Installing SQL Server 2016 on a Windows Server 2016 Failover Cluster without Shared Storage - Part 2 (last update: 12/8/2017)
- Installing SQL Server 2016 on a Windows Server 2016 Failover Cluster without Shared Storage - Part 3 (last update: 1/2/2018)
- Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 1 (last update: 7/17/2013)
- Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 2 (last update: 9/4/2014)
- Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 3 (last update: 9/15/2014)
- Installing, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 4 (last update: 9/23/2014)
- SQL Server 2012 Multi-Subnet Cluster Part 1 (last update: 7/11/2012)
- SQL Server 2012 Multi-Subnet Cluster Part 2 (last update: 7/26/2012)
- SQL Server 2012 Multi-Subnet Cluster Part 3 (last update: 8/13/2012)
- SQL Server 2012 Multi-Subnet Cluster Part 4 (last update: 9/6/2012)
- SQL Server 2017 Unattended Installation on a Windows Server 2016 Failover Cluster via Command Line Part 1 (last update: 7/28/2020)
- SQL Server 2017 Unattended Installation on a Windows Server 2016 Failover Cluster via Command Line Part 2 (last update: 8/3/2020)
- Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 1 (last update: 3/21/2017)
- Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 2 (last update: 4/13/2017)
- Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 3 (last update: 4/20/2017)
- Step-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4 (last update: 4/26/2017)
- Step-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 1 (last update: 9/1/2020)
- Step-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 2 (last update: 10/7/2020)
- Step-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 3 (last update: 10/21/2020)
- Step-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 4 (last update: 11/11/2020)
- Upgrade or Migrate a SQL Server Failover Clustered Instance While Using the Same Virtual Network Name and Virtual IP Address (Option 1) (last update: 11/19/2018)
Common Table Expressions
- Recursive Queries using Common Table Expressions (CTE) in SQL Server (last update: 10/6/2021)
Compression
- Exploring Database Backup Compression in SQL Server 2008 (last update: 6/5/2008)
- Implementing Data Compression in SQL Server 2008 (last update: 9/12/2008)
Containers
- Create SQL Server on Linux Docker Container using Dockerfile - Part 5 (last update: 4/2/2019)
- Create SQL Server on Windows Docker Container using Dockerfile - Part 6 (last update: 4/11/2019)
- Docker Commands with Examples for SQL Server DBAs - Part 3 (last update: 3/7/2019)
- Docker Container Names, Internals and Configuring Storage for SQL Server - Part 4 (last update: 3/20/2019)
- Getting Started with Linux Containers for SQL Server - Part 2 (last update: 2/27/2019)
- Getting Started with Windows Containers for SQL Server - Part 1 (last update: 2/14/2019)
- Update SQL Server 2017 on Linux Container (last update: 1/30/2020)
Database Administration
- Configuring Windows Instant File Initialization for SQL Server 2005 (last update: 8/28/2008)
- Slipstream Installation of Service Packs and Cumulative Updates on SQL Server 2016 and Higher (last update: 6/24/2020)
Database Configurations
- Check If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell (last update: 6/10/2013)
Database Console Commands DBCCs
- Check DBCC CHECKDB Last Execution using PowerShell (last update: 5/2/2013)
Database Mail
- An alternative to SQL Server email alerts (last update: 11/12/2008)
Database Mirroring
- Automate SQL Server Database Mirroring Failover for Multiple Databases With No Witness (last update: 3/5/2009)
- Implementing Database Mirroring in SQL Server 2005 across domains (last update: 3/11/2009)
Disaster Recovery
- Disaster Recovery Procedures in SQL Server 2005 (last update: 10/1/2008)
- Isolating Critical Objects for SQL Server Disaster Recovery Procedures (last update: 10/27/2008)
- SQL Server Partitioned Tables with Multiple Filegroups for High Availability (last update: 11/6/2008)
- Using Page Level Restore as a Disaster Recovery Procedure in SQL Server 2005 (last update: 12/12/2008)
Encryption
- Implementing Transparent Data Encryption in SQL Server 2008 (last update: 5/28/2008)
Express Edition
- Automate SQL Server Express Backups and Deletion of Older Backup Files (last update: 6/2/2018)
High Availability
- SQL Server Networking High Availability and Disaster Recovery Best Practices Webcast Q and A (last update: 7/28/2014)
Language Integrated Query LINQ
- Creating LINQ to SQL Object Models using SqlMetal (last update: 8/27/2009)
- Introduction to Language Integrated Query (LINQ) (last update: 5/20/2008)
- Querying SQL Server databases using LINQ to SQL (last update: 7/7/2008)
- Reading XML documents using LINQ to XML (last update: 6/24/2008)
- Using Stored Procedures with LINQ to SQL (last update: 7/17/2008)
Log Shipping
- Automate Restoration of Log Shipping Databases for Failover in SQL Server (last update: 6/10/2008)
- Configure Log Shipping for SQL Server on Linux (last update: 9/14/2020)
Microsoft Excel Integration
- Introduction to PowerPivot for Excel and SQL Server (last update: 6/27/2011)
Policy Based Management
- Evaluate and Implement Policies in Multiple SQL Server Instances (last update: 5/7/2008)
PowerShell
- Backup SQL Server Databases with a Windows PowerShell Script (last update: 10/20/2009)
- Check SQL Server Virtual Log Files Using PowerShell (last update: 10/9/2012)
- Check the Last SQL Server Backup Date using Windows PowerShell (last update: 7/1/2009)
- Checking SQL Server Agent jobs using Windows PowerShell (last update: 7/21/2009)
- Connect to SQL Server via Windows PowerShell with SQL Server authentication (last update: 2/22/2010)
- Determine Minimum Possible Size to Shrink the SQL Server Transaction Log File (last update: 2/4/2015)
- Disable or Enable SQL Server Agent Jobs using PowerShell (last update: 10/17/2012)
- Find SQL Server Instances Across Your Network Using Windows PowerShell (last update: 5/20/2010)
- Generating SQL Scripts using Windows PowerShell (last update: 9/22/2009)
- Introduction to Windows PowerShell for the SQL Server DBA Part 1 (last update: 2/4/2009)
- Introduction to Windows PowerShell for the SQL Server DBA Part 2 (last update: 3/9/2009)
- Retrieve a List of SQL Server Databases and their Properties using PowerShell (last update: 5/26/2009)
- Retrieve Default SQL Server Backup Folder using PowerShell (last update: 4/15/2010)
- Using PowerShell with SQL Server Management Objects (SMO) (last update: 5/6/2009)
Reporting Services Configuration
- Modify SQL Server Reporting Services Rendering Format In SharePoint-Integrated Mode (last update: 10/28/2014)
Reporting Services Installation
- Install and Configure SQL Server Reporting Services 2012 SP1 and 2014 in SharePoint Integrated Mode Part 1 (last update: 1/26/2015)
- Install SQL Server Reporting Services 32 bit on a 64 bit Windows Server (last update: 11/13/2009)
- Installing and Configuring Reporting Services 2012 SP1 or 2014 in SharePoint-Integrated Mode Part 2 (last update: 3/11/2015)
Reporting Services Network Load Balancing
- Build a Scale Out SQL 2008 R2 Reporting Services Farm using Windows NLB Part 3 (last update: 11/1/2011)
- Building a Scale Out SSRS 2008 R2 Farm using Windows NLB Part 4 (last update: 11/8/2011)
- Scale Out SQL Server 2008 R2 Reporting Services Farm using NLB Part 1 (last update: 3/24/2011)
- Scale Out SSRS R2 Farm using Windows Network Load Balancing Part 2 (last update: 3/28/2011)
Reporting Services Performance
- Highly Available, Scale-Out SQL Server 2008 R2 Reporting Services Farm (last update: 11/15/2011)
Security
- Extend the REVERT statement using the WITH COOKIE clause in SQL Server (last update: 1/6/2009)
SharePoint
- Configuring Alternate Access Mapping in SharePoint 2010 using Windows PowerShell (last update: 4/14/2011)
- Installing SharePoint Foundation 2010 on a Single Server - Part 1 (last update: 5/4/2010)
- Rename SharePoint Content Database (last update: 5/14/2013)
- Renaming the SharePoint Admin Content Database to Follow SQL Server Naming Conventions (last update: 6/14/2012)
SharePoint Administration
- Installing SharePoint Foundation 2010 on a Single Server - Part 2 (last update: 7/6/2010)
SharePoint Configuration
- Configuring Alternate Access Mapping in SharePoint 2010 (last update: 3/17/2011)
- Slipstream Office SharePoint Server 2007 Service Packs for Windows Server 2008 R2 (last update: 3/17/2010)
SQL Server Configurations
- Installing SQL Server 2012 on Windows Server Core Part 1 (last update: 3/27/2012)
- Installing SQL Server 2012 on Windows Server Core Part 3 (last update: 6/28/2012)
- Installing SQL Server 2012 on Windows Server Core Using PowerShell (last update: 5/24/2012)
SQL Server on Linux
- Install a Specific SQL Server Version on Linux Step by Step (last update: 2/27/2020)
- Introduction to PowerShell Core on Linux for the SQL Server DBA - Part 3 (last update: 8/12/2020)
- Introduction to PowerShell Core on Linux for the SQL Server DBA Part 1 (last update: 3/11/2020)
- Learning PowerShell Core on Linux for the SQL Server DBA Part 2 (last update: 3/24/2020)
Stored Procedures
- Switching Stored Procedure Execution Context in SQL Server using the REVERT clause (last update: 9/9/2008)
Surface Area Configuration Manager
- Using the SQL Server Surface Area Configuration Command Line Tool (last update: 1/29/2009)
Triggers
- Using the EventData() Function with DDL triggers in SQL Server 2005 (last update: 8/27/2008)
Upgrades and Migrations
- Slipstream Service Packs and Cumulative Updates on a SQL Server 2008 Installation (last update: 12/16/2009)
Windows Internal Database
- Administering your Windows Internal Database MICROSOFT##SSEE instance (last update: 9/5/2008)
