http://www.sqlservercentral.com/Content tagged Visual Basic 6 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)This article will quickly dive head first right into XML. http://www.sqlservercentral.com/articles/Basics/20010422115709/78/2008/01/04http://www.sqlservercentral.com/articles/Basics/20010422115709/78/The third article in a four part series, this week Andy shows how to use the command object to work with stored procedure parameters. http://www.sqlservercentral.com/articles/Stored+Procedures/introductiontoadothecommandobject/535/2007/02/09http://www.sqlservercentral.com/articles/Stored+Procedures/introductiontoadothecommandobject/535/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/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 is about migrating Pocket PC applications that are written in eMbedded Visual Basic to the .NET Compact Framework. The migration includes a change from using ADO CE for accessing data in a Pocket Access database to using ADO.NET for accessing data in SQL Server CE. The sample code is supplied in both Visual Basic and C#.http://www.sqlservercentral.com/redirect/articles/1876/2005/05/26http://www.sqlservercentral.com/redirect/articles/1876/This article will quickly dive head first right into XML. http://www.sqlservercentral.com/articles/Basics/20010422115709/78/2008/01/04http://www.sqlservercentral.com/articles/Basics/20010422115709/78/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/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! http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticespart1ofaverylongseries/471/2004/12/03http://www.sqlservercentral.com/articles/Miscellaneous/worstpracticespart1ofaverylongseries/471/Need to apply changes to customer (or internal) databases in a calm, controlled manner? Dinish proposes an alterative to standard scripts that uses XML and a small VB app. http://www.sqlservercentral.com/articles/Visual+Basic+6/changingdatabasesusingxml/1285/2004/02/16http://www.sqlservercentral.com/articles/Visual+Basic+6/changingdatabasesusingxml/1285/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/This article will quickly dive head first right into XML. http://www.sqlservercentral.com/articles/Basics/20010422115709/78/2008/01/04http://www.sqlservercentral.com/articles/Basics/20010422115709/78/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. http://www.sqlservercentral.com/articles/DTS/automatedtslogging/1124/2003/09/09http://www.sqlservercentral.com/articles/DTS/automatedtslogging/1124/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. http://www.sqlservercentral.com/articles/Administering/worstpracticebadconnectionstringsandbadinfoinsyspr/802/2003/08/01http://www.sqlservercentral.com/articles/Administering/worstpracticebadconnectionstringsandbadinfoinsyspr/802/Freeware! This add-in gives you some great extra features when working in VB6. It has a tab index setter, options to add a chunk of error handling code, a simple code analyzer that gives you some metrics, and my favorite - an option to identify unused code and variables. If you're still using VB6 it's worth trying. http://www.sqlservercentral.com/redirect/articles/1073/2003/07/30http://www.sqlservercentral.com/redirect/articles/1073/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. http://www.sqlservercentral.com/articles/Administering/managingjobspart4/1037/2003/06/25http://www.sqlservercentral.com/articles/Administering/managingjobspart4/1037/If you're a VB.NET programmer who wants to learn database programming with ADO.NET, here's a new book that presents all the skills you need in a logical progression from the simple to the complex. Along the way, you'll learn how to use the classes, properties, methods, events, and techniques that have made this subject so hard to master. And when you're done, you'll have a reference that you'll use on the job every day. (Publisher Provided Description, not reviewed) http://www.sqlservercentral.com/redirect/articles/1005/2003/06/05http://www.sqlservercentral.com/redirect/articles/1005/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. http://www.sqlservercentral.com/articles/Administering/managingjobspart3/936/2003/03/11http://www.sqlservercentral.com/articles/Administering/managingjobspart3/936/The first part of this series provides a road map for a very cool application using an under-utilized companion of the SQL Server 2000 database platform. http://www.sqlservercentral.com/articles/English+Query/introductiontoenglishqueryandspeechrecognition/534/2003/03/07http://www.sqlservercentral.com/articles/English+Query/introductiontoenglishqueryandspeechrecognition/534/The challenge for Robert Marda was to devise a way to keep the data available at all times while importing the new data, detect if a full or daily update was received and run appropriate data pumps, put in sufficient fail safes to ensure bad data would not get imported, and to make the process automatic including notification to pagers upon failure. Robert shows you how he did it here. http://www.sqlservercentral.com/articles/DTS/importingnewdatawithoutemptyingexistingtables/895/2003/01/09http://www.sqlservercentral.com/articles/DTS/importingnewdatawithoutemptyingexistingtables/895/Are you using default values for your parameters? Using named parameters when you call the proc or passing the values by ordinal? Should you be? Andy thinks 6 out of 10 of our readers will agree with his point of view, we'll be a little more conservative and guess that 5 of out 10 will be closer. http://www.sqlservercentral.com/articles/Miscellaneous/defaultvaluesandnamedparametersforstoredprocs/882/2003/01/08http://www.sqlservercentral.com/articles/Miscellaneous/defaultvaluesandnamedparametersforstoredprocs/882/Andy talks briefly about why the company he works for has decided to require all developers to obtain the MCSD, then takes a look at the book they chose for the initial round of study for the first exam. http://www.sqlservercentral.com/articles/Miscellaneous/reviewofdevelopingwindowsbasedapplicationsforvbnet/852/2002/11/26http://www.sqlservercentral.com/articles/Miscellaneous/reviewofdevelopingwindowsbasedapplicationsforvbnet/852/Andy takes a look at the new book on DMO and likes what he sees - "great book for beginner and intermediate DMO users!". We've been supporters of DMO for a while and we're glad to see a new book on the subject. Read the review, add your comments, buy the book! http://www.sqlservercentral.com/articles/Administering/reviewofrealworldsqldmo/842/2002/11/19http://www.sqlservercentral.com/articles/Administering/reviewofrealworldsqldmo/842/In this article, columnist Christopher Duncan shows you how to create your dream development project. http://www.sqlservercentral.com/articles/Miscellaneous/creatingyourdreamproject/851/2002/11/15http://www.sqlservercentral.com/articles/Miscellaneous/creatingyourdreamproject/851/Following up on a question posted in our discussion area, Andy demonstrates how to backup/restore a database using DMO, how to get the list of files to be restored, and how to do a restore with no recovery. Lots of sample code! http://www.sqlservercentral.com/articles/Miscellaneous/restoringusingdmogettingfilelistandnorecovery/823/2002/10/15http://www.sqlservercentral.com/articles/Miscellaneous/restoringusingdmogettingfilelistandnorecovery/823/Following up on a question posted in our discussion area, Andy looks at how to use DMO to add and remove linked servers. Along the way he points out a couple 'gotchas' and throws in a cool tip about how to save a little time when you experiment with DMO. http://www.sqlservercentral.com/articles/Administering/addinglinkedserversusingsqldmo/801/2002/09/19http://www.sqlservercentral.com/articles/Administering/addinglinkedserversusingsqldmo/801/In this article Andy looks at one way you can separate your presentation code from your data when you generate HTML tables for simple reports. Lots of code examples so you can see how it works. http://www.sqlservercentral.com/articles/Miscellaneous/generatinghtmltables/749/2002/08/05http://www.sqlservercentral.com/articles/Miscellaneous/generatinghtmltables/749/Programmers can most commonly relate to interface-based programming in their programming language. This is harder to accomplish in SQL Server though. In this article by Chris Cubley, he shows you how to build interfaced-based SQL. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/sql_interface_final/732/2002/07/19http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/sql_interface_final/732/Version control for stored procedures isn't always popular and certainly isn't easy. Or can it be? Andy discusses a technique he used on a recent project that you might find interesting. http://www.sqlservercentral.com/articles/Administering/versioncontrolforstoredprocedures/681/2002/05/10http://www.sqlservercentral.com/articles/Administering/versioncontrolforstoredprocedures/681/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/