We are always looking for feedback to ensure we produce products that make your job easier. We’d very much appreciate if you’d take this short...
Survey: What database platforms are you using?
read more
Month: July 2014
Copying Command History as a Tool
In a previous tip we illustrated how you can copy the previously entered interactive PowerShell commands to your favorite script editor. Here is a...
Mobile User Interface Design: Navigation Drawer
Drawer menus are very popular since they allow you to take advantage of more screen real estate when building your app. The main application menu is...
DBAs and Dinosaurs
You have to admit that title is catchier than yet another “Death of the DBA” blog. And that was exactly the direction I was headed until I ran a...
Finding Dates Between Two Dates
If you must know how many days are between two dates, you can easily find out by using New-TimeSpan: $startdate = Get-Date $enddate = Get-Date -Date...
Using Default Parameters
In PowerShell 3.0, an option was added to define default values for arbitrary cmdlet parameters. This line, for example, would set the default value...
Speeding Up Scripts with StringBuilder
Often, scripts add new text to existing text. Here is a piece of code that may look familiar to you: Measure-Command { $text = "Hello" for...
SQL diagnostic manager Secrets: Configuring Alerts
There are a lot of features in SQL diagnostic manager. In this series, I plan to let you know about features that many users never find. In...
Finding Working Days
To find all working days in a given month, here is a neat little one-liner: $month = 7 1..31 | ForEach-Object { Get-Date -Day $_ -Month $month } |...
Why Directories Have a Size of 1
Occasionally, you may notice that folders have a length of 1 byte. This was introduced in PowerShell 3.0. In PowerShell 2.0, they did not report...