SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Content with tags SQL Server 7, Programming Rss

<< Newer    Items 21 to 40 of 83    Older >>

Upsizing the Access Database into the SQL Server

SQL Server and Access are usually linked together as Access used for applications at the beginning of their lifecycle that are later moved to SQL Server when the load gets too high or the data sizes grow. There are often cases where you may also want to use SQL Server as a backend to an Access application. But how do you get your data from Access to SQL Server? Author Dinesh Asanka brings us an overview of the various ways that you can move your Access database to SQL Server.   Read more...
By Dinesh Asanka 2005/02/21 | Source: SQLServerCentral.com | Category: upgrading
Rating: |  Discuss |   Briefcase | 16,679 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,855 reads

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,695 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,405 reads

Comparison of Oracle Drivers

Oracle is usually a dirty word in the SQL Server community, but like it or not, lots of data resides in Oracle databases. And SQL Server is often used to gather this data together in a warehouse of some sort for spinning cubes, generating reports, etc. Haidong Ji looks at the various methods that you can connect to an Oracle driver and compares the speed of each. If you need to get data from Oracle, or may need to, this is the place you want to start.   Read more...
By Haidong Ji 2004/07/21 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 15,879 reads

Dump SQL Permissions

We saw a note from Chad about a tool he wrote in the forums and asked him to write up some notes. Not only did we get notes, we got the source code! See what a DBA can do with some DMO.   Read more...
By Chad Miller 2004/03/17 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 17,714 reads

Executing a Package from Visual Basic

So you've created a SQL Server package and now you're ready to integrate it into your Visual Basic application? In this series, Brian Knight will show you how to use the DTS object model to execute a DTS package from Visual Basic.   Read more...
By Brian Knight 2006/08/18 (first published: 2004/01/23) | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 25,023 reads

RC4 Encryption in a Stored Procedure

Joseph gathered together some various bits of code and came up with a solution that lets you do RC4 encryption via the sp_oa~ procedures.   Read more...
By Joseph Gama 2004/01/09 | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 8,676 reads

Dealing With Changing Data

As Chris points out, in most applications these days you end up having to go with optimistic locking, which presents a few challenges. Chris works through the list of options. If you're building web/disconnected apps and need anything besides last update wins, this one is for you.   Read more...
By Christoffer Hedgate 2003/12/19 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 9,426 reads

New JDBC Driver for SQL

This is one of the vendors we met at PASS 2003. Their new driver is supposed to be faster than the driver provided by Microsoft AND supports NT authentication. Link takes you to a comparision chart of features. (Not Reviewed)  Read more...
By Additional Articles 2003/12/03 | Source: Other | Category: administration
Rating:  Rate this |   Briefcase | 1,497 reads

Introduction to ADO Part 2 - Recordsets

Part two in the Introduction to ADO series, this beginner level article shows how to open a recordset, how to add and edit records, and touches lightly on how to select the best cursor type and locking mode. Good code samples help you get started fast!   Read more...
By Andy Warren 2003/11/28 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 16,216 reads

Custom Log Shipping

One of our favorite authors is back with a great how-to on log shipping. This isn't the baked in log shipping, this is a code your own solution that gives you a starting point for your situation. Even if you don't need it now, it's worth looking at to gain a better understanding of how shipping works.   Read more...
By Chris Kempster 2003/11/26 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 24,596 reads

Using VBScript to Automate Tasks

This article discusses why VBScript should be one of the tools you use to manage your server. Sample scripts show how to remove files over x days old and how to FTP files.   Read more...
By Haidong Ji 2008/03/07 (first published: 2003/11/04) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 100,391 reads

Review of AdeptSQL

Another product review! Chris put AdeptSQL (a schema comparison and sync product) to work and wrote up the results. This article also includes some feedback from the vendor that is worth reading.   Read more...
By Chris Kempster 2003/11/03 | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 4,405 reads

Full-Text Indexing Tips

This article by Jon Winer offers some tips to help you get the most of SQL Full Text Search.   Read more...
By Jon Winer 2003/09/25 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 12,486 reads

Automate DTS Logging

DTS logging is a pretty handy feature - if you've got it enabled. Got lots of packages and want to turn it on for all of them? Thats a lot of point and click using EM, but with the code Haidong has put together, it's a snap. Other possibilities to this code as well. After all, it uses a DTS package to modify other DTS packages.   Read more...
By Haidong Ji 2003/09/09 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 11,980 reads

VBScript Class to Return Backup Information

The second article in a 3 part series that presents another VBScript class file that creates a class that can be used to display the backup information from a SQL server's maintanence plans.   Read more...
By Bruce Szabo 2003/08/28 | Source: SQLServerCentral.com | Category: sql-dmo
Rating: |  Discuss |   Briefcase | 6,760 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,080 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,990 reads

IMP Index Manager

Integrate high performance index- and search functionality in your SQL database. Essentially, IMP Index Manager is a set of tools (search engine, administrative interface, etc.) to make it very easy to add search engine capabilities to SQL Server 2000. Easy to implement, and lightening fast performance. (Not Reviewed)   Read more...
By Additional Articles 2003/06/10 | Source: ASPToday | Category: miscellaneous
Rating:  Rate this |   Briefcase | 1,369 reads
<< Newer    Items 21 to 40 of 83    Older >>
miscellaneous (45)    
administration (30)    
visual basic 6 (23)    
t-sql (18)    
configuring (15)    
strategies (15)    
ado (12)    
sql-dmo (12)    
performance tuning (11)    
security (9)    
dts (8)    
.net (7)    
database design (6)    
replication (6)    
backup and restore (5)    
stored procedures (5)    
access (4)    
indexing (4)    
upgrading (4)    
asp (3)    
best and worst practices (3)    
monitoring (3)    
naming standards (3)    
sql server 6.5 (3)    
worst practices (3)    
availability (2)    
basics (2)    
disaster recovery (dr) (2)    
news (2)    
analysis services (ssas) (1)    
data warehousing (1)    
distributed queries (1)    
english query (1)    
installation (1)    
olap server (1)    
xml (1)