I’m delighted to announce the launch of my 51st course on Pluralsight – “SQL Server Security Fundamentals.”
BDD with Cucumber and Java at Pluralsight
It is with immense pride and joy that I announce the successful completion of my 50th course on Pluralsight – “BDD with Cucumber and Java.”
SQL SERVER – STRING_AGG Function to Concatenate Strings
We were able to improve the performance of the query by using STRING_AGG Function to Concatenate Strings. Let us learn.
SQL SERVER 2022 – GENERATE_SERIES Function
Recognizing an opportunity for optimization, we replaced the original series generation logic in the stored procedure with the GENERATE_SERIES function.
SQL SERVER – Monitoring Database Autogrowth Settings
Monitoring Database Autogrowth Settings is important and is what I often end up discussing in Comprehensive Database Performance Health Check;
SQL SERVER – Generating Complex Passwords with T-SQL
The client needed a robust method for generating complex passwords directly within their SQL Server database. Let us see today.
SQL SERVER – Setting up a Robust Password Policy
Today’s topic of Setting up a Password Policy often emerges during my Comprehensive Database Performance Health Check consultations.