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.
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.
Grouping Data into Bins and Categories – A Comprehensive Course
Pluralsight’s course “Grouping Data into Bins and Categories” is a guide that takes you on a journey to master these essential techniques.
SQL SERVER – Understanding When to Use DBCC UPDATEUSAGE in SQL Server
DBCC UPDATEUSAGE is a command available in SQL Server that is used to update the page and row count metadata for database objects.