SQL Server High Availability – DBCC 2021 – Part 1
| |

SQL Server High Availability – DBCC 2021 – Part 1

Any one of my customers has asked, or should have asked, “do I need a certain level of high availability for my SQL server or one of my SQL servers?” Regrettably, these deliberations often come to a halt when it comes to the budget… Naturally, such HA-solutions are more expensive, and depending on the solution…

Azure SQL VM – no possibility to configure the disk usage
| |

Azure SQL VM – no possibility to configure the disk usage

A customer had asked me the last few days to help him optimize a SQL server on an Azure VM. The customer always had slight performance problems with this SQL server, so he first asked the application manufacturer or supervisor, but they didn’t want to or could help. The only answer they received was that…

Aha effect when setting SQL instance parameters with dbatools

Aha effect when setting SQL instance parameters with dbatools

In the last week, I installed several SQL Servers for one customer and had to install and configure them all identically. What is closer here than to do this with a Powershell script, so I made the “effort” and the individual steps of the SQL Server configuration with dbatools to realize. I do not want…

Desired State Configuration #3 – Details about SQL Server Installation with murphy’s law

Desired State Configuration #3 – Details about SQL Server Installation with murphy’s law

EDIT:If you are looking for a ready solution, please be patient … I explain here my project history, how I proceeded when and how … As the last blog post I will present the “finished” solution. Many Thanks for your understanding In the following post, I would like to step a little more into depth…