Greater dependence on enterprise-class applications has created a demand for centralizing organizational data in their support. Imperatives such as...
database-tools
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...
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...
Make the most of your metadata
Metadata management is not a new concept. However, it is gaining new adherents as we recognize the value of enterprise data governance. We may have...
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...
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....
Empower operational data governance with data lineage
Much of the conventional guidance about implementing a data governance program focuses on organizational structure and the protocols for defining...
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...
Enable customer business intelligence with data catalogs, business glossaries, and data governance
For over three decades, organizations have relied on data warehouses to support the needs for descriptive analytics of business information...
Solving Problems with PowerShell (Part 2)
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...
Become a database administrator for MySQL
You are perhaps reading this because you think that becoming a database administrator may be the right career path for you. Database administrators...
Solving Problems with PowerShell (Part 1)
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...
Super-Fast Network-Printer Inventory
In our previous tips we introduced all kinds of useful PowerShell functions to ping, scan ports, or contact SNMP devices. Today, it’s time to take a...
Align data governance with business-driven data architecture
The role of the data analyst has gained prominence in relation to the recognized criticality of processed and analyzed information as an integral...