Technical Article

Summit 2022 Community Pre-cons have been announced

We’re delighted to announce the Summit community pre-conference sessions and speaker lineup! Choose from 14 pre-cons featuring Brent Ozar, Kimberly Tripp, Melissa Coates, Itzik Ben-Gan, Denny Cherry, and others, taking place on Monday Nov. 14 and Tuesday Nov. 15. Full-day pre-con sessions will cover topics including database performance tuning and troubleshooting, T-SQL querying, DAX, security, cloud VMs, Azure Data Factory, Azure infrastructure, parameter sniffing, Power BI, PostgreSQL, equity toolkits, and much more!

SQLServerCentral Article

Dealing with Transaction Log Growth

Introduction Relational databases are designed to track changes introduced to a database by data modification language (DML) commands. The fundamental reason for this construct is to ensure that changes are durable and that they can be rolled back reliably. The typical DML command used in SQL are INSERT, UPDATE and DELETE. When INSERT introduces new […]

Blogs

Red Flags in Your Query (T-SQL Tuesday #200)

By

When I'm looking at a query, I bet it's bad if I see... a...

T-SQL Tuesday #200: When I Look at a Query …

By

This month is a milestone for T-SQL Tuesday. It’s number 200, which doesn’t sound...

Reflections on the Life of a DBA

By

The DBA life is fraught with pain. Those battles that we endure are mostly...

Read the latest Blogs

Forums

A Quick Second Opinion

By Steve Jones - SSC Editor

Comments posted to this topic are about the item A Quick Second Opinion

Five Intelligent Query Processing Features in SQL Server 2022 That Quietly Tune Your Workload

By vgupta

Comments posted to this topic are about the item Five Intelligent Query Processing Features...

Checking the Error Log I

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Checking the Error Log I

Visit the forum

Question of the Day

Checking the Error Log I

On my SQL Server 2025, I want to search the error log from my T-SQL code for potential issues and then inform an administrator. What is the current way to easily query the error log?

See possible answers