About The Author – Atul Kahate has over 13 years of experience in Information Technology in India and abroad in various capacities. He has done his Bachelor of Science degree in Statistics and his Master of Business Administration in Computer Systems. He has authored 17 highly acclaimed books on various areas of Information Technology. Several of his books are being used as course textbooks or sources of reference in a number of universities/colleges/IT companies all over the world. Atul has been writing articles in newspapers about cricket, since the age of 12. He has also authored two books on cricket and has written over 2000 articles on IT and cricket. He has a deep interest in teaching, music, and cricket besides technology. He has conducted several training programs, in a number of educational institutions and IT organisations, on a wide range of technologies. Some of the prestigious institutions where he has conducted training programs, include IIT, Symbiosis, I2IT, MET, Indira Institute of Management, Fergusson College, MIT, VIIT, MIT, Walchand Government Engineering College besides numerous other colleges in India.

Book Content – 1. Introduction to XML, 2. XML Syntaxes, 3. Document Type Definitions, 4. XML Schemas 5. Cascading Style Sheets, 6. Extensible Stylesheet Language, 7. XML and Java, 8. XML and ASP.NET, 9. Web Services and AJAX, 10. XML Security, Appendix – Miscellaneous Topics

Master the basics of XML as well as the namespaces and objects you need to know in order to work efficiently with XML. You’ll learn extensive support for XML in everything from data access to configuration, from raw parsing to code documentation. You will see clear, practical examples that illustrate best practices in implementing XML APIs and services as part of your C#-based Windows 10 applications. Beginning XML with C# 7 is completely revised to cover the XML features of .NET Framework 4.7 using C# 7 programming language. In this update, you’ll discover the tight integration of XML with ADO.NET and LINQ as well as additional .NET support for today’s RESTful web services and Web API. Written by a Microsoft Most Valuable Professional and developer, this book demystifies everything to do with XML and C# 7. What You Will Learn: Discover how XML works with the .NET Framework Read, write, access, validate, and manipulate XML documents Transform XML with XSLT Use XML serialization and web services Combine XML in ADO.NET and SQL Server Create services using Windows Communication Foundation Work with LINQ Use XML with Web API and more Who This Book Is For : Those with experience in C# and .NET new to the nuances of using XML. Some XML experience is helpful.

Learn how to build an interactive source code analytics system using Roslyn and JavaScript. This concise 150 page book will help you create and use practical code analysis tools utilizing the new features of Microsoft's Roslyn compiler to understand the health of your code and identify parts of the code for refactoring. Source code is one of the biggest assets of a software company. However if not maintained well, it can become a big liability. As source code becomes larger. more complex and accessed via the cloud, maintaining code quality becomes even more challenging. The author provides straightforward tools and advice on how to manage code quality in this new environment. Roslyn exposes a set of APIs which allow developers to parse their C# and VB.NET code and drastically lower the barrier to entry for Meta programming in .NET. Roslyn has a dedicated set of APIs for creating custom refactoring for integrating with Visual Studio. This title will show readers how to use Roslyn along with industry standard JavaScript visualization APIs like HighCharts, D3.js etc to create a scalable and highly responsive source code analytics system. What You Will Learn Understand the Roslyn Syntax API Use Data Visualization techniques to assist code analysis process visually Code health monitoring matrices (from the standard of Code Query Language) Code mining techniques to identify design patterns used in source code Code forensics techniques to identify probable author of a given source code Techniques to identify duplicate/near duplicate code Who This Book is For .NET Software Developers and Architects

