There are some useful features in bigquery like numeric and partition. Now numeric columns support in query result but not support in DDL(create...
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
Coping with the Danger of Malware to Your SQL Servers
Many responsibilities go along with being a DBA in an SQL Server environment. Keeping the systems performing optimally for end-users is an important...
Turning Objects into Hash Tables
Often, a single object needs to be examined, i.e. a process or an Active Directory user. When you display an object in a grid view window such as...
What are some of the lesser-known cloud services that can be helpful to database administrators?
Cloud platforms like Microsoft Azure and Amazon Web Services (AWS) have now matured to the point where they are ready for enterprises. Many...
How can IDERA Database Tools help manage cloud databases in Amazon Web Services (AWS)?
The cloud delivers information technology as a service on-demand, allowing users to only consume the capacity they need. The cloud is the...
Poor Infrastructure Monitoring Can Cripple Your Business
The majority of 21st Century businesses rely heavily on their IT infrastructure to generate income, keep track of customers and employees, and...
October DBArtisan Tips Webinar – Performance Monitoring, the SQL Editor and Security across multiple instances
The October edition of DBArtisan tips and techniques covered three tips for using DBArtisan. Real time Performance Monitoring The SQL Editor...
A Simple Way to Take Care of Your Database Developers
The database development team is an important component of most organizations’ IT departments. They are responsible for creating databases and...
Object Magic (Part 4)
How about turning a single object into a hash table? This way, you can display one object property per line when you output the object in a grid...
Best Practices to Secure Your MySQL Databases
MySQL is one of the most popular database platforms in the world. It is widely used to power eCommerce sites and web applications that are essential...
How can IDERA Database Tools help manage cloud databases in Microsoft Azure?
The cloud is becoming increasingly important to data professionals and to their management. There are a variety of cloud delivery...
What do customers have to say about SQL Management Suite?
Are you curious about who the customers of SQL Management Suite are in terms of the type of organization, industry, and country? And...
Introducing the IDERA ACE Class of 2020!
We are excited to introduce our new 2020 IDERA ACEs! IDERA ACEs are active community members who have shown a passion for helping the community and...
The Benefits of More Effective Database Management
The growth in the volume of data that organizations are expected to process shows no signs of slowing down. In most cases, it will only intensify as...
Object Magic (Part 3)
Let’s assume you want to hide all object properties that have no value (are empty). Here is a simple approach: # get any object $object =...
Managing Big Data with MySQL Can be Challenging
MySQL is an extremely popular open-source database platform originally developed by Oracle. It currently is the second most popular database...
Announcing Precise 10.1 General Availability
We are pleased to announce the release of Precise 10.1, the company’s application performance monitoring platform. This latest release adds...
Precise provides enhanced support for AWS & Azure
Precise provides enhanced support for Amazon Web Services in Precise 10.0 and 10.1 and has extended support to AWS RDS instances Precise 10.0 &...
What are some of the highlights of SQL Diagnostic Manager Pro?
IDERA offers a wide range of products covering the needs of database administrators (DBA) for Microsoft SQL Server. Also, IDERA provides a wide...
The Benefits of Aqua Data Studio and Snowflake Integration
Perhaps owing to its popularity, there are a number of Snowflake integrations geared towards optimizing organization's use of the platform....
Object Magic (Part 2)
Via the secret “PSObject” property, you can get detailed information about object members. For example, if you’d like to know...
Aqua Data Studio & Snowflake Integration Explained
Perhaps owing to its popularity, there are a number of Snowflake integrations geared towards optimizing organization's use of the platform....
Struggling With Big Data Analytics in the Healthcare Industry
Enterprises in many diverse fields are trying to make sense of the possibilities afforded by big data analytics. Taking advantage of the insights...
How Good Do You Feel About Your SLAs?
A service level agreement (SLA) is an important component of a service contract between a provider and its customer. It defines measurable aspects...
Object Magic (Part 1)
In PowerShell, most data are represented as PSObjects, a specific object “wrapper” added by PowerShell. To get to this specific wrapper,...
What do customers have to say about SQL Doctor?
Are you curious about who the customers of SQL Doctor are in terms of the type of organization, industry, and country? And are you...
Who Uses Aqua Data Studio and What Are its Benefits?
Aqua Data Studio is a tool for developers and administrators that offers a platform for data management and analytics across any type of cloud,...
What are the most critical performance tuning checks for MySQL?
MySQL is the most popular and influential open-source relational database. As applications become more data-dependent, the database application...
You Need to Modernize Your Legacy Monitoring Tools
Computer networks have always been one of the most complicated components of an enterprise’s IT environment. They are comprised of numerous...
Encrypting Text (Part 2)
This is the second part of our text encryption/decryption series. In the first part you learned how you can safely encrypt text on a machine. Now...