Secure string content cannot be easily viewed: $password = Read-Host -Prompt 'Your password' -AsSecureString PS C:\> $password...
database-tools
Using Catalog Files
Catalog file support (.cat) is new in PowerShell 5.1. Cat files basically are file lists with hash values. You can use them to ensure that a given...
Making Error Records More Readable
Whenever PowerShell encounters an error, it emits an Error Record with detailed information about the problem. Unfortunately, these objects are a...
Creating Write-Protected Functions
PowerShell functions by default can be overridden anytime, and you can also remove them using Remove-Item: function Test-Lifespan {...
Why your Always On solution is not always on
Microsoft markets a variety of SQL Server availability technologies under the umbrella term Always On. Always On is a broad term covers many...
$FormatEnumerationLimit Scoping Issues
As shown in the previous tip, the secret $FormatEnumerationLimit variable determines how many array elements are shown in output before the output...
Displaying Array Members in Output
When you output objects that have arrays in their properties, only 4 array elements are displayed, then an ellipsis truncates the rest: PS C:\>...
Find All Files Two Levels Deep
Yet another file system task: list all *.log files in a folder structure, but only to a maximum depth of 2 folder structures: Get-ChildItem -Path...
SQL Performance, Part 2: Query Analysis and Access Path Formulation
In part one of our overview of SQL performance we examined relational optimization and the things that impact it. In today’s blog post, we...
Deleting All Subfolders Below A Given Level
Here is another file system task that sounds worse than it actually is. Let’s say you need to remove all folders below a given level in a...
Deleting All Files from a Folder Structure
Sometimes tasks sound worse than they actually are. Let’s say you need to clear a folder structure and remove all files, leaving empty...
Key Considerations for Selecting a Database Tool
Database professionals must handle many different tasks during the work day, ranging from creating queries and scripts to comparing and editing...
Five database administration mistakes that can cost you your job
Everyone makes mistakes. Database administrators are no exception to that rule. When database administrators make mistakes, they are often the ones...
Announcing SQL Admin Toolset 1.9.2 General Availability
We are pleased to announce the general availability of SQL Admin Toolset 1.9.2. Existing users may upgrade to this version through the IDERA...
Adding RSS Ticker to PowerShell Title Bar
A new PowerShell background thread can do things for you in the background, for example updating your PowerShell window title bar with new news...
Invoke-WebRequest vs. Invoke-RestMethod
Invoke-WebRequest simply downloads the content from any web site. It is then your job to read the content and make sense of it. In the previous tip...
SQL Performance, Part 1: Relational Optimization
Application developers must code efficient SQL and understand how to optimize SQL in order to develop efficient applications. But it is not just the...
Downloading PowerShell Code
In the previous tip we explained how Invoke-WebRequest can be used to download the raw HTML content for any web page. This can also be used to...
Hiding Progress Bars
Sometimes, cmdlets automatically display a progress bar. Here is an example of such a progress bar: $url =...
Announcing SQL Inventory Manager 2.5 General Availability
We are pleased to announce the general availability of SQL Inventory Manager 2.5. Existing users may upgrade to this version through the IDERA...
Analyzing Web Page Content
PowerShell comes with a built-in web client which can retrieve HTML content for you. For a simple web page analysis, use the -UseBasicParsing...
Seven steps to alert effectively
Automated alerts are essential to performance monitoring. Automated alerts enable spotting issues in infrastructures, identifying their causes, and...
Adding Extra Safety Net
If you are writing PowerShell functions, and you know a particular function has the potential to cause a lot of harm, there is an easy way of adding...
Introducing IDERA SQL DM Performance Insights for Azure Data Studio
IDERA is pleased to announce the introduction of IDERA SQL DM Performance Insights, a Microsoft Azure Data Studio (ADS) extension which displays key...