Our Blog category is the central hub for all enthusiasts of Microsoft SQL Server and database administration. Here, you’ll find a wealth of informative articles authored by an experienced database expert for Microsoft SQL Server. Dive into the world of databases, best practices, and proven techniques to help you operate your SQL Server instances more efficiently and securely. We cover topics such as configuration, performance optimization, high availability, and Azure SQL. Our articles are rich in technical details and guides, accompanied by helpful images and screenshots. Whether you’re just getting started in the realm of SQL Server administration or an experienced DBA, our blog has something for everyone.
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…
Now I had to fight with a previously unknown “login not possible” problem: Error: 17832, Severity: 20, State: 8 on a SQL Server 2008 R2. Also, the error message in the SQL server log I had not seen so far, let alone heard of it. The login packet used to open the connection is structurally…
This post will delve deeper into how I tailored my Desired State Configuration scripts to facilitate the copy and preparation processes for my Desired State Configuration (DSC) SQL Server rollout. Following the initial two blog posts where I discussed the preparations and fundamentals of the deployment, today I’ll walk you through the actual installation as…
Two years ago, I first dealt with Desired State Configuration (DSC) to create a demo for SQL Saturday #605 that continually monitors and eventually corrects the configuration of the SQL server. Now I have another lovely customer project, where I have the choice between complete implementation in Powershell (via dbatools) or just a little DSC…
I hadn’t been writing this Powershell series for a long time, and I’d like to make up for it, even though a lot of things have changed (in my work & community life) … I’d like to introduce you to two things today, once in a conventional way and how Powershell could configure SQL Server…
Many services in Azure allow certain cost savings through automation, this can also be achieved with the Platform-as-a-Service “Azure SQL Database”, this is what this blog post is all about. Quite as simple as e.g. with the Azure Analysis Service it is not because actually there is no pause-resume functionality – here comes the backup…
