If you’d like to show a default MessageBox with some buttons for the user to click, try this function: function Show-MessageBox {...
database-tools
Displaying Input Box
If you’d like to open a quick and dirty input box to prompt a user for some data, you could access Microsoft Visual Basic and...
Data Lineage – The Power to Connect the Dots in ER/Studio
Howdy! Ever considered or wanted to know how Data would move around the organization? Data Lineage is a key driver that ensures on connecting the...
Reading Text Files Fast
There are plenty of ways how PowerShell can read in text files, and they can differ considerably in time. Check for yourself. The examples below...
Create Universal Time from Local Time in ISO Format
If you’re working across countries and time zones, you may want to use universal time instead of local time. And to ensure that the time...
Reading Event Logs Smart (Part 2)
In the previous tip we illustrated how you can access detailed event log information that you retrieved via Get-EventLog by using...
How to become a database administrator for SQL Server
Database administrators need to handle all facets of managing Microsoft SQL Server ranging from installation and patching to creating databases to...
Reading Event Logs Smart (Part 1)
When you query an event log with PowerShell, by default you get back a text message with the logged information. For example, if you’d like to know...
Understanding Type Accelerators (Part 2)
PowerShell comes with a number of hard-coded type accelerators that serve like aliases for commonly used .NET types, and since they are a lot...
Setting up Basic Master-Slave Replication in MySQL 8
Since April 19th, when MySQL 8.0 became Generally Available (GA), the MySQL community has been abuzz with excitement over all of the new features...
Understanding Type Accelerators (Part 1)
“Type Accelerators” work like aliases for .NET types. They are intended to save typing. For example, the [ADSI] “type”...
Analyze MySQL & MariaDB Error Log Messages using Monyog
The MySQL error log is an essential part of database server performance monitoring. Whenever something goes wrong or performance degrades, the Error...
Out-Notepad: Send Information to Notepad
Have you ever wanted to send text directly to Notepad, without having to use a file? Typically, you would need to write the text to a file, then...
Announcing the GA Release of SQL Compliance Manager 5.5
We’re excited to announce the release of SQL Compliance Manager 5.5 SQL Compliance Manager is a comprehensive database auditing solution that...
Using Secret $FormatEnumerationLimit variable
Format-List by default displays object properties in a list, and if a property contains an array, the array is turned into text, and only a few...
How to learn PowerShell for free
Microsoft’s Windows PowerShell is a task-based command-line shell and scripting language. It is an automation platform and scripting language...
July #SQLChat – Death of the DBA
“The DBA is dying” has been a common concept for at least 15 - 20 years. What makes this time period different? Join IDERA...
Turning Display Off Immediately
If you are about to launch a lengthy automation script, why not turn off the display right away instead of waiting for the screen saver timeout to...
Configuring Network Adapter
Here is a simple example illustrating how you assign IP address, gateway, and DNS server to a network adapter. The script lists all active network...
Connecting to PostgreSQL and MySQL via ODBC to IDERA’s ER/Studio Data Architect
Howdy! Introduction: In this blog post, we will show you how easy it is to connect to MySQL and PostgreSQL via ODBC. As you are aware we can reverse...
Enhance Database Performance with SQL Tuning in DB Optimizer
In today's economy it is imperative that database developers work smarter, not harder, to meet the demands put on them by line of business...
Free PowerShell Help Manuals
Even experienced PowerShell users often ignore that PowerShell comes with an excellent help system, much similar to the man pages in Linux. All you...
Managing Windows 10 Default Apps with PowerShell
Windows 10 comes with a load of apps preinstalled, and even if you remove things manually, they might come back after the next big Windows 10...
Welcome AquaCluster Users to the IDERA Community!
We are excited to welcome the AquaCluster users to the IDERA Community! As you know, IDERA acquired AquaFold in July 2017, and we are committed to...