External Article

Managing Transaction Logs in SQL Server

The Transaction Log provides the means by which either the complete set of tasks of a database transaction are performed or none of them are. It ensures that , via rollback, only valid data is written out to the database, and it allows transactions to be played back to recreate the system state right before a failure. Robert Sheldon explains the various basic tasks involved in managing the transaction log.

Blogs

Walking Through a Planned Failover: SQL Server Availability Groups on Kubernetes

By

When building the sql-on-k8s-operator, I wanted to make sure it could handle both planned...

Reading SQL Server File Headers with DBCC FILEHEADER

By

I’ve been doing a deep dive into SQL Server on-disk structures lately, and one...

T-SQL Tuesday #197 – An impactful session or two from a conference – RECAP

By

Thanks to everyone who joined the blog party this month. I noticed three themes...

Read the latest Blogs

Forums

The Vector Data Type

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The Vector Data Type

What Power BI DirectQuery does to your SQL Server (and how to fix it)

By kat.korson@redeagle.tech

Comments posted to this topic are about the item What Power BI DirectQuery does...

The New OS Wars

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The New OS Wars

Visit the forum

Question of the Day

The Vector Data Type

What is the vector data type in SQL Server?

See possible answers