Simple way to understand transaction isolation levels

I was talking with a friend about how a database works and she asked me to explain transaction isolation levels to her. So let’s try… 362 more words

Sql Server

Memory-optimized Logging

In a previous post I talked about transaction log works, and what about using a memory-optimized table?

SQL Server has the feature Memory-Optimized Objects to improve performance. 387 more words

Sql Server

What the Checkpoint does?

Checkpoints flush dirty data pages from the buffer cache of the current database to disk. This minimizes the active portion of the log that must be processed during a full recovery of a database. 209 more words

Sql Server

VLF (Virtual Log Files)

To see how many VLFs you have solely look at the number of rows returned by DBCC LOGINFO.

The size and number of VLFs you’ll have depends largely on the size that the chunk is when it’s added to you transaction log. 124 more words

Sql Server

There is insufficient system memory in resource pool

Doing crash and recovery tests on my local machine I got the SQL Server instance not going online. After trying the third time to bring my instance online thinking was something else problem I saw the SQL Server errolog file and I could see the problem. 561 more words

Sql Server

Export data from DocumentDB / CosmosDB to SQL Server

CosmosDB is Microsoft’s latest NoSQL database offering, a metamorphosed form of DocumentDB, so to speak. Read more about CosmosDB here.

Here is a quick note on how to export data from CosmosDB to SQL and do data comparison. 176 more words


dbachecks - A different approach for an in-progress and incremental validation

dbachecks is a new PowerShell module from the SQL Server Community! For more information, read introducing dbachecks.

If you don’t know dbachecks, we have released a good amount of blog posts that will help you: 655 more words