Enter a New World of Database Programming C# and ADO.NET facilitate the development of a new generation of database applications, including remote applications that run on the Web. Mastering C# Database Programming is the resource you need to thrive in this new world. Assuming no prior experience with database programming, this book teaches you every aspect of the craft, from GUI design to server development to middle-tier implementation. If you’re familiar with earlier versions of ADO, you’ll master the many new features of ADO.NET all the more quickly. You’ll also learn the importance of XML within the new .NET paradigm.

ADO.NET is Microsoft’s latest data access technology and, as an integral part of the .NET Framework, is far more than simply an upgrade of previous incarnations of ADO. ADO.NET provides an extensive set of .NET classes that facilitate efficient access to data from a large variety of sources, enable sophisticated manipulation and sorting of data, and forms an important framework within which to implement inter-application communication and XML Web Services.

Get hands-on, practical guidance for using Microsoft SQL Server Integration Services, the next generation data integration platform from Microsoft. Integration Services is a powerful tool for business intelligence, so understanding the essentials--how to develop and deploy SSIS packages, as well as how to apply these skills to data warehousing solutions--is critical to harnessing the full benefits of SQL Server. This step-by-step tutorial teaches you all the essentials for getting started, including data transformation, scripting, security, and best practices for developing enterprise-class data integration applications. With STEP BY STEP, you work at your own pace through hands-on, learn-by-doing exercises. Whether you're a beginning programmer or new to this version of the technology, you'll understand the fundamental techniques for using SQL Server 2005 Integration Services. A companion CD includes data sets and sample code.

Pro T-SQL 2005 Programmer's Guide provides comprehensive and detailed coverage of all the major features and facilities of T-SQL for SQL Server 2005. It is designed for all users of T-SQL, database administrators, systems administrators, application developers, and end-users, who want to learn how to exploit the power of T-SQL. Whatever you need to do with T-SQL, you'll find it described clearly here.
Stored procedures, triggers, and user-defined functions are only part of the story. Dynamic SQL, the new XML data type, and SQLCLR programming are also covered, as well as accessing SQL Server with ADO.NET. Exception handling and performance are fully covered, too. This book is truly a complete programmer's guide to T-SQL and SQL Server 2005.

The MCSE SQL 2000 Database Design Exam Cram is the ideal study aid for IT professionals aiming at the "Designing and Implementing Databases with Microsoft SQL Server 2000 Enterprise Edition" exam (70-229). Essential exam objectives like Logical Data Modeling, Database Objects, Data Integrity, XML, and Tuning and Optimizing Data Access are thoroughly covered. Readers can also complete their total exam preparation with insightful test taking strategies, helpful hints and tips, and realistic case studies and practice questions.

Learn how to design and implement database solutions using SQL Server 2000 Enterprise Edition--as you prepare for MCP Exam 70-229, a core requirement for MCDBA certification and an elective for the MCAD, MCSE, and MCSA tracks.

This official MCSE TRAINING KIT teaches how to design and implement database solutions using Microsoft SQL Server 2000 Enterprise Edition, as well as providing in-depth preparation for MCP Exam 70-229-a core exam for MCDBA certification and an elective on the Microsoft Windows 2000 MCSE track. Topics map directly to the objectives measured by the MCP exam, including developing a logical data model, implementing the physical database, retrieving and modifying data, programming business logic, tuning and optimizing data access, and designing a database security plan. Students learn through an integrated system of skill-building tutorials, case study examples, and self-assessment exercises. An economical alternative to classroom instruction, this kit enables students to set their own pace and learn by doing!

This book is about database security and auditing. You will learn many methods and techniques that will be helpful in securing, monitoring and auditing database environments. It covers diverse topics that include all aspects of database security and auditing - including network security for databases, authentication and authorization issues, links and replication, database Trojans, etc. You will also learn of vulnerabilities and attacks that exist within various database environments or that have been used to attack databases (and that have since been fixed). These will often be explained to an internals level. There are many sections which outline the anatomy of an attack before delving into the details of how to combat such an attack. Equally important, you will learn about the database auditing landscape both from a business and regulatory requirements perspective as well as from a technical implementation perspective.

AJAX (Asynchronous JavaScript and XML) is a new approach for developing web applications. It essentially permits users to interact with a Webpage without forcing a slow & tedious reload of the entire page after every action. This means web applications become more responsive, easier to use, and more intuitive. Build Your Own Ajax Web Applications uses a step-by-step tutorial format that's so easy to follow, you'll be able to build sophisticated and intuitive Ajax web interfaces in no time!

Learn how you can save countless hours of research and development time building your Web applications with the SAS/IntrNet Application Dispatcher. Author Don Henderson illustrates the multitude of features and capabilities available in the SAS/IntrNet Application Dispatcher and shows you how to take better advantage of these tools to make your tasks easier. This dynamic book features significant tips, techniques, and well-explained examples that you can immediately incorporate into your SAS/IntrNet Application Dispatcher Web applications.