Alejandro Cobar
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 Groups
- Create an Always On Availability Groups using TSQL (last update: 3/19/2021)
- Powershell Commands for SQL Server Always On Availability Groups (last update: 3/31/2021)
- SQL Server AlwaysOn Availability Groups Inventory and Monitoring Scripts - Part 1 (last update: 11/15/2018)
- SQL Server AlwaysOn Availability Groups Monitoring and Alerting - Part 2 (last update: 12/3/2018)
- SQL Server Availability Group Error 35246 missing sqlconf.dll (last update: 12/22/2020)
- SQL Server Monitoring for all Availability Groups (last update: 12/24/2020)
- SSISDB and SQL Server 2016 Availability Group Issue with Automatic Seeding (last update: 3/10/2021)
Backup
- Auto Generate NetBackup script to backup SQL Server databases (last update: 12/12/2018)
- Script to obtain most recent SQL Server backup information for all databases (last update: 10/22/2018)
Database Administration
- Find SQL Server Installation Date for all Instances with PowerShell (last update: 9/25/2019)
- How to Check Monthly Growth of Database in SQL Server (last update: 9/5/2019)
- Powershell Script to Collect SQL Server Inventory (last update: 4/1/2019)
Database Configurations
- PowerShell Commands for SQL Server Instance and Database Settings (last update: 4/21/2021)
Database Console Commands DBCCs
- Simple DBCC CHECKDB process to report on database corruption for all SQL Server databases (last update: 8/18/2020)
Database Mirroring
- SQL Server Database Mirroring Inventory (last update: 7/2/2021)
- SQL Server Database Mirroring Inventory and Monitoring Scripts (last update: 10/8/2018)
- SQL Server Database Mirroring Missing Logins Report (last update: 3/15/2019)
- SQL Server Database Mirroring Status Check and Manual Failover PowerShell Scripts (last update: 2/6/2019)
- SQL Server Database Mirroring Status Check and Manual Failover T-SQL Scripts (last update: 1/17/2019)
- Synchronize SQL Server Agent Jobs for Database Mirroring (last update: 4/19/2019)
DBA Best Practices
- PowerShell Commands for SQL Server Best Practices (last update: 4/12/2021)
Indexing
- Collect SQL Server Index Usage Information for all Instances with PowerShell (last update: 6/10/2019)
Locking and Blocking
- Configuring Extended Events to find Locking Issues in SQL Server (last update: 10/31/2018)
Monitoring
- How To Check Disk Space in SQL Server (last update: 2/10/2021)
- How to Check SysAdmin Role in SQL Server with PowerShell (last update: 8/20/2020)
- Monitor all Indexes in SQL Server with PowerShell (last update: 8/26/2020)
- Monitor CPU and Memory usage for all SQL Server instances using PowerShell (last update: 1/7/2019)
- Monitor SQL Server Table Size with PowerShell (last update: 12/15/2020)
- Monitoring SQL Server Buffer Pool Usage by Database with PowerShell (last update: 9/28/2020)
- Monitoring SQL Server Instance Version and Builds with PowerShell (last update: 11/9/2020)
- Monitoring SQL Server logins and server roles with PowerShell for Database Security (last update: 10/12/2020)
- Monitoring SQL Server with PowerShell Core Object Setup (last update: 6/24/2020)
- Monitoring SQL Server with PowerShell Instance Data Collection (last update: 6/25/2020)
- sp_whoisactive SQL Server Monitoring (last update: 11/30/2020)
- SQL Server Agent Job Monitoring for Last Execution with PowerShell (last update: 7/27/2020)
- SQL Server Agent Job Monitoring with PowerShell (last update: 6/29/2020)
- SQL Server Backup Monitoring with PowerShell (last update: 6/30/2020)
- SQL Server Configuration Settings Query (last update: 7/10/2019)
- SQL Server Database and Database File Monitoring with PowerShell (last update: 7/30/2020)
- SQL Server Disk Space Monitoring for all Instances with PowerShell Script (last update: 3/1/2019)
- SQL Server High CPU Query Use Monitoring with PowerShell (last update: 9/11/2020)
- SQL Server Statistics Collection and Analysis (last update: 7/16/2021)
- SQL Server Wait Stats Monitoring with PowerShell (last update: 8/31/2020)
Other Database Platforms
- SQL Server vs MySQL vs PostgreSQL Delete Performance Comparison (last update: 10/21/2020)
PowerShell
- Deploy Database Objects to Multiple SQL Server Instances Using PowerShell (last update: 11/19/2020)
- PowerShell Commands for SQL Server – Getting Started (last update: 9/28/2021)
- PowerShell Script to Parse HTML Code with SQL Server Build Numbers (last update: 10/30/2020)
- SQL Server Backup Testing and Verification (last update: 5/25/2021)
Restore
- SQL Server Backup Size vs Database Size Script (last update: 2/26/2020)
SQL Server Agent
- Disable or Enable All SQL Server Agent Jobs (last update: 8/17/2021)
- Inventory SQL Server Agent Jobs for all Instances with PowerShell (last update: 10/4/2019)
System Databases
- Find SQL Server MSDB Database Size and Largest Table Across SQL Server Instances (last update: 5/7/2019)
TSQL
- Script to Delete SQL Server Data in Batches (last update: 3/17/2020)
