Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Content with tags Administration, Best Practices Rss

   Items 1 to 2 of 2   
 

Never update systems tables directly - a study in Agent job scheduling

It is often recommended that system tables should not be updated directly. Presenting a case in point built around nightly job configuration in order to demonstrate the possible issues with updating system tables directly.  Read more...
By Nakul Vachhrajani 2012/09/17 | Source: SQLServerCentral.com | Category: sql server agent
Rating: |  Discuss |   Briefcase | 4,281 reads

SQL Server Upgrade Recommendations and Best Practices - Part 2

This article, Part 2 – SQL Server 6.5 to 2000 Critical Upgrade Decisions and Redundant Upgrade Architecture, will begin to detail the technical components faced by the DBAs and Developers during the Upgrade process. The technical components detail the Critical Upgrade Decisions related to ANSI NULLS, Quoted Identifiers and other items.   Read more...
By Additional Articles 2003/06/30 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,906 reads
   Items 1 to 2 of 2   
 
Tags
best and worst practices (1)    
dba (1)    
nightly jobs (1)    
sql server 7 (1)    
sql server agent (1)    
system tables (1)