In previous tips, we already talked about services such as haveIbeenpwned.com. They harvest leaked passwords from previous hacker attacks so you can...
database-tools
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...
Protecting Your MySQL Servers From Ransomware
A constant in the computing world is that it is always evolving and offering new challenges and opportunities. Software solutions come and go with...
Finding Public IP Address
Here is a one-liner that retrieves your current public IP address: PS> Invoke-RestMethod -Uri http://ipinfo.io ip : 87.153.224.209 hostname :...
How to properly set up SQL Server clusters
Windows Failover Clustering can keep your SQL Server databases online and your end users happy when hardware or operating system problems strike....