In the previous tip, we introduced a function that generates nicely centered headers and accepted a single string. Here is the function and its...
database-tools
Creating Aligned Headers
Reporting and writing log files is a common task in PowerShell. Here is a simple function to create nicely centered headers. Adjust $width to the...
SQL Diagnostic Manager 10.4 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 10.4. Existing users may upgrade to this version through...
Computer Name, DNS Name, and IP Address
Here is a simple one-liner that returns your computers’ current IP address and its full DNS name: PS>...
Managing Windows License Key (Part 4)
Slmgr.vbs is an ancient VBScript used to automate Windows license management. In the previous tip we started bypassing slmgr.vbs by reading the WMI...
Managing Windows License Key (Part 3)
Most Windows license and activation tasks can be automated using an ancient VBScript called slmgr.vbs. It does not make much sense to use this tool...
Managing Windows License Key (Part 2)
Most automated license key management tasks are done via a command called slmgr. This command is actually an ancient VBScript. To read all of your...
Precise for Oracle Performance
Precise AdminPoint is available as a browser agnostic interface. Open Precise in Chrome!, Firefox!. Precise Applications will be...
Managing Windows License Key
Let’s start this mini-series with a one-liner that extracts your Windows license key: PS> $key = (Get-WmiObject -Class...
Create ASCII Art
It’s amazing how versatile PowerShell is: with just a couple of lines of code, you can turn any photo and image into a piece of ASCII art....
Verifying Local User Account Passwords
In the previous tip, we asked Active Directory to validate user account passwords. The same can be done with local accounts. Your PowerShell code...
SQL Diagnostic Manager 10.4 Preview
SQL Diagnostic Manager 10.4 will be available soon and it currently available for our beta customers at...
Verifying Domain Account Passwords
PowerShell can easily verify a password against a domain account. In other words, you can bind script logic to passwords maintained in Active...
Methods for Handling Big Data for Healthcare
Healthcare organizations need methods to overcome challenges to achieve the data-driven financial and clinical objectives. Such approaches include...
Waiting for a Service Status Change
Whenever you start or stop a service, it may take some time for the service to actually adopt the desired state – or it can of course fail....
Converting Text to Image
WPF (Windows Presentation Foundation)is not just a technique to create UIs. You can create any type of vector-based graphics composition and save it...
What has happened with GDPR in the last 9 months?
Largest Fine To Date Google recently made the news with a $57M (50M Euro) fine imposed by the French Regulatory building, CNIL. The case against...
Converting IEEE754 (Float) (Part 2)
Yesterday we looked at how PowerShell can turn IEEE754 floating point values returned by a sensor into the actual value. This involved reversing the...
Converting IEEE754 (Float) (Part 1)
PowerShell is extremely versatile and nowadays often used with IoT and sensors as well. Some return values in IEEE754 float format which typically...
How to Manage Complex Database Environments
Every year, data becomes increasingly critical to the organization. And data becomes even more complicated to manage and keep secure. The growth in...
Be Careful With “Throw” Statements (Part 2)
In the previous tip we explained how the throw statement can be influenced by $ErrorActionPreference set to “SilentlyContinue”, and that throw will...
Properties of Big Data for Healthcare
Healthcare organizations must consider the essential properties of the analytics for big data that when commencing significant projects for...
Be Careful With “Throw” Statements (Part 1)
Throw is a PowerShell statement that emits an exception to the caller and then exits the code. At least in theory. In the real world, throw might...
Reading News Feeds
Here’s a special service to users with German language skills – and a challenge to adjust the code for everyone else: the code below...