В книге содержится информация, предназначенная для практического применения скрытых возможностей операционной системы и разнообразных COM-объектов при разработке собственных информационных систем на платформе 1С: Предприятие версий 7.7 и 8.0. Рассмотрены особенности использования объектов ActiveX, администрирования Windows средствами WMI и WSH, взаимодействия с базами данных посредством интерфейсов ADO и SQL-DMO, применения технологии OLE Automation и многое другое при работе в среде 1С: Предприятие. Во втором издании книги добавлены новые описания возможностей использования технологии ADO и интеграции с офисными приложениями Microsoft Word, Excel, Visio и Project. Материал сопровождается большим количеством наглядных и подробно прокомментированных примеров.

"I come from a T-SQL background, so when I first laid my eyes on SQL Server 2005, I was shocked--and then, I was scared! I didn't have a CLR or XML background and suddenly had an urgent need to learn it. SQL Server 2005 is too big of a release to learn from the books online. Fortunately, now there is a book for developers who need to go from SQL Server 2000 to SQL Server 2005 and to do it as painlessly as possible. Basically, it's one-stop shopping for serious developers who have to get up to speed quickly. I'll keep this one on my desk--not on my bookshelf. Well done, Bob and Dan!"

Version 2.0 of the .NET Framework will offer powerful enhancements to ADO.NET that will give application and service developers unprecedented control over their data. In A First Look at ADO.NET and System.Xml v. 2.0, Microsoft's lead program manager on XML technologies joins with two leading .NET and XML experts to present a comprehensive preview of tomorrow's ADO.NET and System.Xml classes. Drawing on the first .NET Framework 2.0 Technology Preview Release, the authors introduce powerful new techniques for simplifying development, enhancing flexibility, and leveraging .NET's new support for emerging XML standards. They also preview important new synergies between .NET Framework 2.0, XML, and the next version of SQL Server (code-named "Yukon").

From the basics to advanced techniques, this comprehensive reference demonstrates how to connect Access and VBA through ADO, how to extract, manipulate, and retrieve data using SQL queries, benefit from expert advice on error handling, and much more.

The Complete, Practical, 100% Useful Guide for Every SQL Server 2005 DBA! This book has one goal: to help database administrators and their managers run SQL Server 2005 with maximum efficiency, reliability, and performance. Renowned SQL Server expert Buck Woody covers every facet of database administration, from installation and configuration through maintaining enterprise-class business intelligence environments. If you're a new SQL Server administrator, Buck will help you master core tasks rapidlyand avoid costly mistakes that only show up when it's too late. If you're familiar with previous versions of SQL Server, he'll get you up-to-speed fast on everything new that matters, from high availability improvements and Integration Services to the SQL Server Management Studio. Whatever your background, you'll find best practices, real-world scenarios, and easy-to-use automation scriptsall grounded in Buck's unsurpassed SQL Server knowledge.

This is the definitive resource for every network administrator, consultant, and architect who needs to maximize availability, scalability, and performance in Windows server environments. Drawing on two decades of Windows server experience, Jeffrey Shapiro and Marcin Policht have written the most realistic, comprehensive, and independent Windows high availability guide ever published. One step at, a time, they help you plan, implement, and manage clustering, load balancing, fault tolerance, SQL Server, Exchange Server, and much more. Along the way, they address crucial high availability topics that are virtually ignored by most books, such as disaster recovery, performance monitoring, and operations management. Shapiro and Policht offer a clear, concise roadmap for keeping Windows servers running 24x7 and delivering on even the most challenging service-level agreements. They provide real-world case studies and easy-to-use instructions designed to help readers make better decisions more rapidly.

"If you've been looking for one book on the .NET Compact Framework that will teach you everything you need to know, look no further--this is it!" -Derek Ferguson, Chief Technology Evangelist, Expand Beyond Corporation Whether you are an architect, developer, or manager, Building Solutions with the Microsoft .NET Compact Framework is your guide to creating effective solutions for mobile devices with .NET. Authors Dan Fox and Jon Box walk you through four essential architectural concepts and programming techniques, using extensive examples and code listings to show you how to develop more robust mobile development projects. The book briefly describes the context, architecture, and features of both the Framework and Smart Device Programmability (SDP). The heart of the book is its in-depth coverage of key architectural concepts, including local data handling, remote data access (RDA) architectures, robust data caching with SQL Server 2000 Windows CE Edition 2.0 (SQL CE 2.0), and synchronization options. The focus then shifts to localization, security, and deployment, and the final chapter steers you away from potential pitfalls. You will find helpful pointers to further resources throughout, and a companion Web site includes the source code and links to more information. This book can be read cover to cover or the focus can be narrowed to key points of interest.

Рассматриваются архитектура .NET, интегрированная среда разработки Visual Studio .NET и программирование на С#, а также объектно-ориентированное программирование, концепции графического пользовательского интерфейса, язык XML, базы данных, SQL, ADO.NET, ASP.NET, Web-формы, Web-службы и элементы управления Web, организация сетей, структуры данных, обеспечение доступности программных приложений и пакет программ Mobile Internet Toolkit Представлены действующие программы и примеры, протестированные в системах Windows 2000 и Windows ХР. Особое внимание уделено принципам корректного проектирования программных продуктов и их удобочитаемости.

