Sept 2023 Discount: Comprehensive Database Performance Health Check | Testimonials

  • Consulting
  • Training
  • Free Videos
  • All Articles
    • Interview Questions and Answers
    • SQL Tips and Tricks
    • SQL Performance
    • SQL Puzzle
    • Big Data
    • Blog Stats
    • SQL Books
    • Search SQLAuthority
  • Downloads
  • Hire Me
  • Health Check

SQL SERVER – Monitoring Database Autogrowth Settings

July 19, 2023
Pinal Dave
SQL Performance
autogrowth, SQL Server Configuration

Monitoring Database Autogrowth Settings is important and is what I often end up discussing in Comprehensive Database Performance Health Check;

Read More
complex password

SQL SERVER – Generating Complex Passwords with T-SQL

July 18, 2023
Pinal Dave
SQL Tips and Tricks
SQL Function, SQL Password

The client needed a robust method for generating complex passwords directly within their SQL Server database. Let us see today.

Read More
password policy

SQL SERVER – Setting up a Robust Password Policy

July 17, 2023
Pinal Dave
SQL Tips and Tricks
SQL Password, SQL Server Configuration, SQL Server Security

Today’s topic of Setting up a Password Policy often emerges during my Comprehensive Database Performance Health Check consultations.

Read More
xirr

Calculating Extended Internal Rate of Return (XIRR) in SQL Server with T-SQL

July 14, 2023
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function

The Extended Internal Rate of Return (XIRR) is a metric to calculate the annualized rate of return for a series of irregularly timed flows.

Read More
Quadratic Equations

Solving Quadratic Equations with T-SQL

July 13, 2023
Pinal Dave
SQL Tips and Tricks
Mathematical Function, SQL Function

I often find myself teaching mathematics to my daughter, and recently, she has been diving into the realm of Quadratic Equations.

Read More
Rule of 72

SQL SERVER – Writing Function for The Rule of 72

July 12, 2023
Pinal Dave
SQL Tips and Tricks
In-line Functions, SQL Function

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.

Read More

Trace Flags 1117 and 1118 No Longer Required since SQL Server 2016

July 11, 2023
Pinal Dave
SQL Tips and Tricks
SQL TempDB, SQL Trace, TraceFlags

In this blog post, we will discuss the recent implementation of trace flags 1117 and 1118 by a client when it is not required since 2016

Read More
Previous 1 … 5 6 7 8 9 10 11 … 816 Next
  • SQL Interview Q & A
  • Testimonials
  • Search
  • Privacy Policy

© 2006 – 2023 All rights reserved. pinal @ SQLAuthority.com

Go to mobile version