We’ll explore industry guidelines for complex passwords and implement them in an SQL Server stored procedure to generate secure passwords.
SQL SERVER – Login Experience with DEFAULT_DATABASE and MUST_CHANGE
DEFAULT_DATABASE and MUST_CHANGE shape the login experience. Tested on SQL Server 2025: the syntax that fails, and how the two lock a user out.
SQL Server Maintenance Techniques: A Comprehensive Guide to Keeping Your Server Running Smoothly
This comprehensive guide explore into some essential maintenance techniques and best practices to ensure your SQL Server deployment.
SQL SERVER – Fix – Error – The certificate chain was issued by an authority that is not trusted
ASP.NET Core applications can sometimes result in the error “The certificate chain was issued by an authority that is not trusted.”
Maximizing SQL Server Security: Instance Hiding vs SQL Browser Disable
Let us learn more today in this blog about Maximizing SQL Server Security: Instance Hiding vs SQL Browser Disable.
SQL SERVER – What is Instance Hiding? How to do it?
In this blog post, I’ll share a real-life success story of how instance hiding significantly strengthened SQL Server security for one of my clients.
Masking Functions in SQL Server: What Each One Shows
Dynamic data masking hides values at query time, and the masking functions decide what a reader still sees. This post tests default, email, partial, random and datetime on SQL Server 2025 and shows what each one returns. It also covers adding and dropping a mask on an existing column.