This is the third part of a three-part series of blog posts. Read also the first part and second part. Analyze Queries In addition to...
database-tools
Performance (Part 1): From 6 min to 2 sec
Here is a common mistake found in many PowerShell scripts: $start = Get-Date $bucket = @() 1..100000 | ForEach-Object { $bucket += "I am adding...
Keeping Track of Script Execution
Here is a chunk of code that demonstrates how you can store private settings in the Windows Registry: # store settings here $Path =...
Retrieving Outlook Calendar Entries
If you use Outlook to organize your calendar events, here is a useful PowerShell function that connects to Outlook and dumps your calendar entries:...
Getting AD Users with Selected First Letters
How would you query for all AD users with names that start with a “e”-“g”? You shouldn’t use a client-side filter such...
DBA Paradox – Plus ca change, plus c’est la meme chose
The quote comes from Jean-Baptiste Karr. And while some may not be familiar with the source and that original language version, almost...
These are a few of my Favorite Macros!
Howdy! ER/Studio Users, Prospective Users and Data Modeling Enthusiasts.. In this short blog post , I would like to list out some of my Favorite...
Adding New Incrementing Number Column in a Grid View Window
Maybe you’d like to add a column with incrementing indices to your objects. Try this: $startcount = 0 Get-Service | Select-Object -Property...
How to Monitor the Performance of MySQL and MariaDB Databases – Part 2
This is the second part of a three-part series of blog posts. Read also the first part. Click here to view the third part. Get Overview The...
Improving Group-Object
In the previous tip we explained what Group-Object can do for you, and how awesome it is. Unfortunately, Group-Object does not scale well. When you...
We’ll See You at PASS Summit 2018!
It’s that time of year again! IDERA is excited to see everyone at PASS Summit 2018! This year’s summit will take place from November...
Discover Group-Object
Group-Object is an awesome cmdlet: it can easily visualize distributions. Check out the examples below: Get-Process | Group-Object -Property Company...
Automating “Live” Websites
Occasionally, there is the need to automate tasks on websites that have been opened manually. Maybe you need to log into internal web pages first...
Installing Printers
Starting with Windows 8 and Server 2012 R2, these operating systems ship a PowerShell module called PrintManagement. The cmdlets found in this...
How to Set Up MySQL 8 Cluster Replication
In the Setting up Basic Master-Slave Replication in MySQL 8 blog, we went through the process of setting up two MySQL servers on the same box for...
Using CSV to Create Objects
Sometimes it may be clever to use simple text-based CSV format internally to bulk-create objects, especially if the original data is already...
How to Monitor the Performance of MySQL and MariaDB Databases – Part 1
This is the first part of a three-part series of blog posts. Click here to view the second part. Overview SQL Diagnostic Manager for...
Finding Active Directory Group Members Efficiently
Often, AD Administrators need to find all members of a given AD group, including nested members. Here is a code snippet that frequently surfaces in...
Using Artificial Intelligence with Azure Cognitive Services
The cloud these days not only offers virtual machines and storage, but also brand new and exciting services such as the cognitive services. You need...
How to Build Effective Data Visualizations
A tool like Aqua Data Studio provides a rich canvas for creating data visualizations. While these charts, graphs, etc. can be eye candy, without...
Backing Up All Scripts to ZIP
PowerShell 5 finally includes support for ZIP files, so if you want to backup all of your PowerShell scripts into one ZIP file, here is a one-liner:...
Running PowerShell Code as Someone Else
Local admin privileges are extremely powerful, and you should use techniques such as JEA to minimize the number of local Admins as much as you can....
Announcing SQL Safe Backup 8.5.1 General Availability
We are pleased to announce the general availability of SQL Safe Backup 8.5.1. Existing users may upgrade to this version through the IDERA Customer...
Hardening Script Block Logging
By default, script block logging data is open to anyone, not just Administrators. When script block logging is enabled, any user can access the log...