No Clocks

No Clocks

2086 bookmarks
Newest
Doing More with Windows Sandbox • The Lonely Administrator
Doing More with Windows Sandbox • The Lonely Administrator
One of the reasons I was looking forward to updating to Windows 10 2004 was to have access to the Windows Sandbox feature. I think I tinkered with a pre-release version and was intrigued. I normally have a set of Hyper-V virtual machines that I can test with, but I’m always looking for something new...
·jdhitsolutions.com·
Doing More with Windows Sandbox • The Lonely Administrator
Using Terraform to Manage Infrastructure
Using Terraform to Manage Infrastructure
Large applications are often a mix of code your team has written and third-party applications your team needs to manage. These third-party applications could be things like AWS or Docker. In my team’s case, it’s Twilio TaskRouter. The configuration of these services may not...
·shopify.engineering·
Using Terraform to Manage Infrastructure
Excel VBA Error Handling - All You Need to Know!
Excel VBA Error Handling - All You Need to Know!
Learn all about Excel VBA errors and how make sure these are handled properly in your VBA code. Covers all the error types and error handling methods.
·trumpexcel.com·
Excel VBA Error Handling - All You Need to Know!
VBA Code: Excel Object Explorer
VBA Code: Excel Object Explorer
VBA Code Excel Object Explorer : Example Macros on Workbook, Worksheet, Range, Cells, Charts, Pivot tables, Shapes, List Objects (Tables) Methods, Properties, Events.
·analysistabs.com·
VBA Code: Excel Object Explorer
The Ultimate PowerShell Profile
The Ultimate PowerShell Profile
Putting the "Power" back into PowerShell with custom functions and aliases 💪
What is a PowerShell profile?A PowerShell profile is a script that runs when PowerShell starts. It's a great way to customize the shell to your liking and to add functionality that doesn't exist out of the box.
The PromptThe first thing I wanted to change was the prompt. The default prompt is a bit boring and doesn't provide much information. I wanted to add some colour and some useful information.I've done this using a third-party module called Oh-My-Posh. This module provides a number of themes and allows you to customize the prompt to your liking. I've chosen the Material theme.
The prompt now shows the current directory, the git branch, and the time.
GitHub IntegrationI use two machines for my day-to-day work. My laptop, and my desktop. I wanted to be able to easily sync my PowerShell profile between the two machines. In order to achieve this, I have included a setup script in the repository. This script will create a symbolic link to the profile in the repository, and place it in the correct location. This allows me to make changes to the profile on either machine and have those changes reflected on the other machine.Within the profile, there is a function that runs each time the profile is loaded. This checks to see if the local git repository is up to date with the remote repository. If it's not, a friendly message is displayed to remind me to pull the latest changes (another function included in the profile).
Support For All Session TypesThe two main interactions I have with PowerShell are through the Windows Terminal and Visual Studio Code. I wanted to ensure that the profile worked in both of these environments.The first hurdle was the font. The material Oh-My-Posh theme requires a font that supports Powerline characters. I chose the Caskaydia Cove Nerd Font. This is not installed by default on Windows, so there is logic in the setup script that installs the font and sets it as the default font in the Windows Terminal.If you look at most documentation for customizing the PowerShell profile, you'll see that it's recommended to use the $PROFILE environment variable. This is a variable that is set by PowerShell and points to the location of the current user's profile script. This works great for the Windows Terminal, but not for Visual Studio Code.
In order to support both environments for a consistent experience, a slightly different (not well-documented) approach is required. You need to use the $PROFILE.CurrentUserAllHosts variable. This variable points to the location of the profile, regardless of the host. This means that the profile will be loaded in both the Windows Terminal, Visual Studio Code, and anywhere else you might use PowerShell on the local machine.
Linux-like AliasesBecause I'm constantly switching between bash and PowerShell, I often get confused about which commands are (and aren't) already aliased. For example, ls is aliased to Get-ChildItem, but there is no equivalent for touch.I've added a number of custom functions to mimic (as closely as possible) the behaviour of their Linux counterparts. For example, grep is now an alias for my custom Find-String function, and df is an alias for the built-in Get-Volume command.My favourite addition is su, which is an alias for Start-AdminSession. This opens a new elevated Windows Terminal window.
function Start-AdminSession { <# .SYNOPSIS Starts a new PowerShell session with elevated rights. Alias: su #> Start-Process wt -Verb runAs }
Secret ManagementWhen writing scripts, it's often necessary to store secrets. These could be passwords, API keys, or other sensitive information. In the past, I've haphazardly stored these in plain text variables. This is obviously not ideal, but it was the easiest way to get the job done.In order to create the lowest barrier to entry, I've created a function called Get-OrCreateSecret. This is a semi-interactive function that will prompt for a secret if it doesn't already exist. Now I only need one line in my scripts to get a secret.
Using the SecretManagement & SecretStore modules, the secret is encrypted and stored in a local vault. This means that the secret is only accessible to the user that created it, on the machine that it was created on. Much better than storing it in plain text!
Further ImprovementsYou'll notice that the repository name is not "PowerShell Profile" and is instead "Windots". Windots is a short form for Windows dotfiles. Dotfiles are a Linux convention for storing configuration files. Though this is not commonplace on Windows, I intend to hack together more centralised configurations for my Windows environments. Hopefully easing the pain of switching between and setting up machines.
·scottmckendry.tech·
The Ultimate PowerShell Profile
Correlation Formula
Correlation Formula
Formula to Calculate Correlation Correlation is a statistical measure between two variables. One may define it as the change of quantity in one variable
·wallstreetmojo.com·
Correlation Formula
AskMyDB
AskMyDB
Generated by create next app
·askmydb.vercel.app·
AskMyDB