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.
3 PowerShell Scripting techniques you must know with SQL Server AlwaysOn
PowerShell is no second class citizen when it comes to working with SQL Server. Learn PowerShell scripting techniques that can make your life easier.