[PSCustomObject _i="0" _address="0" theme_builder_area="post_content" /][2 _i="1" _address="1" theme_builder_area="post_content" /][0 _i="2"...
database-tools
Understanding Script Block Logging (Part 1)
Beginning with PowerShell 5, the PowerShell engine starts to log executed commands and scripts. By default, only commands considered potentially...
Adding Leading Zeroes
If you need numbers with leading zeroes, for example for server names, here are two approaches. First, you can turn the number into a string, then...
How to increase SQL Server performance with existing hardware
Unlike their failed counterparts, solutions are successful solely because systems, users, and organizations have come to depend upon them. Solutions...
Displaying Message Box
If you’d like to show a default MessageBox with some buttons for the user to click, try this function: function Show-MessageBox {...
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...