Home

Author: 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. He began his professional journey as a developer (a bit more than 10 years ago) and has been going back and forth with DBA roles as well, being the latter the one he has mostly developed throughout the years. He also has several Microsoft SQL Server Certifications that have helped him go even further on his skills as a SQL Server Database Administrator.

Stored Procedure to Get Logins and Server Roles Inventory

March 18, 2022• Database development, Stored Procedures

Security is for sure one of the most important areas that we, as professional DBAs, must cover....
Read More →

Get Your SQL Server Database Size with Ease: Stored Procedures in Action

September 27, 2021• Database administation, Memory Optimization

As popular as the cloud services are nowadays, there’s still a good chunk of on-premises deployments of SQL Server that still require our...
Read More →

How to Get Tables Information in SQL Server via Stored Procedure

August 19, 2021• Database development, Stored Procedures

As a database administrator, developer, or data analyst, understanding the structure and details of your SQL Server database tables is...
Read More →

How to Show List of Indexes in SQL Server using Stored Procedure

August 16, 2021• Database development, Stored Procedures

As SQL Server DBAs, we’ve heard that index structures can dramatically improve the performance of...
Read More →

How to Use the sp_whoisactive PowerShell Script for Real-Time SQL Server Monitoring

July 30, 2021• Database development, Stored Procedures

Nowadays, within the SQL Server DBA community, it is extremely likely that we use, or at the very least have heard of, the famous stored...
Read More →
CodingSight - Delete Duplicate Records in SQL Table

Stored Procedure to Delete Duplicate Records in SQL Table

July 14, 2021• Database development, Stored Procedures, Tables

Sometimes during our run as DBAs, we come up across at least one table that is loaded with duplicate records. Even if the table has a...
Read More →
CodingSight - The Stored Procedure to Get the Instance Settings/Values

How to Find SQL Server Instance Name and More with Stored Procedures

June 10, 2021• Database development, Stored Procedures

SQL Server instances serve as the backbone of a business model, housing databases that contain...
Read More →
CodingSight - A PowerShell Tool to Get the Status of SQL Agent Jobs

How to Check Status Of SQL Agent Jobs using PowerShell Tool

May 21, 2021• Languages & Coding, Microsoft Azure, PowerShell, SQL Server, Tools & technologies

From a certain point in my career, I started to play around with PowerShell. But I never imagined that it would become such an essential...
Read More →
CodingSight - a Dedicated Stored Procedure to Get the Latest Database Backups Status

How to Get Backup Status in SQL Server using Stored Procedure

May 21, 2021• Database development, Stored Procedures

Any SQL Server DBA (of course, this applies to all platforms) will agree that database backups are the most essential things for data...
Read More →
CodingSight - SQL Server 2019 (Windows vs Linux)

MS SQL Server on Linux vs Windows Performance Test to Spot the Difference

April 30, 2021• Database administation, Perfomance Tuning

Since the release of SQL Server 2017 for Linux, Microsoft has pretty much changed the entire game....
Read More →
↑
Close