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.
SQL SERVER 2022 – Oldest Compatibility Level Supported
This post will look at the oldest compatibility supported by SQL Server 2022 (compatibility level 160) and discuss why it is essential.
The Importance of Data Binning in Data Analysis
One of the key techniques used in data analysis is data binning (or bucketing). This post explores the importance of data binning.