Distribute Actionable, Timely BI with Microsoft® SQL Server® 2016 and Power BI Drive better, faster, more informed decision making across your organization using the expert tips and best practices featured in this hands-on guide. Delivering Business Intelligence with Microsoft SQL Server 2016, Fourth Edition, shows, step-by-step, how to distribute high-performance, custom analytics to users enterprise-wide. Discover how to build BI Semantic Models, create data marts and OLAP cubes, write MDX and DAX scripts, and share insights using Microsoft client tools. The book includes coverage of self-service business intelligence with Power BI. • Understand the goals and components of successful BI • Build data marts, OLAP cubes, and Tabular models • Load and cleanse data with SQL Server Integration Services • Manipulate and analyze data using MDX and DAX scripts and queries • Work with SQL Server Analysis Services and the BI Semantic Model • Author interactive reports using SQL Server Data Tools • Create KPIs and digital dashboards • Implement time-based analytics • Embed data model content in custom applications using ADOMD.NET • Use Power BI to gather, model, and visualize data in a self-service environment

R in Action, Second Edition presents both the R language and the examples that make it so useful for business developers. Focusing on practical solutions, the book offers a crash course in statistics and covers elegant methods for dealing with messy and incomplete data that are difficult to analyze using traditional methods. You'll also master R's extensive graphical capabilities for exploring and presenting data visually. And this expanded second edition includes new chapters on time series analysis, cluster analysis, and classification methodologies, including decision trees, random forests, and support vector machines. About the Technology Business pros and researchers thrive on data, and R speaks the language of data analysis. R is a powerful programming language for statistical computing. Unlike general-purpose tools, R provides thousands of modules for solving just about any data-crunching or presentation challenge you're likely to face. R runs on all important platforms and is used by thousands of major corporations and institutions worldwide. About the Book R in Action, Second Edition teaches you how to use the R language by presenting examples relevant to scientific, technical, and business developers. Focusing on practical solutions, the book offers a crash course in statistics, including elegant methods for dealing with messy and incomplete data. You'll also master R's extensive graphical capabilities for exploring and presenting data visually. And this expanded second edition includes new chapters on forecasting, data mining, and dynamic report writing. What's Inside Complete R language tutorial Using R to manage, analyze, and visualize data Techniques for debugging programs and creating packages OOP in R Over 160 graphs About the Reader This book is designed for readers who need to solve practical data analysis problems using the R language and tools. Some background in mathematics and statistics is helpful, but no prior experience with R or computer programming is required. About the Author Dr. Rob Kabacoff is a seasoned researcher who specializes in data analysis. He has taught graduate courses in statistical programming and manages the Quick-R website at statmethods.net. Quotes Essential to anyone doing data analysis with R, whether in industry or academia. - Cristofer Weber, NeoGrid A go-to reference for general R and many statistics questions. - George Gaines, KYOS Systems Inc. Accessible language, realistic examples, and clear code. - Samuel D. McQuillin, University of Houston Offers a gentle learning curve to those starting out with R for the first time. - Indrajit Sen Gupta, Mu Sigma Business Solutions

Each new print copy includes Navigate 2 Advantage Access that unlocks a comprehensive and interactive eBook, student practice activities and assessments, a full suite of instructor resources, and learning analytics reporting tools.

Fully revised and updated, the Sixth Edition of the best-selling text Computer Science Illuminated retains the accessibility and in-depth coverage of previous editions, while incorporating all-new material on cutting-edge issues in computer science. Authored by the award-winning Nell Dale and John Lewis, Computer Science Illuminated’s unique and innovative layered approach moves through the levels of computing from an organized, language-neutral perspective.

Designed for the introductory computing and computer science course, this student-friendly Sixth Edition provides students with a solid foundation for further study, and offers non-majors a complete introduction to computing.

Key Features of the Sixth Edition include:

Access to Navigate 2 online learning materials including a comprehensive and interactive eBook, student practice activities and assessments, learning analytics reporting tools, and more
Completely revised sections on HTML and CSS
Updates regarding Top Level Domains, Social Networks, and Google Analytics
All-new section on Internet management, including ICANN control and net neutrality 
New design, including fully revised figures and tables
New and updated Did You Know callouts are included in the chapter margins
New and revised Ethical Issues and Biographies throughout emphasize the history and breadth of computing
Available in our customizable PUBLISH platform

