Capacity planning, especially when done for Microsoft SQL Server, is not for the faint of heart. Storage and disk capacity are apparent, but to...
database-tools
How to monitor and diagnose SQL query performance
Executing resource-intensive SQL queries requires a significant amount of processor time, memory, and bandwidth, and storage. Resource-intensive SQL...
Using Default Parameter Values
You may have heard about PowerShell default parameter values and $PSDefaultParameterValues. When you assign a hash table to this special variable,...
Correctly Importing Excel CSV Files
If you have exported an Excel sheet to CSV and would like to import this file into PowerShell, here is how to do this: $path =...
Supporting Risk Mitigation in PowerShell Functions
When a PowerShell function performs system changes that may be risky, it is worth supporting the –WhatIf and –Confirm risk mitigation...
Binding Parameters by Data Type
PowerShell can automatically bind values to parameters by data type matching. Here is a sample that shows what benefit this can be. Simply run this...
Deleting Environment Variables
[AllowNull() _i="0" _address="0" theme_builder_area="post_content" /][AllowEmptyString() _i="1" _address="1" theme_builder_area="post_content" /]
Troubleshooting Common Cloud Database Connectivity Issues
Howdy! And wishing Y'all a Very Happy and Prosperous 2018! In this very first blog of 2018, I'm excited to be writing this series on...
Setting Environment Variables
PowerShell can set environment variables only in its process set, so these changes will not persist and are not visible outside of PowerShell. To...
Appending the Clipboard
PowerShell 5 introduces cmdlets to copy text to the clipboard, and paste it back: Set-Clipboard and Get-Clipboard. Set-Clipboard also supports the...
Deleting User Profiles
Whenever a user logs on to your computer, a user profile is created, and in the previous tip we explained how PowerShell can dump a list of user...
Managing User Profiles
["MYDOMAINUser01" _i="0" _address="0" theme_builder_area="post_content" /]
Running Commands on Multiple Computers in Parallel
Provided you have enabled PowerShell remoting (see our previous tips), you can easily run commands and scripts on many computers at the same time....
Accessing Remote Machines via PowerShell Remoting
[targetComputerName _i="0" _address="0.0.0.0" theme_builder_area="post_content" /][targetComputerName _i="1" _address="0.0.0.1"...
Balancing Data and Processes to Achieve Organizational Maturity
On December 19th, 2017, Ron Huizenga presented a DATAVERSITY webinar on the importance of organizational maturity. His experience with manufacturing...
Playing with PowerShell Remoting
If you’d like to test-drive PowerShell remoting, you need to enable it at least on the target machine (the one you’d like to visit). For...
Loading and Saving Options in JSON Format
If you’d like to persist information in your script, you might want to save your data as an object in JSON format. Here is an example: #...
Joining Computers to a Domain
Execution Policy Override
If PowerShell won’t let you run a script, you may have to enable script execution first, for example like this: Set-ExecutionPolicy -Scope...
Formatting Text Output
If you’d like to nicely format output text, you may want to use a PSCustomObject and output it as a formatted list like so: $infos =...
Slack & Pagerduty Integration with Monyog v8.4.0
Important notice: With this release, we have changed the registration keys. As usual, the new keys are available for registered users from our...
Converting User Name to SID
If you’d need to find out the SID for a user name, here is a useful chunk of code that does the job: $domain = 'MyDomain' $username =...
Test-Drive PowerShell 6 – Side by Side
PowerShell 6 can be downloaded and run side-by-side with the official Windows PowerShell. If you’d like to test-drive it, head over to...
January #SQLChat: SQL Server New Year Resolutions – Breaking SQL Bad Habits for 2018
The New Year is almost here! Have you made any resolutions for 2018? Participate in our next #SQLChat on Wednesday, January 3rd at 11 AM CT with...