Gail Shaw

  • Interests: Computer Graphics, Aikido, Roleplaying

SQL Server Transaction Log Management by Tony Davis and Gail Shaw

When a SQL Server database is operating smoothly and performing well, there is no need to be particularly aware of the transaction log, beyond ensuring that every database has an appropriate backup regime and restore plan in place. When things go wrong, however, a DBA's reputation depends on a deeper understanding of the transaction log, both what it does, and how it works. An effective response to a crisis requires rapid decisions based on understanding its role in ensuring data integrity.

3 (2)

2013-08-26

6,137 reads

Blogs

What’s new with Power BI?

By

At the Microsoft Business Applications Summit 2021, a ton of new features for Power...

Tech Field Day 23 Recap

By

April 21 to 23 saw a new milestone for me. I was a new...

Daily Coping 17 May 2021

By

I started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Query Recommendations

By sizal0234

Hi,   There is a select query which is running very slow. Select customerAcc_ID,...

How to find a user and a spid that holds database in single_user mode?

By SQL Guy 1

I am recreating a scenario when somebody or a process set database to single_user...

SSIS Import only new values from a CSV without using a staging table

By datsun

Hello, How can I import a CSV file in SSIS (2016) at the same...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers