Site Logo

SQL Server Configuration, Security & AI Tips

Tuning Performance, Migration & Azure Integration

Article image
2025-10-03  | Twan Pelkmans Category: Links

Links

Usefull links

Article image
2025-06-22  | Twan Pelkmans Category: Encryption

Is Your SQL Server Traffic Secure? Why TLS Encryption Is No Longer Optional

It takes minimal effort to install a TLS certificate to encrypt the traffic between your client and the SQL Server. Every new operational database product provided by Microsoft now has encryption in flight by default. Why would you not do it for your current SQL installations? Do not expose your data especially when the amount of effort is minimal.

Article image
2021-01-04  | Twan Pelkmans/Theo Ekelmans Category: SQL Failover Cluster

Do *not* place TEMPDB on a local disk in a SQL failover cluster

Message from the trenches: Placing tempdb on local (fast SSD) disk may seem beneficial, but it comes with a caveat. Since the disk is not part of the cluster resources, it will not initiate a failover when the local disk fails

Articles by Category

    • Is Your SQL Server Traffic Secure? Why TLS Encryption Is No Longer Optional (2025-06-22)
    • Links (2025-10-03)
    • Do *not* place TEMPDB on a local disk in a SQL failover cluster (2021-01-04)

© 2025 All rights reserved.
Disclaimer: The information on this site is for informational purposes only and is without guarantees.
LinkedIn