Old South Exchange

Server Variables Asp

ASP in a Nutshell $31.99 ASP in a Nutshell provides the high-quality reference documentation that web application developers really need to create effective Active Server Pages. It focuses on how features are used in a real application and highlights little-known or undocumented features. This book also includes an overview of the interaction between the latest release of Internet Information Server (version 5) and ASP 3.0, with an introduction to the IIS object model and the objects it comprises. The examples shown in this section and throughout the book are illustrated in VBScript. The main components of this book are: Active Server Pages Introduction. Brief overview of the ASP application paradigm with examples in VBScript. Also included is an introduction to Microsoft’s Internet Information Server 5.0, the IIS object model, and the objects that it comprises. Object Reference. Each object is discussed in the following manner: descriptions, properties, collections, methods, events, accessory files/required DLLs, and remarks, including real-world uses, tips and tricks, and author’s experience (where applicable). The objects–Application, Response, Request, Server, Session, ObjectContext, and ASPError, as well as ASP Directives, Global.ASA, and Server-Side Includes–all follow this paradigm. Component Reference. This section follows the same paradigm found in Object Reference. The discussion covers all of the additional components included with IIS, such as ActiveX Data Objects, the Ad Rotator, the Browser capabilities component, the File System Object, and more. Appendixes. Gives examples in one or two objects and components using Perl, REXX, and Python in ASP. Like other books in the “In a Nutshell” series this book offers the facts, including critical background information, in a no-nonsense manner that users will refer to again and again. It is a detailed reference that enables even experienced web developers to advance their ASP applications to new levels.

Server Side Programming in Asp $23.4 No Synopsis Available

ASP .NET Programming with C# & SQL Server, 1st Edition $106.99 ASP .NET PROGRAMMING WITH C# AND SQL SERVER covers the basics of ASP.NET, C#, and SQL Server along with advanced topics including object-oriented programming and how to build Web sites that incorporate authentication and security. After completing this text, you will be able to use ASP.NET to build professional quality, database-driven Web sites.

ASP Made Simple $30.95 ASP Made Simple provides a brief introduction to ASP for the person who favours self teaching and/or does not have expensive computing facilities to learn on. The book will demonstrate how the principles of ASP can be learned with an ordinary PC running Personal Web Server, MS Access and a general text editor like Notepad. After working through the material readers should be able to: * Write ASP scripts that can display changing information on a web browser * Request records from a remote database or add records to it * Check user names & passwords and take this knowledge forward, either for their own web-development projects or as a stepping-stone to understanding more formal texts *Exercises and material builds up into a simple project, which is a customizable shell *Starts from first principles and does not assume the reader is a scripting expert *Constructed to give all the information needed to build a web site with database connectivity

eBook: ASP .NET Programming with C# & SQL Server $56.49 N/A

SQL Server Database: 5 Building and Maintenance Mistakes

Constructing and maintaining a SQL server database environment is like trying to hit a moving target. There are many parameters to consider for design, support, and troubleshooting. Making mistakes in these areas or missing important details will makes these tasks much more difficult.

Find out about SQL server monitor benefits.

These are 5 typical mistakes that occur in the creation and maintenance of a SQL server database environment. There are certainly more, but these are a few that you should be aware of.

1. No Backup Plan
By failing to backup your databases fairly often you are opening yourself up for big problems. Proper backup procedures include a backup plan that 1) makes regular backups, 2) tests your ability to retrieve and restore data from backup systems, and 3) uses alternative locations other than the database server for data storage. Backup early and backup often. You will never want to come across a scenario where you don't have the backed up data.

2. Using an Ad Hoc Query
Stored procedures on the application level should be the only way a user can access the database. Permissions like INSERT, UPDATE, SELECT, and DELETE are usable when users are writing their on code with an Ad Hoc query. Stored procedures enable only EXECUTE permissions preserving data integrity and providing improved performance through compiling and caching. Ideal SQL optimization starts with getting rid of all or most of these ad hoc queries.

3. Improper Testing
Similar to having an inferior backup plan, putting untested code into production can open you up to some big problems. It is certainly a mistake not to provide for beta and sustained testing. Optimum pre-production testing must mimic production environments as closely as possible. A small database meant for testing purposes probably won't scale well to a fully functional production environment. Doing the correct testing now will help prevent fixes needed in the future.

Discover more advantages of SQL optimization.

4. Insufficient Monitoring
You should not assume that your database is already optimized and has no issues with performance. Continuing SQL optimization will require you to constantly perform performance monitoring to be sure that all users are getting a seamless experience. Not performing the proper monitoring opens you up to slowed performance due to applications and queries using up system resources. SQL server hardware environments and queries need to have constant monitoring and optimization to make certain that performance is as good as it can get. SQL monitors will gather trends in performance over a period of time that will enable you to establish plans to tune the database.

5. Insufficient Change Management Processes
Changing a stable production environment should not be done light-heartedly. It requires the appropriate testing, planning, and implementation processes. Having a change management process provides some structure for how changes are made. If database changes don't go according to plan, having the right documentation of how, why and when changes should be made will provide for quick reversions. Thorough pre-production tests must also be a piece in the change management puzzle. One simple hint: document everything.

ASP. Net 2.0 Demystified $19.95 The fast and easy way to learn ASP.NET 2.0Get up to speed on ASP.NET 2.0 in no time using this easy-to-follow guide. ASP.NET 2.0 Demystified shows you how to write server-side components for dynamic, interactive web pages and powerful web-based applications. Step-by-step instructions with lots of examples help you learn quickly.First, you’ll find out how web applications and programming languages work, then you’ll learn the fundamentals of ASP.NET 2.0, including forms, objects, and variables. Next, it’s on to generating dynamic web pages, using databases, managing sessions, handling errors, and debugging programs. Featuring end-of-chapter quizzes and a final exam, this book will have you programming in ASP.NET 2.0 right away.Simple enough for a beginner, but challenging enough for an advanced student, ASP.NET 2.0 Demystified is your shortcut to mastering this powerful web development tool.This one of a kind self-teaching text offers: An easy way to understand ASP.NET 2.0 A quiz at the end of each chapter A final exam at the end of the book No unnecessary technical jargon A time-saving approachJim Keogh (Ridgefield Park, NJ) is a Columbia University Faculty member and teaches Java programming along with other computer science courses. Keogh has spent decades developing applications for major corporations and is the author of over 55 books, including Java, OOP & Data Structures Demystified.

Sams Teach Yourself E-Commerce Programming with ASP in 21 Days $35.99 The Barnes & Noble Review Active Server Pages technology has been used to build many of the world's leading e-commerce sites, including (dare we say it?) this one. It's a remarkably flexible solution for e-commerce development. If you're already comfortable with VBScript (or even VB), and maybe a little SQL, SAMS Teach Yourself E-Commerce Programming With ASP In 21 Days will have you performing e-commerce magic almost as quickly as your boss wants it. In this project-based course, you'll walk through building many of the meat-and-potatoes features of a typical e-commerce site, and several advanced features as well. In Week I, you'll write ASP scripts that retrieve customer information, track it with cookies and session variables; manage a catalog; create product pages; and implement product search. In Week II, you'll create a subscription-based, database-integrated site with a user registration system that restricts some pages to paying customers. Finally, in Week III, you'll learn techniques for administering your store remotely with ASP scripts; debugging your ASP-based e-commerce applications; sending email from ASP pages; generating store reports; managing banner advertising; and more. You'll find all the projects on the accompanying CD-ROM — a great starting point for the real-world stuff your boss is banging on you for!—bncom editor