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

Content with tags Programming, Visual Basic 6 Rss

<< Newer    Items 41 to 51 of 51   
 

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,315 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,727 reads

COM+ Application Guidelines for Visual Basic Development

This 80-page reference article presents guidelines for designing, building, and deploying COM+ applications, with an emphasis on Visual Basic.   Read more...
By Additional Articles 2001/10/05 | Source: Microsoft MSDN | Category: visual basic 6
Rating:  Rate this |   Briefcase | 851 reads

Connection Pooling with Microsoft SQL Server 2000 Analysis Services

This white paper describes how to use the connection pooling objects included with the Microsoft XML for Analysis Provider to develop scalable client and Web applications for Microsoft SQL Server 2000 Analysis Services. (11 printed pages)   Read more...
By Additional Articles 2001/09/11 | Source: Microsoft MSDN | Category: visual basic 6
Rating:  Rate this |   Briefcase | 1,271 reads

Try the SQL Parser Object to Colorize your SQL!

The SQLParser object - mostly undocumented - gives you an easy way to convert a TSQL string into a colorized RTF string. Andy started with that and wrote some code to change it to HTML. Useful? Never know! Code and demo program included with the article.   Read more...
By Andy Warren 2001/08/31 | Source: SQLServerCentral.com | Category: visual basic 6
Rating: |  Discuss |   Briefcase | 7,564 reads

Using COM to Output Queries to a Text File

This article presents a method of outputting the results of a query as a tab delimited text file using COM.   Read more...
By Les Smith 2001/07/20 | Source: SQLServerCentral.com | Category: advanced querying
Rating: |  Discuss |   Briefcase | 6,554 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

Creating SQL Objects on the fly with VB and XML

A method for creating databases and other objects on the fly and distribute these objects to multiple servers.   Read more...
By Additional Articles 2001/06/08 | Source: ASPToday | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,654 reads

Creating Merge Replication Conflict Resolvers

This article describes how to create a Visual Basic application for merge replication that will handle both conflict and non-conflict changes between the affected tables.   Read more...
By Additional Articles 2001/05/01 | Source: Microsoft MSDN | Category: replication
Rating:  Rate this |   Briefcase | 1,642 reads

MSMQ COM Object Programming in Visual Basic

Jon Winer provides an intro to using MSMQ.   Read more...
By Jon Winer 2001/04/22 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 4,640 reads

Index Server COM Object Programming in Visual Basic

Jon Winer talks about his adventures with Index Server and provides some hints to help you avoid some common problems.   Read more...
By Jon Winer 2001/04/22 | Source: SQLServerCentral.com | Category: visual basic 6
Rating: |  Discuss |   Briefcase | 4,123 reads
<< Newer    Items 41 to 51 of 51   
 
Tags
sql server 7 (23)    
miscellaneous (22)    
ado (14)    
t-sql (14)    
administration (12)    
configuring (8)    
.net (6)    
sql-dmo (6)    
strategies (6)    
basics (4)    
dts (4)    
performance tuning (4)    
stored procedures (4)    
xml (4)    
database design (3)    
replication (3)    
advanced querying (2)    
backup / restore (2)    
system development life cycle (2)    
analysis services (ssas) (1)    
asp (1)    
best and worst practices (1)    
career (1)    
certifications (1)    
data warehousing (1)    
distributed queries (1)    
english query (1)    
indexing (1)    
installation (1)    
naming standards (1)    
security (1)    
updategrams (1)    
worst practices (1)