http://www.sqlservercentral.com/Articles tagged Programming, SQL Server 7, 2000 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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. http://www.sqlservercentral.com/articles/Security/freeencryption/1980/2008/04/25http://www.sqlservercentral.com/articles/Security/freeencryption/1980/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. http://www.sqlservercentral.com/articles/Administering/usingvbscripttoautomatetasks/1171/2008/03/07http://www.sqlservercentral.com/articles/Administering/usingvbscripttoautomatetasks/1171/SQL Server 2000 is the basis for the new Access database storage. However there are still many cases where applications developed on Access are outgrown and need to be moved to SQL Server to support the load. Author Kathi Kellenberger brings us a look at the Upsizing Wizard and how you can move your databases to SQL Server. http://www.sqlservercentral.com/articles/SQL+Server+2000+Upgrading/accesstosqlservertheupsizingwizard/1721/2007/01/12http://www.sqlservercentral.com/articles/SQL+Server+2000+Upgrading/accesstosqlservertheupsizingwizard/1721/SQL Server 2000 and Access databases can be configured to work closely together. If you find that the Access storage format is not handling your needs and an upgrade is needed, you need not through away all of your access development. Instead, you can link Access tables to underlying tables in SQL Server and improve your application by using SQL Server as the backend for your Access project. Author Kathi Kellenberger brings us her second articles in an Access series looking at Linking tables to http://www.sqlservercentral.com/articles/SQL+Server+2000+Upgrading/accesstosqlserverlinkingtables/1722/2006/11/17http://www.sqlservercentral.com/articles/SQL+Server+2000+Upgrading/accesstosqlserverlinkingtables/1722/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. http://www.sqlservercentral.com/articles/DTS/executingpackagefromvisualbasic/585/2006/08/18http://www.sqlservercentral.com/articles/DTS/executingpackagefromvisualbasic/585/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! http://www.sqlservercentral.com/articles/Administering/copyingdtspackagestoadifferentserver/638/2006/05/05http://www.sqlservercentral.com/articles/Administering/copyingdtspackagestoadifferentserver/638/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. http://www.sqlservercentral.com/articles/Security/freeencryption/1980/2008/04/25http://www.sqlservercentral.com/articles/Security/freeencryption/1980/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. http://www.sqlservercentral.com/articles/DTS/leveragingxpexcelxmlandopenxmlfordataimports/2134/2005/11/22http://www.sqlservercentral.com/articles/DTS/leveragingxpexcelxmlandopenxmlfordataimports/2134/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. http://www.sqlservercentral.com/articles/Miscellaneous/usesqldmoandexceltoquicklycreatereportsforauditors/2064/2005/10/04http://www.sqlservercentral.com/articles/Miscellaneous/usesqldmoandexceltoquicklycreatereportsforauditors/2064/Do you know the difference between a login and a user? What's the best way to add them; Enterprise Manager, T-SQL, or SQL-DMO? In this beginner level article Andy demonstrates how to use all three methods to add logins and users and offers his view of which is the best technique. http://www.sqlservercentral.com/articles/Administering/loginsusersandrolesgettingstarted/514/2005/09/30http://www.sqlservercentral.com/articles/Administering/loginsusersandrolesgettingstarted/514/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. http://www.sqlservercentral.com/articles/Replication/adventuresinreplication/2013/2005/08/22http://www.sqlservercentral.com/articles/Replication/adventuresinreplication/2013/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. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/performancemonitoringbyinternalfragmentationmeasur/2014/2005/08/16http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/performancemonitoringbyinternalfragmentationmeasur/2014/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. http://www.sqlservercentral.com/articles/Security/freeencryption/1980/2008/04/25http://www.sqlservercentral.com/articles/Security/freeencryption/1980/One of the best ways to reduce the load on your server and increase application responsiveness is to reduce the number of "round trips" your application makes. This article by Andy Warren shows you a few ways to increase your performance by reducing round trips. http://www.sqlservercentral.com/articles/Performance+Tuning/roundtrips/586/2005/07/15http://www.sqlservercentral.com/articles/Performance+Tuning/roundtrips/586/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! http://www.sqlservercentral.com/articles/Administering/worstpracticesmakingdatabasescasesensitiveoranythi/489/2005/07/08http://www.sqlservercentral.com/articles/Administering/worstpracticesmakingdatabasescasesensitiveoranythi/489/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. http://www.sqlservercentral.com/articles/Administering/usingvbscripttoautomatetasks/1171/2008/03/07http://www.sqlservercentral.com/articles/Administering/usingvbscripttoautomatetasks/1171/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! http://www.sqlservercentral.com/articles/Administering/sqlmaintenanceplans/663/2005/03/04http://www.sqlservercentral.com/articles/Administering/sqlmaintenanceplans/663/Microsoft Access targets individual information workers and small teams that use the Microsoft Office System to track, manage, prioritize, and act upon an increasing volume of business information. The data stored in these databases rarely justifies moving to a more robust platform until the application begins expanding into departmental scenarios. When this happens, it is worthwhile to consider moving the data into a more robust platform for enhanced reliability, scalability, and greater IT control. In most cases, the data can be moved through a process called "upsizing" while the Access application front-end continues to provide information workers with access to critical data. Microsoft has created resources in the following three categories to help manage Access data in your organizations: http://www.sqlservercentral.com/redirect/articles/1738/2005/02/23http://www.sqlservercentral.com/redirect/articles/1738/SQL Server 2000 and Access databases can be configured to work closely together. If you find that the Access storage format is not handling your needs and an upgrade is needed, you need not through away all of your access development. Instead, you can link Access tables to underlying tables in SQL Server and improve your application by using SQL Server as the backend for your Access project. Author Kathi Kellenberger brings us her second articles in an Access series looking at Linking tables to http://www.sqlservercentral.com/articles/SQL+Server+2000+Upgrading/accesstosqlserverlinkingtables/1722/2006/11/17http://www.sqlservercentral.com/articles/SQL+Server+2000+Upgrading/accesstosqlserverlinkingtables/1722/SQL Server 2000 is the basis for the new Access database storage. However there are still many cases where applications developed on Access are outgrown and need to be moved to SQL Server to support the load. Author Kathi Kellenberger brings us a look at the Upsizing Wizard and how you can move your databases to SQL Server. http://www.sqlservercentral.com/articles/SQL+Server+2000+Upgrading/accesstosqlservertheupsizingwizard/1721/2007/01/12http://www.sqlservercentral.com/articles/SQL+Server+2000+Upgrading/accesstosqlservertheupsizingwizard/1721/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. http://www.sqlservercentral.com/articles/SQL+Server+2000+Upgrading/upsizingtheaccessdatabaseintothesqlserver/1724/2005/02/21http://www.sqlservercentral.com/articles/SQL+Server+2000+Upgrading/upsizingtheaccessdatabaseintothesqlserver/1724/Mindy explores the metadata stored in SQL 2000 to show you how to produce a simple and useful data dictionary! http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/2005/02/04http://www.sqlservercentral.com/articles/Installation/datadictionaryfromwithinsqlserver2000/607/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.http://www.sqlservercentral.com/redirect/articles/1470/2004/08/20http://www.sqlservercentral.com/redirect/articles/1470/Are you familiar with using the Command object in ADO? If so, migrating to ADO.NET should be a snap. http://www.sqlservercentral.com/articles/News/anintroductiontousingtheadonetsqlcommandobject/542/2004/08/06http://www.sqlservercentral.com/articles/News/anintroductiontousingtheadonetsqlcommandobject/542/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. http://www.sqlservercentral.com/articles/DTS/comparisonoforacledrivers/1430/2004/07/21http://www.sqlservercentral.com/articles/DTS/comparisonoforacledrivers/1430/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. http://www.sqlservercentral.com/articles/Administering/dumpsqlpermissions/1314/2004/03/17http://www.sqlservercentral.com/articles/Administering/dumpsqlpermissions/1314/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. http://www.sqlservercentral.com/articles/DTS/executingpackagefromvisualbasic/585/2006/08/18http://www.sqlservercentral.com/articles/DTS/executingpackagefromvisualbasic/585/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. http://www.sqlservercentral.com/articles/Security/rc4encryptioninastoredprocedure/1254/2004/01/09http://www.sqlservercentral.com/articles/Security/rc4encryptioninastoredprocedure/1254/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. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/dealingwithchangingdata/1233/2003/12/19http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/dealingwithchangingdata/1233/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)http://www.sqlservercentral.com/redirect/articles/1206/2003/12/03http://www.sqlservercentral.com/redirect/articles/1206/