12 Years, 50 Courses: A Tale of Enthusiasm, Determination, and Resilience. Looking back, the past twelve years feel almost dream-like.
SQL Server Security Fundamentals at Pluralsight
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.
Calculating Extended Internal Rate of Return (XIRR) in SQL Server with T-SQL
The Extended Internal Rate of Return (XIRR) is a metric to calculate the annualized rate of return for a series of irregularly timed flows.
Solving Quadratic Equations with T-SQL
I often find myself teaching mathematics to my daughter, and recently, she has been diving into the realm of Quadratic Equations.