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

Welcome to 3Cloud …

By

A little over a month ago, Pragmatic Works Consulting was a part of a...

Daily Coping 23 Oct 2020

By

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

One Thousand SQL Saturdays (*ish)

By

This weekend is SQL Saturday #1000, running virtually from Oregon. It’s a good schedule,...

Read the latest Blogs

Forums

How to get these description from XML into the table?

By NewDBA201

  I want all these description in different row. TIA Example descriptions 0|Home 1|Office|False...

Need help to form query to get missing month data

By anuxps

I want to know what are the customers having missing month data based on...

What would cause slow disk access on an AWS EBS SQL Server? (PAGELATCHIO_SH)

By apresley

I have an EC2 instance (r5a.4xlarge) which should be able to do 2Gbps+ in...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers