| Complete. Authoritative. Practical. The only SQL Server book you need. Mastering SQL Server 2000 is the one indispensable resource for anyone working with the latest version of SQL Server. Whether you build or administer SQL Server databases or write applications that communicate with them, you'll find the background knowledge and the practical instruction you need to accomplish any task, from the most basic to the most advanced. Coverage includes:
- Understanding SQL Server architecture
- Designing an efficient normalized database
- Writing Transact-SQL statements and batches
- Creating databases
- Creating tables and views
- Creating stored procedures and triggers
- Administering SQL Server
- Managing SQL Server security
- Designing applications using ADO, SQL-DMO, and SQL-NS
- Using Data Transformation Services
- Integrating SQL Server with the Internet
- Optimizing SQL Server performance
- Understanding and managing replication
- Using Analysis Services to analyze data
- Using Microsoft English Query
- Troubleshooting common problems
About the Author Mike Gunderloy, an MCSE, MCSD, and MCT, is a senior consultant with MCW Technologies, where he specializes in Microsoft Visual Basic and SQL Server. He is the author of SQL Server 7 In Record Time,Visual Basic Developer's Guide to ADO, and VB/VBA Developer's Guide to the Windows Installer, all from Sybex. Mike lives on a farm in rural Washington state with his family and an ever-growing population of livestock.
Joseph L. Jorden is an MCSE, MCT, CCNA, and CCDA who has been administering databases for the last seven years. Currently Joseph works independently, consulting and instructing on a variety of technologies. |
|
|
Frame Relay for High-Speed NetworksEmerging new applications for a mature technology. Frame relay has recently emerged as a popular interface choice for today's high-speed services, including videoconferencing, SNA networking, voice-over data, and high-speed Internet access itself. Stressing services rather than bits and bytes, this book reexamines this mature technology in light of... | | | | The Adobe Illustrator CS Wow! BookOne of the first things you might notice about the newest version of Adobe Illustrator is that numbers are out, and letters are in. Instead of the predictable "Illustrator 11," this release has been given the name "Illustrator CS." The CS stands for Creative Suite, and in fact it is a pretty suite deal... |
Core JSTL: Mastering the JSP™ Standard Tag LibraryUsing JSTL, software developers and Web page authors can create robust, flexible Web applications more quickly and easily than ever before. Now, best-selling author and JSTL expert David Geary presents the definitive guide to JSTL: its built-in tags, powerful expression language, and extensibility. Through practical examples... | | Data Mining in Drug Discovery
Written for drug developers rather than computer scientists, this monograph adopts a systematic approach to mining scientifi c data sources, covering all key steps in rational drug discovery, from compound screening to lead compound selection and personalized medicine. Clearly divided into four sections, the first part discusses the different... | | Advanced Crime Scene Photography
Advanced Crime Scene Photography developed over time and out of my
experiences as a crime scene investigator with a large metropolitan police
department. Like any major city, violent crime is prevalent, offering numerous
opportunities to utilize the different skills and techniques learned and
evolved through numerous schools, scene... |
|