A collection of programming language chapters are available as low-cost bundling options. Available chapters include: Java, C++, Python, Alice, SQL, VB.NET, RUBY, Perl, Pascal, and JavaScript.

With Navigate 2, technology and content combine to expand the reach of your classroom. Whether you teach an online, hybrid, or traditional classroom-based course, Navigate 2 delivers unbeatable value. Experience Navigate 2 today at www.jblnavigate.com/2

Vikas Bhardwaj is a Technical Architect at Syntel Inc. Vikas has 14 years of IT experience with Microsoft Technologies like BizTalk Server, .NET, C#, SQL Server. Vikas has implemented various integration solution using BizTalk Server including one of the largest implementation of BizTalk and HL7. Vikas presently lives in Nashville, Tennessee with his wife Poonam and two kids Shivam & Ayaan. You can check out Vikas' blog at http://vikasbhardwaj15.blogspot.com/ and Vikas can be contacted directly at [email protected]. HL7 for BizTalk provides a detailed guide to the planning and delivery of a HL7-compliant system using the dedicated Microsoft BizTalk for HL7 Accelerator. The HL7 Primary Standard, its various versions, and the use of the HL7 Accelerator for BizTalk are broken out and fully explained. HL7 for BizTalk provides clear guidance on the specific healthcare scenarios that HL7 is designed to overcome and provides working case study models of how HL7 solutions can be implemented in BizTalk, deployed in practice and monitored during operation. Special emphasis is given in this book to the BizTalk reporting functionality and its use to provide HL7 oversight within organizations. HL7 for BizTalk is suitable for use with BizTalk versions from 2006 R2 to 2013 R2 to suit the reader organization. All three versions of the HL7 standard and their differences, are explained. Howard S. Edidin is an integrations architect specializing in enterprise application integration. Howard runs his own consulting firm, Edidin Group, Inc, which is a Gold Member of the HL7 International Organization. Howard's firm specializes in delivering HL7 and HIPAA Healthcare solutions and providing guidance in the use of HL7 with BizTalk. Howard is active in several HL7 Working Groups and is involved with the development of a new HL7 Standard. In addition to BizTalk, Howard works with Azure, SQL Server, and SharePoint. Howard and his wife Sharon, live in a northern suburb of Chicago. Howard maintains several blogs, biztalkin-howard.blogspot.com and fhir-biztalk.com. Howard can be contacted directly at [email protected].

Geospatial mapping applications have become hugely popular in recent years. With smart-phone and tablet numbers snow-balling this trend looks set to continue well into the future. Indeed, it is true to say that in today's mobile world location-aware apps are becoming the norm rather than the exception. In Microsoft Mapping author Ray Rischpater showcases Microsoft's Bing Maps API and demonstrates how its integration features make it by far the strongest mapping candidate for business that are already using Windows 8 or the .NET Framework. Whether you want to build a new app from scratch of add a few modest geospatial features to your existing website Ray's carefully chosen examples will provide you with both the inspiration and the code you need to achieve your goals. What you'll learn Fully working code samples that show the concepts in use with ASP.NET 4.5, Windows 8 and Windows Phone. Complete solutions to the common problems of geospatial development: visualisation, hosting and localization of services are all explained. Demonstrates how the Bing Maps API can be connected to the Azure Cloud in order to provide a stand-alone mapping bolt-on with little additional up-front cost and great reliability. Unique coverage of how the Bing Maps API can be implanted within Windows Phone and iOS apps to provide a robust service tailored to the capabilities of each device. Who this book is for This book is for experienced Microsoft developers with a grounding in C# and .NET together with a basic understanding of WCF.

