Tatiana Bron has been working with the SQL team since 2021 across consulting and Service Desk activities. She holds Microsoft Azure Fundamentals, Azure Data Fundamentals, and Administering Relational Databases on Microsoft Azure certifications. She holds an ES degree in computer management from the Haute école de gestion Arc in Neuchâtel, having also studied at the École d'Informatique de Gestion in Delémont.
Recently, I had to renew an SSL certificate on an SQL Server Reporting Services (SSRS) server. The task seemed straightforward: replacing an expired certificate with a new one containing the same configuration. However, once the change had been made, HTTPS wasn’t working anywhere — neither via the usual DNS names nor even when accessing the server directly. Only HTTP remained…
This blog will be for queries we use for minor everyday problems. This blog will address issues related to disk space, SID for SQL login, and index fragmentation.. For this blog, you will only need SSMS and sysadmin rights on your environment. Disk Space problem If you have a full disk.Instead of connecting to the server.You can use this query,…
If you have a clusturized environment already up and running, but you want or need change the complete ip adress of your wall with minimal downtime (full downtime during operation: 3 min). You’re in the right place, I will show you how we can do that. Context Two-node clustered environment in sql 2022 with OS environment in 2022 .In 1…
Tuesday 14.03.23 was the first day of SQLBits. This day was dedicated to the workshop, and I chose to follow “A Day with SQL Managed Instance”.During this day, we talked about provisioning, connection and configuration, security, but also data migration and mobility, monitoring, and performance. Last year, Microsoft developers made 42 improvements to the service SQL Managed instance. As you…
