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
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
Other Database Platforms 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
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 (31)
Analysis Services Analysis Services Development (94)
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 Tools (1)
Analysis Services Analysis Services Tutorials (6)
Analysis Services Cortana (5)
Analysis Services Performance Point (4)
Business Intelligence Big Data (25)
Business Intelligence Data Warehousing (6)
Cloud Amazon AWS (51)
Cloud Apache Spark (9)
Cloud Azure (147)
Cloud Azure Backup and Restore (25)
Cloud Azure Cosmos DB (15)
Cloud Azure Data Factory (69)
Cloud Azure Databricks (26)
Cloud Azure Integration Services (14)
Cloud Azure SQL Database (49)
Cloud Azure SQL Managed Instance (2)
Cloud Azure Synapse Analytics (39)
Cloud Cloud Strategy (20)
Data Quality Data Quality Services (9)
Data Quality Master Data Services (41)
Database Administration Amazon AWS RDS (1)
Database Administration Availability Groups (79)
Database Administration Backup (78)
Database Administration Central Management Servers (10)
Database Administration Clustering (74)
Database Administration Comparison Data and Objects (14)
Database Administration Compression (22)
Database Administration Contained Databases (4)
Database Administration Containers (12)
Database Administration Database Administration (199)
Database Administration Database Configurations (19)
Database Administration Database Console Commands DBCCs (25)
Database Administration Database Mail (18)
Database Administration Database Mirroring (33)
Database Administration DBA Best Practices (39)
Database Administration Dedicated Administrator Connection (4)
Database Administration Deprecated Features (5)
Database Administration DevOps (36)
Database Administration Disaster Recovery (23)
Database Administration Error Logs (11)
Database Administration Express Edition (16)
Database Administration Extended Events (22)
Database Administration FILESTREAM (9)
Database Administration Fragmentation and Index Maintenance (27)
Database Administration Google Cloud (5)
Database Administration Hardware (14)
Database Administration High Availability (3)
Database Administration Indexing (87)
Database Administration Install and Uninstall (32)
Database Administration Licensing (4)
Database Administration Linked Servers (18)
Database Administration Locking and Blocking (41)
Database Administration Log Shipping (18)
Database Administration Maintenance (34)
Database Administration Monitoring (117)
Database Administration Other Database Platforms (86)
Database Administration Partitioning (17)
Database Administration Performance Data Warehouse (4)
Database Administration Performance Tuning (124)
Database Administration Policy Based Management (29)
Database Administration PowerShell (130)
Database Administration Profiler and Trace (20)
Database Administration Query Store (7)
Database Administration Recovery Models (4)
Database Administration Referential Integrity (4)
Database Administration Replication (75)
Database Administration Resource Governor (5)
Database Administration Restore (42)
Database Administration Snowflake (1)
Database Administration SQL Server 2016 (96)
Database Administration SQL Server 2017 (44)
Database Administration SQL Server 2019 (20)
Database Administration SQL Server 2022 (22)
Database Administration SQL Server Configurations (75)
Database Administration SQL Server on Linux (76)
Database Administration StreamInsight (2)
Database Administration System Databases (31)
Database Administration Upgrades and Migrations (54)
Database Administration Virtualization (25)
Database Administration Windows Internal Database (1)
Database Development Application Development (41)
Database Development Artificial Intelligence (1)
Database Development Azure Functions (7)
Database Development Change Data Capture (15)
Database Development Common Runtime Language (13)
Database Development Common Table Expressions (3)
Database Development Constraints (19)
Database Development Data Cleansing for Validation (2)
Database Development Data Science (3)
Database Development Data Types (18)
Database Development Database Design (78)
Database Development Dates (54)
Database Development Debugging (4)
Database Development Dynamic Management Views and Functions (33)
Database Development Dynamic SQL (7)
Database Development Entity Framework (13)
Database Development Error Handling (10)
Database Development Full Text Search (21)
Database Development Functions System (73)
Database Development Functions User Defined UDF (41)
Database Development Identities (17)
Database Development Import and Export (77)
Database Development In Memory OLTP (32)
Database Development JOIN Tables (21)
Database Development Language Integrated Query LINQ (7)
Database Development Microsoft Access Integration (8)
Database Development Microsoft Excel Integration (41)
Database Development Microsoft Flow (1)
Database Development Paging (5)
Database Development Python (73)
Database Development Query Optimization (14)
Database Development Query Plans (20)
Database Development R Language (11)
Database Development Scripts (35)
Database Development Service Broker (11)
Database Development Spatial Data Storage (9)
Database Development SQL Injection (5)
Database Development SQL Server Management Objects SMO (3)
Database Development Stored Procedures (29)
Database Development Synonyms (5)
Database Development Table Valued Parameters (4)
Database Development Temp Tables (10)
Database Development Temporal Tables (13)
Database Development Testing (31)
Database Development Transactions (9)
Database Development Triggers (44)
Database Development TSQL (367)
Database Development User Defined Type UDT (3)
Database Development Views (16)
Database Development XML (14)
Integration Services Data Transformation Services (5)
Integration Services Integration Services Administration (10)
Integration Services Integration Services Analysis Services Tasks (5)
Integration Services Integration Services Best Practices (12)
Integration Services Integration Services Configuration Options (22)
Integration Services Integration Services Connection Managers (5)
Integration Services Integration Services Control Flow Transformations (14)
Integration Services Integration Services Data Flow Transformations (19)
Integration Services Integration Services Development (110)
Integration Services Integration Services Email (3)
Integration Services Integration Services Error Handling (8)
Integration Services Integration Services Excel (14)
Integration Services Integration Services Execute Package Options (8)
Integration Services Integration Services Import and Export Wizard (2)
Integration Services Integration Services NULL Management (4)
Integration Services Integration Services Oracle (4)
Integration Services Integration Services Performance (12)
Integration Services Integration Services Security (7)
Integration Services Integration Services Upgrade (4)
Power Platform Power Apps (20)
Power Platform Power BI (148)
Power Platform Power BI Charts (52)
Power Platform Power BI Formatting (16)
Professional Development Professional Development Books (3)
Professional Development Professional Development Branding (14)
Professional Development Professional Development Career (18)
Professional Development Professional Development Career Planning (16)
Professional Development Professional Development Career Transition (4)
Professional Development Professional Development Certifications (50)
Professional Development Professional Development Community (16)
Professional Development Professional Development Conferences (2)
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 (18)
Professional Development Professional Development Management (11)
Professional Development Professional Development Recruiters (6)
Professional Development Professional Development Resume (13)
Professional Development Professional Development Skills Development (18)
Reporting Services Reporting Services Administration (20)
Reporting Services Reporting Services Analysis Services (4)
Reporting Services Reporting Services Best Practices (6)
Reporting Services Reporting Services Charts (25)
Reporting Services Reporting Services Configuration (10)
Reporting Services Reporting Services Custom Report (2)
Reporting Services Reporting Services Dashboard (1)
Reporting Services Reporting Services Data Sources (10)
Reporting Services Reporting Services Development (38)
Reporting Services Reporting Services Drill Through (4)
Reporting Services Reporting Services Dynamic Reports (11)
Reporting Services Reporting Services Filtering (3)
Reporting Services Reporting Services Formatting (26)
Reporting Services Reporting Services Functions (5)
Reporting Services Reporting Services Images (2)
Reporting Services Reporting Services Installation (9)
Reporting Services Reporting Services KPI (5)
Reporting Services Reporting Services Maps (4)
Reporting Services Reporting Services Migration (5)
Reporting Services Reporting Services Monitoring (5)
Reporting Services Reporting Services Network Load Balancing (4)
Reporting Services Reporting Services Overview (5)
Reporting Services Reporting Services Parameters (15)
Reporting Services Reporting Services Performance (6)
Reporting Services Reporting Services Report Builder (9)
Reporting Services Reporting Services Report Models (1)
Reporting Services Reporting Services Security (8)
Reporting Services Reporting Services SharePoint (1)
Reporting Services Reporting Services Subreports (4)
Reporting Services Reporting Services Tutorials (1)
Security Auditing and Compliance (46)
Security Encryption (35)
Security Security (196)
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)
Tools Azure Data Studio (17)
Tools SQL Operations Studio (11)
Tools SQL Server Agent (93)
Tools SQL Server Management Studio (78)
Tools SQL Server Management Studio Configuration (22)
Tools SQL Server Management Studio Shortcuts (9)
Tools Tools (33)










get free sql tips
agree to terms