Pro SQL Database for Windows Azure, 2nd Edition shows how to create enterprise-level database deployments without the usual investment in datacenter and other infrastructure. Take advantage instead of Microsoft's worldwide backbone for cloud computing that delivers all the power of SQL Server in the form of the cloud-based SQL Database for Windows Azure. You can create and deploy a database in mere minutes that is accessible worldwide and takes advantage of SQL Database's high-availability features to protect your data while ensuring 99.9% uptime. SQL Azure is ideally suited for startups, who can benefit from instant access to a robust and secure web-accessible database platform for use in rapidly deploying new products to market. SQL Azure is also ideal for small and mid-sized businesses, giving them the same ability to deploy SQL Server as any large enterprise, but without the management overhead. Even large enterprises find SQL Azure useful in creating failover environments, development environments, extra capacity to handle surges in demand, and more. Pro SQL Database for Windows Azure covers the very latest in Microsoft's fast-moving, cloud platform, showing how to program and administer it in a variety of cloud computing scenarios. You'll learn to program SQL Azure from ASP.NET, from WinForms, and from SQL Reporting Services. You'll learn to manage the platform by planning for scalability, troubleshooting performance issues, and implementing strong security. You'll learn the unique aspects of SQL Azure such as sharding and federation support that combine to place SQL Azure a step above and ahead of the competiton. Shows how to use SQL Azure from classic Windows applications, ASP.NET and Windows Communication Foundation Covers management, performance, scalability, and troubleshooting Addresses the all-important issue of securing your data Helps you properly design for high-performance in a cloud environment Helps you adopt the new Federations feature in SQL Azure What you'll learn Create and manage SQL Database for Windows Azure databases Access SQL Azure from WinForms, ASP.NET, Reporting Services, and more Optimize database design for Azure's distributed cloud platform Share data between databases using SQL Database's Data Synch Service Secure data from intrusion and unauthorized access Learn strategies for data migration and backup Who this book is for Pro SQL Database for Windows Azure, 2nd Edition is aimed at developers and database administrators desiring instant access to a fully-capable SQL Server database environment without the pain of sorting out and managing the physical infrastructure.

Pro T-SQL 2012 Programmer's Guide is every developer's key to making full use of SQL Server 2012's powerful, built-in Transact-SQL language. Discussing new and existing features, the book takes you on an expert guided tour of Transact-SQL functionality. Fully functioning examples and downloadable source code bring technically accurate and engaging treatment of Transact-SQL into your own hands. Step-by-step explanations ensure clarity, and an advocacy of best-practices will steer you down the road to success. Transact-SQL is the language developers and DBAs use to interact with SQL Server. It's used for everything from querying data, to writing stored procedures, to managing the database. New features in T-SQL 2012 include full support for window functions, stored sequences, the ability to throw errors, data paging, and more. All these important new features are covered in this book. Developers and DBAs alike can benefit from the expressive power of Transact-SQL, and Pro T-SQL 2012 Programmer's Guide provides the gateway to success in applying this increasingly important database language to everyday business and technical tasks. What you'll learn Take full advantage of window functions and other new features in T-SQL 2012 Move business logic into the database via procedures and functions Develop using advanced features such as encryption and full-text search Store and retrieve XML data using XQuery and XPath Debug and Optimize T-SQL Execution Build ADO.NET Client Applications Who this book is for Pro T-SQL 2012 Programmer's Guide is written for SQL Server and Transact-SQL developers who want to implement best-practices and take full advantage of all that SQL Server has to offer. NET programmers will find the book helpful in showing how to run .NET code within SQL Server. Database administrators who need to write triggers and the occasional stored procedure will also benefit from the book.

