Technical Article

SQL Server Error Log Manager

Provides a method to regularly recycle the sql server error logs based on a given file size.  If the current log file is larger than that size, then the current log is closed and a new log created.This proc takes one parameter, @MaxFileSize, which is the target file size.  This parameter defaults to 10 MB. […]

You rated this post out of 5. Change rating

2003-10-27

921 reads

Blogs

Capturing errors and auditing in Azure SQL DB

By

Logging is a necessity in the database world, well, the entire tech world. You...

Stepping into Event Streaming with Microsoft Fabric

By

(2025-July-06) Very often, real-time, high-speed streams of events come from IoT devices, social media...

Sabbatical le Troisième: A Recharge Week

By

It’s been a week since I flew home from London and Redgate to begin...

Read the latest Blogs

Forums

Unmasking CXPACKET and CXCONSUMER in SQL Server: What Your Execution Plan Isn’t Telling You

By Chandan Shukla

Comments posted to this topic are about the item Unmasking CXPACKET and CXCONSUMER in...

how to move all SP from one db to another db?

By water490

Hi everyone I have two db - one is test and other is archive. ...

The Long Weekend

By Grant Fritchey

Comments posted to this topic are about the item The Long Weekend

Visit the forum

Question of the Day

Independence Day

The film independence day was released in 1996. Which of these queries returns that year is run today?

See possible answers