Windows can automatically determine the updates that may be missing on your system, provided you have an Internet connection. PowerShell can use the...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Auto-Logging Command Output
In the previous tip we introduced the PreCommandLookupAction supported by PowerShell 3 and better. Today we have a special implementation for you....
Replacing Commands
PowerShell comes with a couple of “secret” (better: under-documented) settings. One is PreCommandLookupAction, and it gives you great...
New plugin – Monitor Windows NTP metrics
Hey folks. Robert here. On my last day with Idera I've been doing some final housekeeping and I wanted to make sure I committed any of the stuff...
Easy Parsing of Setting Files (Part 3)
In the previous tip you have discovered how ConvertFrom-StringData can turn plain text key-value pairs into a hash table. What’s missing is...
Become an IDERA ACE Today!
Applications for the 2017 IDERA ACEs are now open! The search has begun for the 2017 IDERA ACEs. Do you have a passion in helping the community and...
Easy Parsing of Setting Files (Part 2)
In the previous tip we used ConvertFrom-StringData to parse plain text key-value pairs into hash tables. Here is an example where such conversion...
Easy Parsing of Setting Files (Part 1)
Let’s assume you want to save settings to a file in the most simplest form. Your settings may look like this: $settings = ' Name=Weltner...
Adding Live Clock to PowerShell Title Bar (Part 2)
In the previous tip we presented code that would update the PowerShell title bar in a background thread, displaying a live clock. Wouldn’t it...
Adding Live Clock to PowerShell Title Bar (Part 1)
To continuously update the PowerShell title bar, and for example display the current date and time, you need a background thread that takes care of...
When Add-Type Fails…
Add-Type can be used to load additional .NET assemblies from DLL files into PowerShell. This works well most of the time, and here is a sample call...
Understanding PowerShell and System Paths
PowerShell maintains its own current location: PS> Get-Location Path ---- C:\Users\tobwe The current location applies to relative paths used with...
Finding PowerShell’s Current File System Path
To find out the path your PowerShell is currently using, simply run Get-Location: PS> Get-Location Path ---- C:\Users\tobwe However, the current...
Dealing with “Windows PowerShell” and “PowerShell Core”
There are two PowerShell Editions now: “Windows PowerShell” shipping with Windows, and running on the full .NET Framework, and the...
Setting up an Apache Web Server in Debian using Google Cloud
Setting up an Apache Web Server in Debian using Google Cloud Howdy! In the...
Windows PowerShell and PowerShell Core
Lately there has been confusion about PowerShell versions. There is a “PowerShell 6” open source initiative at GitHub...
Fireproof Your DBA Career in our Next Twitter Chat!
Is your DBA career fireproof? Let’s discuss the things that can get you fired and make sure you’re not doing them. Our next #SQLChat...
Setting PowerShell Title Text
You probably know that you can change the title text of a PowerShell host window with a line like this: PS> $host.UI.RawUI.WindowTitle =...
Clearing All User Variables
In the previous tip we illustrated how you can identify built-in PowerShell variables with an approach like this: $ps = [PowerShell]::Create() $null...
Finding PowerShell Default Variables (Part 3)
In the previous tip we illustrated how you can identify built-in PowerShell variables with an approach like this: $ps = [PowerShell]::Create() $null...
Setting up a Linux VM using Google Cloud
Howdy! In this blog post, I will be showing you all on how to setup a new Linux VM in Google Cloud. If you are new to Google Cloud, I would...
RDS/Aurora OS monitoring with Monyog v8.1.0
With this Monyog release, we will provide monitoring capabilities for RDS/Aurora OS metrics along with an emphasis on the User Experience in several...
Finding PowerShell Default Variables (Part 2)
In the previous tip we explained how you can use a separate new and fresh PowerShell to retrieve all default variables. When you examine these...
Secure your Uptime MSSQL backend database connection with SSL!
Hey there Uptimers! There's been a lot of stuff in the news lately regarding cyber attacks and data security in general. Just this morning I was...
Finding PowerShell Default Variables (Part 1)
Sometimes it would be useful to identify the automatic PowerShell variables managed by PowerShell so you could differentiate between built-in...
Finding PowerShell Classes
Starting in PowerShell 5, you can define PowerShell classes. They are defined dynamically and live in memory. So how would you know the names of...
Using PowerShell Classes 2
Starting in PowerShell 5, you can define PowerShell classes. You can use classes to create new objects, and by defining one or more...
Using PowerShell Classes
Starting with PowerShell 5, you can define classes. They have many use cases. One would be to create libraries of useful helper functions to better...
Reading Registry Values (Workaround)
In the previous tip we illustrated that Get-ItemProperty cannot read registry key values when there is a value present with corrupted content:...
Reading Registry Values Fails
Occasionally, reading values of a registry key may fail with a strange error message: PS> $key =...