Alex Marsh

Blogs

Accelerated Database Recovery in SQL Server 2019: Choose your own filegroup for the version store

By

An exciting new feature in SQL Server 2019 is Accelerated Database Recovery (ADR). Resulting...

Adding SQL Change Automation to Jenkins for Database CI

By

In a previous post, I explained how to get Jenkins running in a container...

DevOps for the DBA, Slide Deck

By

I have an all day seminar I give called “DevOps for the DBA”. If...

Read the latest Blogs

Forums

2 core machine with 4 Tempdb files

By AlphaTangoWhiskey

Just curious if there is a performance hit by having 4 tempdb files with...

User datareader access problem

By jay-h

I went to give a user (via AD account) datareader access to a number...

Slower performance on SQL.

By EasyBoy

We are moving from one SQL server to newer SQL with better hardware. Both...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers