I am feeling very thankful and a bit surprised. It’s been 17 years since I started SQL Authority. This journey was about learning, sharing.
SQL SERVER – Exploring SQL Graph Pattern Matching with MATCH
One of the powerful features of SQL Graph is the ability to search and traverse these graph pattern relationships easily using the MATCH clause.
SQL SERVER – Exploring PIVOT and UNPIVOT
The SQL Server PIVOT and UNPIVOT operators are powerful tools that provide an easy way to transform your data in SQL.
SQL SERVER – Best Practices for Securely Storing Passwords
This post will explore industry-standard techniques to securely store passwords. Let us learn about Best Practices for Securely Storing Passwords.
SQL SERVER – Generating Secure Passwords
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
We will look at how these two options can streamline things for users when they connect and change passwords. Let us discuss the login experience.
SQL SERVER – Ins and Outs of Online Index Operations
I recently talked about Ins and Outs of Online Index Operations with my clients during the Comprehensive Database Performance Health Check.