The popularity of cloud platforms continues to grow for a variety of reasons. For example, it allows organizations to pay only for the computing...
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
Finding All of Your Assets After a Cloud Migration
If your company is like the majority of others out there, they are likely to be interested in taking advantage of the cloud for at least some of...
Encrypting Text (Part 1)
Let’s take a look at a safe way of encrypting text on a computer. The below Protect-Text function takes any text and encrypts it...
How Backups Protect Your Databases From Malware Attacks
The daily responsibilities of a DBA make it an extremely challenging and critical role in a company’s IT department. The importance of an...
What do customers have to say about SQL Safe Backup?
Are you curious about who the customers of SQL Safe Backup are in terms of the type of organization, industry, and country? And are you...
Are You Ready for SQL Server 2008 End of Support?
Organizations and individuals who use Microsoft SQL Server 2008 have to make a choice. Extended support of the database platform ended as of July 9,...
Creating NT4 Password Hashes
Internally, Active Directory stores all passwords as so-called NTLM Hashes. There are a number of security-analysis tools that can read and dump...
The Challenge of Monitoring Hybrid Cloud Solutions
There is a major emphasis among businesses across all sectors of commerce and industry to take advantage of cloud computing. The cloud promises many...
How do databases on cloud virtual machines compare to managed cloud databases?
You will need to make a couple of significant decisions right off the bat if you want to move your SQL Server database to the cloud. First of all,...
How Data Analytics Can Lead to Creative Solutions
Many modern businesses are essentially drowning in a sea of data. The explosive growth in the sheer volume of information which an organization must...
Simple PowerShell Chat
Here’s a fun PowerShell script that you can use to create a simple multi-channel chat room. All you need is a network share where everyone has...
IDERA Named 2019 Most Promising Solution Provider for Microsoft by CIOReview Magazine
We are proud to announce that CIOReview Magazine recognized IDERA as being a Top 50 Solution Provider for Microsoft, and a Top 10 Solution Provider...
Why and How to Implement Galera Cluster for MySQL
There are three types of replication that people in the MySQL and MariaDB Server world care about: asynchronous (the default), semi-synchronous, and...
Finding the Right Place in the Cloud for Your MySQL Databases
Here’s the scenario. You’re a DBA at a medium-sized company that has serious growth aspirations. You are one of the team members...
Testing Password Strength
In previous tips, we already talked about services such as haveIbeenpwned.com. They harvest leaked passwords from previous hacker attacks so you can...
What do customers have to say about SQL Diagnostic Manager for SQL Server?
Are you curious about who the customers of SQL Diagnostic Manager for SQL Server are in terms of the type of organization, industry, and...
Which top metrics should you monitor for MySQL databases?
As tables increase in size and more and more users come online, it becomes necessary to finetune the database server from time to time. The secret...
Identifying Hidden Value with Visual Data
There is a staggering amount of data with which modern businesses are expected to cope to remain viable in their chosen market. It is estimated that...
Converting SecureString to Text
It can be very useful to be able to convert an encrypted SecureString back to a plain text. This way, for example, you can use PowerShell’s...
What is Azure SQL Hyperscale high-performance database-as-a-service?
Azure SQL Hyperscale is a new database as a service (DBaaS) offering from Microsoft. Microsoft built Azure SQL Hyperscale on the experiences learned...
Capacity Planning is the Roadmap to Controlled Growth
A constant across virtually all aspects of an organization’s IT environment is that requirements are always changing. Updates, upgrades, and the...
Ensuring Database Security and Appropriate Permissions
Data security is a topic that should be uppermost in the minds of all IT professionals. Protecting an organization’s intellectual resources...
Embedding Binaries (Pictures, DLLs) in PowerShell Scripts
If your script requires external binary resources such as picture files or DLLs, you can of course ship them together with your script. You could,...
Minimizing the Stress of Migrating MySQL to the Cloud
One of the tasks that a database team needs to be prepared to perform is a MySQL migration. In the deep, dark past of the early 21st Century, this...
Built-In SSH support in Windows 10
In October 2018, a Windows 10 update added built-in SSH support to Windows 10. From now on, Windows 10 ships with a command-line tool called “ssh”....
Optimize your Database Performance with Load Testing and Profiling
Today’s complex applications execute hundreds of SQL procedures and maybe thousands of SQL statements during a typical workload. How do you...
Monitoring Can Help Prevent Unauthorized Network Guests
Your organization’s network is the entry point through which users access all of your company’s systems, data, and intellectual capital....
Unleashing the Power of the API for Automation
Database administrators and developers face increased workloads as businesses continue to expand the size and scope of data they collect and manage....
Playing with Latest PowerShell Core Version
In the previous tip we illustrated how you can download a PowerShell script which automatically downloads the latest version of PowerShell Core....
How to become a database administrator for MySQL
You are reading this because you think that becoming a database administrator may be the right career path for you. Database administrators are...