This text explores connectivity options, then delves into optimization methods that can be implemented in the Crystal environment, including the use of SQL Expressions and SQL Commands, and much more.

The amount of information stored in corporate databases is exploding exponentially. Data mining—finding meaningful patterns in all that data—can give any organization a competitive advantage. This book is the in-depth reference from Microsoft® for anyone who wants to take full advantage of the powerful data-mining features in SQL Server™ 2000. It examines the SQL Server 2000 Analysis Services architecture and shows how data mining fits into its complete suite of information-extraction technologies. Then it demonstrates how to structure and mine large databases with the algorithms included with SQL Server 2000 to find nuggets of useful information. It even shows how to create a practice data-mining model using data downloaded from a database.

Part 1 : SQL/Framework. - 67 p.

IBM DB2 Universal Database Certification gives you a powerful advantage in the marketplace for expertise on the world's #1 enterprise database platform. Passing IBM DB2 Universal Database V8.1 Family Fundamentals Exam 700 earn you the IBM Certified Database Associate certification and is the prerequisite for all intermediate and follow-on certifications. In this book, Roger E. Sanders-one of the world's leading DB2 Universal Database experts and an active participant in IBM's DB2 Universal Database exam development process-covers everything you need to know to pass DB2 Universal Database V8.1 Exam 700. Sanders covers every exam objective, beginning with a review of the DB2 family of tools and products, as well as fundamental database concepts such as SQL and data consistency.

Illustrating all of the integration, analysis, and reporting capabilities of SQL Server 2005, this unique resource shows you, step-by-step, how to author, customize, and distribute information that will give your company the competitive edge.

"Delphi 6/7. Базы данных и приложения. Лекции и упражнения" предлагает читателю ознакомиться с процессом разработки программного обеспечения для реляционных баз данных. В данном издании рассматриваются основы языка Object Pascal на примере создания консольных приложений; объектно-ориентированные возможности языка Object Pascal и технология визуального программирования; основные принципы работы с SQL-сервером InterBase. Также здесь описываются: методика взаимодействия программ, созданных в среде Delphi, с базами данных различного типа, в частности, SQL-сервером InterBase; основы проектирования баз данных с использованием программы ERwin; методика разработки клиентского приложения для доступа к базам данных с использованием библиотек динамической загрузки, а также популярных программ World и Excel для создания отчетов. Способом БД "Учебные компьютерные курсы" рассматривается процесс разработки программного обеспечения: от вопросов проектирования до подготовки отчетов. Авторами рассмотрены примеры, которые тестировались в шестой и седьмой версиях Delphi. Книга может найти применение на лекционных курсах, где проходят приведенные программные продукты. Это издание пригодится старшеклассникам, студентам, аспирантам, преподавателям и пользователям ПК, которые хотят заняться программированием.

Рассмотрены вопросы, связанные с программированием информационного обмена между системой 1С:Предприятие и внешними приложениями, разработанными в Delphi. Приведены общие сведения о конфигурации системы 1С:Предприятие. На конкретных примерах показаны приемы программирования и доступ к информационной структуре системы 1С:Прсдприятие с использованием механизма OLE Automation, а также прямой доступ к данным с помощью SQL-запросов. Уделено внимание вопросам внешнего администрирования системы 1С:Прсдприятие. Материал сопровождается большим количеством практических примеров, размещенных на прилагаемом компакт-диске.

В книге Сергея Попова "Delphi и 1С:Предприятие. Программирование информационного обмена" рассматриваются задачи, связанные с программированием информационного обмена между системой 1С:Предприятие и внешними приложениями, разработанными в Delphi. Приводятся общие сведения о конфигурации системы 1С:Предприятие. Приемы программирования и доступ к информационной структуре системы 1С:Предприятие с использованием механизма OLE Automation показаны на конкретных образцах, и прямой доступ к данным с помощью SQL-запросов. Отдельно рассмотрены вопросы внешнего администрирования системы 1С:Предприятие.

Meeting the demand for a definitive, design-focused guidebook to Microsoft's database technologies, Riordan offers practical discussion and instructive examples. She clarifies the rich but vast set of Microsoft tools for database development--from Access 20000 and SQL Server 7.0 to the various data access technologies within Visual Basic. Source code is featured on the CD-ROM.

SQL Server 2000 Reporting Services streamlines the process of extricating meaningful reports from your data sources. Hitchhiker's Guide to SQL Server 2000 Reporting Services picks up where the Microsoft documentation leaves off, providing report developers, database administrators, application developers, their managers, and report users with invaluable inside information on the workings of Reporting Services.

This is the definitive companion to Microsoft SQL Server 2000. The authors have combined the perspectives of the developer and the user into a readable and comprehensive guide. Ron Soukup led the SQL Server development team for a decade, and he continues to be one of its key architects. Kalen Delaney has been working with the application designers and developers for almost that long. This is their guide to why SQL Server is the way it is, and how it should be used. The guide complements the reference material in SQL Server Books Online.