An IT company that deals with the healthcare industry in South Africa develop a variety of software products, which cover a wide range of...
database-tools
Turn Windows Terminal into a Portable App
On Windows 10, there is a new and awesome tool available for any PowerShell user: Windows Terminal. It lets you use multiple PowerShell and other...
Why You Should Consolidate Your SQL Server Environment
Microsoft’s SQL Server is one of the most widely-used relational database solutions on the planet. Due to its popularity, there are numerous...
What do IDERA’s customers have to say about SQL Doctor?
Are you curious about who the customers of SQL Doctor are in terms of the organization, industry, and country? What is the size and the deployment...
Launching Windows Terminal for Any User
On Windows 10, there is a new and awesome tool available for any PowerShell user: Windows Terminal. It lets you use multiple PowerShell and other...
How are you tuning the performance of SQL Server, Azure SQL Database, and Amazon RDS for SQL Server?
SQL Doctor diagnoses and provides the cure for what ails SQL Server on premise, in the cloud, and as a managed cloud database. Collect performance...
Permanently Deleting AD Objects
Many Active Directory objects are protected from deletion. When you try to delete them, you get an error, preventing you from accidentally removing...
How to Handle Unexpected Issues During Cloud Migration
A common issue that affects many areas of the IT world is that things often do not go as smoothly as anticipated. Despite the best efforts that...
Deploy PowerShell as Clickable Icons (Part 2)
In the previous tip we illustrated how you can embed up to 4096 characters of PowerShell code inside a Windows Explorer shortcut file and produce...
Are You Willing to Pay the Price of Non-Compliance?
Data privacy is a hot topic in the world of information technology and promises to remain so for the foreseeable future. As the shift continues to a...
Installing Precise in an AWS or Azure environment
Precise provides support for AWS and Azure. We have provided support for AWS and Azure since Precise 9.9. (June 2018) The Precise framework...
Announcing the General Availability of SQL Secure 3.4
We are pleased to announce the general availability of SQL Secure 3.4. Customers can access the new version via the IDERA Customer Portal. New...
Deploy PowerShell as Clickable Icons (Part 1)
You can use .lnk files to deploy small PowerShell solutions to end users. Here’s how: Take below code, and replace the payload code inside...
The Problem of Data Breaches Shows No Signs of Slowing Down
An unfortunate and common problem that is encountered just about everywhere in the world is the theft of valuable items from their owners by...
Welcome to the SQL Server Query Store
The current situation we all face with the COVID-19 pandemic has made it difficult or impossible for many individuals to visit their favorite local...
Test-Driving New SSH Remoting
If you’d like to test-drive the new PowerShell remoting alternative that is using SSH instead of WinRM, make sure you install PowerShell 7...
You Need A Reliable Strategy for Protecting Data Resources
Today’s database administrator (DBA) has many responsibilities related to protecting and maintaining access to enterprise data resources....
Test Whether Applications Exist
Here is a simple one-liner that can test whether PowerShell 7 is installed on your system (or any other application): # name of application you want...
Who is Responsible and Accountable for a Data Breach?
One of the benefits of forming a corporation is that it provides a level of protection for the individuals who are making decisions regarding the...
Announcing The General Availability of DB PowerStudio 17.1
In the previous tip we introduced the PowerShell “SmbShare” module which comes with Windows and enables you to manage file shares. We looked at the...
Converting File Paths to 8.3 (Part 2)
In the previous post we explained how you can use an old COM component to convert default long path names to short 8.3 path names. While...
Do You Know How Many SQL Servers You Have?
It’s a pretty straightforward question that many database teams may have difficulty answering. For multiple reasons, it may become necessary...
Converting File Paths to 8.3 (Part 1)
Many years ago, file and folder names had a maximum of 8 characters, and these short path names still exist. They can even still be useful: short...
Lessons Learned From 3 Years in the Trenches with AWS
Since the time of our founding, IDERA has been using Amazon Web Services (AWS). It was critical to us to use cloud technologies to build our...