I'm sure you have all heard the phrase "Beauty is in the Eye of the Beholder". It's something we learn when we are young, that...
database-tools
Getting List of Current Group Memberships
While you can contact the Active Directory to retrieve a list of group memberships for a user, a much easier way gets that information directly from...
Integrating SQL Diagnostic Manager with ServiceNow! email receiver functionality
This document describes the procedure of using email action responses in SQL DM to provide information to ServiceNow via its email receiver and...
ServiceNow! SOAP API Integration PowerShell script for SQL Diagnostic Manager
A PowerShell script to integrate SQL Diagnostic Manager into ServiceNow! Uses the SOAP API, and a custom WSDL in ServiceNow! Requires some...
Translating SID to Username
Ever wanted to translate a security identifier (SID) to the real name? Here is a function helping you: #requires -Version 3.0 function...
Get GeoLocation of Computer
Here is yet another free source of geolocation information, exposing your current public IP and location information: #requires -Version 3.0...
Why Be Normal?
Being normal may not seem like much fun; I wore a “Why Be Normal?” button with pride throughout college. And I did it out of choice rather than as...
Precise Alerting: duration of history & GUI speed
Precise keeps a rolling three year history. Some shops value this duration because it includes multiple quarter-end and year-end processing...
Finding Operating System Architecture Information
Here is a one-liner that retrieves information about your operating system: Get-WmiObject -Class Win32_OperatingSystem | Select-Object -Property...
Finding Operating System Versions in Active Directory
If you have installed the free Microsoft RSAT tools with the “ActiveDirectory” PowerShell module, here is a quick way to get a list of...
Finding First and Last Day in Month
Did you ever need the first and last day in a given month? Here is a simple approach: # specify the date you want to examine # default is today...
Building a Business-Driven Data Architecture
In September, IDERA’s Ron Huizenga joined Eric Little and Malcolm Chisholm for a Hot Technologies session, hosted by Eric Kavanagh of the Bloor...
Geolocating Your IP on a Map
As you have seen in previous tips, the Internet knows your IP address, and also where you are located. You can get the latitude and longitude of...
IDERA Announces Rapid Database Extractor Free Tool
We’ve recently released our latest free tool which is the first in the database development portfolio. With this new release, we now have 23...
Finding Public IP Address
Would you like to know what your public IP address is that you are currently using while being connected to the Internet? It’s a one-liner:...
Finding Location of IP Address
Most IP addresses can be located using web services. Here is a very simple function that takes an IP address and returns information about its...
Finding IP Address Assigned by DHCP
Beginning with Windows 8 and Server 2012, operating systems ship with extensive PowerShell modules to manage server and client. They provide cmdlets...
Enum Week: Enums in PowerShell 5
Requires PowerShell 5 or better This week we are looking at enumerations: what they are, and how you can benefit from them. Beginning in PowerShell...
Enum Week: Suppressing Cmdlet Errors – Fast
This week we are looking at enumerations: what they are, and how you can benefit from them. In the previous tips, we looked at enumerations, and...
Enum Week: Understanding Enumeration Values
This week we are looking at enumerations: what they are, and how you can benefit from them. In the previous tips, we explored how enumerations work....
Enum Week: Listing Enumeration Values
This week we are looking at enumerations: what they are, and how you can benefit from them. In the previous tip we explained how PowerShell converts...
Enum Week: Auto-Conversion for Enums
This week we are looking at enumerations: what they are, and how you can benefit from them. When a cmdlet or method requires an enumeration value,...
Working with UTC Times
When working across language boundaries, you might want to use a way to “normalize” date and time, for example for logging. Instead of...
New Free Tool: Rapid Database Extractor
IDERA released a new free tool, Rapid Database Extractor, designed to help you gain quick visibility into SQL Server and Oracle databases from a...