Development

Normal Forms

  • Article

To prevent data change anomalies, a database should be normalized. Did you know that there are 10 normal forms? In this article, Joe Celko reviews normalizing databases including commonly used normal forms.

2020-12-15

Automating the Setup of the Local Developer Machine

  • Article

On both Windows and Linux, the chore of setting up a development workstation can take several days, and there always seem to be a few configuration settings that get missed. You can reduce the time and tedium dramatically by automating the process by using Vagrant to set up the operating system, followed by your choice of provisioning, configuration management and orchestration applications such as Puppet, Chef, Ansible, Salt, Docker, Chocolatey and Boxstarter. Vishwas shows how to make it easy to do with Vagrant, Chocolatey and Boxstarter.

2017-01-24

3,844 reads

Development Delusions: That it is Enough to Build a Better Mousetrap

  • Article

You've written a superb, clever, application that you are trying to encourage your colleagues to use. They're not interested. Why? You've neglected the documentation. Surely, the saying goes 'Build a better mousetrap and the world will beat a path to your door'? Nope, not without comprehensive and complete documentation and marketing, it won't. Documentation is the secret of ensuring that good software will succeed.

2017-01-20

3,650 reads

Blogs

Goal Progress–Feb 2021

By

I set goals at the beginning of the year, and I’m tracking my progress...

How to: exec sp_help on temp tables?

By

Say you have a temp table and you want to see the columns names. For...

Daily Coping 26 Feb 2021

By

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

Read the latest Blogs

Forums

MSDTC and Always On AG

By VastSQL

Hi Experts, We are planning to implement 2 Node AO SQL Server 2019. For...

Remove Carriage Returns / Line Breaks / Any other reason the "text" moves down

By DCL

I know this has been covered ad nauseum all over the internet for years....

Better query to get count based on column value

By IT researcher

I am using SQL server 2008 R2 express edition. Out of below 3 method...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers