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.
SQL SERVER – Writing Function for The Rule of 72
I had a fascinating side conversation with a client that introduced me to a financial concept called the Rule of 72. Let us learn today.