The PowerShell console (powershell.exe, pwsh.exe) offers extensive completion support. When you enter a command and then add a space and a hyphen,...
database-tools
Reading Registry Remotely (Part 2)
In the previous example we showed the code required to read registry values remotely from another machine using the old-fashioned DCOM protocol. If...
Azure MySQL Database as a Service – The next best thing to an Azure Database as a Service Addon
Azure MySQL...
Simple Worthwhile Database Security Practices – Part IV
Database security is a hot topic these days, especially with all the new and seemingly never-ending security compliance requirements being imposed...
Reading Registry Remotely (Part 1)
If you cannot use PowerShell remoting, and you need to read registry values from another system via DCOM, here is some example code you might want...
Hardening PowerShell Script Block Logging Log
When you enable ScriptBlockLogging, PowerShell logs all PowerShell code that is executed on your machine. Even if it is disabled, any...
SQL Diagnostic Manager 10.3 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 10.3. Existing users may upgrade to this version through...
Manipulating Registry User Hive
Reading and writing values to the HKEY_LOCAL_USER hive in the registry is easy, because this hive is the same for all users. How would you read or...
SQL Diagnostic Manager for MySQL 8.7 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager for MySQL 8.7. Existing users may upgrade to this version through...
Initializing replication from backup
Initialization of a transactional replication subscriber is a highly valuable tool. For very large databases (VLDBs), snapshot generation and...
Managing Windows Features (Part 2)
In Windows 10, unlike in Windows Server, you cannot use the Get-WindowsFeature and Add-WindowsFeature cmdlets to manage Windows features. However,...
Managing Windows Features (Part 1)
Windows 10 comes with a vast number of features, and only a subset is installed. Manually, you would open Control Panel and look at the Windows...
Simple Worthwhile Database Security Practices – Part III
Database security is a hot topic these days, especially with all the new and seemingly never-ending security compliance requirements being imposed...
Running CMD commands in PowerShell
PowerShell by default does not support the native cmd.exe command such as „dir“. Instead, it uses historic aliases called...
IDERA Now Offers Safyr for ER/Studio
Hopefully you’ve seen the news by now, but if you haven’t, you should know that earlier this month, Silwood Technologies announced that...
Getting Excuses Automatically
Invoke-WebRequest can retrieve HTML info from web pages, and regular expressions can then scrape information from these pages. Here is some code...
Separating Variables in Expandable Strings
When you use double-quoted strings, you can expand variables inside of them like this: PS C:\> "Windir: $env:windir" Windir: C:\Windows...
Understanding database backup strategies
As seasoned database administrators, you should be well on top of your backup strategies. These strategies are not written in stone. It is a journey...
Finding Windows Build Numbers
When you run winver.exe, you can easily retrieve the full Windows build number. Reading the build number from PowerShell is not as obvious. There is...
Checking for USB Devices
If you’d like to know whether a specific device is attached to your computer, you can use WMI to dump the names of all plug&play devices:...
Migrating Schemas and Data with DBArtisan
DBArtisan is a product developed by IDERA. It is a multi-platform database administration tool that simplifies your day-to-day tasks. One of those...
Simple Worthwhile Database Security Practices – Part II
Database security is a hot topic these days, especially with all the new and seemingly never ending security compliance requirements being imposed...
Using PSGraph
PSGraph is an awesome free PowerShell library that you can use to visualize relationships. Before you can use PSGraph, you need to install its...
Using AD Filters with Cmdlets (Part 4)
In the previous tip we started to look at how cmdlets from the ActiveDirectory module (part of the free RSAT tools) can filter results, and looked...