Windows Subsystem for Linux (WSL) can now run systemd inside our installed WSL distributions. This is old news, announced September 2022, but I only found out about this today! I might need to update some of my WSL blog posts. […]
Troubleshooting Database Mirroring Issues in SQL Server
Maintaining high availability and data integrity in a SQL Server environment is one of the main priorities as a SQL DBA. One issue we may encounter is Mirrored databases being left in a Disconnected or In Recovery state. In this […]
Most Common SQL Commands
Structured Query Language, or SQL, stands as the backbone of relational database management systems (RDBMS). SQL commands are the tools that empower developers, data analysts, and database administrators to interact seamlessly with databases. In this blog post, we’ll explore the […]
Get SQL Server Services Info from Command
As a SQL Server database administrator (DBA), one of your primary responsibilities is ensuring the smooth operation of SQL Server services. Whether it’s monitoring service status, managing startup configurations, or tracking service accounts, having quick access to this information can […]
Understanding Log Space Usage in SQL Server
In a SQL Server environment, monitoring database log space usage is crucial for maintaining database performance and ensuring data integrity. Insufficient log space can lead to transactional failures, database downtime, and even data loss. In this blog post, we’ll share […]
Adding Comments in PowerShell
In PowerShell, effective commenting is not just a best practice; it’s a skill for maintaining clean, understandable code, as it is in other coding languages. Comments serve as guides for developers, offering insights into code functionality, reasoning, and even temporary […]