SQLServerCentral Article

Design Oversight - Preliminary Review

We all know what the ideal application design environment is for building a database back-end: an experienced DBA takes inputs from end users and developers and creates the database design in order to support the application being developed. But in reality, we don't get the opportunity to do application design like this very often. This article covers how to quickly find and fix problems in a design.

Blogs

Daily Coping 26 May 2022

By

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

Microsoft Build event announcements

By

There were a number of data platform announcements at Microsoft Build yesterday that I...

Data is not immutable

By

Information — in the form of data — usually stored as binary 1s and...

Read the latest Blogs

Forums

Print sql server substring from a table column and put into a table

By SQL_Hunt

Hello, Looking for a guidance to form a script to extract a specific substring...

Backup by specified date interval

By lucasomoura

Good afternoon, Consulting the SQL Server documentation I saw that there are some types...

Selecting distinct values from dupes based on latest date

By DaveBriCam

I have a table of patients that has often multiple occurrences of a patient...

Visit the forum

Ask SSC Logo Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers