Everyday SQL

Blog Post

Trace Flag 3625 Follow Up

Several months ago, I discussed my customer’s intention to enable trace flag 3625. Since that time, we have observed an intriguing phenomenon when encountering a login failure. To demonstrate...

2024-12-13 (first published: )

473 reads

Blog Post

How to Convert FileTime to DateTime

One of my customers recently wanted to rename each of the SQL audit files will the datetime stamp of when it was created. I explained to them the filename...

2025-01-15 (first published: )

539 reads

Blog Post

How to Test Trace Flag 3625

Recently, one of my customers considered enabling Trace Flag 3625 on one of their SQL Servers, but they wanted a way to quickly test its functionality beforehand. For those...

2023-12-22 (first published: )

511 reads

Blogs

Monday Monitor Tips: Customizing Data Retention

By

One of the biggest challenges with monitoring data is managing the volume over time....

Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure Container App: A…

By

Build a Dockerized Todo List RESTful API in C# with GitHub Actions and Azure...

Cyber Scams and Operation Shamrock

By

Erin West gave the keynote for the 2025 Techno Security & Digital Forensics East...

Read the latest Blogs

Forums

are the caching messages in ssis for a lookup an indication of poor performance?

By stan

Hi, i am curious if i made the best choices for a lookup component...

SQL Server Single User Mode Problem

By fped

I'm trying to recover the sysadmin password. Mixed authentication set. Unable to get SQL...

Update Last Run Outcome in SQL Server Jobs

By AMCiti

We run a lot of SQL Server Jobs, but as they become not needed,...

Visit the forum

Question of the Day

Adding Lots of Dates

The second parameter for the EOMONTH() function is an integer. In June 2025, if I run this code, what is returned?

DECLARE @d DATE = GETDATE()
SELECT EOMONTH(@d, 95695)

See possible answers