Your essential guide to key programming features in Microsoft SQL Server 2012 Take your database programming skills to a new level—and build customized applications using the developer tools introduced with SQL Server 2012. This hands-on reference shows you how to design, test, and deploy SQL Server databases through tutorials, practical examples, and code samples. If you’re an experienced SQL Server developer, this book is a must-read for learning how to design and build effective SQL Server 2012 applications. Discover how to: Build and deploy databases using the SQL Server Data Tools IDE Query and manipulate complex data with powerful Transact-SQL enhancements Integrate non-relational features, including native file streaming and geospatial data types Consume data with Microsoft ADO.NET, LINQ, and Entity Framework Deliver data using Windows Communication Foundation (WCF) Data Services and WCF RIA Services Move your database to the cloud with Windows Azure SQL Database Develop Windows Phone cloud applications using SQL Data Sync Use SQL Server BI components, including xVelocity in-memory technologies

Implement a Robust BI Solution with Microsoft SQL Server 2012 Equip your organization for informed, timely decision making using the expert tips and best practices in this practical guide. Delivering Business Intelligence with Microsoft SQL Server 2012, Third Edition explains how to effectively develop, customize, and distribute meaningful information to users enterprise-wide. Learn how to build data marts and create BI Semantic Models, work with the MDX and DAX languages, and share insights using Microsoft client tools. Data mining and forecasting are also covered in this comprehensive resource. Understand the goals and components of successful BI Design, deploy, and manage data marts and OLAP cubes Load and cleanse data with SQL Server Integration Services Manipulate and analyze data using MDX and DAX scripts and queries Work with SQL Server Analysis Services and the BI Semantic Model Author interactive reports using SQL Server Data Tools Create KPIs and digital dashboards Use data mining to identify patterns, correlations, and clusters Implement time-based analytics Embed BI reports in custom applications using ADOMD.NET

R in Action is the first book to present both the R system and the use cases that make it such a compelling package for business developers. The book begins by introducing the R language, including the development environment. Focusing on practical solutions, the book also offers a crash course in practical statistics and covers elegant methods for dealing with messy and incomplete data using features of R. About the Technology R is a powerful language for statistical computing and graphics that can handle virtually any data-crunching task. It runs on all important platforms and provides thousands of useful specialized modules and utilities. This makes R a great way to get meaningful information from mountains of raw data. About the Book R in Action is a language tutorial focused on practical problems. It presents useful statistics examples and includes elegant methods for handling messy, incomplete, and nonnormal data that are difficult to analyze using traditional methods. And statistical analysis is only part of the story. You'll also master R's extensive graphical capabilities for exploring and presenting data visually. What's Inside Practical data analysis, step by step Interfacing R with other software Using R to visualize data Over 130 graphs Eight reference appendixes About the Reader About the Author Dr. Rob Kabacoff is a seasoned researcher who specializes in data analysis. He has taught graduate courses in statistical programming and manages the Quick-R website at statmethods.net. Quotes Lucid and engaging...and fun way to learn R! - Amos A. Folarin, University College London Finally, a book that brings R to the real world. - Charles Malpas, University of Melbourne R from a programmer's point of view. - Philipp K. Janert, Principal Value, LLC A great balance of targeted tutorials and in-depth examples. - Landon Cox, 360VL, Inc. An excellent introduction and reference from the author of the best R website. - Christopher Williams, University of Idaho

SQL Azure represents Microsoft's cloud-based delivery of its enterprise-caliber, SQL Server database management system (formerly under the code name "Oslo"). Pro SQL Azure introduces you to this new platform, showing you how to program and administer it in a variety of cloud computing scenarios. You'll learn to program SQL Azure from Silverlight, ASP.NET, WinForms, and from SQL Reporting Services. You'll also understand how to manage the platform by planning for scalability, troubleshooting performance issues, and implementing strong security. Shows how to use SQL Azure from Silverlight, ASP.NET, and more Covers management, scalability, and troubleshooting Addresses the all-important issue of securing your data

