Create New Files and Folders in PowerShell
The New-Item cmdlet will create new files or folders in PowerShell. Amend the -ItemType parameter to File or Directory and include a Name for the file or folder.
AWS CLI – List IAM Users
AWS CLI – List IAM Users The aws iam list-users is a handy command for managing your AWS IAM users. It lets you get a list of all the users in your AWS account, along with some basic info about each one.
Get All Database Sizes & Free Space Info In SQL Server
Tracking database file sizes and free space within data and log files is an important part of monitoring SQL Server. This information, along with other metrics such as growth events, can help you to better predict and plan for future disk space provisioning needs.
Find String in Tables in SQL Server
Finding strings in SQL is usually done within a WHERE clause – you’re searching for rows in a table containing your condition which can of course include a string.
Show Only the Domain of an Email Address in SQL Server
When performing data analysis of email data in SQL, there’s often a need to show only the domain of an email address.
USE Command in SQL Server
USE [database] in SQL Server is a way to change the context to a specific database when you are running a query in Microsoft SQL Server.
Change Default Database in SQL Server
When you log into SQL Server using SQL Server Management Studio (SSMS), opening a new query window will automatically scope you within the default database set when your user was created.
Install oh-my-posh On Windows
Oh-my-posh is a theme engine for PowerShell that’s separate from your default PowerShell console. It’s powered by posh-git and has status indications for git, failed, and admin commands.
How to Install Windows Terminal
Windows Terminal is a more modern command-line tool that has many additional features. A major benefit of WT is the multiple tabs feature.
Install posh-git on Windows
Posh-git is a PowerShell module that integrates with Git to show git status information on the command line, and it comes with tab completion for common commands.
Install Chocolatey on Windows
This post is a guide on installing the Chocolatey package manager on Windows by running a PowerShell command. Chocolatey allows you to manage software packages on your system with simple ‘choco’
Disk Usage by Top Tables Report in SQL Server
The Disk Usage by Top Tables Report in SQL Server is a quick way to get the sizes of all tables within a database.
