In the ever-changing world of technology, we sometimes inherit environments with multiple database platforms and must continue to manage them. This...
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
Test-Driving PowerShellGet Version 3
PowerShellGet is a module and contains important cmdlets such as Install-Module, so this module is really the prerequisite for downloading and...
How did the database administrator role change in 2022?
Organizations are experiencing the effects of rapid technological advancement across every sector and industry, causing them to rely on secure and...
SpeculationControl: Use PowerShell to Check for Risks
Microsoft released a module a couple of years ago (updated 3 weeks ago) that you can use to identify whether your hardware is vulnerable against...
Getting Parent Culture
Most of the time, localized resources are tagged with a culture name such as “en-us” or “de-de”. If you’d like to know what such an ID stands for,...
Design data intensive cloud native applications
The cloud is transforming the way modern-day applications are being designed. Data is at the center of multiple challenges while architecting...
Dealing with the Complexities of Regulatory Compliance
Why is Data Privacy Important? An incredible amount of digital information is generated daily, with an estimated 1.7 MB of data being created every...
Invoke-RestMethod Cancellation Issues
Both Invoke-WebRequest and Invoke-RestMethod are simple-to-use cmdlets to download information from the web. For example, this simple code can query...
Key points to remember while using SQLyog
SQLyog is a powerful MySQL development and administration solution, trusted by 2.5 million users around the world. With SQLyog, organizations have a...
Two Type Casts (and one bug)
To explicitly convert one data type to another, PowerShell offers two ways: PS> [int]5.6 6 PS> 5.6 -as [int] 6 While both approaches yield identical...
Announcing General Availability of DB PowerStudio (DBPS) version 18.4
We are pleased to announce the general availability of DB PowerStudio version 18.4! IDERA’s DB PowerStudio provides a powerful cross-platform...
Fundamentals of database people and DevOps
DevOps is a software delivery philosophy that focuses on delivering quality faster. The environment of everyone is different. But we can translate...
Mounting ISO Files
In our previous tip we showed how you can easily turn local folders into ISO file images. Today, we look at how you can mount (and dismount) your...
Monitor MySQL managed cloud databases with ease
Once upon a time, organizations hosted their database servers on-premises. Later, they moved to data centers, and now we often find the same servers...
Creating ISO Files
PowerShell can turn regular folders into ISO files. ISO files are binary files that can be mounted and then behave like a read-only CD-ROM drive. In...
Progress Bar Tricks (Part 4)
Due to popular request, here is a code that illustrates how you can use nested progress bars and show a "real" progress indicator for each task your...
Understand indexes to write better queries
It is easy to learn how to query a database for information. SQL is a declarative language, meaning we tell the engine what to get, not how to get...
Initialize Transactional Replication from your Backups
This blog provides guidance on the perceived limitations and restrictions on initializing transactional replication subscribers from backups. The...
Progress Bar Tricks (Part 3)
PowerShell's built-in progress bar can be nested, showing one progress bar per task. For this to work, assign distinct ID numbers to your progress...
Better manage MySQL and MariaDB databases
Database administration refers to managing the databases in an organization. Database administration for MySQL and MariaDB databases encompasses...
Progress Bar Tricks (Part 2)
Publishing on – Mon May 15 The built-in PowerShell progress bar supports a “real” progress indicator provided you submit a “percentCompleted” value...
Adapting to the Evolving Role of the DBA with SQL DM
Over the years, the job of a Database Administrator (DBA) has become more complex and strategic, from just managing databases to a much bigger...
Compare four leading database tools
Today, many roles within an organization work with the ever growing amounts of data in databases. No longer are databases the purview of just the...
Progress Bar Tricks (Part 1)
PowerShell comes with a built-in progress bar. It typically automatically disappears when your script is done: Write-Progress -Activity 'I am busy'...
Monitor the top metrics in MySQL databases
As tables increase in size and more and more users come online, it becomes necessary to fine tune the database server from time to time. The secret...
Listing Active Domain Controller
If your machine is connected to a domain, you can use PowerShell to identify the domain controller you are connected to. Either use this command:...
Listing All Domain Controllers
To get a quick list of all of your domain controllers, run this one-liner: Get-AdDomainController -Filter * | Select-Object -Property Name, Domain,...
Achieve more with fewer resources
The current uncertainty in the economy is causing many organizations to look for ways of making their operations more productive. These...
Permanently Deleting Hard Drive Content
When you delete files on storage media like hard drives or USB sticks, as you probably know, the data is not immediately deleted. Instead, the data...
Understanding Azure SQL Database Architecture
This blog will give you a glimpse into the internal architecture of SQL Database and brings to light some of the critical concepts that SQL Database...