The Right Way to Optimize a MySQL Query

Identifying a slow running SQL query is a necessary prerequisite for any type of optimization. Next, you'll need the right tools and principles to assess the best approach for optimizing.

Slow is still slow: database performance matters even in the cloud

Learn why it's critical to be able to accurately assess root cause of slow database performance, whether running on-premise or in the cloud.

Managing SQL Server with PowerShell

Learn the basics of getting started using PowerShell with SQL Server. In part 1, we cover the basics of getting started using PowerShell with SQL Server. In part 2, we dive into examples of performing common SQL Server management tasks with PowerShell.

3 Key Features of Oracle Database 12c Architecture

This topic could fill an entire book, but for our purposes here, we’ll focus on the most important aspects. This article highlights concepts and provides a general overview of the players that deliver this proprietary database management system.