All PowerShell Versions WMI is a great and powerful technique: simply specify a WMI class name, and back you get all the instances of that class:...
database-tools
List All Information
All PowerShell Versions Most of the time, PowerShell will not show you the complete results that you get from cmdlets. Instead, PowerShell limits...
Big Data the BuzzWord by Pinal Dave
The talk of the town these days is around Big Data if you are in a data-related domain. Most of the top CIOs are trying to get onto this bandwagon...
5 Things Developers Must Know for Working with their Databases
This article by Pinal Dave looks at some of the developer traits that one must keep in mind while working with databases Being in the databases...
Getting US ZIP Codes
All PowerShell Versions Ever wanted to find out the ZIP code of a city, or vice versa find out the city that belongs to a ZIP code? Then simply ask...
Reading Registry Values with Type
All PowerShell Versions Reading all registry values is simple when you do not need the data type: simply use Get-ItemProperty: Get-ItemProperty...
Finding Files plus Errors
All PowerShell Versions When you use Get-ChildItem to recursively search directory paths for files, you may stumble across subfolders where you do...
The Metadata Conundrum – by David Loshin
This is the second in a series of six posts from David Loshin. Read the previous post and the next post in the series. In my last...
Finding Changeable Properties
All PowerShell Versions When you get back results from PowerShell cmdlets, the results are objects and have properties. Some properties can be...
Auto Replace in Rapid SQL by Dan Hotka
Hi! Dan Hotka here with more knowledge about Rapid SQL. I’ll address the auto replace feature of this tool and how you can use this feature to...
Rapid SQL Query Builder Tips and Techniques by Dan Hotka
Hi! Don’t you just love a good SQL query builder? I found this tool in Rapid SQL easy to learn and easy to produce the SQL I desired. You start it...
Getting a Variable Inventory
PowerShell ISE 3 and later For documentation purposes, you may want to get a list of all variables that a PowerShell script uses. Here is a function...
Renaming Variables
PowerShell ISE 3 and later Here is a simple variable renaming function that you can use in the built-in ISE editor that ships with PowerShell 3 and...
Normalizing Line Endings
All PowerShell Versions When you download files from the Internet, you may run into situations where the file won’t open correctly in editors....
Identifying Network Vendors by MAC Address
All PowerShell Versions Each MAC address uniquely identifies a network device. The MAC address is assigned by a network equipment vendor. So you can...
SQL Traffic Accelerator as a DB performance tool
We get questions from time to time from folks asking what SQL Traffic Accelerator does for DBAs since it sounds like a network monitoring tool....
Getting MAC Addresses
All PowerShell Versions Getting the MAC of a network adapter is rather simple in PowerShell. Here is one of many ways: PS> getmac /FO CSV |...
Advanced Text Splitting
All PowerShell Versions When you use the –split operator to split text, then the split text is consumed: PS> 'Hello, this is a text,...
Text Splitting
All PowerShell Versions With the –split operator, you can split text at given locations. The operator expects a regular expression, so if you...
Replacing Duplicate Spaces
All PowerShell Versions To eliminate any duplicate space, try this regular expression: PS> '[ Man, it works! ]' -replace...
Creating TinyURLs
All PowerShell Versions You probably have heard about shortening long URLs. There are plenty of free services available. Here is a script that turns...
Mission Impossible? Effective Database Backup Strategies
Mission Impossible? Effective Database Backup Strategies Organizations use multiple strategies when working with backups. An effective restore...
Enterprise Data Confusion – Did We Bring This Onto Ourselves? – authored by David Loshin, Knowledge Integrity, Inc.
This is the first in a series of six posts from David Loshin. Read his next post. A few years back, I had the opportunity to work with...
Finding PowerShell Functions
PowerShell 3.0 and later To quickly scan your PowerShell script repository and find all files that have a given function in them, try this filter:...