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… <ul>
<li>Build mobile and desktop applications using SQL Server Compact Edition </li>
<li>Set up the development and production environment with Visual Studio, SQL Server, and SQL Server Compact Edition </li>
<li>Optimize performance and plan for security </li>
<li>Manage databases using SQL Server Management Studio, Visual Studio, and Query Analyzer </li>
<li>Develop applications using ADO.NET and OLEDB provider for SQL Server Compact Edition </li>
<li>Upgrade from earlier versions of SQL CE, .NET Compact Framework, and Visual Studio </li>
<li>Use Merge Replication to synchronize data between SQL Server and SQL Server Compact Edition </li>
<li>Exchange data between SQL Server and SQL Server Compact Edition using Remote Data Access</li> </ul>
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 SQL Server 2005

Computers & Technology

Swanson, Trent

Dhingra, Prashant

Programming

Sams.

Book + Content Update Program “Beyond just describing the basics, this book dives into best practices every aspiring microservices developer or architect should know.” —Foreword by Corey Sanders, Partner Director of Program Management, Azure Microservice-based applications enable unprecedented agility and ease of management, and Docker containers are ideal for building them. Microsoft Azure offers all the foundational technology and higher-level services you need to develop and run any microservices application. Microservices with Docker on Microsoft Azure brings together essential knowledge for creating these applications from the ground up, or incrementally deconstructing monolithic applications over time. The authors draw on their pioneering experience helping to develop Azure’s microservices features and collaborating with Microsoft product teams who’ve relied on microservices architectures for years. They illuminate the benefits and challenges of microservices development and share best practices all developers and architects should know. You’ll gain hands-on expertise through a detailed sample application, downloadable at github.com/flakio/flakio.github.io. Step by step, you’ll walk through working with services written in Node.js, Go, and ASP.NET 5, using diverse data stores (mysql, elasticsearch, block storage). The authors guide you through using Docker Hub as a service registry, and Microsoft Azure Container service for cluster management and service orchestration. Coverage includes: <ul>
<li>Recognizing how microservices architectures are different, and when they make sense </li> <li>Understanding Docker containers in the context of microservices architectures </li> <li>Building, pulling, and layering Docker images </li> <li>Working with Docker volumes, containers, images, tags, and logs </li> <li>Using Docker Swarm, Docker Compose, and Docker Networks </li> <li>Creating Docker hosts using the Azure portal, Azure Resource Manager, the command line, docker-machine, or locally via Docker toolbox </li> <li>Establishing development and DevOps environments to support microservices applications </li> <li>Making the most of Docker’s continuous delivery options </li> <li>Using Azure’s cluster and container orchestration capabilities to operate and scale containerized microservices applications with maximum resilience </li> <li>Monitoring microservices applications with Azure Diagnostics, Visual Studio Application Insights, and Microsoft Operations Management Suite </li> <li>Developing microservices applications faster and more effectively with Azure Service Fabric</li> <li>An extensive sample application demonstrating the microservices concepts discussed throughout the book is available online 
</li> </ul>In addition, this book is part of InformIT’s exciting new Content Update Program, which provides content updates for major technology improvements! As significant updates are made to Docker and Azure, sections of this book will be updated or new sections will be added to match the updates to the technologies. As updates become available, they will be delivered to you via a free Web Edition of this book, which can be accessed with any Internet connection. To learn more, visit informit.com/cup. How to access the Web Edition: Follow the instructions inside to learn how to register your book to access the FREE Web Edition.

Microservices with Docker on Microsoft Azure (Addison-wesley Microsoft Technology)

Scholl, Boris

Fernandez, Daniel

Networking & Cloud Computing

Addison-Wesley Professional

Developers often struggle when first encountering the cloud. Learning about distributed systems, becoming familiar with technologies such as containers and functions, and knowing how to put everything together can be daunting. With this practical guide, you’ll get up to speed on patterns for building cloud native applications and best practices for common tasks such as messaging, eventing, and DevOps.
Authors Boris Scholl, Trent Swanson, and Peter Jausovec describe the architectural building blocks for a modern cloud native application. You’ll learn how to use microservices, containers, serverless computing, storage types, portability, and functions. You’ll also explore the fundamentals of cloud native applications, including how to design, develop, and operate them.
<ul>
<li>Explore the technologies you need to design a cloud native application</li>
<li>Distinguish between containers and functions, and learn when to use them</li>
<li>Architect applications for data-related requirements</li>
<li>Learn DevOps fundamentals and practices for developing, testing, and operating your applications</li>
<li>Use tips, techniques, and best practices for building and managing cloud native applications</li>
<li>Understand the costs and trade-offs necessary to make an application portable</li>
</ul>

Cloud Native: Using Containers, Functions, and Data to Build Next-Generation Applications

Jausovec, Peter

Computer Science

O'Reilly Media

Cloud applications have a unique set of characteristics. They run on commodity hardware, provide services to untrusted users, and deal with unpredictable workloads. These factors impose a range of problems that you, as a designer or developer, need to resolve. Your applications must be resilient so that they can recover from failures, secure to protect services from malicious attacks, and elastic in order to respond to an ever changing workload. This guide demonstrates design patterns that can help you to solve the problems you might encounter in many different areas of cloud application development. Each pattern discusses design considerations, and explains how you can implement it using the features of Windows Azure. The patterns are grouped into categories: availability, data management, design and implementation, messaging, performance and scalability, resilience, management and monitoring, and security. You will also see more general guidance related to these areas of concern. It explains key concepts such as data consistency and asynchronous messaging. In addition, there is useful guidance and explanation of the key considerations for designing features such as data partitioning, telemetry, and hosting in multiple datacenters. These patterns and guidance can help you to improve the quality of applications and services you create, and make the development process more efficient. Enjoy!

Cloud Design Patterns: Prescriptive Architecture Guidance for Cloud Applications (Microsoft patterns & practices)

Sharp, John

Homer, Alex

Narumoto, Masashi

Brader, Larry

Hardware & DIY

Microsoft patterns & practices

See the best price to sell, buy, or rent books by Swanson, Trent. BookScouter helps to compare book prices from 25+ online bookstores and 30+ buyback vendors with a single search.

Books by Swanson, Trent