PowerShell 3+ The popular winrm command to manage and configure PowerShell Remoting is really just a batch and a VBS file: PS> Get-Command winrm...
database-tools
Listening to Music in the Background
PowerShell 3+ In the previous tip we presented to you a “Dancing Rick ASCII”, created by Lee Holmes. Lee uses music stored on his server...
The Most Powerful Reaction in IT
Lately, I’ve been seeing a particular video depicting simple yet amazing chemical reactions making its way through my social media feeds....
5 Database Reports In SQL Server Management Tools
When connecting to a SQL Server instance in SQL Server Management Studio, there are built in reports for databases you can use for free. These RDL...
Smuggling In PowerShell Code
PowerShell 2 There is a good reason why Invoke-Expression is considered risky. This cmdlet executes whatever string it gets, and attackers can...
This Idera ACE Has Been Busy
This year has been a whirlwind so far, thanks to the Idera ACE program. For those that don’t know what that is … What is an Idera ACE? (According to...
Display Windows
PowerShell 3+ It is fairly easy to use WPF (Windows Presentation Foundation) to create and show simple dialog windows in PowerShell. If you’d...
The Importance of Enterprise Data Architecture
An expert in enterprise data architecture, IDERA’s Ron Huizenga joined several other panelists on a DMRadio session called “Method to...
Add a Clock to PowerShell
PowerShell 2+ Here is a fun example that illustrates how to work with timers. It adds a clock to the title bar of the PowerShell console or the...
Changing Page File Location
PowerShell 2+ To move the Windows page file to a new location, you can use WMI: #requires -Version 2 $args = @{ Name = "D:\pagefile.sys" InitialSize...
Encrypting and Decrypting Secret Strings
When there is the need to encrypt sensitive data, scripts always face the challenge to protect the secret key used to decrypt. If the secret is to...
Do you Manage Multiple Servers? Participate in our September #SQLChat!
Our next #SQLChat will take place Wednesday, September 7th at 11 AM CT with K. Brian Kelley (@kbriankelley). Corresponding with Brian’s...
Finding Groups of Logged On User
If you’d like to know the group memberships of the currently logged on user (the one that is running a script), you don’t need to query...
Setup ER/Studio Repository with Microsoft SQL Server in Amazon Web Services
Howdy! In this series, we will explore on how easy it is to setup our Model Repository in the Amazon Web Services Cloud...
Setting up ER/Studio Repository with Microsoft SQL Server in Microsoft Azure Virtual Machines
Howdy! In this series, we will explore on how easy it is to setup our Model Repository in the Microsoft Azure Cloud. Now I will not be...
The Bloor Group: Hot Technologies with Dr. Robin Bloor, Dez Blanchfield and IDERA
Precise is an Application Performance Management solution. It solves a frustrating, time consuming, and expensive problem. When...
Creating Dynamic Variable Content
PowerShell 2+ In the previous tip we introduced variables with read-only dynamic content that updated each time the variable was read. This required...
Creating Dynamic Variable Content
PowerShell 2+ A little-known fact is that you can add variables to PowerShell that automatically update their content. If you need random numbers,...
End Users Complaining About Screen Freeze
Few things are more frustrating than not being able to complete a task because the computer screen froze. Screen freezes are particularly...
Peoplesoft 9.2 Upgrade – Fluid User Interface Performance
PeopleSoft version 9.2 offers new functionality to improve processes and productivity. Per PeopleSoft 9.2, there are over 1,000 enhancements. This...
Create Simple PowerShell Host
PowerShell 2 or better There are sometimes a lot of good reasons why you’d like to run a script by a different host. powershell.exe might be...
Creating PowerShell Web Server
All Versions Here is an example that implements a simple web server with just a few lines of code. When you run this script, you can enter one of...
Changing Password
All versions Here is a simple way how an existing user can change the password for his account. The user must know his old password and does not...
Why Netflix decided to migrate to AWS?
Netflix recently published an article describing the completion of billing migration to Amazon Web Services. More than half of the services...