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

Content with tags Administration, Visual Basic 6, Configuring Rss

   Items 1 to 11 of 11   
 

Copying DTS Packages To a Different Server

How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't!   Read more...
By Andy Warren 2006/05/05 (first published: 2002/03/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 37,490 reads

Worst Practices - Making Databases Case Sensitive (Or Anything Else)

Article number four in this popular series continues exposing Worst Practices! This week Andy continues his tirade by talking about why case sensitive databases should be BANNED from the planet. Is he right or just OUT OF CONTROL? Read the article and join the discussion - your comment may lead to an article, that's what generated this one!   Read more...
By Andy Warren 2005/07/08 (first published: 2001/10/29) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 28,322 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,790 reads

Worst Practice - Bad Connection Strings and Bad Info in Sysprocesses

Andy returns to the Worst Practice series this week with a short article looking at how connection strings in applications affect what you see in sysprocesses. Perhaps less controversial (in our opinion) that some of the other worst practices, this is something easy to fix and definitely worth fixing! Read the article and post a comment - explore other points of view! Readers posting a comment will be entered in a drawing for a copy of the SQL Server 2000 Resource Kit.   Read more...
By Andy Warren 2003/08/01 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 15,035 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

Adding Linked Servers Using SQL-DMO

Following up on a question posted in our discussion area, Andy looks at how to use DMO to add and remove linked servers. Along the way he points out a couple 'gotchas' and throws in a cool tip about how to save a little time when you experiment with DMO.   Read more...
By Andy Warren 2002/09/19 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 12,116 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,374 reads

Copying DTS Packages To a Different Server

How do you easily copy DTS packages from one server to another? DTS, BCP, T-SQL? Are there advantages to using one method over another? Andy did some research - read the article and see what works and what doesn't!   Read more...
By Andy Warren 2006/05/05 (first published: 2002/03/19) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 37,490 reads

Data Dictionary from within SQL Server 2000

Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary!   Read more...
By Mindy Curnutt 2005/02/04 (first published: 2002/02/11) | Source: SQLServerCentral.com | Category: installation
Rating: |  Discuss |   Briefcase | 35,790 reads

Review of SQL Comparison and Synchronization Toolkit

This week Andy takes a look at a new product from Red-Gate that gives you even more options than you get with their SQL Compare and SQL Data Compare tools - now you can build your own. Add the features you always wanted. Build automated processes instead of using the GUI. It's an interesting product - read the review and then maybe even enter the contest to win a free copy.   Read more...
By Andy Warren 2002/01/16 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 5,361 reads

Worst Practices - Making Databases Case Sensitive (Or Anything Else)

Article number four in this popular series continues exposing Worst Practices! This week Andy continues his tirade by talking about why case sensitive databases should be BANNED from the planet. Is he right or just OUT OF CONTROL? Read the article and join the discussion - your comment may lead to an article, that's what generated this one!   Read more...
By Andy Warren 2005/07/08 (first published: 2001/10/29) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 28,322 reads
   Items 1 to 11 of 11   
 
Tags
programming (8)    
sql server 7 (8)    
ado (4)    
miscellaneous (4)    
sql-dmo (3)    
database design (2)    
replication (2)    
t-sql (2)    
backup / restore (1)    
basics (1)    
best and worst practices (1)    
distributed queries (1)    
dts (1)    
installation (1)    
security (1)    
stored procedures (1)    
strategies (1)    
worst practices (1)