Organizations that make efforts to secure MySQL databases can massively mitigate the risk of suffering a data breach. The escalating number of data...
database-tools
The Right Tools Makes All the Difference
The earliest evidence of the ancient use of tools goes back to about 2.6 million years ago. Basic stone implements were one of the driving forces...
Identifying Antivirus Engine State
In the previous tip you learned how you can query WMI to find out the antivirus product present on your Windows machine: $info = Get-CimInstance...
How can you handle the complexities of analytics for big data for healthcare?
Analytics for big data rapidly has become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions...
Identifying Installed Antivirus Product
A PowerShell one-liner can help you identify the antivirus product installed on a Windows box: PS> Get-CimInstance -Namespace...
What are the real benefits of database automation?
Many of the administrative tasks required to keep databases operating efficiently need to be performed regularly. While in some respects, these...
An Efficient Solution for Multi-Platform Environments
One of the challenges that database teams face every day is keeping up with their responsibilities in multi-platform environments. In many shops, a...
Deleting Microsoft Teams Cache Data
If you use Microsoft Teams for video conferencing, you may occasionally want to clean cache files and remove traces which reside in a number of...
SQL Server Tuning Tips You Need to Know
Tuning their systems for optimal performance is one of the main responsibilities of database administrators. It can often be a difficult task to...
Best Practices for a Successful Data Migration
Data migration is defined as the process of transporting data between computer systems, storage devices, or formats. While it is usually not part of...
Deleting Multiple Subfolders
Occasionally, it may become necessary to delete a set of subfolders within a given folder. Here is a simple chunk of code that deletes the folders...
What do you need to consider when moving databases out of the cloud during cloud repatriation?
The promise inherent in new paradigms can often be the impetus for making major decisions in the business world. Companies want to take advantage of...
Surviving the Damages of a Data Breach
Just about the last thing that any IT organization wants to experience is a data breach. The ramifications of misappropriated data can be severe and...
Managing Autostarts
To manage auto starting programs on Windows, don’t bother writing extensive scripts. PowerShell can directly open the autostart manager...
Is your organization ready for the Internet of Things (IoT)?
The Internet of Things (IoT) is the term used to describe the connection of network-capable devices to the Internet and other connected devices. The...
Using Data Analytics for a Competitive Advantage
In the ultra-competitive markets of the 21st Century, business leaders are always in search of methods with which to gain an advantage over their...
Downloading Useful Scripts
The PowerShell Gallery not only offers public modules with new PowerShell commands but also public scripts. Before you invest time, you may want to...
Welcome to the Modern Precise
Welcome to the modern Precise UI. Precise is now available on all modern browsers such as Chrome and Firefox and can even be launched on tablets...
What You Need to Know About SQL Server Blocking and Locking
When implementing SQL Server instances, performance is one of the key factors in determining the success or failure of a database and its...
Speeding Up PowerShell Remoting
PowerShell remoting is insanely powerful: with Invoke-Command, you can send arbitrary PowerShell code to one or many remote machines and execute it...
Learn about advanced database performance tuning for SQL Server and Azure SQL Database.
The roles of database professionals are always evolving. However, their tuning skills should remain sharp. Tuning proficiency is still one of the...
IDERA Newsletter August 2020 (Database Administrator edition)
Product Release SQL Diagnostic Manager for SQL Server 10.6 We are delighted to announce that the latest release of SQL Diagnostic Manager is...
IDERA Newsletter August 2020 (Database Developer edition)
Product Release New! Aqua Data Studio 20.6 We are delighted to announce that the latest release of Aqua Data Studio is now available....
Database Development in Multi-Platform Environments
Multi-platform database environments are the norm in today’s business world. A database developer or administrator may still exhibit expertise...