Blog

Big data presents organizations with the raw materials from which to develop business intelligence. the ER/Studio family of data modeling tools can help turn big data resources into actionable insights that provide a company with a competitive edge.

Introduction When we talk about SQL Server indexes, we are usually discussing the rowstore clustered or non-clustered index. However, along with rowstore indexes, SQL Server has columnstore indexes as well. In today’s blog post, we will be disc...

SQL Server index fragmentation can kill database performance. SQL Defrag Manager helps SQL Server database teams control index fragmentation by automating defragmentation and managing it from a centralized console.

Database developers can benefit from the use of an IDE. Aqua Data Studio offers a comprehensive IDE that supports over 30 different databases platforms to help improve productivity and streamline development.

SQL Diagnostic Manager for SQL Server has many features that make it the perfect tool for SQL Server DBAs. It's a customizable and reliable monitoring solution that lets a database team stay on top of performance-impacting issues.

Introduction During a recent SQL Server Performance Tuning consultation, I was asked a fascinating question by a Senior DBA working with me from the client-side. Let me share this query, as I believe you will find it intriguing as well. “We oft...

Taking a proactive approach to database administration can result in increased productivity as issues are dealt with before they become problems. SQL Admin Toolset provides a set of features that assist a proactive DBA to manage their SQL Server environment.

Data governance is a valuable method of obtaining consistency regarding enterprise data assets across an organization. Data modeling tools such as those in the ER/Studio family of solutions can improve data governance and the overall understanding of data resources.

Do you like hammering nails with screwdrivers? Me neither, but all too often we take this kind of approach when writing our SQL queries. We use the wrong tool for the job, and consequently end up consuming more time and resources to do a simple task....

SQL Servers are inviting targets for crypto miners. This poses multiple problems for DBAs protecting these systems. SQL Secure can help keep your database environment safe by providing visibility into your SQL Servers security.

Continuing with our Performance Tuning series as you have learned baselining and knowing your normal system performance metrics is an important part of performance tuning. In part 1 we discussed collecting vital system metrics such as CPU Utilization...

Introduction I have now warned several times against the mindset that suggests indexing is a silver bullet for SQL Server performance. In the previous blog post, we discussed under-indexing. It is well-known that we may have performance issues if we ...

MySQL provides many metrics that can be used by DBAs to track down problems that impact database performance. SQL Diagnostic Manager for MySQL gives them a valuable tool for real-time monitoring of MySQL metrics that are important for optimal performance.

Introduction All too often, people treat a good index as a silver bullet in terms of SQL Server performance. It is well-known that we will encounter performance issues when we inadequately index our environment. However, we can also expect to encount...

There are hidden complexities and opportunities to modernize IT systems when migrating to the cloud. Data modeling is one technique used to address these issues. ER/Studio Data Architect can create data models that increase data awareness and help make migration decisions.

DBAs are faced with an increasingly complex role as they struggle to keep up with the demands of handling enterprise data resources effectively. Automation with tools like SQL Diagnostic Manager for SQL Server can help minimize the chances of mistakes and save time spent on routine activities.

Data visualization is a technique that organizations can use to make better use of their data resources. Aqua Data Studio is a versatile database tool that supports the creation of data visualizations from relation, NoSQL, and cloud platforms.

Understanding the types of backups and recovery methods available for SQL Server is the key to successfully protecting them. SQL Safe Backup provides a dedicated backup tool that lets you manage enterprise SQL Server backups from a unified console and offers multiple advanced recovery techniques.

Capacity planning is a valuable activity that should be performed in all IT environments. Uptime Infrastructure Monitor provides features designed to facilitate capacity planning along with comprehensive IT monitoring capabilities.

Introduction People often characterize indexes as silver bullets for the performance issues in SQL Server. Is it true? Well, yes and no. In this five-part series, we will discuss indexing for SQL Server Performance. In this first part, we will discus...

The fines for non-compliance with the GDPR are increasing as authorities try to influence the behavior of organizations in regard to data privacy. SQL Compliance Manager helps database teams ensure that the SQL Server environment complies with the GDPR and other regulatory standards.

Database fragmentation can slowly eat away at database performance, causing significant problems. SQL Defrag Manager can automate the defragmentation process and help keep your systems running optimally.

IT consolidation can provide economic and organizational benefits for companies that undertake the task. DBArtisan provides a tool that can consolidate multi-platform database support from a single interface.

Performance Monitoring Tools In this second post we are diving into what tools you can use to capture the important performance metrics you need to gather for baselining your environment. Be sure to read part one here.  Performance Monitor First...