Databases Archives

First Look at SQL Operations Studio

Since the release of SQL Server® 2017 on Linux®, DBAs have been waiting for a native release of SQL Server Management Studio (SSMS) on Linux. At this point, Microsoft has stated that they have no plans for a native Linux version of SSMS. However, they have just released a preview version of SQL Operations Studio, … Read moreFirst Look at SQL Operations Studio

Maximizing Database Performance – MySQL Tuning Best Practices

by Janis Griffin

With the added complexity of growing data volumes and ever changing workloads, database performance tuning is now necessary to maximize resource utilizations and system performance. However, performance tuning is often easier said than done. Let’s face it, tuning is difficult for a number of reasons. For one thing, it requires a significant amount of expertise … Read moreMaximizing Database Performance – MySQL Tuning Best Practices

The Importance of Performance Certainty

by Gerardo Dada

Uptime is assumed. Performance is the new black. You can’t hope for performance, you need to be certain of the performance of the system. You need to know what drives performance and how any changes to the system change (or could change) the performance profile. This is, in summary, what performance certainty means. It’s a new world, performance matters Not … Read moreThe Importance of Performance Certainty

How SQL Server DMVs Can Be a Savior in SQL Azure, Too

by Pinal Dave

Be it SQL Server or the improved version of SQL Server on the cloud called as SQL Azure, when it comes to monitoring, there is nothing as powerful as DMVs (Dynamic Management Views). For a primer, Dynamic Management Views (DMVs) are a set of virtual views which expose the internal states of SQL Server deployment. … Read moreHow SQL Server DMVs Can Be a Savior in SQL Azure, Too

Must-know Tips and Tools for Oracle Virtualization

by Staff Contributor

These days, even business-critical applications are being virtualized, and with the increasing costs and complexity of data environments, it’s not surprising. Some estimate that large organizations are as much as 70% virtualized already, with no plans to go back to physical servers. Virtualization, however, introduces new challenges for the Oracle DBA, including getting visibility to … Read moreMust-know Tips and Tools for Oracle Virtualization

TDD: A Blueprint for Choosing Metrics

by Staff Contributor

Test Driven Development (TDD) is not only a discipline we like to write about, we practice it ourselves every day. This is a blog post we shared with our friends over at Rainforest QA. Because we know you can’t enough of a good thing, we’re re-posting it here. Enjoy! Librato is a prolific engineering shop. … Read moreTDD: A Blueprint for Choosing Metrics

Top 50+ Tech Influencers and Thought Leaders You Should Follow

by Staff Contributor

Today’s technology is growing at an extraordinary pace, so it is important to follow industry influencers and thought leaders to stay in the loop and learn new trends and best practices. Keeping on top of things in the industry is a great way to make sure you are functioning most effectively every day.

We have compiled a list (in no particular order) of tech geeks from system, virtualization, storage, database, network, and security management domains, who we think are the top influencers and thought leaders you should follow.

SQL Server Performance Tuning Tips

by Staff Contributor

Query tuning is often the fastest way to accelerate SQL Server performance. Most often system-level server performance (memory, processors, and so on) improvement measures are ineffective and expensive. Expert developers believe most performance issues can be traced to poorly written queries & inefficient indexing, not hardware constraints. In fact, some performance issues can only be … Read moreSQL Server Performance Tuning Tips

SQL and Database Performance Tuning Guide and Checklist: Expert Tips

by Staff Contributor

A Database Administrator (DBA) is like a racecar technician. Building and optimizing a high-performance vehicle requires minuscule fine-tuning and attention to detail. A tweak here and an adjustment there could shave just a fraction of a second from your lap time. Of course, that fraction of a second could determine whether you win or lose … Read moreSQL and Database Performance Tuning Guide and Checklist: Expert Tips