The current uncertainty in the economy is causing many organizations to look for ways of making their operations more productive. These...
database-tools
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...
What are the benefits of SQLyog’s Ultimate versus the Community edition?
SQLyog is a powerful graphical user interface tool to manage MySQL and MariaDB servers and databases in physical, virtual, and cloud environments....
Undeleting Office365 Mailboxes (Part 2)
Let’s assume someone left the company, and you deleted its Office365 user account. As it turns out, this also deletes the attached mailbox. If you...
How to select a database tool
Choosing a database development and management tool does not need to be a complicated process, but you should at least determine what features are...
Undeleting Office365 Mailboxes (Part 1)
If you have deleted a Office365 user account and then realize that you still need the data in its mailbox, you may be able to recover the mailbox....
What are the most important MySQL performance tuning checks?
MySQL is the most popular and powerful open-source database. As applications become more data-dependent, the database application resources are...
Renaming Properties (Simple)
Select-Object can not just select properties but also rename. Let’s assume you need a list of files in a folder with their size. This line would...
Announcing the General Availability of SQL Compliance Manager 6.0
We’re excited to announce the release of SQL Compliance Manager 6.0 SQL Compliance Manager is the industry leading SQL Server auditing solution that...
Common Pitfall and Strange Results: Comparison Operator
Can you spot what’s wrong in the code below? $result = 'NO' if ($result = 'YES') { 'Result: YES' } else { 'Result: NO' } It always returns “Result:...
Improve database development
Wherever data takes the organization, the database must follow. And wherever the database goes, database administrators and developers must take the...
SQL Diagnostic Manager 12.2 General Availability
We are pleased to announce the general availability of SQL Diagnostic Manager 12.2. Existing users may upgrade to this version through the Idera...
PowerShell Deprecations (Part 2: Remote PowerShell (RPS) in Exchange Online)
PowerShell cmdlets in Exchange Online use “Remote PowerShell” as a remoting technology which is a legacy technology with security risks in today’s...
Benefits of third-party tools for MySQL
Adding third-party tools can be an effective method of enhancing software, since they may provide additional features lacking in the original...
PowerShell Deprecations (Part 1: PowerShell 2.0)
Windows PowerShell 2.0 is still part of any Windows PowerShell for backwards compatibility, and when enabled, it is a serious security risk –...
We are excited to announce the General Availability of Aqua Data Studio, Version 22.3.2
Aqua Data Studio is the industry leading multi-platform Integrated Development Environment (IDE) for databases with Visual Analytics. What’s...
Simplify your data analytics
Generating useful data analytics involves multiple time-consuming and tedious steps, including: Accessing usable data that can help business users...
Richer Printer Information
Get-Printer returns basic information about all local printers. When you add the switch parameter -Full, it returns even more detailed information...
How to Maintain Security Compliance to Prevent a Costly Data Breach
As businesses and government organizations shift a growing amount of their operations online, security has become an increasingly important issue....
Tune MySQL performance
MySQL is a popular relational database management system. It is the preferred platform for business critical eCommerce systems that companies rely...
Solving Problems with PowerShell (Part 4)
PowerShell offers you a plentitude of approaches to solve a task. They always boil down to the same strategies. In this mini-series, we will...
Solving Problems with PowerShell (Part 3)
PowerShell offers you a plentitude of approaches to solve a task. They always boil down to the same strategies. In this mini-series, we will...
Do you need a tool to manage your databases?
The growing amount of data that organizations must store and manage is increasing the challenges faced by all database professionals, including...