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, Miscellaneous, Programming Rss

   Items 1 to 20 of 51    Older >>
 

Free Encryption

Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.   Read more...
By Michael Coles 2008/04/25 (first published: 2005/07/21) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 75,294 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,318 reads

Free Encryption

Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.   Read more...
By Michael Coles 2008/04/25 (first published: 2005/07/21) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 75,294 reads

Leveraging XP Excel , XML, and OPENXML for Data Imports

DTS is a fantastic ETL tool and it is often used to import Excel documents. However this can be a manual process in many cases in setting up the package. New author Sloan Holliday brings us a way that you can leverage Office XP's automation facilities and XML to import data into SQL Server.   Read more...
By Sloan Holliday 2005/11/22 | Source: SQLServerCentral.com | Category: dts
Rating: |  Discuss |   Briefcase | 10,638 reads

Use SQL-DMO and Excel to Quickly Create Reports for Auditors

Auditing SQL Server, or any system, is not an easy task and with new regulations like Sarbanes-Oxley, it is becoming a full time job in some environments. Chad Miller brings us a way that he developed with Excel and some scripting to automate some of the security information for a large installation of SQL Servers.   Read more...
By Chad Miller 2005/10/04 | Source: SQLServerCentral.com | Category: miscellaneous
Rating: |  Discuss |   Briefcase | 11,137 reads

Adventures in Replication

SQL Server 2000 replication is the easiest so far to setup and work with. However there are some areas that you can get yourself into trouble with if you are not careful. New author Chris Rock brings us a few lessons learned in getting replication working with a remote office.   Read more...
By Chris Rock 2005/08/22 | Source: SQLServerCentral.com | Category: replication
Rating: |  Discuss |   Briefcase | 9,639 reads

Performance Monitoring by Internal Fragmentation Measurement

It has not been clear to what extent fragmentation, either internal or external, truly affects the performance of your SQL Server 2000 databases. New author Koby Biller discusses some of the impacts that it could have and has a free tool for download that can help you determine how fragmented your disk truly is.   Read more...
By Koby Biller 2005/08/16 | Source: SQLServerCentral.com | Category: performance tuning
Rating: |  Discuss |   Briefcase | 8,399 reads

Free Encryption

Free SQL Server 2000 Encryption for your data!!! Author Michael Coles has put together a tolljit and some XPs that you can use to encrypt your data with the Blowfish algorithm. It is hard to write good applications that encrpyt data and manage the keys and security. This will give you a great headstart on protecting your data.   Read more...
By Michael Coles 2008/04/25 (first published: 2005/07/21) | Source: SQLServerCentral.com | Category: security
Rating: |  Discuss |   Briefcase | 75,294 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,318 reads

SQL Maintenance Plans

Do you use the maintenance plans or hate them? Wish they would do more? Curious about how they work under the hood? Cmon, you gotta read this one! Trust us, it's not another "how-to" article! Well, maybe just a little bit!   Read more...
By Andy Warren 2005/03/04 (first published: 2002/04/11) | Source: SQLServerCentral.com | Category: administration
Rating: |  Discuss |   Briefcase | 33,815 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,794 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,399 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,853 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,648 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,421 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,245 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,312 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,318 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,399 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,423 reads
   Items 1 to 20 of 51    Older >>
 
Tags
administration (22)    
t-sql (16)    
strategies (14)    
visual basic 6 (12)    
configuring (11)    
performance tuning (8)    
security (7)    
ado (6)    
database design (6)    
sql-dmo (5)    
.net (4)    
dts (4)    
replication (4)    
stored procedures (4)    
backup / restore (3)    
best and worst practices (3)    
indexing (3)    
monitoring (3)    
naming standards (3)    
worst practices (3)    
asp (2)    
availability (2)    
basics (2)    
analysis services (ssas) (1)    
data warehousing (1)    
disaster recovery (dr) (1)    
english query (1)    
installation (1)    
olap server (1)    
sql server 6.5 (1)    
xml (1)