Web Dragons offers a perspective on the world of Web search and the effects of search engines and information availability on the present and future world. In the blink of an eye since the turn of the millennium, the lives of people who work with information have been utterly transformed. Everything we need to know is on the web. It's where we learn and play, shop and do business, keep up with old friends and meet new ones. Search engines make it possible for us to find the stuff we need to know. Search engines — web dragons — are the portals through which we access society's treasure trove of information. How do they stack up against librarians, the gatekeepers over centuries past? What role will libraries play in a world whose information is ruled by the web? How is the web organized? Who controls its contents, and how do they do it? How do search engines work? How can web visibility be exploited by those who want to sell us their wares? What's coming tomorrow, and can we influence it? As we witness the dawn of a new era, this book shows readers what it will look like and how it will change their world. Whoever you are: if you care about information, this book will open your eyes and make you blink. Presents a critical view of the idea of funneling information access through a small handful of gateways and the notion of a centralized index--and the problems that may cause Provides promising approaches for addressing the problems, such as the personalization of web services Presented by authorities in the field of digital libraries, web history, machine learning, and web and data mining Find more information at the author's site: webdragons.net

Oracle Performance Survival Guide A Systematic Approach to Database Optimization The fast, complete, start-to-finish guide to optimizing Oracle performance Oracle Performance Survival Guide offers a structured, systematic, start-to-finish methodology for optimizing Oracle performance as efficiently as possible. Leading Oracle expert Guy Harrison shows how to maximize your tuning investment by focusing on causes rather than symptoms, and by quickly identifying the areas that deliver the greatest “bang for the buck.” Writing for DBAs and developers with all levels of experience, Harrison covers every area of Oracle performance management, from application design through SQL tuning, contention management through memory and physical IO management. He also presents up-to-the-minute guidance for optimizing the performance of the Oracle 11g Release 2. You’ll start by mastering Oracle structured performance tuning principles and tools, including techniques for tracing and monitoring Oracle execution. Harrison illuminates the interaction between applications and databases, guides you through choosing tuning tools, and introduces upfront design techniques that lead to higher-performance applications. He also presents a collection of downloadable scripts for reporting on all aspects of database performance. Coverage includes • “Tuning by layers,” the most effective, highest-value approach to Oracle performance optimization • Making the most of Oracle’s core tools for tracing, monitoring, and diagnosing performance • Highly efficient database logical and physical design, indexing, transaction design, and API use • SQL and PL/SQL tuning, including the use of parallel SQL techniques • Minimizing contention for locks, latches, shared memory, and other database resources • Optimizing memory and physical disk IO • Tuning Real Application Cluster (RAC) databases guyharrison.net informit.com/ph

SQL Server 2008 Administration in Action offers over 100 DBA-tested, high-value, best practices that will help you tame the beast and keep it under control. Unlike the many comprehensive SQL Server reference tomes out there that attempt to cover the whole SQL Server feature set, this book drills down on the techniques, procedures, and practices that help you keep your database running like clockwork. About the Technology The integrity and security of your database is crucial to your business. SQL Server 2008 is a massive and mature product with a very large feature set. As a SQL Server administrator, you must be equipped to handle myriad day-to-day tasks to keep your database healthy, and you must also be prepared to act quickly when something unexpected happens. About the Book SQL Server 2008 Administration in Action focuses the production DBA, digging deep into the various tasks specific to that role. Expert author Rod Colledge — check him out at sqlCrunch.com — teaches you best practices that cover the lifecycle of a SQL Server system, including infrastructure design, installation, and operational maintenance. And while many of these techniques will work in any recent version of SQL Server, you'll find full coverage of emerging SQL Server 2008 best practices. Each technique is presented in a task-driven style, and in the order of the typical life cycle of a SQL Server system. This allows you to easily open the book at the appropriate page and focus on what you need to know for each specific situation. What's Inside Selecting and configuring server components Distributing I/O load over multiple controllers Selecting the appropriate stripe size Configuring storage cache Preparing for SQL Server clustering Configure the private network for cluster use only Configure the cluster network priority Prepare resources for a clustered SQL Server installation Index selection and maintenance Identify and drop unused indexes Identify and create missing indexes Select the appropriate clustered index Database mirroring Prepare the mirror server for failover Select the appropriate failover mode Consider disabling log stream compression for CPU bottlenecked systems Upgrading SQL Server Reduce downtime with T-Log backup/restore and the side-by-side upgrade method Prior to an upgrade, run DBCC checks and take full backups with verification Ensure read only is not enabled prior to the upgrade About the Reader This book is a DBA's best friend. It covers the most important and often overlooked areas that you need to maintain to keep your databases secure, in-tune, and well-protected in the event of disaster. About the Author Rod Colledge is an independent SQL Server consultant based in Brisbane, Australia. Since 1996, Rod has specialized in the development and administration of SQL Server database systems. His recent work has included the design and implementation of custom transactional replication and log shipping solutions, performance tuning large, high-volume databases, and developing procedures for operational maintenance of large database systems. In September 2007, Rod founded sqlCrunch.com, a website specializing in summarizing and categorizing links to SQL Server white papers and best practices. Quotes Simply loaded with excellent and immediately useful information. - Kevin Kline, Quest Software I thought I knew SQL Server until I read this book. - Tariq Ahmed, Coauthor of Flex 4 in Action A refreshing database administration book. - Michael Redman, Microsoft Required for any MS DBA. - Andrew Siemer, OTX Research It delivered way beyond my expectations...Packed with useful enterprise-level knowledge. - Darren Neimke, Author of ASP.NET 2.0 Web Parts in Action

