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

Content with tags Programming, Strategies Rss

<< Newer    Items 21 to 29 of 29   
 

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

Review of Refactoring: Improving the Design of Existing Code

It's not a SQL book and the code examples are in Java, but there is a lot to like about this book. What is refactoring? How would you find it useful? Read the review to find out!   Read more...
By Andy Warren 2002/07/02 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 3,469 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,367 reads

Analyzing Requirements and Defining Solution Architectures

Andy says it's not the greatest book for preparing for the 70-100 exam, but the case study is worth reading for it's explanation of the Microsoft Solution Framework. Read the full review!   Read more...
By Andy Warren 2002/01/02 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 3,540 reads

70-100 MCSD Architectures Exam Cram

Should you use this book to prepare for the 70-100 exam? Read the review and find out!   Read more...
By Andy Warren 2001/12/26 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: (not yet rated) |  Discuss |   Briefcase | 3,704 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,448 reads

Worst Practices - Part 1 of a Very Long Series!

Andy starts a new series about Worst Practices - come find out why and read about the first one on his list - using Hungarian Notation for column names!   Read more...
By Andy Warren 2004/12/03 (first published: 2001/10/09) | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 33,726 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,579 reads

Using DMO to Restore a Database

This article by Andy Warren includes code samples showing you how to restore a database from a file or a device backup.   Read more...
By Andy Warren 2006/06/16 (first published: 2001/05/07) | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 24,529 reads
<< Newer    Items 21 to 29 of 29   
 
Tags
miscellaneous (24)    
sql server 7 (15)    
administration (11)    
t-sql (9)    
database design (6)    
visual basic 6 (6)    
configuring (5)    
.net (4)    
naming standards (4)    
sql-dmo (4)    
stored procedures (4)    
disaster recovery (dr) (3)    
security (3)    
system development life cycle (3)    
availability (2)    
backup / restore (2)    
book reviews (2)    
career (2)    
certifications (2)    
monitoring (2)    
performance tuning (2)    
reviews (2)    
best and worst practices (1)    
replication (1)    
sql puzzles (1)    
worst practices (1)