In the previous tip we created a function called ConvertFrom-ErrorRecord that makes it easy to retrieve all relevant error information from...
Using ConvertFrom-ErrorRecord in try/catch
read more
database-tools
Converting Error Records
Whenever PowerShell raises an error, an error record is written to $error which is an array storing the last errors that occurred. You can try and...
Improve MariaDB Performance using Query Profiling
Query profiling is a useful technique for analyzing the overall performance of a database. Considering that a single mid-to-large sized application...
Downloading Information from Internet (Part 8)
In the previous tip we illustrated how to download files from the internet using Invoke-WebRequest. However, this works for HTTP addresses only....
Downloading Information from Internet (Part 7)
In this part of this mini-series, we are showing you how Invoke-WebRequest can download files from the internet for you. Simply use the parameter...
Downloading Information from Internet (Part 6)
In the previous tip we explained how you can retrieve XML data from webpages using either Invoke-WebRequest or Invoke-RestMethod. For XML data,...
April SQLChat on DataGovernance (on Twitter)
This week I had the honor to host the #SQLChat on Twitter on the topic of Data Governance. Here's some quick highlights from hour long...
Downloading Information from Internet (Part 5)
In the previous tip we illustrated how Invoke-WebRequest can be used to download JSON or XML data from a web page. This example downloads the...
Data Vault Modeling with ER/Studio Data Architect
Overview I have been asked multiple times if ER/Studio supports Data Vault Modeling. The answer is yes, ER/Studio does support multiple approaches...
Downloading Information from Internet (Part 4)
In the previous tip we explained how you can use Invoke-WebRequest to download data from webpages, and for example retrieve excuses from a webpage...
Downloading Information from Internet (Part 3)
In previous tips, we showed how to use Invoke-WebRequest to download data from webpages, and process data delivered in JSON or XML format. Most...
Error Logging in MySQL 8
Although only available as a Release Candidate, MySQL 8 is already proving itself to be a huge leap forward in many regards. Error logging is no...
Downloading Information from Internet (Part 2)
Invoke-WebRequest can download any type of information, and it is up to you to convert it into the format of choice. In the previous tip, we...
Webyog joins Idera’s Database Tools Family
We’re excited to announce that Webyog has been acquired by Idera, Inc. Idera, Inc. is a leading provider of B2B software productivity tools that...
Downloading Information from Internet (Part 1)
PowerShell comes with two powerful cmdlets that you can use to retrieve information from the internet. Today, we focus on Invoke-WebRequest. This...
Purging Kerberos Tickets for All Accounts
In the previous tip we covered klist.exe and how it can be used to purge all Kerberos tickets for the current user so that new permissions will take...
Learning from Facebook’s Data Harvesting Mistakes
At the moment, Mark Zuckerberg is testifying in front of Congress. Facebook is under the microscope because they allowed an app to take data that...
Setting up ER/Studio in the Google Cloud Platform – Part I – Setup
Hi All, In this blog post we will be going through on how to setting up IDERA's ER/Studio Repository Database Setup in The Google Cloud. In Part...
Purging Kerberos Tickets for the Current User
No need to reboot a system just to apply new permission settings. Instead, purge your Kerberos tickets so that you will get a new ticket based on...
Changing Lanes: Shifting Roles with Relational and Big Data Platforms
As Relational and Big Data Store databases evolve, so do the responsibilities of the people that support them. Whether you are an Analyst dealing...
Creating Hexadecimal Values
Here are a couple of ways to convert decimal to hexadecimal notation: $value = 255 [Convert]::ToString($value, 16) '{0:x}' -f $value...
Announcing SQL Safe Backup 8.5 General Availability
We are pleased to announce the general availability of SQL Safe Backup 8.5. Existing users may upgrade to this version through the IDERA Customer...
Is Redshift giving you the Blues? ER/Studio has the cure.
In my 35 years of data modeling many data platforms have come and gone, while others continue to change. For many, maintaining pace with the...
Installing PowerShell 6 with Chocolatey
In the previous tips, we explained how you can download and install Chocolatey, a free Windows package manager that can install software for you....