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

Content with tags SQL Server 7, .Net Rss

   Items 1 to 8 of 8   
 

Stop SQL Injection Attacks Before They Stop You

A new article from MSDN magazine on stopping SQL Injection attacks by examining how the SQL can be exploited. It's a good basic article for developers as well as DBAs who might have to review code.  Read more...
By Additional Articles 2004/08/20 | Source: MSDN Communities | Category: security
Rating:  Rate this |   Briefcase | 2,409 reads

An introduction to using the ADO.NET - SqlCommand Object

Are you familiar with using the Command object in ADO? If so, migrating to ADO.NET should be a snap.   Read more...
By Jon Winer 2004/08/06 (first published: 2001/12/11) | Source: SQLServerCentral.com | Category: news
Rating: |  Discuss |   Briefcase | 18,393 reads

Managing Jobs - Part 4

Andy has been busy lately on a project you'll be hearing more about soon (!), but he did manage to get part four of his managing jobs series done. This article discusses ideas for patterns to follow when building jobs, including writing to the console, setting errorlevels, and how to get them installed on the server. DBA's, if you're not developers, look at this article - this is stuff you can take to your development team and get better/more manageable jobs.   Read more...
By Andy Warren 2003/06/25 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,980 reads

Managing Jobs Part 3

This week Andy looks at where, when, and how jobs should be run and why you need to think about those items before you build the job. Part of this is deciding what runs on production servers and what doesn't.   Read more...
By Andy Warren 2003/03/11 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 7,109 reads

Open Source ASP Enterprise Manager in Design Phase

Andy relates some info he got from Wes Grant about his freeware and open source project to build a web based admin tool for SQL that is currently in the design/initial coding phase. Get the scoop and maybe write some of the code too!   Read more...
By Andy Warren 2002/10/22 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,810 reads

Performance Comparison: Data Access Techniques

Architectural choices for data access affect performance, scalability, maintainability, and usability. This article focuses on the performance aspects of these choices by comparing relative performance of various data access techniques, including Microsoft® ADO.NET Command, DataReader, DataSet, and XML Reader in common application scenarios with a Microsoft SQL Server™ 2000 database.  Read more...
By Additional Articles 2002/03/01 | Source: Microsoft SQL Home | Category: performance tuning
Rating:  Rate this |   Briefcase | 2,427 reads

An introduction to using the ADO.NET - SqlCommand Object

Are you familiar with using the Command object in ADO? If so, migrating to ADO.NET should be a snap.   Read more...
By Jon Winer 2004/08/06 (first published: 2001/12/11) | Source: SQLServerCentral.com | Category: news
Rating: |  Discuss |   Briefcase | 18,393 reads

Improve System Performance in Your Indexing Scheme Using Asynchronous

The Web Data Administrator is a utility program implemented in ASP.NET that enables you to easily manage your SQL data, wherever you are.  Read more...
By Additional Articles 2001/10/10 | Source: Microsoft MSDN | Category: administration
Rating:  Rate this |   Briefcase | 1,491 reads
   Items 1 to 8 of 8   
 
Tags
programming (7)    
administration (4)    
miscellaneous (4)    
t-sql (3)    
visual basic 6 (3)    
ado (2)    
strategies (2)    
news (1)    
performance tuning (1)    
security (1)