Any version If you browsed to a folder using File Explorer, and then would like to open a PowerShell with the current folder set to the browsed...
database-tools
Why Uber migrated its databases from Postgres to MySQL?
Uber has been in the news for numerous reasons in the past few days. Be it expansion to new countries or selling its China operations to Didi...
Getting GIT tips online
Here is an example that illustrates how you access a REST API online. The script retrieves GIT tips. GIT is an open-source control system. Even if...
Creating Shortcut Drives
All PowerShell Versions Simply add a new drive to one of the file locations you often visit: # create folder if it does not exist yet $path =...
Running PowerShell Tasks with Progress Bar
PowerShell 2+ Sometimes it may take some time for a PowerShell command to complete, and while the command is working, the user gets no visual clue....
Welcoming a New Free Tool: SQL Query Store Optimizer
We are excited to announce the release of a new free tool, SQL Query Store Optimizer, designed to help you improve the performance of SQL...
Colorful Console
PowerShell 5 PowerShell 5.0 on Windows 10 ships with a much-enhanced and colorful PowerShell console. PowerShell 5.0 on other operating systems just...
APC UPS Monitor is now available!
Hey all. I was bored this past weekend so I created a new plugin for APC UPS monitoring. The code is packaged into an Uptime plugin now and has...
Finding AD User by SAMAccountName
PowerShell 5 The free Microsoft RSAT tools come with a full-blown ActiveDirectory module, but sometimes simple AD tasks can be mastered with just a...
Finding Nested Object Secrets
PowerShell 2+ Objects can have a nested and complex inner structure, and it can be tiresome to examine properties one by one. Here is a simple...
Checking Success of Command
PowerShell 3+ Often, all you want is suppress errors, and find out whether a given cmdlet worked or not. Here is a very simplistic approach that...
ER/Studio Technical Training Sessions by e-Modelers
Are you looking for a deep-dive multi-day online training session for ER/Studio? IDERA is committed to helping our customers make the best use of...
Creating Parameters with Dynamic IntelliSense
PowerShell 3+ Today, we dive a little deeper in the programming part, and show you how a PowerShell function can have parameters that have dynamic...
Happy System Administrator Appreciation Day! Participate and Win a Roku Streaming Stick!
Friday, July 29 is National System Administrator Appreciation Day! IDERA wants to thank and recognize System Admins and other IT workers for their...
Getting New NTFS Cmdlets
PowerShell 3+ / PowerShellGet In the previous tip we explained PowerShellGet. This module ships with PowerShell 5.0 but is available for download on...
Exporting Modules across the Network
PowerShell 3+ Did you know that you can easily export modules from other computers to your local machine? Assume you don’t have the RSAT tools...
Using a Lookup Component in SSIS for Surrogate Keys in a Fact table
There are many suggestions for loading a data warehouse using SQL Server integration Services (SSIS). Once you get started, you find a pattern to...
Email round trip monitor failures on checking for email, unable to find valid certification path to requested target
Email round trip monitor failures on checking error text : sun.security.validator.ValidatorException: PKIX path building failed:...
Debugging Other PowerShell Processes
PowerShell 5 Beginning with PowerShell 5.0, the PowerShell ISE can connect to other processes that run a PowerShell runspace, display the source...
Use CredSSP to Fight Double-Hop Networking Issues
PowerShell 2+ If you do PowerShell remoting, you may have experienced “double-hop” problem. It occurs when you try to pass on your...
Reading NTFS Permissions
PowerShell 2+ NTFS permissions are represented by complex object hierarchies that are hard to read. A much simpler way is to output the structure in...
New Delayed Output in PowerShell 5.0
PowerShell 2+ Let’s do two things. First, have a look at a useful small new function that does DNS resolution. Then, let’s discuss why...
Decoded: A Day in the Life of a Database Administrator
Companies know they need a database administrator, but they probably don't have any clue about what they actually do. The primary duty for a...
Creating Your Private PowerShellGet Repository
PowerShell 3+ / PowerShellGet In the previous tip we introduced PowerShellGet and showed how you can install this module from...