Edwin Sarmiento

Edwin M Sarmiento is a Microsoft SQL Server MVP and Microsoft Certified Master from Ottawa, Canada specializing in high availability, disaster recovery and system infrastructures.

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

CategoryTitle
Analysis Services AdministrationClustering SQL Server Analysis Services Part 2
Analysis Services AdministrationTroubleshooting Common SQL Server Analysis Services Connectivity Issues
Auditing and ComplianceSQL Server 2008 TSQL Auditing Commands for SELECT statements
Availability GroupsBuild Distributed Availability Groups to migrate SQL Server databases to a different AD Domain - Part 2
Availability GroupsConfigure a Dedicated Network Adapter for SQL Server Always On Distributed Availability Groups Data Replication Traffic
Availability GroupsConfigure a Read-Scale Always On Availability Group on Windows for Offloading Reporting and Analytical Workloads
Availability GroupsConfigure Distributed Availability Groups Between Failover Clusters on Different Active Directory Domains - Part 3
Availability GroupsConfigure Distributed Availability Groups for SQL Server Disaster Recovery with Failover Clustering
Availability GroupsConfigure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using PowerShell
Availability GroupsConfigure SQL Server 2012 AlwaysOn Availability Groups Read-Only Routing using T-SQL
Availability GroupsConfiguring a Dedicated Network for SQL Server Always On Availability Groups Data Replication Traffic
Availability GroupsConfiguring Distributed Availability Groups Between Failover Clusters on Different Active Directory Domains Part 1
Availability GroupsConfiguring Transparent Data Encryption with SQL Server 2012 AlwaysOn Availability Groups
Availability GroupsCreate and Configure SQL Server 2016 Always On Availability Groups using Windows PowerShell
Availability GroupsEnable SQL Server 2012 AlwaysOn Availability Groups Using Windows PowerShell
Availability GroupsImplement a SQL Server 2016 Availability Group without Active Directory Part 1
Availability GroupsImplement a SQL Server 2016 Availability Group without Active Directory Part 2
Availability GroupsInstall and Configure SQL Server 2017 Availability Groups on Linux - Part 1
Availability GroupsInstall and Configure SQL Server 2017 Availability Groups on Linux - Part 2
Availability GroupsInstall and Configure SQL Server 2017 Availability Groups on Linux - Part 3
Availability GroupsInstall and Configure SQL Server 2017 Availability Groups on Linux - Part 4
Availability GroupsInstall and Configure SQL Server 2017 Availability Groups on Linux - Part 5
Availability GroupsManual Failover of SQL Server Always On Distributed Availability Group for Disaster Recovery Testing
Availability GroupsSetup and Implement SQL Server 2016 Always On Basic Availability Groups
Availability GroupsSetup and Implement SQL Server 2016 Always On Distributed Availability Groups
Availability GroupsSQL Server Availability Group Maintenance with Distributed Availability Groups
Availability GroupsStep-by-step Configuration of SQL Server Read-Scale Always On Availability Group on Windows for Disaster Recovery
AzureIntroduction to Azure PowerShell Modules for the SQL Server DBA Part 1
AzureIntroduction to Azure PowerShell Modules for the SQL Server DBA Part 2
AzureIntroduction to Azure PowerShell Modules for the SQL Server DBA Part 3
AzureIntroduction to Azure PowerShell Modules for the SQL Server DBA Part 4
BackupCheck for full SQL Server database backups before creating other backups
BackupSQL Server backup and restore of the Resource database
Big DataIntroduction to PolyBase in SQL Server 2016 - Part 1
Big DataIntroduction to PolyBase in SQL Server 2016 - Part 2
ClusteringClustering SQL Server Analysis Services Part 1
ClusteringConfigure Cloud Witness for Windows Server 2016 Failover Clusters
ClusteringConfigure Network Binding Order for a Windows Server 2016 Failover Cluster
ClusteringConfiguring Volume Mountpoints on a SQL Server 2008 Failover Cluster running on Windows Server 2008
ClusteringDeploy a Windows Server 2016 Failover Cluster without Active Directory - Part 1
ClusteringDeploy a Windows Server 2016 Failover Cluster without Active Directory - Part 2
ClusteringFix SQL Server Agent on Windows Failover Cluster
ClusteringForce Start a Windows Server Failover Cluster without a Quorum to bring a SQL Server Failover Clustered Instance Online
ClusteringInstall SQL Server 2008 on a Windows Server 2008 Cluster Part 1
ClusteringInstall SQL Server 2008 on a Windows Server 2008 Cluster Part 2
ClusteringInstall SQL Server 2008 on a Windows Server 2008 Cluster Part 3
ClusteringInstall SQL Server 2008 on a Windows Server 2008 Cluster Part 4
ClusteringInstall SQL Server 2017 on Windows Server 2016 Failover Cluster - Part 1
ClusteringInstall SQL Server 2017 on Windows Server 2016 Failover Cluster - Part 2
ClusteringInstalling SQL Server 2016 on a Windows Server 2016 Failover Cluster without Shared Storage - Part 1
ClusteringInstalling SQL Server 2016 on a Windows Server 2016 Failover Cluster without Shared Storage - Part 2
ClusteringInstalling SQL Server 2016 on a Windows Server 2016 Failover Cluster without Shared Storage - Part 3
ClusteringInstalling, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 1
ClusteringInstalling, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 2
ClusteringInstalling, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 3
ClusteringInstalling, Configuring and Managing Windows Server Failover Cluster using PowerShell Part 4
ClusteringSQL Server 2012 Multi-Subnet Cluster Part 1
ClusteringSQL Server 2012 Multi-Subnet Cluster Part 2
ClusteringSQL Server 2012 Multi-Subnet Cluster Part 3
ClusteringSQL Server 2012 Multi-Subnet Cluster Part 4
ClusteringSQL Server 2017 Unattended Installation on a Windows Server 2016 Failover Cluster via Command Line Part 1
ClusteringSQL Server 2017 Unattended Installation on a Windows Server 2016 Failover Cluster via Command Line Part 2
ClusteringStep-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 1
ClusteringStep-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 2
ClusteringStep-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 3
ClusteringStep-by-step Installation of SQL Server 2016 on a Windows Server 2016 Failover Cluster - Part 4
ClusteringStep-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 1
ClusteringStep-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 2
ClusteringStep-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 3
ClusteringStep-by-step Installation of SQL Server 2019 on a Windows Server 2019 Failover Cluster - Part 4
ClusteringUpgrade or Migrate a SQL Server Failover Clustered Instance While Using the Same Virtual Network Name and Virtual IP Address (Option 1)
Common Table ExpressionsRecursive Queries using Common Table Expressions (CTE) in SQL Server
CompressionExploring Database Backup Compression in SQL Server 2008
CompressionImplementing Data Compression in SQL Server 2008
ContainersCreate SQL Server on Linux Docker Container using Dockerfile - Part 5
ContainersCreate SQL Server on Windows Docker Container using Dockerfile - Part 6
ContainersDocker Commands with Examples for SQL Server DBAs - Part 3
ContainersDocker Container Names, Internals and Configuring Storage for SQL Server - Part 4
ContainersGetting Started with Linux Containers for SQL Server - Part 2
ContainersGetting Started with Windows Containers for SQL Server - Part 1
ContainersUpdate SQL Server 2017 on Linux Container
Database AdministrationConfiguring Windows Instant File Initialization for SQL Server 2005
Database AdministrationSlipstream Installation of Service Packs and Cumulative Updates on SQL Server 2016 and Higher
Database ConfigurationsCheck If a SQL Server Database Is In Pseudo-Simple Recovery Model Using Windows PowerShell
Database Console Commands DBCCsCheck DBCC CHECKDB Last Execution using PowerShell
Database MailAn alternative to SQL Server email alerts
Database MirroringAutomate SQL Server Database Mirroring Failover for Multiple Databases With No Witness
Database MirroringImplementing Database Mirroring in SQL Server 2005 across domains
Disaster RecoveryDisaster Recovery Procedures in SQL Server 2005
Disaster RecoveryIsolating Critical Objects for SQL Server Disaster Recovery Procedures
Disaster RecoverySQL Server Partitioned Tables with Multiple Filegroups for High Availability
Disaster RecoveryUsing Page Level Restore as a Disaster Recovery Procedure in SQL Server 2005
EncryptionImplementing Transparent Data Encryption in SQL Server 2008
Express EditionAutomate SQL Server Express Backups and Deletion of Older Backup Files
High AvailabilitySQL Server Networking High Availability and Disaster Recovery Best Practices Webcast Q and A
Language Integrated Query LINQCreating LINQ to SQL Object Models using SqlMetal
Language Integrated Query LINQIntroduction to Language Integrated Query (LINQ)
Language Integrated Query LINQQuerying SQL Server databases using LINQ to SQL
Language Integrated Query LINQReading XML documents using LINQ to XML
Language Integrated Query LINQUsing Stored Procedures with LINQ to SQL
Log ShippingAutomate Restoration of Log Shipping Databases for Failover in SQL Server
Log ShippingConfigure Log Shipping for SQL Server on Linux
Microsoft Excel IntegrationIntroduction to PowerPivot for Excel and SQL Server
Policy Based ManagementEvaluate and Implement Policies in Multiple SQL Server Instances
PowerShellBackup SQL Server Databases with a Windows PowerShell Script
PowerShellCheck SQL Server Virtual Log Files Using PowerShell
PowerShellCheck the Last SQL Server Backup Date using Windows PowerShell
PowerShellChecking SQL Server Agent jobs using Windows PowerShell
PowerShellConnect to SQL Server via Windows PowerShell with SQL Server authentication
PowerShellDetermine Minimum Possible Size to Shrink the SQL Server Transaction Log File
PowerShellDisable or Enable SQL Server Agent Jobs using PowerShell
PowerShellFind SQL Server Instances Across Your Network Using Windows PowerShell
PowerShellGenerating SQL Scripts using Windows PowerShell
PowerShellIntroduction to Windows PowerShell for the SQL Server DBA Part 1
PowerShellIntroduction to Windows PowerShell for the SQL Server DBA Part 2
PowerShellRetrieve a List of SQL Server Databases and their Properties using PowerShell
PowerShellRetrieve Default SQL Server Backup Folder using PowerShell
PowerShellUsing PowerShell with SQL Server Management Objects (SMO)
Reporting Services ConfigurationModify SQL Server Reporting Services Rendering Format In SharePoint-Integrated Mode
Reporting Services InstallationInstall and Configure SQL Server Reporting Services 2012 SP1 and 2014 in SharePoint Integrated Mode Part 1
Reporting Services InstallationInstall SQL Server Reporting Services 32 bit on a 64 bit Windows Server
Reporting Services InstallationInstalling and Configuring Reporting Services 2012 SP1 or 2014 in SharePoint-Integrated Mode Part 2
Reporting Services Network Load BalancingBuild a Scale Out SQL 2008 R2 Reporting Services Farm using Windows NLB Part 3
Reporting Services Network Load BalancingBuilding a Scale Out SSRS 2008 R2 Farm using Windows NLB Part 4
Reporting Services Network Load BalancingScale Out SQL Server 2008 R2 Reporting Services Farm using NLB Part 1
Reporting Services Network Load BalancingScale Out SSRS R2 Farm using Windows Network Load Balancing Part 2
Reporting Services PerformanceHighly Available, Scale-Out SQL Server 2008 R2 Reporting Services Farm
SecurityExtend the REVERT statement using the WITH COOKIE clause in SQL Server
SharePointConfiguring Alternate Access Mapping in SharePoint 2010 using Windows PowerShell
SharePointInstalling SharePoint Foundation 2010 on a Single Server - Part 1
SharePointRename SharePoint Content Database
SharePointRenaming the SharePoint Admin Content Database to Follow SQL Server Naming Conventions
SharePoint AdministrationInstalling SharePoint Foundation 2010 on a Single Server - Part 2
SharePoint ConfigurationConfiguring Alternate Access Mapping in SharePoint 2010
SharePoint ConfigurationSlipstream Office SharePoint Server 2007 Service Packs for Windows Server 2008 R2
SQL Server ConfigurationsInstalling SQL Server 2012 on Windows Server Core Part 1
SQL Server ConfigurationsInstalling SQL Server 2012 on Windows Server Core Part 3
SQL Server ConfigurationsInstalling SQL Server 2012 on Windows Server Core Using PowerShell
SQL Server on LinuxInstall a Specific SQL Server Version on Linux Step by Step
SQL Server on LinuxIntroduction to PowerShell Core on Linux for the SQL Server DBA - Part 3
SQL Server on LinuxIntroduction to PowerShell Core on Linux for the SQL Server DBA Part 1
SQL Server on LinuxLearning PowerShell Core on Linux for the SQL Server DBA Part 2
Stored ProceduresSwitching Stored Procedure Execution Context in SQL Server using the REVERT clause
Surface Area Configuration ManagerUsing the SQL Server Surface Area Configuration Command Line Tool
TriggersUsing the EventData() Function with DDL triggers in SQL Server 2005
Upgrades and MigrationsSlipstream Service Packs and Cumulative Updates on a SQL Server 2008 Installation
Windows Internal DatabaseAdministering your Windows Internal Database MICROSOFT##SSEE instance
No Records Found
CategoryGroupCategory (articles)
Analysis ServicesAnalysis Services Administration (31)
Analysis ServicesAnalysis Services Development (95)
Analysis ServicesAnalysis Services Dimensions (16)
Analysis ServicesAnalysis Services Measure Groups (7)
Analysis ServicesAnalysis Services Performance (14)
Analysis ServicesAnalysis Services Security (7)
Analysis ServicesAnalysis Services Tools (1)
Analysis ServicesAnalysis Services Tutorials (6)
Analysis ServicesCortana (5)
Analysis ServicesPerformance Point (4)
Business IntelligenceBig Data (23)
Business IntelligenceData Warehousing (4)
CloudAmazon AWS (45)
CloudApache Spark (3)
CloudAzure (187)
CloudAzure Backup and Restore (25)
CloudAzure Cosmos DB (11)
CloudAzure Data Factory (68)
CloudAzure Databricks (23)
CloudAzure Integration Services (14)
CloudAzure Synapse Analytics (35)
CloudCloud Strategy (3)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (74)
Database AdministrationBackup (78)
Database AdministrationCentral Management Servers (9)
Database AdministrationClustering (73)
Database AdministrationComparison Data and Objects (14)
Database AdministrationCompression (21)
Database AdministrationContained Databases (4)
Database AdministrationContainers (12)
Database AdministrationDatabase Administration (189)
Database AdministrationDatabase Configurations (17)
Database AdministrationDatabase Console Commands DBCCs (25)
Database AdministrationDatabase Mail (18)
Database AdministrationDatabase Mirroring (33)
Database AdministrationDBA Best Practices (39)
Database AdministrationDedicated Administrator Connection (4)
Database AdministrationDeprecated Features (5)
Database AdministrationDevOps (34)
Database AdministrationDisaster Recovery (23)
Database AdministrationError Logs (10)
Database AdministrationExpress Edition (16)
Database AdministrationExtended Events (22)
Database AdministrationFILESTREAM (9)
Database AdministrationFragmentation and Index Maintenance (27)
Database AdministrationHardware (13)
Database AdministrationHigh Availability (3)
Database AdministrationIndexing (82)
Database AdministrationInstall and Uninstall (32)
Database AdministrationLicensing (4)
Database AdministrationLinked Servers (18)
Database AdministrationLocking and Blocking (38)
Database AdministrationLog Shipping (18)
Database AdministrationMaintenance (34)
Database AdministrationMonitoring (115)
Database AdministrationOther Database Platforms (69)
Database AdministrationPartitioning (15)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (121)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (128)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (41)
Database AdministrationSQL Server 2016 (100)
Database AdministrationSQL Server 2017 (44)
Database AdministrationSQL Server 2019 (19)
Database AdministrationSQL Server 2022 (3)
Database AdministrationSQL Server Configurations (75)
Database AdministrationSQL Server on Linux (76)
Database AdministrationStreamInsight (2)
Database AdministrationSystem Databases (31)
Database AdministrationUpgrades and Migrations (54)
Database AdministrationVirtualization (25)
Database AdministrationWindows Internal Database (1)
Database DevelopmentApplication Development (36)
Database DevelopmentChange Data Capture (15)
Database DevelopmentCommon Runtime Language (12)
Database DevelopmentCommon Table Expressions (3)
Database DevelopmentConstraints (20)
Database DevelopmentData Cleansing for Validation (2)
Database DevelopmentData Science (3)
Database DevelopmentData Types (17)
Database DevelopmentDatabase Design (68)
Database DevelopmentDates (47)
Database DevelopmentDebugging (4)
Database DevelopmentDynamic Management Views and Functions (33)
Database DevelopmentDynamic SQL (7)
Database DevelopmentEntity Framework (13)
Database DevelopmentError Handling (8)
Database DevelopmentFull Text Search (21)
Database DevelopmentFunctions System (65)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (76)
Database DevelopmentIn Memory OLTP (32)
Database DevelopmentJOIN Tables (21)
Database DevelopmentLanguage Integrated Query LINQ (7)
Database DevelopmentMicrosoft Access Integration (8)
Database DevelopmentMicrosoft Excel Integration (39)
Database DevelopmentMicrosoft Flow (1)
Database DevelopmentPaging (5)
Database DevelopmentPython (38)
Database DevelopmentQuery Optimization (14)
Database DevelopmentQuery Plans (20)
Database DevelopmentR Language (11)
Database DevelopmentScripts (35)
Database DevelopmentService Broker (11)
Database DevelopmentSpatial Data Storage (9)
Database DevelopmentSQL Injection (5)
Database DevelopmentSQL Server Management Objects SMO (3)
Database DevelopmentStored Procedures (27)
Database DevelopmentSynonyms (4)
Database DevelopmentTable Valued Parameters (4)
Database DevelopmentTemp Tables (9)
Database DevelopmentTemporal Tables (13)
Database DevelopmentTesting (31)
Database DevelopmentTransactions (8)
Database DevelopmentTriggers (44)
Database DevelopmentTSQL (301)
Database DevelopmentUser Defined Type UDT (3)
Database DevelopmentViews (13)
Database DevelopmentXML (14)
Integration ServicesData Transformation Services (5)
Integration ServicesIntegration Services Administration (10)
Integration ServicesIntegration Services Analysis Services Tasks (5)
Integration ServicesIntegration Services Best Practices (11)
Integration ServicesIntegration Services Configuration Options (21)
Integration ServicesIntegration Services Connection Managers (5)
Integration ServicesIntegration Services Control Flow Transformations (14)
Integration ServicesIntegration Services Data Flow Transformations (19)
Integration ServicesIntegration Services Development (107)
Integration ServicesIntegration Services Email (3)
Integration ServicesIntegration Services Error Handling (8)
Integration ServicesIntegration Services Excel (14)
Integration ServicesIntegration Services Execute Package Options (8)
Integration ServicesIntegration Services Import and Export Wizard (2)
Integration ServicesIntegration Services NULL Management (4)
Integration ServicesIntegration Services Oracle (4)
Integration ServicesIntegration Services Performance (12)
Integration ServicesIntegration Services Security (7)
Integration ServicesIntegration Services Upgrade (4)
Power PlatformPower Apps (17)
Power PlatformPower BI (128)
Power PlatformPower BI Charts (44)
Power PlatformPower BI Formatting (15)
Professional DevelopmentProfessional Development Books (3)
Professional DevelopmentProfessional Development Branding (13)
Professional DevelopmentProfessional Development Career (17)
Professional DevelopmentProfessional Development Career Planning (16)
Professional DevelopmentProfessional Development Career Transition (4)
Professional DevelopmentProfessional Development Certifications (47)
Professional DevelopmentProfessional Development Community (16)
Professional DevelopmentProfessional Development Conferences (2)
Professional DevelopmentProfessional Development Interview Questions BI (15)
Professional DevelopmentProfessional Development Interview Questions DBA (22)
Professional DevelopmentProfessional Development Interview Questions Developer (6)
Professional DevelopmentProfessional Development Interviewing (38)
Professional DevelopmentProfessional Development Job Search (17)
Professional DevelopmentProfessional Development Management (9)
Professional DevelopmentProfessional Development Recruiters (6)
Professional DevelopmentProfessional Development Resume (13)
Professional DevelopmentProfessional Development Skills Development (18)
Reporting ServicesReporting Services Administration (19)
Reporting ServicesReporting Services Analysis Services (4)
Reporting ServicesReporting Services Best Practices (6)
Reporting ServicesReporting Services Charts (25)
Reporting ServicesReporting Services Configuration (10)
Reporting ServicesReporting Services Custom Report (2)
Reporting ServicesReporting Services Dashboard (1)
Reporting ServicesReporting Services Data Sources (10)
Reporting ServicesReporting Services Development (37)
Reporting ServicesReporting Services Drill Through (4)
Reporting ServicesReporting Services Dynamic Reports (11)
Reporting ServicesReporting Services Filtering (3)
Reporting ServicesReporting Services Formatting (26)
Reporting ServicesReporting Services Functions (5)
Reporting ServicesReporting Services Images (2)
Reporting ServicesReporting Services Installation (9)
Reporting ServicesReporting Services KPI (5)
Reporting ServicesReporting Services Maps (4)
Reporting ServicesReporting Services Migration (5)
Reporting ServicesReporting Services Monitoring (5)
Reporting ServicesReporting Services Network Load Balancing (4)
Reporting ServicesReporting Services Overview (5)
Reporting ServicesReporting Services Parameters (15)
Reporting ServicesReporting Services Performance (6)
Reporting ServicesReporting Services Report Builder (9)
Reporting ServicesReporting Services Report Models (1)
Reporting ServicesReporting Services Security (8)
Reporting ServicesReporting Services SharePoint (1)
Reporting ServicesReporting Services Subreports (4)
Reporting ServicesReporting Services Tutorials (1)
SecurityAuditing and Compliance (45)
SecurityEncryption (31)
SecuritySecurity (194)
SecuritySurface Area Configuration Manager (4)
SharePointSharePoint (130)
SharePointSharePoint Administration (46)
SharePointSharePoint Configuration (27)
SharePointSharepoint Design (46)
SharePointSharePoint Document Management (20)
ToolsAzure Data Studio (11)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (92)
ToolsSQL Server Management Studio (76)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (32)