When you right-click a PowerShell script in File Explorer, you typically find a context menu entry called “Run with PowerShell” which...
database-tools
Categories
- Free tools
- SQL Admin Toolset
- SQL Compliance Manager
- SQL Defrag Manager
- SQL Diagnostic Manager for MySQL
- SQL Diagnostic Manager for SQL Server
- SQL Diagnostic Manager Pro
- SQL Doctor
- SQL Enterprise Job Manager
- SQL Inventory Manager
- SQL Query Tuner for SQL Server
- SQL Safe Backup
- SQL Secure
- SQL Workload Analysis for SQL Server
- Uptime Infrastructure Monitor Formerly Uptime
Launching PowerShell Scripts for Dummies
Assume you want to hand a PowerShell script to an unexperienced user. How can you reliably get that person to correctly launch your script file?...
How to better understand SQL indexing to improve SQL Server performance
Indexes in SQL Server databases can have the most significant positive impact on the performance of SQL Server instances, or they can be the worst...
Repairing PowerShellGet Publishing
If you are using Publish-Module to publish your modules to a PowerShell repository, and you keep getting exceptions about unsupported commands, it...
Splitting Large Files in Smaller Parts (Part 3)
In previous tips we illustrated how you can use PowerShell to split files into smaller file chunks, and how to join the chunks to recreate the...
Splitting Large Files in Smaller Parts (Part 2)
In our previous tip we explained how you can split large files into smaller chunks. Today, we complete this with a function that takes these file...
News from the General Manager: A Report to our Customers on Embarcadero’s Plans
Developers are under increasing pressure to reduce development cycles and keep up with changing platforms. Here’s how Embarcadero is making that...
Splitting Large Files in Smaller Parts (Part 1)
PowerShell can split large files in multiple smaller parts, for example to transfer them as email attachments. Today, we focus on splitting files....
Sending Mails via Outlook
To send mails via PowerShell, you can use Send-MailMessage. However, this requires that you have access to an SMTP server, and mails sent this way...
How to tune SQL Server in the cloud
As organizations migrate their databases to the cloud, database administrators need to consistently manage databases on-premise and in the cloud...
Mind Jogging Generator
The human mind can read sentences even if the characters are scrambled as long as the first and last letter of each word stays intact. Here is a...
Speeding Up the PowerShell Pipeline
PowerShell scripts can grow very slow when you (a) need to process a lot of items and (b) you are using the PowerShell pipeline. Let’s today...
Where-Object: Just A Pipeline-Aware If-Clause
Where-Object is one of the most frequently used PowerShell commands, yet it looks unfamiliar to new PowerShell users. Those who are familiar with...
Using Custom Prompts for Mandatory Parameters
When you define mandatory parameters in PowerShell, the user gets prompted for the value if it is missing. The prompt uses the parameter name only...
Checking Cmdlet Availability and Script Compatibility (Part 3)
Not all PowerShell cmdlets ship with PowerShell. Many are part of 3rd party modules which in turn ship when you install certain software, or use...
Organizational changes and the need to inventory SQL Server environments
In recent headlines, we have heard or seen the news on company mergers in different sectors of the economy. “Cigna and Express Script”...
How to backup and restore SQL Server in the cloud
As organizations migrate their data to the cloud, database administrators need to consistently manage data on-premise and in the cloud with existing...
Checking Cmdlet Availability and Script Compatibility (Part 2)
Not all PowerShell cmdlets ship with PowerShell. Many are part of 3rd party modules which in turn ship when you install certain software, or use...
Monitoring Windows Services with SQL Diagnostic Manager
As we all probably already know, SQL Diagnostic Manager is a powerful performance monitoring and diagnostics solution that proactively alerts...
Checking Cmdlet Availability and Script Compatibility (Part 1)
Not all PowerShell cmdlets ship with PowerShell. Many cmdlets are part of 3rd party modules which in turn ship when you install certain software, or...
Colorful ASCII-Art from Images
In the previous tip we showed you how you can take any image or photo and turn it into a black&white ASCII art. Today, we have a revised...
SQL Diagnostic Manager for MySQL 8.8 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager for MySQL 8.8. Existing users may upgrade to this version through...
Testing Raw Data with Checksums – A Real-World Example
With PowerShell entering the IoT world, sometimes it is necessary to deal with binary sensor data and ancient checksum models to verify data...
Inverting Bits
Occasionally it is necessary to invert the bits for a number. Most often, this is part of custom algorithms or checksum calculations. It raises the...
Benefit from these free resources to learn more about the cloud
This blog post is an update to the previous blog post “Learn more about the cloud with these free resources” from Thursday, May 3, 2018....
Calculating Most and Least Significant Byte
Numbers are stored internally as bytes. An Int32 value, for example, uses four bytes. Sometimes it is required to split up the number into its byte...
Accepting Parameters without Quotes
In the previous tip, we introduced a function that generates nicely centered headers and accepted a single string. Here is the function and its...
Creating Aligned Headers
Reporting and writing log files is a common task in PowerShell. Here is a simple function to create nicely centered headers. Adjust $width to the...
SQL Diagnostic Manager 10.4 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 10.4. Existing users may upgrade to this version through...
Computer Name, DNS Name, and IP Address
Here is a simple one-liner that returns your computers’ current IP address and its full DNS name: PS>...