Every environment is different. SQL Diagnostic Manager has pre-configured metrics that it monitors and collects...
posts
DevOps Impact on Database Administration
The current trend for software development teams is to adopt a continuous delivery approach based on DevOps and agile development techniques. DevOps...
Best Practices to Protect and Backup Your SQL Servers
One of the most important jobs a DBA has is keeping their databases safe and protected. While performance is a critical factor in database...
How to run prescriptive analysis with SQL Diagnostic Manager for SQL Server
SQL Diagnostic Manager distinguishes itself from typical monitoring tools because it is more than just a symptom-based monitoring tool, since it can...
The Value of a Complete Server Inventory
Performing an inventory may not immediately spring to mind when considering the various tasks performed by an organization’s database team....
Focusing on the IT End-User Experience
Most computer systems and applications are designed to provide information to human users. There are certain interactions between applications or...
Strong Policies Result in Better Database Security
Keeping their databases secure is one of the things that can keep a DBA up at night. There might be pressure to improve performance to satisfy...
How to configure metric thresholds and baselines with SQL Diagnostic Manager for SQL Server
In SQL Diagnostic Manager, whenever a metric exceeds the configured value or threshold, the state of the metric changes and it can execute an...
The Challenge of Keeping PII Secure in the Cloud
A common characteristic shared by things of value is that measures must be taken to keep them safe. There are always entities who would like to take...
Enterprise Data Modeling for Business Intelligence Applications
Executing an effective business intelligence workflow requires effective data management. You need to know where you’ve been and what you have...
How to configure alert actions and responses with SQL Diagnostic Manager for SQL Server
One of the more innovative components in SQL Diagnostic Manager is the alert actions and responses. This is the part of SQL Diagnostic Manager that...
Informative Alerts Help You Avoid SQL Server Problems
Microsoft’s SQL Server is an extremely popular relational database management system (RDBMS) that is used by hundreds of thousands of...