Skip to content

DBASco

Database & System Engineering Blog

  • Home
  • SQL Server
    • MSSQL Scripts
  • PowerShell
    • PowerShell Scripts
  • DBA Cheat Sheet
  • Other Posts
  • About
Restarting WSL Linux Distributions
WSLTagged Windows Subsystem for Linux1 Comment on Restarting WSL Linux Distributions

Restarting WSL Linux Distributions

December 28, 2023March 3, 2024

While using Windows Subsystem for Linux (WSL), you may need to restart your WSL Linux distribution to make changes to the WSL config, or due to another random issues. To do this, we can simply run the wsl –shutdown -d […]

PowerShell Script: Create Multiple Test CSV Files
PowerShellLeave a Comment on PowerShell Script: Create Multiple Test CSV Files

PowerShell Script: Create Multiple Test CSV Files

December 27, 2023January 22, 2024

In this post we share a PowerShell script that generates multiple CSV files in the current directory, each containing a random number of rows with sample data. Please note that this script uses basic random data for illustration purposes, and […]

WSL: Basic Commands
WSLTagged Windows Subsystem for Linux, WSL Tips1 Comment on WSL: Basic Commands

WSL: Basic Commands

December 26, 2023March 3, 2024

Windows Subsystem for Linux (WSL) is a feature released by Microsoft in 2016 that allows us to install and manage multiple Linux distributions on our local Windows computer with ease. The latest versions of Windows comes with a set of […]

SQL Server Error: Database Cannot Be Opened. It Is in the Middle of a Restore.
SQL ServerTagged SQL Server DB Restores, SQL Server ErrorsLeave a Comment on SQL Server Error: Database Cannot Be Opened. It Is in the Middle of a Restore.

SQL Server Error: Database Cannot Be Opened. It Is in the Middle of a Restore.

December 24, 2023January 22, 2024

Database [DatabaseName] Cannot Be Opened. It Is in the Middle of a Restore is a common error in SQL Server that can happen when you are trying to query, alter or drop a database while it’s still in the middle […]

SQL Server Script: User Permissions Audit
SQL ServerTagged MSSQL Scripts, SQL Server Users and PermissionsLeave a Comment on SQL Server Script: User Permissions Audit

SQL Server Script: User Permissions Audit

December 23, 2023January 22, 2024

As a Database Administrator (DBA), managing and auditing user permissions is a crucial aspect of ensuring the security and integrity of a SQL Server environment. Having a script to check a user’s permissions quickly is key to day-to-day support as […]

Disabling Windows Firewall with PowerShell
PowerShellTagged PowerShell Tips, Windows Firewall1 Comment on Disabling Windows Firewall with PowerShell

Disabling Windows Firewall with PowerShell

December 21, 2023January 20, 2024

In this blog post, we’ll dive into a specific scenario: disabling the Windows Firewall using PowerShell. It’s crucial to emphasize that this is a specific use case, as maintaining a robust level of security is paramount. The Windows Firewall serves […]

Posts pagination

Previous 1 … 13 14 15 16 Next

Popular Posts

DBASco (SQL DBA Blog) - 2024