Alejandro Cobar

Alejandro Cobar is an MCP, SQL Server DBA and Developer with 10+ years of experience working in a variety of environments.
  • MSSQLTips Awards: Author of the Year - 2020 | Rising Star (50+ tips) - 2021 | Author Contender - 2019, 2021
Title Category Date
GitHub Copilot to Create Indexes and Tune Queries in SQL Server Artificial Intelligence2023-08-18
GitHub Copilot to Generate SQL Server Stored Procedures and Functions Artificial Intelligence2023-08-01
GitHub Copilot for Azure Data Studio to Boost Developer Productivity Artificial Intelligence2023-07-24
Enforcing Referential Integrity Across SQL Server Databases Referential Integrity2023-06-30
Referential Integrity for Tables in Different SQL Server Databases Referential Integrity2023-05-26
Puppet to Schedule and Automate DevOps Tasks with PowerShell DevOps2023-05-02
Automate PowerShell Script Execution with Jenkins for DevOps Projects DevOps2023-04-04
How to Run a PowerShell Script with SQL Server Agent or Task Scheduler PowerShell2023-03-15
PowerShell Scripts to Query All SQL Servers for Central Monitoring Database Administration2022-10-31
PowerShell Script for SQL Server Instance Details, Create Backup, Jobs PowerShell2022-07-06
PowerShell Pipelines Sample Code to Pass Parameters PowerShell2022-06-08
CMDLETs for PowerShell Examples and Usage PowerShell2022-05-24
PowerShell Functions for SQL Server DBAs PowerShell2022-05-05
PowerShell Loops – FOR, FOREACH, WHILE, DO UNTIL and DO WHILE PowerShell2022-04-20
PowerShell If, If Else and Switch Examples PowerShell2022-03-24
PowerShell Variable Examples for Data Types, Scope, Naming, Assignment PowerShell2022-02-10
Getting Started with PowerShell for the SQL Server DBA PowerShell2021-10-29
Getting Started with PowerShell Commands for SQL Server PowerShell2021-09-28
Disable or Enable All SQL Server Agent Jobs SQL Server Agent2021-08-17
SQL Server Statistics Collection and Analysis Monitoring2021-07-16
SQL Server Database Mirroring Inventory Database Mirroring2021-07-02
SQL Server Backup Testing and Verification PowerShell2021-05-25
PowerShell Commands for SQL Server Instance and Database Settings Database Configurations2021-04-21
PowerShell Commands for SQL Server Best Practices DBA Best Practices2021-04-12
Powershell Commands for SQL Server Always On Availability Groups Availability Groups2021-03-31
Create an Always On Availability Groups using TSQL Availability Groups2021-03-19
SQL Server 2016 Availability Group Issue with Automatic Seeding Availability Groups2021-03-10
How To Check Disk Space in SQL Server Monitoring2021-02-10
SQL Server Monitoring for all Availability Groups Availability Groups2020-12-24
SQL Server Availability Group Error 35246 missing sqlconf.dll Availability Groups2020-12-22
Monitor SQL Server Table Size with PowerShell Monitoring2020-12-15
sp_whoisactive SQL Server Monitoring Monitoring2020-11-30
Deploy Database Objects to Multiple SQL Server Instances PowerShell2020-11-19
Monitoring SQL Server Version and Build Numbers Monitoring2020-11-09
PowerShell Script to Parse HTML Code with SQL Server Build Numbers PowerShell2020-10-30
Delete SQL Performance for SQL Server, MySQL and PostgreSQL PostgreSQL2020-10-21
SQL Server Monitoring with PowerShell for Database Security Monitoring2020-10-12
SQL Server Monitoring of Buffer Pool Usage by Database Monitoring2020-09-28
SQL Server High CPU Query Use Monitoring with PowerShell Monitoring2020-09-11
SQL Server Wait Stats Monitoring with PowerShell Monitoring2020-08-31
Monitor all Indexes in SQL Server with PowerShell Monitoring2020-08-26
How to Check SysAdmin Role in SQL Server with PowerShell Monitoring2020-08-20
Simple Corruption Check for all SQL Server databases Database Console Commands DBCCs2020-08-18
SQL Server Database and Database File Monitoring with PowerShell Monitoring2020-07-30
SQL Server Agent Job Monitoring for Last Execution with PowerShell Monitoring2020-07-27
SQL Server Backup Monitoring with PowerShell Monitoring2020-06-30
SQL Server Agent Job Monitoring with PowerShell Monitoring2020-06-29
Monitoring SQL Server with PowerShell Instance Data Collection Monitoring2020-06-25
Monitoring SQL Server with PowerShell Core Object Setup Monitoring2020-06-24
Script to Delete SQL Server Data in Batches SQL DELETE and Truncate2020-03-17
SQL Server Backup Size vs Database Size Script Restore2020-02-26
Inventory SQL Server Agent Jobs for all Instances with PowerShell SQL Server Agent2019-10-04
Find SQL Server Installation Date for all Instances with PowerShell Database Administration2019-09-25
How to Check Monthly Growth of Database in SQL Server Database Administration2019-09-05
SQL Server Configuration Settings Query Monitoring2019-07-10
Collect SQL Server Index Usage for All Instances with PowerShell Indexing2019-06-10
Get SQL Server MSDB Size and Largest Table for All Instances System Databases2019-05-07
Synchronize SQL Server Agent Jobs for Database Mirroring Database Mirroring2019-04-19
Powershell Script to Collect SQL Server Inventory Database Administration2019-04-01
SQL Server Database Mirroring Missing Logins Report Database Mirroring2019-03-15
SQL Server Disk Space Monitoring for All Instances with PowerShell Monitoring2019-03-01
SQL Server DB Mirroring Status Check and Manual Failover PS Scripts Database Mirroring2019-02-06
SQL Server DB Mirroring Status Check and Manual Failover TSQL Scripts Database Mirroring2019-01-17
Monitor CPU and Memory for All SQL Server Instances with PowerShell Monitoring2019-01-07
Auto Generate NetBackup script to backup SQL Server databases Backup2018-12-12
Always On Availability Groups Monitoring and Alerting – Part 2 Availability Groups2018-12-03
Always On Availability Group Inventory and Monitoring Scripts – Part 1 Availability Groups2018-11-15
Configuring Extended Events to find Locking Issues in SQL Server Locking and Blocking2018-10-31
Get most recent SQL Server backup information for all databases Backup2018-10-22
SQL Server Database Mirroring Inventory and Monitoring Scripts Database Mirroring2018-10-08