In the previous tip we created a function called ConvertFrom-ErrorRecord that makes it easy to retrieve all relevant error information from...
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
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....
Using Chocolatey with PowerShell
Chocolatey is a free package manager for Windows that can be used to download and install software. Before you can use Chocolatey from PowerShell,...
Free Virtual Conference! IDERA Live 2018
It’s that time of year again! We invite you to join us for IDERA Live, our second-annual Virtual Conference, designed to educate and inform...
Examining Digital Signature Signers
When you download a script from the internet, it may contain a digital signature that can help you find out where the script comes from. We looked...
Trusting Downloaded Scripts
Scripts downloaded via Internet have a great potential of being infected with malware, or originate from illegitimate sources. Digital signatures...
Execution Policy and Downloaded Script Files
When you download a file from the internet, it may be tagged by Windows (via NTFS stream), and PowerShell may refuse to execute it: PS> &...
Creating Custom Reports in Precise
The Precise solution gathers a lot of information across all tiers of web-based applications, as well as database activity. This data is stored in...