Microsoft SQL Server Integration Services is Microsoft’s powerful platform for building enterprise-level data integration and data transformation solutions. It’s a powerful product, but it’s also complex and can be confusing if you don’t have a clear map for the journey. Microsoft SQL Server 2008 Integration Services Unleashed will be the only book you’ll need to harness the power that Integration Services provides. Through clear, concise explanations and samples, you’ll grasp a clear understanding of working in the Integration Services environment, including how to set up stock components, how to use the various designer features, and how to gain practical knowledge on configuring, deploying, securing, and managing packages. Sample packages are provided to reinforce the discussion and quickly help you gain hands-on experience, and more complex topics such as Data Flow Task internals and tuning, advanced transformations, and writing custom components are all illustrated in easy-to-understand graphics. In addition, there are several custom tasks and transformations and two useful utilities with full source code available for you to use and study, including an ADO.NET destination, a text file encryption task, and a data profiling transform. Detailed information on: Using the powerful Integration Services tools to create solutions without the need to write lines of code Creating packages programmatically or developing custom tasks via the Integration Services object Building robust packages to solve common requirements Securing packages for different environments Using often overlooked or unknown platform features Setting up all the stock components, including data flow components, tasks, Foreach enumerators, connection managers, and log providers Writing robust and useful custom tasks Building packages that seamlessly deploy to other environments Writing custom data flow adapters and transforms Using script tasks and components Easily modifying configurations for multiple packages simultaneously Writing a Task UI that looks just like the stock tasks Tapping into the power of Integration Services for accessing heterogeneous data sources Using expressions to make packages more responsive to the environment Migrating your DTS packages with no stress Kirk Haselden is the Group Program Manager for the Microsoft Master Data Management product forthcoming in the next wave of Office SharePoint Services and owns the long term strategy, vision, planning, and development of that product. Kirk has been with Microsoft for 12 years in various groups including Hardware, eHome, Connected Home, SQL Server, and Office Business Platform. He was the development manager for Integration Services and the primary designer for the runtime, as well as many of the tasks. He has written a number of articles for SQL Server Magazine, speaks regularly at industry events, writes profusely on his personal and MSDN blog, and holds 35 patents or patents pending. Category: Microsoft SQL Server Covers: Microsoft SQL Server 2008 Integration Services User Level: Intermediate—Advanced $59.99 US / $71.99 CAN / £38.99 Net UK

