ApexSQL Refactor is a free SQL Server Management Studio and Visual Studio add-in for database refactoring and SQL code formatting. ApexSQL Refactor has 11 databases and SQL code refactors including:
You can check out the original post here: SQL SERVER – Start Services or Stop Services with PowerShell – Question to Readers?.
Recently I received a very interesting question- I have no idea about its answer so I will request your help to answer this question.
Question:
“I am using a Powershell script to shutdown SQL Services. Here is the command I use.
In year 2013, I had focused on MySQL along with SQL Server in database products. As I learn more and more MySQL, I quickly realized that there is no proper course or structured information for MySQL Performance Tuning. I had decided to build a course around common MySQL Performance Problems. I have decided to build the performance tuning course in two parts. 1) MySQL Indexing for Performance and 2) MySQL Query Optimization and Performance Tuning. I had released MySQL Indexing for Performance course earlier this year and right before the end of the year 2013 the second course MySQL Query Optimization and Performance Tuning has released as well.