The designers of modern SQL Server environments have many implementation models available to them. Based on the organization’s needs,...
How to Keep Track of Your SQL Servers
read more
database-tools
Identifying Compromised Passwords (Part 2)
When you want to submit sensitive information to a PowerShell function, you typically use the SecureString type. This type makes sure a user gets...
Why You Should be Encrypting Database Backups
Data security is a hot topic in the IT industry for reasons that range from simply safeguarding information resources to maintaining compliance with...
Monitoring Oracle Containers and Pluggable Databases with Precise
Precise for Oracle allows you to monitor Oracle Container Databases and Pluggable Databases (also known as Oracle Mult Tenant Architecture). It...
Identifying Compromised Passwords (Part 1)
Passwords are no longer considered safe when they are complex. Instead, you need to ensure that passwords have not been compromised and are not part...
COVID-19 Disruption Navigation
IT Systems Under Pressure? We’re here to help during this uncertain time. View our free resources to help you navigate disruption caused by...
Create Software Inventories
The Windows registry stores the names and details of all software that you installed. PowerShell can read this information and provide you with a...
Handling the Challenges of MySQL Performance in the Pandemic
The COVID-19 pandemic has highlighted the reliance that the world puts on resources available through websites. Though some of the information...
Heightened Productivity for Your DBAs with Aqua Data Studio
The importance of data resources to modern businesses has resulted in database administrators assuming a more critical role in the corporate IT...
Keep PowerShell Modules Up-To-Date
It’s important to check every now and then that your PowerShell modules are up-to-date. If you are using old and outdated modules, you can run...
Using SQL Server Database Projects
Back in 2012, I had the pleasure and privilege of working with one of the sharpest developers I’ve ever met. He was a .NET lead of the...
The Challenge of Providing Peak SQL Server Performance
Of the many responsibilities thrust upon database administrators, attempting to provide peak performance is one that can attract a lot of unwanted...
Keep Your MySQL Servers Running Smoothly
During these hard times, it is important to maintain the performance and security of your MySQL servers. Organizations are reacting to rapidly...
Adding New PowerShell Commands
PowerShell is just a scripting platform and can be extended with new commands. A great source for new commands is the public PowerShell Gallery. You...
Are Statistics Being Used?
You know those tweets that you see once but can never find again? I remember seeing one a while ago where someone tweeted to #sqlhelp asking if the...
The Importance of Database Performance During the COVID-19 Crisis
In the days before the COVID-19 pandemic began to sweep across the world, many people took information technology (IT) and databases for granted....
Getting Help for WMI Objects
WMI is extremely powerful but a little underdocumented. To change this, a group has formed and is creating a PowerShell-specific WMI reference:...
IDERA Newsletter April 2020
The Latest News from IDERA Product Release Updates, Vote IDERA, and Learn Something New Introducing SQL Inventory Manager v2.6 Get Complete...
Monitoring Infrastructure Will Help You Meet Your SLAs
In the world of information technology (IT) services, it is a requirement that some kind of contract defines the customer’s expectations and...
Backups are Your Best Friend When Disaster Strikes
IT professionals like programmers and database administrators have heard about best practices many times during their careers. Sometimes they adopt...
Ensure Database Health
Keep multiple database platforms running with a single tool. Organizations react to rapidly changing demands because of the escalating crisis while...
Reading Chassis SKU
In Windows 10 and Server 2016, WMI added a new property that simplifies collecting chassis or enclosure SKUs. This one-liner reads the SKU for you:...
Managing Automatic Reset
When a Windows system crashes, it typically reboots immediately. This is called “Automatic Reset Capability”, and with this one-liner...
The Impact of COVID-19 on Database Security
The COVID-19 pandemic is causing havoc in many areas of society across the globe. It has been the cause of thousands of deaths and has stressed our...