Monitoring & Performance
Security & Compliance
Backup & Administration
Data Modeling and Architecture
Aqua Data Studio
SQL Development and Tuning
Uptime Cloud Monitor
Uptime Infrastructure Monitor
Ask the Experts
sql diagnostic manager
SQL DM for MySQL
Blog - Post List
By view count
By comment count
What has happened with GDPR in the last 9 months?
Largest Fine To Date Google recently made the news with a $57M (50M Euro) fine imposed by the French Regulatory building, CNIL. The case against Google is geared towards their use of automatically opting people into advertising programs and vague pri...
15 Feb 2019
How to Manage Complex Database Environments
Every year, data becomes increasingly critical to the organization. And data becomes even more complicated to manage and keep secure. The growth in the diversity of the deployments of databases (such as physical, virtual, private cloud, and public cl...
13 Feb 2019
Properties of Big Data for Healthcare
Healthcare organizations must consider the essential properties of the analytics for big data that when commencing significant projects for analytics. Such features include relevance, reliability, soundness, diversity, stability, speed, and capacity....
12 Feb 2019
Data Architecture: The Foundation for Enterprise Architecture and Governance
Organizations are faced with an increasingly complex data landscape, finding themselves unable to cope with exponentially increasing data volumes, compounded by additional regulatory requirements with increased fines for non-compliance. Enterpr...
11 Feb 2019
What Tech Professionals Really Think About IDERA ER/Studio - by Danielle Felder
Over the last few months, the IT Central Station team gathered reviews from IDERA ER/Studio’s customers with one goal: to find out more about their experience with this top ranked
database development and management solution
. As the leading sit...
7 Feb 2019
Handling the Complexities of Analytics for Big Data for Healthcare
Analytics for big data rapidly has become indispensable for nearly all clinical and operational processes in the healthcare industry. Such functions include support for clinical decisions, predictive analytics for big data, management of revenue cycl...
5 Feb 2019
Monitor the performance of SQL Server in the hybrid cloud
As organizations migrate their databases to the cloud, database administrators need to consistently manage databases on-premise and in the cloud with existing staff and tools. While it is relatively straightforward to provision and maintain databases...
30 Jan 2019
Resolutions for your Data Management Strategy
As 2019 has just begun, it’s a good time to assess what you accomplished last year and what goals to set for the new year. It's also a great opportunity to review, evaluate, and update your company’s Data Management Strategy to prom...
25 Jan 2019
Using SQL Secure to monitor SQL Instances and Databases running on Azure
As companies migrate more and more applications and data to the cloud using services like Azure and Amazon, it is important to ensure that the SQL Server instances and databases running in the cloud are monitored to ensure that they are protected fro...
23 Jan 2019
Better understand the architecture of Microsoft Azure SQL Database
Microsoft Azure SQL Database is the relational database service offered as a Platform as a Service on the Microsoft Azure cloud. SQL Database has evolved significantly over the years and has become a robust and highly available database platform wrap...
23 Jan 2019
How to troubleshoot locking problems in SQL Server with Dynamic Management Views
Database professionals are often called upon to investigate performance problems related to locking, but most investigations into locking rarely go beyond checking for blocks or investigating deadlocks. It is not very often that database professional...
16 Jan 2019
Microsoft announces the availability of IDERA SQL DM Performance Insights for Azure Data Studio
We are pleased to announce an updated version of IDERA SQL DM Performance Insights for Azure Data Studio. And we are excited to be announcing the inclusion of this new version in the Azure Data Studio Marketplace and to be making this announcement in...
14 Jan 2019
Precise for Sybase monitoring & performance
Precise for Sybase builds a history of activity showing resource consumers. SQL statements are correlated to stored producers, logins, and programs. Execution sub-states and waits are measured. The screens below show a simple e...
10 Jan 2019
What to do when the SQL Server service does not start
The executable process that is the SQL Server Database Engine is called the Database Engine service. The Database Engine service is an executable program that runs as a Windows service that can continuously operate without displaying any activity on ...
9 Jan 2019
Data Proximity for Data Warehousing Performance
Data Warehousing DBAs usually work with huge tables, often possessing hundreds of millions or even billions of rows. And occasionally, these DBAs might need to perform maintenance that requires either recreating the entire huge table or some of its p...
8 Jan 2019
Data Modeling: Common Mistakes and Their Impact
“Dew knot trussed yore spell chequer two fined awl yore mistakes.” – Brendan Hills Although data modeling has been around for over 30 years, it ranks among the top areas from whence database application problems arise. Moreover, th...
8 Jan 2019
Back to Basics: Build a Foundation for Data Governance in 2019
Those who are watching the data management industry have definitely seen an increase in the volume of posts, whitepapers, and webinars on the topic of Data Governance. This activity is partly due to the data privacy regulations that also have receive...
3 Jan 2019
Top metrics to monitor in your MySQL databases
As tables increase in size and more users come online, it becomes increasingly necessary to fine-tune your MySQL database server from time to time. The secret to knowing what adjustments need to be made is to perform regular monitoring. Most database...
19 Dec 2018
Business Value Metrics for Data Governance
As data professionals, we recognize and understand the need for data governance, focusing on data quality in particular. We have made some progress in this area, as illustrated by the emergence of the Chief Data Officer role in recent years. However,...
17 Dec 2018
Use ER/Studio Governance Attachments in SQL Server (and other platforms too!)
ER/Studio Data Architect contains extensive metadata for all constructs utilized in the models and data dictionaries, whether used in logical modeling, physical modeling, or both. This includes names, descriptions, comments, datatypes, lengths and a ...
15 Dec 2018
Sharing Files and SQL statements using Aqua Data Studio
There are many ways to share files or SQL statements using Aqua Data Studio. These range from shortcuts to your own file directories or company mapped drives, to shareable Aqua files, to popular native features within the menus and toolbars.&nb...
13 Dec 2018
What are visual SQL tuning diagrams?
SQL queries are the primary mechanism to interact with databases. Therefore, ensuring that SQL queries perform well is essential. An important method to improve the performance of SQL queries is to use indexes properly to locate data quickly. To crea...
12 Dec 2018
SQL Performance, Part 4: Additional Considerations
Today’s blog post concludes our four-part look into SQL performance and optimization.
introduced and explained relational optimization;
reviewed query analysis and introduced single-table access path formulation;
10 Dec 2018
Is GDPR a Grinch?
Most people know that GDPR went into effect in May of 2018. For those of you who don't know, GDPR was put in place to protect people's PII (Personally Identifiable Information) Data. This is the first holiday season with GDPR in effect, and add...
6 Dec 2018
Could Your Merger or Acquisition Detect (or Cause) a Data Breach?
It seems like we hear about a new data breach on an almost daily basis. This past week, we heard about two newsworthy data breaches that were caused/detected in some part by a Merger or Acquisition. The first worth mentioning is the ...
6 Dec 2018