Alejandro Cobar
Alejandro Cobar is a SQL Server Database Administrator from Guatemala City. I am currently responsible for Production, QA and Development SQL Server Environments to make sure they are constantly performing as expected.
Alejandro has been a Microsoft Certified Professional since 2017, by passing the 70-462 exam. Before 2018 is over, I’m planning to achieve the MCSA in 2016 SQL Database Administration.
I focus 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.
- 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: Nintendo, PS4.
2020 Awards
2019 Awards
2018 Awards
Availability Groups
- 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)
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 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 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)
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 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 Script to Parse HTML Code with SQL Server Build Numbers (last update: 10/30/2020)
Restore
- SQL Server Backup Size vs Database Size Script (last update: 2/26/2020)
SQL Server Agent
- 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)
T-SQL
- Script to Delete SQL Server Data in Batches (last update: 3/17/2020)
