Maybe you stumbled across code like this in the past: $shell = New-Object -ComObject WScript.Shell $value = $shell.Popup('Restart...
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
Monitoring MySQL and MariaDB Servers
In week 5 of our Benefits of SQL Diagnostic Manager for MySQL blog series, we detail MySQL and MariaDB monitoring features with SQL Diagnostic...
Before You Stop Using MySQL, Read This
An organization’s databases contain information that is essential for its survival. This may encompass sensitive customer data, employee...
Increasing Pipeline Speed
The PowerShell pipeline tends to be slow when it is processing a lot of elements. This can take a lot of time: $result = 1..15000 | ForEach-Object {...
July #SQLChat – Let’s Talk About SQL Server 2019!
What’s new in SQL Server 2019? Join IDERA (@Idera_Software) and host Matt Gordon (@sqlatspeed) on July 31 at 11AM CT for a community...
The Tradeoff Between Database Security and Database Performance
Welcome to our new blog series, The Tradeoff Between Database Security and Database Performance. This series will cover best practices that will...
Using a Centralized Console Will Make You a Better DBA
Consider the working life of a database administrator (DBA). It is their responsibility to maintain the systems that contain an organization’s...
Detecting Key Presses
It may be useful for PowerShell to know whether a given key is currently pressed. This way, your profile script could, for example, do things during...
Monitoring Can be a Valuable Capacity Planning Tool
The cloud provides numerous examples of new and exciting uses of its powerful and flexible computing resources. There are many advantages afforded...
Understand Database Performance Trends
Next in our Benefits of SQL Diagnostic Manager for MySQL blog series, we discuss monitoring and understanding performance trends using visual...
Overriding Out-Default (Part 3)
Advanced PowerShell users often find themselves doing one of three things: They run a previous command and add Get-Member to learn more about the...
What’s New in SQL Compliance Manager 5.6
SQL Compliance Manager 5.6 was released last week Last week we released SQL Compliance Manager 5.6. Along with it are some new and exciting changes...
When was the Last Time You Tested Your DR Plan?
It’s a fairly innocent question that can send a DBA into a bit of a panic. Hopefully, the issue is not over the very existence of a...
DBArtisan Tips, Security, Projects and Visual Query builder
Welcome to the DB PowerStudio Blog. This blog will cover all things about DB PowerStudio. DBArtisan is one part of the suite of tools known as DB...
Overriding Out-Default (Part 2)
When you override Out-Default to do something meaningful, you really want to make sure the old behavior isn’t lost, and instead just something...
Optimize Your MySQL Systems with Focused Monitoring
The working life of a DBA is often centered on optimizing their systems to provide users with the best performance. There are many aspects of a...
Get Prepared for an American GDPR
Business vector created by freepik - www.freepik.com From its definition of a data breach to the size of the punitive fines it has the power to...
Overriding Out-Default (Part 1)
Out-Default is a hidden PowerShell cmdlet that gets called at the end of each command, and outputs results to the console. You can override this...
Announcing the GA Release of SQL Compliance Manager 5.6
We’re excited to announce the release of SQL Compliance Manager 5.6. SQL Compliance Manager is a comprehensive database auditing solution that...
Find, Monitor, and Analyze Problematic SQL Queries – SQL Diagnostic Manager for MySQL
In week 3 of our series, Benefits of SQL Diagnostic Manager for MySQL, we discuss how to identify and analyze problematic SQL queries using SQL...
How to Identify Security Weaknesses with Performance Monitoring
Technology photo created by rawpixel.com - www.freepik.com Modern IT systems present complex and interconnected frameworks on which organizations...
How to Make Your Data Say More With Visualization
Business photo created by rawpixel.com - www.freepik.com Ever since the first photographs were taken in the 1800s, people have been influenced by...
Use Out-GridView as Output Window
Typically, Out-GridView opens a window and displays whatever you pipe into the cmdlet: PS C:\> Get-Service | Out-GridView However, with a little...
Beer Challenge Results: Shortest Code for Password Analysis
At psconf.eu there was recently a challenge for the shortest code to check for how often a password was previously pwnd (hacked). Here is the result...
Cloud Deployment Models
Concluding our Solutions for the Cloud blog series, we discuss cloud deployment models - public cloud, private cloud, hybrid cloud, and community...
Geocoding: Sentiment Analysis (Part 5)
Some geocoding APIs provide sophisticated sentiment analysis like in the example below: "Most important museums of Amsterdam are located on the...
Geocoding: Text Scanning (Part 4)
Geocoding can automatically extract geolocations from text. This example also shows a new way of submitting information to a server: in the example...
Agentless Monitoring and Cloud Readiness with SQL Diagnostic Manager for MySQL
Welcome back to our blog series, Benefits of SQL Diagnostic Manager for MySQL. Last week, we discussed some of the challenges associated with MySQL...
Geocoding: Converting Lat/Long to Addresses (Part 3)
Today, we’d like to do the opposite and translate latitude and longitude into an address: '52.37799,9.75195' | ForEach-Object -Begin...
Geocoding: Converting Addresses to Lat/Long (Part 2)
Let’s start with translating addresses into latitude and longitude coordinates. We assume you read the previous parts to fully understand the...