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,...
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
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...
A Unified Platform for More Efficient SQL Job Management
There are many challenges that DBAs face every day. They are expected to maintain the availability of the databases they support and work toward...
DBArtisan Tips
Welcome to the DB PowerStudio Blog. This blog will cover all things about DB PowerStudio. DBArtisan is one part of the suite of tools...
Why You Should Choose MySQL as Your Database Platform
The tremendous amount of data that businesses need to assimilate is increasing daily. Information streams from the Internet of Things (IoT),...
Installing PowerShell Core
As you probably know, Windows PowerShell (the one shipping in Windows) is done, and all efforts go into development of the new cross-platform...
Real Benefits of a Unified Database Management Solution
The sheer quantity of data that an organization is required to manage to stay competitive is growing every day. Big data and the Internet of Things...