================================================ SEARCHDATABASE.COM'S Database Developer Tip August 29, 2001 ================================================ Welcome to the searchDatabase.com Database Developer Tip newsletter! Today's tip, "Creating a SQL Server database" can also be viewed online at: http://www.searchDatabase.com/tip/1,289483,sid13_gci764004,00.html Don't forget about our collection of over 200 DBA, developer, Oracle, DB2, and SQL Server tips FREE to searchDatabase members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html ******** Sponsored by Lumigent *********** "Eat Your Spinach!" Mom taught you many good habits. If she was a DBA she would have given you a few more tips, like "use Log Explorer to find and fix user errors" and "don't recover from a backup, use Log Explorer to recover column, row or table data selectively and in real time." Get your FREE TRIAL--> http://ad.doubleclick.net/clk;3265854;5058249;r?http://www.lumigent.com/go/searchdb8 ************************************************* "Creating a SQL Server database" By Rob Hawthorne As with most tasks in SQL Server 2000, there are many different ways to achieve the same thing. You can use a nice user interface or you can enter Transact-SQL directly against the database. Listed here are the three basic methods you can use to create a database in SQL Server 2000: * Run the Database Creation Wizard, which is contained in Enterprise Manager. This is a simple wizard that allows you to enter the parameters that you require to model your database on. Although using the wizard is an effective and simple way to create an application database, as a DBA you usually will use one of the two following methods because they are a little quicker. For this reason we will not cover the creation of a database through the wizard. * Using the UI in Enterprise Manager to create a database. This is done by selecting the New Database option from the pop-up menu when you right-click the database folder within Enterprise Manager. This is the most common way of creating a database in SQL Server 2000, probably because of the friendly user interface you are provided. We will initially create our application database with this method. * Enter the CREATE DATABASE Transact-SQL statement directly into Query Analyzer. This is by far the most difficult to remember (I always have trouble remembering the exact syntax), but it gives you the most flexibility and is probably the preferred way for most DBAs. The reason? The knowledge is cross-transferable. Even if you move to another database management system (heaven forbid), you will know the basic structure of the statement. As you can see, SQL Server 2000 has the ability to create a database quickly and easily by all levels of users. Now, let's get down to business... STEP-BY-STEP DETAILS ABOUT CREATING A SQL SERVER DATABASE AVAILABLE HERE: http://www.searchDatabase.com/tip/1,289483,sid13_gci764004,00.html This tip is excerpted from "SQL Server 2000 Database Development From Scratch," by Rob Hawthorne. Courtesy of InformIT: http://informit.com/content/index.asp?session_id={CF234B4D-F383-4C08-B4E0-D7A5F7979087}&product_id={2C1877C0-50B1-4191-B0BB-1ECC77E9F3B4} SUBMIT YOUR OWN TIP AND WIN FREE TECHNICAL BOOKS! http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz520733_cts520732,00.html ================================================ MORE GREAT STUFF ON SEARCHDATABASE.COM! ================================================ This week's Featured Topic: Database-web connectivity Integrating a DBMS with the Web and replacing static HTML with dynamic, database-driven Web pages continue to be top IT challenges. Our collection of tips and advice will help you understand & implement database-Web connectivity technologies. http://searchdatabase.techtarget.com/featuredTopic/0,290042,sid13_gci762529,00.html Mark your calendars: BILL INMON, the father of data warehousing, will be presenting "Ten critical data warehousing success factors" live on searchDatabase.com September 6 at 1 pm Eastern (18:00 GMT). He will also be available to take your questions. Don't miss this opportunity to chat with the premier data warehousing guru in the world! http://searchdatabase.techtarget.com/onlineEvents/0,289675,sid13,00.html A searchDatabase.com exclusive: Informix product line lives on inside IBM IBM has sent strong signals that the Informix product line will not suffer a quick death now that Big Blue has completed its $1 billion acquisition of the software maker's database business. At a recent media briefing, IBM officials discussed future releases of Informix products, as well as how Informix technology will be incorporated into IBM's DB2 Universal Database. More: http://www.searchdatabase.com/originalContent/0,289142,sid13_gci763216,00.html Over 200 DBA, developer, Oracle, DB2, and SQL Server tips FREE to searchDatabase members: http://searchdatabase.techtarget.com/tips/0,289484,sid13_tax281808,00.html Hundreds of hand-picked and reviewed resources about every aspect of database development, including SQL, ADO, ODBC, ASP, PERL, and much more: http://searchdatabase.techtarget.com/bestWebLinks/0,289521,sid13_tax281563,00.html Ask the Expert category of the day: "SQL Server" http://searchdatabase.techtarget.com/ateAnswers/0,289620,sid13_cid376817_tax285649,00.html SQL Server gurus Mike Hotek, Bianca Blount & Jorge Cano are waiting to tackle your toughest SQL Server problems. ======================================= LEARNING ZONE FEATURED BOOK OF THE WEEK ======================================= "SQL Server 2000 Black Book" By Patrick Dalton & Paul Whitehead An insightful guide to utilizing the power and flexibility of SQL Server 2000. Geared toward the intermediate to advanced database administrator and programmer, this book will help you leverage the full potential of relational database technology to create a state-of-the-art database solution. This book will help you: install and configure SQL Server 2000, solve complex database management problems, master the tools and utilities, write faster database applications, unlock the power of SQL, and much more. http://www.digitalguru.com/DigitalGuru/product_detail.asp?Catalog_Name=Books&Category_name=SQL+Server+%28Microsoft%29&Product_Id=1576107701&partner_id=77 ================================================ SUBMIT A TECHNICAL TIP AND WIN A PRIZE! ================================================ Do you have a time-saving shortcut, trick, or script that you want to share with other database pros? The highest rated tips each month will win our "Tip of the Month" contest and receive a high-quality searchDatabase.com denim shirt AND a free book of your choice from Wrox Press. We're accepting short, focused tips or code snippets on topics of interest to DBA's and database developers, such as Oracle, DB2, SQL Server, database design, SQL, performance tuning, etc. Click here for more info and to submit your tip: http://searchdatabase.techtarget.com/tipsPrize/0,289492,sid13_prz520733_cts520732,00.html This will be a great way to share your knowledge, cement your status as an industry expert, and maybe win a prize. Send us your tip today! ================================================ If you would like to sponsor this or any TechTarget newsletter, please contact Gabrielle DeRussy at [EMAIL PROTECTED] ================================================ If you no longer wish to receive this newsletter simply reply to this message with "REMOVE" in the subject line. Or, visit http://searchDatabase.techtarget.com/register and adjust your subscriptions accordingly. If you choose to unsubscribe using our automated processing, you must send the "REMOVE" request from the email account to which this newsletter was delivered. Please allow 24 hours for your "REMOVE" request to be processed.