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.
Function in the WHERE Clause – SQL in Sixty Seconds 201
Few even asked me to build a video on this topic. Hence, I decided to make a Function in the WHERE Clause – SQL in Sixty Seconds 201.
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.