Building and analyzing queries are tasks common to both database administrators (DBAs) and developers. The processes can take up a substantial...
Building and Analyzing Queries with Aqua Data Studio
read more
blog
Reading Printer Properties (Part 2)
In the previous tip we looked at Get-PrinterProperty which is part of the PrintManagement module and available on Windows operating systems. In this...
How to Create and Implement a Data Governance Policy
Data-driven companies need to create and implement a data governance policy to make the most effective use of enterprise information resources. A...
Reading Printer Properties (Part 1)
You probably know Get-Printer which returns the names of all installed printers on a system. However, you can’t get specific printer features...
Learn How to Better Manage Your SQL Servers
Do you need to manage your SQL Server environment for availability, health, performance, disaster recovery, security, and compliance? Join...
Optimization and Organization Are Key to A Successful Cloud Migration Project
Ultimately a data migration to the cloud is a technical exercise – we will use technical tools to move data to a cloud-based destination. That...
SQL Server Database Index Fragmentation: Why You Should Care About It
SQL Server Database Index Fragmentation is one of the leading culprits for slowing down your server’s response time. SQL Server indexes...
Improve Database Performance with More Efficient Database Profiling
Maintaining and improving database performance is a critical part of a database administrator’s (DBA’s) job. Slow and under-performing...
Overcome Advanced Persistent Threat Attacks with Infrastructure Monitoring
Infrastructure monitoring helps organizations prevent and recognize advanced persistent threat (APT) attacks, brute-force entries, and more. This...
A Guide to MySQL Troubleshooting
Effective MySQL troubleshooting starts with effective monitoring. Users need the ability to identify problems at their source so fixes can be made...
What is a Data Governance Framework?
A data governance framework is a means of standardizing the use of data within the enterprise. This includes its classification, organization,...
Announcing Precise 10.3.1 General Availability
We are pleased to announce the release of Precise 10.3.1, the leading database and application performance monitoring platform. What's New...
SQL Server Security: How to Protect SQL Server Databases
For organizations leveraging SQL Server databases, SQL Server security and understanding how to protect SQL Server databases is a fundamental...
Managing Multi-platform Database Environments
Multi-platform database environments help organizations manage multiple databases - a key capability for modern, data-driven...
Choosing The Right Database Tool for Database Administrators
Versatile database tools for database administrators (DBAs) can help streamline the workload and increase productivity. And in modern,...
The New Features in Aqua Data Studio Improve its Functionality
The release of version 22.0 of Aqua Data Studio continues the pattern of steadily enhancing the scope and functionality of the application. ...
Physical Data Modeling
Physical data modeling is the last of three stages (or types) of data modeling used to facilitate database design. It’s considered a data modeling...
Announcing the General Availability of SQL Enterprise Job Manager 2.3
We’re excited to announce the release of SQL Enterprise Job Manager 2.3 SQL Enterprise Job Manager is an industry leading monitoring,...
An Effective Way to Establish Regulatory Compliance in the Cloud
Establishing and maintaining regulatory compliance in the cloud is an increasingly common requirement for modern organizations. Complying with...
How to Start Database Performance Tuning and Query Optimization
Database performance tuning and query optimization are critical capabilities for modern, data-driven organizations. Database performance tuning - or...
Threading The CPU
From a slang term for the clothes you wear, through what makes up those clothes, to how a computer process work, they are all called threads. In...
Performance Tuning vs. Query Tuning
We are going to get right to it and not bury the lead here, query tuning is not the same thing as performance tuning. Now there are certainly...
Why Load Testing Database Systems is Crucial
Load testing database systems helps prevent performance issues or outages that affect mission-critical database applications. Modern, data-driven...
The One Configuration Change to Make on All SQL Server Instances
With every fresh SQL Server installation, there are several default configuration changes you probably consider. For instance, you should probably...