Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tag integrity Rss

   Items 1 to 5 of 5   
 

Design : Find and script out Missing Foreign Keys

Find missing Foreign Keys by name, only reference single column primary keys which are on top of an identity,also find where column names reference table with column name ='ID'.  Read more...
By Doran Mackay 2016/02/01 | Source: SQLServerCentral.com | Category: integrity
Rating: |  Discuss |   Briefcase | 921 reads

DB Integrity & Backup Report

This script returns the date for the most recent log/full backups and checks if a DBCC CHECKDB has ran within a week.  Read more...
By Nicholas Williams 2015/07/23 | Source: SQLServerCentral.com | Category: backup
Rating: |  Discuss |   Briefcase | 1,185 reads

Prevent overlapping of time events with an indexed view

Prevent overlapping of time events with an indexed view.  Read more...
By Adrian Facio 2013/11/26 | Source: SQLServerCentral.com | Category: overlap
Rating: |  Discuss |   Briefcase | 3,820 reads

Security Basics - The C-I-A Triad

In the course of giving my security presentations over the past year, I've learned that quite a few folks have never seen the C-I-A triad before. The C-I-A triad stands for...  Read more...
By Brian Kelley 2009/04/27 | Source: SQLServerCentral.com | Category: blogs
Rating: (not yet rated)  Rate this |   Briefcase | 4,233 reads

Check FK Violations

Identify orphaned records in a datebase.  Read more...
By Man inTheMiddle 2008/09/30 | Source: SQLServerCentral.com | Category: integrity
Rating: |  Discuss |   Briefcase | 857 reads
   Items 1 to 5 of 5   
 
Tags
backup (1)    
blogs (1)    
check (1)    
checkdb (1)    
data quality (1)    
indexed views (1)    
overlap (1)    
time events (1)