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.
READ MORE >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.
READ MORE >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.
READ MORE >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.
READ MORE >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.
READ MORE >