There are several examples where data theft has halted businesses or resulted in bad press that will leave a tarnished image. For instance, in 2017,...
database-tools
Categories
- Free tools
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- 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
Identifying AD Accounts without Proper Encryption Type
You may have accounts (inc. trust accounts) in AD that have a null value for msds-SupportedEncryptionTypes. They may have been working "by accident"...
SpeculationControl: Use PowerShell to Check for Risks
Checking Hardware Vulnerability to Spectre and Meltdown Microsoft released a module a couple of years ago (updated 3 weeks ago) that you can use to...
Creating ISO Files
PowerShell can turn regular folders into ISO files. ISO files are binary files that can be mounted and then behave like a read-only CD-ROM drive....
Automating Defender Antivirus (Part 2)
On Windows, PowerShell comes with cmdlets to automate the built-in antivirus engine “Defender”. In this second part, let’s take a look at how you...
Manage data and result sets, and SQL queries with Aqua Data Studio
Aqua Data Studio improves access and consistency by accessing data sources from a single tool to minimize the learning curve and maximize the...
Converting Wavelength to RGB
PowerShell is a generic script language so you can do all kinds of stuff with it. Below is a function that takes a light wavelength and converts it...
Querying Advanced Printer Info via SNMP
Many network printer support SNMP to query information about the device, i.e. its serial number, the status and paper sizes of installed trays, or...
Analyze blocking for SQL Server
Blocking is a normal activity that occurs in SQL Server and it does that to control data integrity and make sure only one resource can change a set...
Using Efficient Lists in PowerShell
By default, PowerShell uses simple “object arrays” when you define lists, when commands return more than one result, or when you otherwise need to...
Managing File Shares on Windows with PowerShell (Part 1)
Managing Network Shares with the SMBShare Module Windows comes with a module called “SMBShare” which contains 42 cmdlets to manage network shares....
Out-GridView with Custom Columns
Out-GridView can be a universal dialog when you use the -OutputMode or -PassThru parameters. When you do, a grid view window displays additional...
Converting Ticks to DateTime
Occasionally, date and time information are stored as “Ticks” in the format of a so-called “FileTime”. Ticks are 100-nanosecond units since...
Repairing Install-Module (PowerShellGet)
With Install-Module, you can easily download and install additional PowerShell modules from the PowerShell Gallery (www.powershellgallery.com)....
Identifying Name of Local Administrator Account
Occasionally, PowerShell scripts need to access or use the built-in Administrator account or the built-in Administrators group. Unfortunately, their...
Reading Last Logged-On User and Other Registry Values
Reading some registry values with PowerShell is typically a snap: simply use Get-ItemProperty. This snippet of code reads the Windows operating...
Converting File Paths to 8.3 (Part 1)
Why Short Path Names Still Matter Many years ago, file and folder names had a maximum of 8 characters, and these short path names still exist. They...
Updating Help without Admin Privileges
In Windows PowerShell, updating help used to require Administrator privileges due to a design flaw: help had to be stored in the location where the...
Setting and Clearing Trusted Hosts
PowerShell remoting maintains a list of trusted IP addresses and/or machine names on the client side (the machine that issues the command and...
Using PowerShell 7 inside PowerShell ISE
The PowerShell ISE built into Windows works with Windows PowerShell only and is stuck at PowerShell version 5.1. Typically, when you want to use an...
Identifying Antivirus Engine State
In the previous tip you learned how you can query WMI to find out the antivirus product present on your Windows machine: $info = Get-CimInstance...