Much Ado about nothing: missing data
Joe Celko explains how missing data is handled from the printing press to databases.
2021-07-26
Design and Theory
Constraints and declarative referential integrity
Database systems have powerful features built right in that can ensure the integrity of data. In this article, Joe Celko discusses keys and constraints.
2021-05-28
2019-10-31
888 reads
2019-07-19
938 reads
2012-10-31
2,524 reads
2011-09-07
2,319 reads
2011-06-14
2,494 reads
2011-06-13
2,368 reads
2011-06-10
2,541 reads
2011-06-02
2,638 reads
Blogs
Data Modeling at your fingertips
By Rayis Imayev
(2021-July-30) A picture is worth a thousand words, the same way a visual database schema...
How to put a SQL Server Database into Recovery Pending
By John
You might be asking why on earth would you want to get a database...
Daily Coping 30 Jul 2021
By Steve Jones
I started to add a daily coping tip to the SQLServerCentral newsletter and to...
Forums
Migrate SQL Sever 2012 Database To Server 2014 and Subsequent Versions
Hi Guys, I have an SQL Server 2012 Express database that I would like...
Deploying SQL Server Automatically
Comments posted to this topic are about the item Deploying SQL Server Automatically
Setting data compression on a database or even server level possible?
I well realize data compression is a subject to a few variables, such as...
Ask SSC