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

Content with tags Strategies, Miscellaneous, SQL Server 7 Rss

<< Newer    Items 21 to 31 of 31   
 

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

Worst Practice - Not Having An Archive Plan For Each Table

We're curious to see what our readers have to say about this one! How many of us have tables accruing data that won't be used and/or isn't of any value? At what point do we get rid of it to free up resources?   Read more...
By Andy Warren 2002/11/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,149 reads

The Case for SQL Logins - Part Two

In this follow up to one of our most popular articles, Andy responds to comments posted by readers and discusses how to manage SQL logins effectively in your applications.   Read more...
By Andy Warren 2002/08/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 6,770 reads

SQL Maintenance Plans - Under the Covers!

In this follow up article Andy looks at how maintenance plans report errors and how they actually accomplish what they do. A little snooping with Profiler reveals all!   Read more...
By Andy Warren 2002/05/21 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,195 reads

Citrix MetaFrame, SQL Server, and the DBA

In this article, Brian looks at how Citrix MetaFrame can use SQL Server for its internal data repository. The basic operation of SQL Server in a Citrix MetaFrame installation is covered. In addition, Brian looks at how a DBA is an integral part of the support team for a successful Citrix MetaFrame farm.   Read more...
By Brian Kelley 2007/03/02 (first published: 2002/05/13) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 26,393 reads

Version Control for Stored Procedures

Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting.   Read more...
By Andy Warren 2002/05/10 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 13,382 reads

Worst Practices - Encrypting Data

Continuing with the Worst Practices Series: Steve Jones examines why encryption in the database is a bad idea.   Read more...
By Steve Jones 2002/01/08 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 8,380 reads

Enforcing Security in Multi-Tier Applications

The major part of the article, however, is dedicated to a topic that often confuses people and leads to some of the strongest disagreements among IT professionals and developers: the benefits and drawbacks of enforcing security in the middle (or business) tier versus the data tier.   Read more...
By Additional Articles 2001/12/25 | Source: Microsoft MSDN | Category: security
Rating:  Rate this |   Briefcase | 1,453 reads

DBA Job Description: What type of DBA are you?

One of the common questions that Brian Knight sees in the newsgroups is what is a DBA officially supposed to be doing? In this article, Brian covers the many hats a DBA can and does wear.   Read more...
By Brian Knight 2001/11/05 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 18,675 reads

Executing Multiple Scripts in a Folder using the ScriptRunner Utility

Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze.   Read more...
By Andy Warren 2001/06/14 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 9,581 reads

A Look at SQL Server CE

An introductory article from Microsoft on the newest version of SQL Server: SQL Server CE designed for Windows CE devices. Includes some ideas for where this version fits in your architecture.   Read more...
By Additional Articles 2001/05/30 | Source: Microsoft SQL Home | Category: replication
Rating:  Rate this |   Briefcase | 1,395 reads
<< Newer    Items 21 to 31 of 31   
 
Tags
administration (20)    
programming (14)    
t-sql (11)    
configuring (7)    
database design (4)    
security (4)    
visual basic 6 (4)    
availability (3)    
backup / restore (3)    
best and worst practices (3)    
disaster recovery (dr) (3)    
naming standards (3)    
performance tuning (3)    
stored procedures (3)    
worst practices (3)    
.net (2)    
indexing (2)    
monitoring (2)    
replication (2)    
sql-dmo (2)    
career (1)    
dts (1)    
sql server 2005 (1)    
state of the business (1)    
system development life cycle (1)