Welcome to the “SQL Server” category! This is your hub for all things related to Microsoft’s premier database management system. As an experienced database administrator with years of hands-on experience in managing Microsoft SQL Servers, I’m your guide in this category. We will delve deep into the various aspects of this powerful DBMS.
In our articles, you’ll find comprehensive information about SQL Server installations, configurations, best practices, and performance optimizations. We will also explore the integration of Azure SQL, covering techniques for connectivity, secure operation, and efficiency maximization.
We’ll address critical topics such as database management, security considerations, and automation using PowerShell and dbatools. Moreover, we’ll discuss real-world challenges and their solutions to assist you in tackling your SQL Server issues.
Our content is practical and enriched with technical details. We provide references to official Microsoft documentation and offer guides and recommendations based on best practices.
Dive into the world of SQL Server with us, expand your knowledge, and stay up to date with the SQL community.
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…
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…
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…
After my first contribution – Preparing to use Desired State Configuration (DSC) – you can now take the first steps to install a SQL Server. So what do we need for prerequisites for installing a SQL Server on a new Windows Server? To my test environment … I’m using a development environment in Azure consisting…
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…
T-SQL Tuesday is a recurring blog series started by Adam Machanic (b | t), a blogger hosts a SQL Server topic every month, and anyone can write a blog post on this particular topic. This month, Ewald Cress (b | t) is our host and it’s about the people who have influenced us in our lives with…