SQL Server Compact Edition is a slimmed down version of SQL Server that you can use on Pocket PCs, Smart phones, Tablet PCs, and Desktops. With this book, you will learn how to build applications for resource constrained devices. You’ll discover how the SQL Server Compact Edition database can also be used as an embedded in-proc database for desktop-based applications. You’ll learn how to manage the SQL Server Compact Edition database using SQL Server Management Studio, Visual Studio, and Query Analyzer. Laptops, Tablet PCs, and mobile devices enable information workers to access enterprise data from remote locations. With the step-by-step exercises provided in this book, you’ll learn how to synchronize data between SQL Server and SQL Server Compact Edition. You’ll also learn Remote Data Access–a lightweight method to exchange data between SQL Server and SQL Server Compact Edition. Also in this book are code samples to help you write database applications for mobile devices and for desktop PCs. Throughout the book you’ll find expert tips for building and deploying enterprise applications. Understand how to… Build mobile and desktop applications using SQL Server Compact Edition Set up the development and production environment with Visual Studio, SQL Server, and SQL Server Compact Edition Optimize performance and plan for security Manage databases using SQL Server Management Studio, Visual Studio, and Query Analyzer Develop applications using ADO.NET and OLEDB provider for SQL Server Compact Edition Upgrade from earlier versions of SQL CE, .NET Compact Framework, and Visual Studio Use Merge Replication to synchronize data between SQL Server and SQL Server Compact Edition Exchange data between SQL Server and SQL Server Compact Edition using Remote Data Access Introduction 1 1 Getting Started with SQL Server 2005 Compact Edition 7 2 Platform Support and Installation35 3 Getting to Know the Tools 63 4 Managing the SQL Server 2005 Compact Edition Database 109 5 Defining Database Structure 131 6 Manipulating the Database 175 7 Programming SQL Server 2005 Compact Edition with ADO.NET 205 8 Introducing Native Access 247 9 Using Operators in SQL Server 2005 Compact Edition 279 10 Using the Built-In Functions 295 11 Upgrading from a Previous Version 327 12 Synchronizing Data with Merge Replication 345 13 Synchronizing Data with Remote Data Access 411 14 Securing the SQL Server 2005 Compact Edition Database 459 15 SQL Server 2005 Compact Edition Performance Tuning 505 Index 551

"Microsoft Office InfoPath represents a revolutionary leap in XML technologies and a new paradigm for gathering business-critical information. I am delighted that Scott Roberts and Hagen Green, two distinguished members of the InfoPath product team, decided to share their experience in this book." --From the Foreword by Jean Paoli, cocreator of XML 1.0 and Microsoft Office InfoPath Microsoft Office InfoPath 2007 offers breakthrough tools for gathering, managing, and integrating business-critical information, and creating efficient forms-driven processes. Two longtime members of Microsoft's InfoPath product team have written the first comprehensive, hands-on guide to building successful XML-based solutions with InfoPath 2007. The book opens with a practical primer on the fundamentals of InfoPath form template design for information workers and application developers at all levels of experience. It then moves into advanced techniques for customizing, integrating, and extending form templates--with all the code examples and detail needed by professional developers. Learn how to: Design form templates: create blank form templates, insert and customize controls, use advanced formatting, and construct and lay out views Work with data: start with XML data or schema, manually edit data sources, and understand design-time visuals Add custom business logic to forms, and integrate them with other applications Retrieve and query data from external data sources, including XML files, databases, SharePoint lists, Web services, and ADO.NET DataSets Submit and receive form data using ADO.NET Save, preview, and publish to e-mail, SharePoint, and more Build reusable components with template parts Create workflows with SharePoint and InfoPath E-Mail Forms Administer Forms Services and Web-enabled form templates Build advanced form templates using C# form code, custom controls, add-ins, and the new InfoPath 2007 managed object model Design form templates using Visual Studio Tools for Office (VSTO) Update, secure, and optimize your form templates List of Figures PART I: Designing Forms