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

Content with tags Backup / Restore, Security Rss

   Items 1 to 12 of 12   
 

BackUp_DBs.sql

Make backup several databases with a cursor  Read more...
By @fracionero 2012/08/03 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,249 reads

Create_sp_help_revlogin_DB

Enhanced sp_help_revlogin  Read more...
By David A. Long 2012/08/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,259 reads

Automatically Scripting Out Permissions for Cross Environment Restores

This article from Warren Campbell shows a process to recreate permissions in development environments after restoring a database from a production instance.  Read more...
By Warren Campbell 2011/12/05 | Source: SQLServerCentral.com | Category: automation
Rating: |  Discuss |   Briefcase | 4,813 reads

E-Discovery and Data Retention

While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.  Read more...
By Phil Factor 2008/11/20 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 230 reads

E-Discovery and Data Retention

While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.  Read more...
By Steve Jones 2008/11/13 | Source: SQLServerCentral.com | Category: editorial - wmv
Rating: (not yet rated)  Rate this |   Briefcase | 417 reads

E-Discovery and Data Retention

While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.  Read more...
By Steve Jones 2008/11/13 | Source: SQLServerCentral.com | Category: editorial - ipod
Rating: (not yet rated)  Rate this |   Briefcase | 366 reads

E-Discovery and Data Retention

While most DBAs might never encounter the legal aspects of their professional, Phil Factor brings to light a few things that you might want to be aware of in these litigious times.  Read more...
By Steve Jones 2008/11/13 | Source: SQLServerCentral.com | Category: editorial - mp3
Rating: (not yet rated)  Rate this |   Briefcase | 647 reads

Understanding and dealing with orphaned users in a SQL Server database

Attaching and restoring databases from one server instance to another are common tasks executed by a DBA. After attaching or restoring of a database, previously created and configured logins in that database do not provide access. This tip looks at how to deal with this.  Read more...
By Additional Articles 2008/10/09 | Source: MSSQLTips.com | Category: security
Rating:  Rate this |   Briefcase | 3,745 reads

Create_sp_help_revlogin_DB

Enhanced sp_help_revlogin  Read more...
By David A. Long 2012/08/01 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 2,259 reads

BackUp_DBs.sql

Make backup several databases with a cursor  Read more...
By @fracionero 2012/08/03 | Source: SQLServerCentral.com | Category: backup / restore
Rating: |  Discuss |   Briefcase | 2,249 reads

Review of SQL 2000 Fast Answers

A monster book at 980 pages, it's written in 'how-to' format and has a ton of good material. Andy gave it the once over for us and reports back - see what he thinks!   Read more...
By Andy Warren 2003/04/18 | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 18,204 reads

Review of SQL Server 2000 Programming (MSPress)

Andy sits down with an entry level book to see if he should use it at work as a teaching aid. Did he like it? Should you buy it? Read the review now!   Read more...
By Andy Warren 2002/06/04 | Source: SQLServerCentral.com | Category: installation
Rating: (not yet rated) |  Discuss |   Briefcase | 6,398 reads
   Items 1 to 12 of 12   
 
Tags
data retention (4)    
legal issues (4)    
administration (2)    
configuring (2)    
dts (2)    
indexing (2)    
installation (2)    
miscellaneous (2)    
sql server 7 (2)    
stored procedures (2)    
triggers (2)    
t-sql (2)    
user defined function (udf) (2)    
automation (1)    
distributed queries (1)    
editorial (1)    
editorial - ipod (1)    
editorial - mp3 (1)    
editorial - wmv (1)    
english query (1)    
job (1)    
monitoring (1)    
openxml (1)    
orphaned users (1)    
performance tuning (1)    
permissions (1)    
replication (1)    
scripting (1)    
sql server 2005 (1)    
updategrams (1)    
xml (1)    
xsl (1)