Tag Archives: Backup and Recovery

The Transaction Log, Delayed Durability, and considerations for its use with In-Memory OLTP – Part I

In this mini-series of posts, we will discuss how the mechanics of SQL Server’s transaction logging work to provide transactional durability. We will look at how Delayed Durability changes the logging landscape and then we will specifically see how In-Memory … Continue reading

Posted in SQL | Tagged , ,

Restoring CDC enabled databases

Performing database and transaction log backups (and restores) are the meat and veg of a DBA’s responsibilities and if you are a seasoned professional I am sure you will have performed those operations ad-infinitum. Being complacent is perhaps the biggest mistake you … Continue reading

Posted in SQL, SQLServerPedia Syndication | Tagged , | 1 Comment

T-SQL Tuesday #19 – Your mistake… my problem

This month’s T-SQL Tuesday is brought to you by Allen Kinsel (blog|twitter) who contributes a great amount of his time to the SQL Community and so we can only say a huge thank you for your efforts and keep up … Continue reading

Posted in Events, SQL, SQLServerPedia Syndication | Tagged , , , | 1 Comment