Maintenance

Developing Low-Maintenance Databases

  • Article

Alex Kuznetsov's team of developers are geared to doing rapid development of database applications in a busy corporate setting, yet take considerable time over meticulous database design, extensive constraints, automated tests, error logs, and defensive coding. Why? Because it cuts down on the subsequent need for maintenance.

2012-07-23

3,977 reads

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

Multiple tables created in CDC

By DBA_007

Hello Team, I have enabled CDC for a particular database in SqlServer and enabled...

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...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers