http://www.sqlservercentral.com/Content tagged Programming, Miscellaneous, Visual Basic 6 posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)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/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/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/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/This week Andy continues his series on how to reduce the number of round trips to the server by looking at some things you can easily add to your applications without a lot of rearchitecting. http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/reducingroundtripspart3/621/2002/03/11http://www.sqlservercentral.com/articles/Performance+Tuning+and+Scaling/reducingroundtripspart3/621/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/Last week Andy started a discussion of the various ways you can reduce the number of round trips to the server. This week he continues by looking at a method he used recently to do client side caching of data to eliminate the round trip altogether. Gotta read it! http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/2002/02/06http://www.sqlservercentral.com/articles/Performance+Tuning/reducingroundtripspart2/588/The application scenario described here, an e-mail-based SQL update program, uses a simple data model; however, this solution will apply to any data model that you are working with. It will also eliminate the need for complex n-tier Internet applications and serves as a low maintenance solution for providing data access. http://www.sqlservercentral.com/redirect/articles/573/2002/01/15http://www.sqlservercentral.com/redirect/articles/573/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/Ever have a large batch of scripts you need to run? It takes a while if you have to open each one in Query Analyzer and execute it. One of our readers proposed an alternative - take a look the small app Andy Warren wrote to make doing this task a breeze. http://www.sqlservercentral.com/articles/Administering/scriptrunner/292/2001/06/14http://www.sqlservercentral.com/articles/Administering/scriptrunner/292/A method for creating databases and other objects on the fly and distribute these objects to multiple servers. http://www.sqlservercentral.com/redirect/articles/257/2001/06/08http://www.sqlservercentral.com/redirect/articles/257/Jon Winer provides an intro to using MSMQ. http://www.sqlservercentral.com/articles/Miscellaneous/20010422114502/76/2001/04/22http://www.sqlservercentral.com/articles/Miscellaneous/20010422114502/76/