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

Content with tags Administration, Replication, Miscellaneous Rss

   Items 1 to 5 of 5   
 

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,205 reads

Another Disaster (Almost)

Andy had a semi-disaster similar to the one he wrote about last year. Interesting to see the kinds of problems that happen to other people. This article raises some interesting points that are outside the scope of basic disaster recovery, looking at how/when to move databases to a different server and how to reduce the server load dynamically.   Read more...
By Andy Warren 2003/01/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,034 reads

Review of Real-World SQL-DMO

Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book!   Read more...
By Andy Warren 2002/11/19 | Source: SQLServerCentral.com | Category: administration
Rating: (not yet rated) |  Discuss |   Briefcase | 5,245 reads

The Case for SQL Logins - Part 1

Andy says Windows Authentication "is bad". What? That's not what Microsoft says! Heck, that's not even what we say! Everyone knows NT authentication is the way to go. Then again, when was the last time Andy wrote an article that wasn't worth reading?! Read the article, rate it and add a comment - and automatically be entered in a drawing for a copy of SQL Server 2000 Performance Tuning donated by Microsoft Press.   Read more...
By Andy Warren 2002/06/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,593 reads

Middle Tier Application Data Caching with SQL Server 2000

Middle tier applications often use a single database management system (DBMS) to store data, which can expose scaling limitations as the number of user requests increases. Caching, a technique used to increase application performance by copying data and then using the copied data in place of the original data, can dramatically increase the throughput (the number of application requests serviceable per unit time) and scalability of middle tier applications.   Read more...
By Additional Articles 2002/03/08 | Source: Microsoft SQL Home | Category: administration
Rating:  Rate this |   Briefcase | 1,706 reads
   Items 1 to 5 of 5   
 
Tags
configuring (5)    
sql server 7 (5)    
backup / restore (3)    
programming (3)    
distributed queries (2)    
monitoring (2)    
performance tuning (2)    
security (2)    
ado (1)    
availability (1)    
disaster recovery (dr) (1)    
dts (1)    
english query (1)    
indexing (1)    
installation (1)    
openxml (1)    
sql-dmo (1)    
stored procedures (1)    
strategies (1)    
triggers (1)    
t-sql (1)    
updategrams (1)    
user defined function (udf) (1)    
visual basic 6 (1)    
xml (1)    
xsl (1)