Alejandro Cobar

Alejandro Cobar is an MCP, SQL Server DBA and Developer with 10+ years of experience working in a variety of environments.

Alejandro Cobar is a multi-platform DBA (with a stronger focus in SQL Server), with a passion to automate stuff as much as possible to make things work for the greater good. In 2020 he contributed a series of articles, using PowerShell, to help DBAs take care of their DB Infrastructure in a holistic approach.

In 2021 he will be releasing a series of PowerShell articles to help DBAs tackle specific tasks in their day-to-day work, and hopefully add a ton of value to them.

He has several certifications under his belt, being the latest one the MCSE: Data Management and Analytics (2020).

His focus is on the following aspects of SQL Server:

  • Guide the customer with the best alternatives and practices when new SQL Server deployments are required.
  • Install and configure all supported versions of SQL Server and components.
  • Install, configure and maintain High Availability/DR solutions.
  • Plan, test, and deploy service pack installations and version upgrades.
  • Design, implement, and support backup and recovery plans including scripting and scheduling.
  • Migration of databases, database objects, and users.
  • Databases refresh on Dev/Test/QA environments.
  • Participate in DR drills exercises.
  • Provide expert diagnostic analysis and resolution for all database operational problems that arise.
  • Performance tuning and query optimization for large production environments.
  • SQL Server DBA workbook creation and maintenance, including up to date procedures and how-to’s.
  • Deployment of custom crafted scripts to monitor specific areas of the environment under my support (backups, mirroring status, always on availability groups status, disk drives usage, resources utilization by the SQL Server process).

Hobbies: Play Nintendo Switch with my daughter.

2021 Awards      

2020 Awards      

2019 Awards   

2018 Awards   

Availability GroupsCreate an Always On Availability Groups using TSQL
Availability GroupsPowershell Commands for SQL Server Always On Availability Groups
Availability GroupsSQL Server AlwaysOn Availability Groups Inventory and Monitoring Scripts - Part 1
Availability GroupsSQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2
Availability GroupsSQL Server Availability Group Error 35246 missing sqlconf.dll
Availability GroupsSQL Server Monitoring for all Availability Groups
Availability GroupsSSISDB and SQL Server 2016 Availability Group Issue with Automatic Seeding
BackupAuto Generate NetBackup script to backup SQL Server databases
BackupScript to obtain most recent SQL Server backup information for all databases
Database AdministrationFind SQL Server Installation Date for all Instances with PowerShell
Database AdministrationHow to Check Monthly Growth of Database in SQL Server
Database AdministrationPowershell Script to Collect SQL Server Inventory
Database ConfigurationsPowerShell Commands for SQL Server Instance and Database Settings
Database Console Commands DBCCsSimple DBCC CHECKDB process to report on database corruption for all SQL Server databases
Database MirroringSQL Server Database Mirroring Inventory
Database MirroringSQL Server Database Mirroring Inventory and Monitoring Scripts
Database MirroringSQL Server Database Mirroring Missing Logins Report
Database MirroringSQL Server Database Mirroring Status Check and Manual Failover PowerShell Scripts
Database MirroringSQL Server Database Mirroring Status Check and Manual Failover T-SQL Scripts
Database MirroringSynchronize SQL Server Agent Jobs for Database Mirroring
DBA Best PracticesPowerShell Commands for SQL Server Best Practices
IndexingCollect SQL Server Index Usage Information for all Instances with PowerShell
Locking and BlockingConfiguring Extended Events to find Locking Issues in SQL Server
MonitoringHow To Check Disk Space in SQL Server
MonitoringHow to Check SysAdmin Role in SQL Server with PowerShell
MonitoringMonitor all Indexes in SQL Server with PowerShell
MonitoringMonitor CPU and Memory usage for all SQL Server instances using PowerShell
MonitoringMonitor SQL Server Table Size with PowerShell
MonitoringMonitoring SQL Server Buffer Pool Usage by Database with PowerShell
MonitoringMonitoring SQL Server Instance Version and Builds with PowerShell
MonitoringMonitoring SQL Server logins and server roles with PowerShell for Database Security
MonitoringMonitoring SQL Server with PowerShell Core Object Setup
MonitoringMonitoring SQL Server with PowerShell Instance Data Collection
Monitoringsp_whoisactive SQL Server Monitoring
MonitoringSQL Server Agent Job Monitoring for Last Execution with PowerShell
MonitoringSQL Server Agent Job Monitoring with PowerShell
MonitoringSQL Server Backup Monitoring with PowerShell
MonitoringSQL Server Configuration Settings Query
MonitoringSQL Server Database and Database File Monitoring with PowerShell
MonitoringSQL Server Disk Space Monitoring for all Instances with PowerShell Script
MonitoringSQL Server High CPU Query Use Monitoring with PowerShell
MonitoringSQL Server Statistics Collection and Analysis
MonitoringSQL Server Wait Stats Monitoring with PowerShell
Other Database PlatformsSQL Server vs MySQL vs PostgreSQL Delete Performance Comparison
PowerShellDeploy Database Objects to Multiple SQL Server Instances Using PowerShell
PowerShellPowerShell Commands for SQL Server – Getting Started
PowerShellPowerShell for the DBA - Basic Functions
PowerShellPowerShell for the DBA - CMDLETs and Advanced Functions
PowerShellPowerShell for the DBA - If Else and Switch statements
PowerShellPowerShell for the DBA – FOR and WHILE Loops
PowerShellPowerShell for the SQL Server DBA - Variable Fundamentals
PowerShellPowerShell for the SQL Server DBA – Environment Setup
PowerShellPowerShell Script to Parse HTML Code with SQL Server Build Numbers
PowerShellSQL Server Backup Testing and Verification
RestoreSQL Server Backup Size vs Database Size Script
SQL Server AgentDisable or Enable All SQL Server Agent Jobs
SQL Server AgentInventory SQL Server Agent Jobs for all Instances with PowerShell
System DatabasesFind SQL Server MSDB Database Size and Largest Table Across SQL Server Instances
TSQLScript to Delete SQL Server Data in Batches
No Records Found
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 (33)
Data QualityData Quality Services (7)
Data QualityMaster Data Services (41)
Database AdministrationAvailability Groups (73)
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 (188)
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 (67)
Database AdministrationPartitioning (14)
Database AdministrationPerformance Data Warehouse (4)
Database AdministrationPerformance Tuning (121)
Database AdministrationPolicy Based Management (29)
Database AdministrationPowerShell (127)
Database AdministrationProfiler and Trace (20)
Database AdministrationQuery Store (7)
Database AdministrationRecovery Models (4)
Database AdministrationReplication (75)
Database AdministrationResource Governor (5)
Database AdministrationRestore (40)
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 (14)
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 (20)
Database DevelopmentFunctions System (65)
Database DevelopmentFunctions User Defined UDF (40)
Database DevelopmentIdentities (17)
Database DevelopmentImport and Export (74)
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 (36)
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 (296)
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 (10)
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 (106)
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 (12)
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 (28)
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 (10)
ToolsSQL Operations Studio (11)
ToolsSQL Server Agent (92)
ToolsSQL Server Management Studio (74)
ToolsSQL Server Management Studio Configuration (22)
ToolsSQL Server Management Studio Shortcuts (9)
ToolsTools (31)