Converting old Word documents to the new .docx format can be a lot of work, and in part 1 you learned the basic steps to automate conversion....
Converting Word Documents from .doc to .docx (Part 2)
read more
database-tools
Why is MySQL So Popular?
There are a lot of choices for an organization to consider when selecting a relational database management system (RDBMS). In some cases, the...
Converting Word Documents from .doc to .docx (Part 1)
Converting old Word documents to the new .docx format can be a lot of work. Thanks to PowerShell, you can automate the conversion: function...
Fine-tune Infrastructure Monitoring for Better Results
Knowing what is going on in an enterprise’s computing environment’s infrastructure is important for several reasons. The most obvious...
How to customize the dashboard, monitor query-level waits, and monitor backups with SQL Diagnostic Manager for SQL Server.
SQL Diagnostic Manager for SQL Server SQL Diagnostic Manager for SQL Server helps database administrators to find and fix SQL Server performance...
How Analytics Has Changed The World of Professional Sports
For some people, data analytics may conjure up images of large data sets being processed to find answers to questions that are important but largely...
Exploring PowerShell Modules
Most PowerShell commands live in modules, and by adding new modules, you can add new commands to your PowerShell environment. To find out whether a...
Juggling SQL Agent Jobs in a Complex Environment
Microsoft’s SQL Server includes many features that make it an attractive solution for organizations needing a relational database management...
Ways for Improving Your MySQL Database Performance
MySQL DBAs have a wide range of responsibilities related to keeping their databases available to the end-users and applications that depend on them....
WMI Explorer
WMI (Windows Management Instrumentation) is a great information source: you can find almost any information about your computer somewhere. The hard...
Is SSH tunnelling available yet in ADS 20?
hi I need to connect to MySQL servers over SSH. Is this possible yet in ADS 20? thanks Mark Response Thomas Conrad over 3 years ago Hi Mark, That...
Bigquery Support for numeric and partition
There are some useful features in bigquery like numeric and partition. Now numeric columns support in query result but not support in DDL(create...
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...