Alejandro Cobar

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   MSSQLTips award   MSSQLTips award

2020 Awards   MSSQLTips award   MSSQLTips award

2019 Awards   MSSQLTips award

2018 Awards   MSSQLTips award

Category Tip Title
Artificial Intelligence GitHub Copilot Examples to Create SQL Server Indexes and Tune Queries
Artificial Intelligence GitHub Copilot for Azure Data Studio to Boost Database Development Productivity - Part 1
Artificial Intelligence GitHub Copilot to Auto Generate Code for SQL Server Stored Procedures and Functions - Part 2
Availability Groups Create an Always On Availability Groups using TSQL
Availability Groups Powershell Commands for SQL Server Always On Availability Groups
Availability Groups SQL Server AlwaysOn Availability Groups Inventory and Monitoring Scripts - Part 1
Availability Groups SQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2
Availability Groups SQL Server Availability Group Error 35246 missing sqlconf.dll
Availability Groups SQL Server Monitoring for all Availability Groups
Availability Groups SSISDB and SQL Server 2016 Availability Group Issue with Automatic Seeding
Backup Auto Generate NetBackup script to backup SQL Server databases
Backup Script to obtain most recent SQL Server backup information for all databases
Database Administration Build Your Own SQL Server Central Monitoring Solution with PowerShell
Database Administration Find SQL Server Installation Date for all Instances with PowerShell
Database Administration How to Check Monthly Growth of Database in SQL Server
Database Administration Powershell Script to Collect SQL Server Inventory
Database Configurations PowerShell Commands for SQL Server Instance and Database Settings
Database Console Commands DBCCs Simple DBCC CHECKDB process to report on database corruption for all SQL Server databases
Database Mirroring SQL Server Database Mirroring Inventory
Database Mirroring SQL Server Database Mirroring Inventory and Monitoring Scripts
Database Mirroring SQL Server Database Mirroring Missing Logins Report
Database Mirroring SQL Server Database Mirroring Status Check and Manual Failover PowerShell Scripts
Database Mirroring SQL Server Database Mirroring Status Check and Manual Failover T-SQL Scripts
Database Mirroring Synchronize SQL Server Agent Jobs for Database Mirroring
DBA Best Practices PowerShell Commands for SQL Server Best Practices
DevOps Jenkins Installation, Configuration and Automation for DevOps Projects
DevOps Scheduling PowerShell Scripts with Puppet
Indexing Collect SQL Server Index Usage Information for all Instances with PowerShell
Locking and Blocking Configuring Extended Events to find Locking Issues in SQL Server
Monitoring How To Check Disk Space in SQL Server
Monitoring How to Check SysAdmin Role in SQL Server with PowerShell
Monitoring Monitor all Indexes in SQL Server with PowerShell
Monitoring Monitor CPU and Memory usage for all SQL Server instances using PowerShell
Monitoring Monitor SQL Server Table Size with PowerShell
Monitoring Monitoring SQL Server Buffer Pool Usage by Database with PowerShell
Monitoring Monitoring SQL Server Instance Version and Builds with PowerShell
Monitoring Monitoring SQL Server logins and server roles with PowerShell for Database Security
Monitoring Monitoring SQL Server with PowerShell Core Object Setup
Monitoring Monitoring SQL Server with PowerShell Instance Data Collection
Monitoring sp_whoisactive SQL Server Monitoring
Monitoring SQL Server Agent Job Monitoring for Last Execution with PowerShell
Monitoring SQL Server Agent Job Monitoring with PowerShell
Monitoring SQL Server Backup Monitoring with PowerShell
Monitoring SQL Server Configuration Settings Query
Monitoring SQL Server Database and Database File Monitoring with PowerShell
Monitoring SQL Server Disk Space Monitoring for all Instances with PowerShell Script
Monitoring SQL Server High CPU Query Use Monitoring with PowerShell
Monitoring SQL Server Statistics Collection and Analysis
Monitoring SQL Server Wait Stats Monitoring with PowerShell
PostgreSQL SQL Server vs MySQL vs PostgreSQL Delete Performance Comparison
PowerShell Deploy Database Objects to Multiple SQL Server Instances Using PowerShell
PowerShell PowerShell Commands for SQL Server – Getting Started
PowerShell PowerShell for the DBA - Basic Functions
PowerShell PowerShell for the DBA - CMDLETs and Advanced Functions
PowerShell PowerShell for the DBA - If Else and Switch statements
PowerShell PowerShell for the DBA - Performing DBA tasks using SQL Server CMDLETs
PowerShell PowerShell for the DBA – FOR and WHILE Loops
PowerShell PowerShell for the SQL Server DBA - Pipelines
PowerShell PowerShell for the SQL Server DBA - Variable Fundamentals
PowerShell PowerShell for the SQL Server DBA – Environment Setup
PowerShell PowerShell Script to Parse HTML Code with SQL Server Build Numbers
PowerShell Run PowerShell Scripts with SQL Server Agent or Windows Task Scheduler
PowerShell SQL Server Backup Testing and Verification
Referential Integrity Checking Cross-Database Referential Integrity in SQL Server - Part 1
Referential Integrity Control Referential Integrity Across SQL Server Databases and Identify Orphan Records
Restore SQL Server Backup Size vs Database Size Script
SQL Server Agent Disable or Enable All SQL Server Agent Jobs
SQL Server Agent Inventory SQL Server Agent Jobs for all Instances with PowerShell
System Databases Find SQL Server MSDB Database Size and Largest Table Across SQL Server Instances
TSQL Script to Delete SQL Server Data in Batches
No Records Found
No Records Found
CategoryGroup Category (articles)
Analysis Services Analysis Services Administration (33)
Analysis Services Analysis Services Development (95)
Analysis Services Analysis Services Dimensions (16)
Analysis Services Analysis Services Measure Groups (7)
Analysis Services Analysis Services Performance (14)
Analysis Services Analysis Services Security (7)
Analysis Services Analysis Services Tutorials (6)
Business Intelligence Artificial Intelligence (23)
Business Intelligence Big Data (25)
Business Intelligence Data Science (3)
Business Intelligence Data Warehousing (7)
Business Intelligence Import and Export (81)
Business Intelligence R Language (11)
Business Intelligence Snowflake (29)
Cloud Amazon AWS (38)
Cloud Amazon AWS RDS (21)
Cloud Azure (149)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (15)
Cloud Azure Functions (7)
Cloud Azure SQL Database (51)
Cloud Azure SQL Managed Instance (5)
Cloud Cloud Strategy (24)
Cloud Google Cloud (10)
Cloud Analytics Apache Spark (13)
Cloud Analytics Azure Data Factory (73)
Cloud Analytics Azure Databricks (39)
Cloud Analytics Azure Integration Services (14)
Cloud Analytics Azure Synapse Analytics (41)
Cloud Analytics Microsoft Fabric (17)
Data Quality Data Cleansing for Validation (4)
Data Quality Data Quality Services (10)
Data Quality Master Data Services (41)
Database Administration Central Management Servers (10)
Database Administration Comparison Data and Objects (14)
Database Administration Database Administration (208)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Scripts (35)
Database Administration System Databases (31)
Database Configuration Compression (22)
Database Configuration Database Configurations (19)
Database Configuration Database Mail (18)
Database Configuration FILESTREAM (9)
Database Configuration Full Text Search (21)
Database Configuration In Memory OLTP (32)
Database Configuration Linked Servers (18)
Database Configuration Policy Based Management (29)
Database Configuration Recovery Models (4)
Database Configuration Resource Governor (5)
Database Configuration SQL Server Configurations (75)
Database Design Constraints (20)
Database Design Data Types (22)
Database Design Database Design (92)
Database Design Identities (17)
Database Design JOIN Tables (23)
Database Design Synonyms (5)
Database Design Table Valued Parameters (4)
Database Design Temp Tables (15)
Database Design Temporal Tables (13)
Database Design User Defined Type UDT (3)
Database Design Views (17)
Database Development Application Development (46)
Database Development Common Runtime Language (13)
Database Development Debugging (4)
Database Development DevOps (36)
Database Development Entity Framework (13)
Database Development Language Integrated Query LINQ (7)
Database Development Paging (5)
Database Development Referential Integrity (5)
Database Development Service Broker (11)
Database Development Testing (32)
Database Development XML (14)
Database Maintenance Database Console Commands DBCCs (25)
Database Maintenance Fragmentation and Index Maintenance (28)
Database Maintenance Maintenance (34)
Disaster Recovery / High Availability Availability Groups (79)
Disaster Recovery / High Availability Backup (81)
Disaster Recovery / High Availability Clustering (77)
Disaster Recovery / High Availability Database Mirroring (33)
Disaster Recovery / High Availability Disaster Recovery (23)
Disaster Recovery / High Availability High Availability (3)
Disaster Recovery / High Availability Log Shipping (18)
Disaster Recovery / High Availability Replication (78)
Disaster Recovery / High Availability Restore (42)
Functions Dates (56)
Functions Functions System (99)
Functions Functions User Defined UDF (41)
Infrastructure Contained Databases (4)
Infrastructure Containers (12)
Infrastructure Hardware (14)
Infrastructure Spatial Data Storage (9)
Infrastructure Virtualization (25)
Integration Services Admin Integration Services Administration (10)
Integration Services Admin Integration Services Best Practices (12)
Integration Services Admin Integration Services Configuration Options (22)
Integration Services Admin Integration Services Performance (12)
Integration Services Admin Integration Services Security (7)
Integration Services Admin Integration Services Upgrade (4)
Integration Services Development Data Transformation Services (6)
Integration Services Development Integration Services Analysis Services Tasks (5)
Integration Services Development Integration Services Connection Managers (5)
Integration Services Development Integration Services Control Flow Transformations (14)
Integration Services Development Integration Services Data Flow Transformations (19)
Integration Services Development Integration Services Development (116)
Integration Services Development Integration Services Error Handling (8)
Integration Services Development Integration Services Excel (14)
Integration Services Development Integration Services Execute Package Options (8)
Integration Services Development Integration Services Oracle (4)
Microsoft Office Microsoft Access Integration (8)
Microsoft Office Microsoft Excel Integration (44)
Microsoft Office Microsoft Flow (1)
Other RDBMS Other Database Platforms (16)
Other RDBMS PostgreSQL (11)
Other RDBMS SQL Server and Oracle Comparison (29)
Other RDBMS SQL Server on Linux (78)
Other RDBMS SQL Server vs Oracle vs PostgreSQL Comparison (20)
Performance Dynamic Management Views and Functions (34)
Performance Error Logs (11)
Performance Extended Events (22)
Performance Indexing (94)
Performance Locking and Blocking (43)
Performance Monitoring (110)
Performance Partitioning (17)
Performance Performance Data Warehouse (4)
Performance Performance Tuning (124)
Performance Profiler and Trace (20)
Performance Query Optimization (15)
Performance Query Plans (20)
Performance Query Store (7)
Power Platform Power Apps (20)
Power Platform Power BI (172)
Power Platform Power BI Charts (57)
Power Platform Power BI Formatting (17)
Professional Development Professional Development Branding (16)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (20)
Professional Development Professional Development Certifications (62)
Professional Development Professional Development Community (16)
Professional Development Professional Development Interview Questions BI (18)
Professional Development Professional Development Interview Questions DBA (23)
Professional Development Professional Development Interview Questions Developer (9)
Professional Development Professional Development Interviewing (39)
Professional Development Professional Development Job Search (24)
Professional Development Professional Development Management (14)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Python Python (88)
Reporting Services Admin Reporting Services Administration (21)
Reporting Services Admin Reporting Services Best Practices (6)
Reporting Services Admin Reporting Services Configuration (10)
Reporting Services Admin Reporting Services Installation (10)
Reporting Services Admin Reporting Services Migration (5)
Reporting Services Admin Reporting Services Monitoring (5)
Reporting Services Admin Reporting Services Network Load Balancing (4)
Reporting Services Admin Reporting Services Performance (6)
Reporting Services Admin Reporting Services Security (8)
Reporting Services Development Reporting Services Analysis Services (4)
Reporting Services Development Reporting Services Charts (25)
Reporting Services Development Reporting Services Data Sources (10)
Reporting Services Development Reporting Services Development (67)
Reporting Services Development Reporting Services Dynamic Reports (11)
Reporting Services Development Reporting Services Formatting (26)
Reporting Services Development Reporting Services KPI (5)
Reporting Services Development Reporting Services Overview (5)
Reporting Services Development Reporting Services Parameters (15)
Reporting Services Development Reporting Services Report Builder (9)
Security Auditing and Compliance (47)
Security Encryption (35)
Security Security (199)
Security SQL Injection (5)
Security Surface Area Configuration Manager (4)
SharePoint SharePoint (131)
SharePoint SharePoint Administration (46)
SharePoint SharePoint Configuration (27)
SharePoint Sharepoint Design (46)
SharePoint SharePoint Document Management (20)
SQL Coding Change Data Capture (16)
SQL Coding Common Table Expressions (4)
SQL Coding Dynamic SQL (7)
SQL Coding Error Handling (11)
SQL Coding Stored Procedures (30)
SQL Coding Transactions (9)
SQL Coding Triggers (44)
SQL Coding TSQL (342)
Tools Azure Data Studio (18)
Tools PowerShell (131)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (94)
Tools SQL Server Management Objects SMO (3)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (35)
Versions Deprecated Features (6)
Versions Express Edition (16)
Versions Install and Uninstall (33)
Versions Licensing (4)
Versions SQL Server 2016 (96)
Versions SQL Server 2017 (44)
Versions SQL Server 2019 (20)
Versions SQL Server 2022 (21)
Versions Upgrades and Migrations (55)










get free sql tips
agree to terms