We’re excited to announce the release of SQL Compliance Manager 5.6. SQL Compliance Manager is a comprehensive database auditing solution that...
database-tools
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...
Working with GeoCoding (Part 1)
Last year, Google changed their terms and requires an individual API key now to use their geocode API. Fortunately, there are free alternatives, so...
Agile is the new Waterfall
With changes in software development methodologies, the role of the data modeler has changed significantly. In many organizations, data...
Managing Backup & Recovery is the Most Important Thing DBAs Do
I know that many database professionals will cringe at the title of this blog post, but it is absolutely the truth. DBAs are charged with many...
Cloud Service Delivery Models
In week 3 of our Solutions for the Cloud blog series, we dive into three service delivery models of the cloud concept. If you missed it, feel free...
Using Session Variables in Web Requests
Sometimes, web requests that work fine in a browser do not seem to work well in PowerShell. For example, when you navigate to...
Left Side of Comparison
When using comparison operators, always make sure the relevant part is placed left. That’s because PowerShell looks at the left side of an...
Benefits of SQL Diagnostic Manager for MySQL
Welcome to our new blog series Benefits of SQL Diagnostic Manager for MySQL. This series will discuss the features of SQL Diagnostic Manager for...
Subscribe to Lock and Unlock Events
Whenever a user locks his machine, and whenever a user unlocks a machine, Windows emits an event. PowerShell can subscribe to these events and do...
Finding Installed Updates (Part 2)
The Windows Update Client maintains its own log of installed updates. Rather than querying the generic system event log, or actively searching for...
Finding Installed Updates (Part 1)
Get-Hotfix returns installed hotfixes but really only is a wrapper around the Win32_QuickFixEngineering WMI class. It is not returning all installed...
Cloud Building Blocks and Layers
Welcome back to our blog series, Solutions for the Cloud. Now that we’ve discussed three concepts of virtualization related to the cloud, we...
Finding Missing Updates
PowerShell can access the same logic that is used by the Windows Update Client, and query for missing updates: $UpdateSession = New-Object...