Get to grips with Office 365 through in-depth tutorials and insights from leading experts. Topics covered include Exchange Online, SharePoint Online, Skype Online, and more. This deeply technical book tackles key aspects of online collaboration and business productivity within Office 365. Expert Office 365 is written by a dedicated team of Microsoft Premier Field Engineers (PFEs), and captures advice, best practices, and insights from their experience in the field. What You'll Learn Develop client Web Parts with the new SharePoint Framework Create a recovery plan for SharePoint Online Configure SharePoint Online Hybrid Search and Portals Configure and optimize Exchange Online Optimize collaboration in your organization through analytics insights Who This Book Is For Senior IT pros and developers who wish to master business productivity within Office 365. This book is aimed at organizations that are already on Office 365 or that are currently planning their migration to the cloud.

Obtain all the skills you need to configure and manage a PostgreSQL database. In this book you will begin by installing and configuring PostgreSQL on a server by focusing on system-level parameter settings before installation. You will also look at key post-installation steps to avoid issues in the future. The basic configuration of PostgreSQL is tuned for compatibility rather than performance. Keeping this in mind, you will fine-tune your PostgreSQL parameters based on your environment and application behavior. You will then get tips to improve database monitoring and maintenance followed by database security for handling sensitive data in PostgreSQL. Every system containing valuable data needs to be backed-up regularly. PostgreSQL follows a simple back-up procedure and provides fundamental approaches to back up your data. You will go through these approaches and choose the right one based on your environment. Running your application with limited resources can be tricky. To achieve this you will implement a pooling mechanism for your PostgreSQL instances to connect to other databases. Finally, you will take a look at some basic errors faced while working with PostgreSQL and learn to resolve them in the quickest manner. What You Will Learn Configure PostgreSQL for performance Monitor and maintain PostgreSQL instances Implement a backup strategy for your data Resolve errors faced while using PostgreSQL Who This Book Is For Readers with basic knowledge of PostgreSQL who wish to implement key solutions based on their environment.

The first edition of this book became a classic for developers and DBAs. This edition offers 400 pages of updated material on Oracle features, including parallel server, parallel query, Oracle Performance Pack, disk striping and mirroring, RAID, MPPs, SMPs, distributed databases, backup and recovery, and much more.

This is a shareware developer's and game programmer's guide to creating games with Flash technology. The building blocks of Flash games tools are explained in this guide for developing high-quality games with Web programming. It demonstrates the construction of these tools, the methods for importing graphics in GIF/PNG and JPEG formats, and the creation of clips, buttons, and animation effects. Motion Tween and Shape Tween animations are presented, and instructions for changing Action Script code for working with the program shell, integrating the Shockwave Flash component into the Delphi environment, and writing a C program for working with a Flash movie are provided. Practical information on an Action Script, coding the game scenario, game interaction with the server, and preparing game graphics will help the shareware developer and game programmer utilize Flash tools effectively. The accompanying CD-ROM includes Flash project, graphic and SWF files, sever PHP scripts, executable files for the key generator in Delphi, MSVC++, and Perl, and key files for game. It also includes the fontonizer program (fontonizer1), the program for displaying all Flash animations on a Web page (saveflash_5460), powerful shareware file manager (a_Frigate3_Pro_v30), and a professional shareware icon editor with ready-to-use effects (awiconsprosetup).

Is Responsive Web Design (RWD) slowing your site down? It doesn't have to. With this concise book, you'll learn practical techniques for improving performance with RWD, including a default set of guidelines you can use as an easy starting point. Web performance researcher and evangelist Guy Podjarny walks you through several existing solutions for dealing with RWD performance problems, and offers advice for choosing optimizations that will be most useful for your needs. RWD performance problems stem from excessive downloads of resources, including images, JavaScript and CSS, and HTML--downloads designed to let your web application adapt to different screen sizes. Podjarny presents a series of increasingly larger-scope solutions to each issue, including client-side techniques and RESS (Responsive + Server Side Components). Address performance issues by starting with Podjarny's default guidelines Use a JavaScript image loader and an image transcoding service to create Responsive Images Reduce JavaScript and CSS downloads with asynchronous scripts, conditional loading, and multi-viewport CSS Prioritize resources to avoid excess content in RWD and defer the load of any content that's not critical Explore server-side Adaptive Delivery and RESS solutions as an alternative to "pure" RWD Guy Podjarny, or Guypo for short, is the Chief Technology Officer (CTO) of Akamai's Web Experience business unit.

Learn how to write, tune, and port SQL queries and other statements for a Big Data environment, using Impala - the massively parallel processing SQL query engine for Apache Hadoop. The best practices in this practical guide help you design database schemas that not only interoperate with other Hadoop components, and are convenient for administers to manage and monitor, but also accommodate future expansion in data size and evolution of software capabilities. Ideal for database developers and business analysts, Getting Started with Impala includes advice from Cloudera's development team, as well as insights from its consulting engagements with customers. Learn how Impala integrates with a wide range of Hadoop components Attain high performance and scalability for huge data sets on production clusters Explore common developer tasks, such as porting code to Impala and optimizing performance Use tutorials for working with billion-row tables, date- and time-based values, and other techniques Learn how to transition from rigid schemas to a flexible model that evolves as needs change

Server bottlenecks and failures are a fact of life in any database deployment, but they don't have to bring everything to a halt. This practical book explains replication, cluster, and monitoring features that can help protect your MySQL system from outages, whether it's running on hardware, virtual machines, or in the cloud.

Written by engineers who designed many of the tools covered, this book reveals undocumented or hard-to-find aspects of MySQL reliability and high availability--knowledge that's essential for any organization using this database system. This second edition describes extensive changes to MySQL tools. Versions up to 5.5 are covered, along with several 5.6 features.Learn replication fundamentals, including use of the binary log and MySQL Replicant LibraryHandle failing components through redundancyScale out to manage read-load increases, and use data sharding to handle large databases and write-load increasesStore and replicate data on individual nodes with MySQL ClusterMonitor database activity and performance, and major operating system parametersKeep track of masters and slaves, and deal with failures and restarts, corruption, and other incidentsExamine tools including MySQL Enterprise Monitor, MySQL Utilities, and GTIDs

Book + Content Update Program SQL Server 2016 High Availability Unleashed provides start-to-finish coverage of SQL Server's powerful high availability (HA) solutions for your traditional on-premise databases, cloud-based databases (Azure or AWS), hybrid databases (on-premise coupled with the cloud), and your emerging Big Data solutions. This complete guide introduces an easy-to-follow, formal HA methodology that has been refined over the past several years and helps you identity the right HA solution for your needs. There is also additional coverage of both disaster recovery and business continuity architectures and considerations. You are provided with step-by-step guides, examples, and sample code to help you set up, manage, and administer these highly available solutions. All examples are based on existing production deployments at major Fortune 500 companies around the globe. This book is for all intermediate-to-advanced SQL Server and Big Data professionals, but is also organized so that the first few chapters are great foundation reading for CIOs, CTOs, and even some tech-savvy CFOs. Learn a formal, high availability methodology for understanding and selecting the right HA solution for your needs Deep dive into Microsoft Cluster Services Use selective data replication topologies Explore thorough details on AlwaysOn and availability groups Learn about HA options with log shipping and database mirroring/ snapshots Get details on Microsoft Azure for Big Data and Azure SQL Explore business continuity and disaster recovery Learn about on-premise, cloud, and hybrid deployments Provide all types of database needs, including online transaction processing, data warehouse and business intelligence, and Big Data Explore the future of HA and disaster recovery In addition, this book is part of InformIT's exciting Content Update Program, which provides content updates for major technology improvements! As significant updates are made to SQL Server, 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.

Prominent FileMaker developers Susan Prosser and Stuart Gripman know how to work magic with FileMaker Pro, and they share their knowledge in this bestselling book. You'll learn how to build a database and organize all of your information quickly and efficiently.

Get a head start with eXist, the open source NoSQL database and application development platform built entirely around XML technologies. With this hands-on guide, you'll learn eXist from the ground up, from using this feature-rich database to work with millions of documents to building complex web applications that take advantage of eXist's many extensions. If you're familiar with XML - as a student, professor, publisher, or developer - you'll find that eXist is ideal for all kinds of documents. This book shows you how to store, query, and search documents with XQuery and other XML technologies, and how to construct applications on top of the database with tools such as eXide and eXist's built-in development environment. Manage both data-oriented and text-oriented markup documents securely Build a sample application that analyzes and searches Shakespeare's plays Go inside the architecture and learn how eXist processes documents Learn how to work with eXist's internal development environment Choose among various indexes, including a full-text index based on Apache Lucene Dive into eXist's APIs for integrating or interacting with the database Extend eXist by building your own Triggers, Scheduled Tasks, and XQuery extension modules

Beginning SQL Server 2012 Administration provides the essential skills and knowledge needed to begin a successful career as an SQL Server database administrator. It's an ideal book for those new to database administration, as well for those moving to SQL Server from other database brands such as Oracle and IBM DB2. SQL Server is more than just a database. It's situated within a larger context that includes solutions for reporting, for integrating data from other systems, for business intelligence and analysis, and more. Beginning SQL Server 2012 Administration paints the big picture to help you understand SQL Server's place in the grand scheme. Then you'll move into the nuts and bolts of installing the product, learning the management tools at your disposal, creating your first database, and maintaining that database in an ongoing state of readiness. Beginning SQL Server 2012 Administration goes beyond teaching just the core competencies of effective database administration. You will also learn the latest trends in SQL Server such as virtualizing and consolidating of servers, and using SQL Server in the cloud as a service.Administrators experienced on other platforms will find insight from comparisons of key features between SQL Server and other platforms. Beginning SQL Server 2012 Administration lays an excellent foundation for success as an SQL Server database administrator. * Provides the essentials of successful SQL Server administration * Covers the latest trends such as virtualization and cloud computing * Paints the big picture of Microsoft's data platform What you'll learn * Master basic database administration skills * Plan and install new database environments * Ensure the ability to recover from disaster and data loss * Manage security and regulatory compliance * Take advantage of new features in SQL Server 2012 * Create private-cloud databases for your organization Who this book is for Beginning SQL Server 2012 Administration is aimed at aspiring database administrators, as well as at experienced administrators from competing platforms such as Oracle. The book quickly provides the essentials of SQL Server administration, laying a foundation for success in a career as an SQL Server database administrator.Table of Contents * The Database Administration Profession * Planning and Installing SQL Server 2012 * What's in the Toolbox? * Supporting the Developer * Creating Tables and Other Objects * Transact-SQL * SQL Server Internals * Database Backup Strategies * Database Restore Strategies * Common Database Maintenance Tasks * SQL Server Security * Auditing, Encryption, Compliance * Performance Tuning & Optimization * Fault Tolerance * Cloud Computing for the DBA * Database as a Service * Where to Go Next?

This book is intended primarily for those who plan to become data scientists as well as anyone who needs to perform data cleaning tasks. It contains a variety of features of NumPy and Pandas and how to create databases and tables in MySQL. Chapter 7 covers many data wrangling tasks using Python scripts and awk-based shell scripts. Companion files with code are available for downloading from the publisher. FEATURES: Provides the reader with basic Python 3, Java, and Pandas programming concepts, and an introduction to awk. Includes a chapter on RDBMs and SQL. Companion files with code.

Understanding dBASE5 for Windows is a good tutor for anyone interested in the new Windows version.

From this systematic and comprehensive book, you can learn the basics and features of dBASE as well as the advanced techniques that will make you an expert.

The book presents the basic concepts of using a database, and instructs you to build sophisticated database systems step by step. It is full of valuable tips, tricks and timesaving techniques.

Publisher's Note: Products purchased from Third Party sellers are not guaranteed by the publisher for quality, authenticity, or access to any online entitlements included with the product. Apply Your SQL Server DBA Skills to Oracle Database AdministrationUse your SQL Server experience to set up and maintain a high-performance Oracle Database environment. Written by a DBA with expertise in both platforms, Oracle Database Administration for Microsoft SQL Server DBAs illustrates each technique with clear explanations, examples, and comparison tables. Get full details on Oracle Database intervals, creation assistants, management techniques, and query tools. High availability, disaster recovery, and security procedures are also extensively covered in this comprehensive Oracle Press guide. Install and configure Oracle Database on Windows or Linux systems Administer and monitor databases from Oracle Enterprise Manager Implement robust security using roles, permissions, and privileges Back up and restore databases with Oracle Recovery Manager Use the Oracle cost-based optimizer to tune performance Write, debug, and execute PL/SQL queries using Oracle SQL Developer Maximize availability with Oracle Real Application Clusters Build standby and failover servers using Oracle Data Guard

Getting started with MongoDB is easy, but once you begin building applications with it, you'll face some complex issues. What are the tradeoffs between normalized and denormalized data? How do you handle replica set failure and failover? This collection of MongoDB tips, tricks, and hacks helps you resolve issues with everything from application design and implementation to data safety and monitoring.

You get specific guidance in five topic areas directly from engineers at 10gen, the company that develops and supports this open source database: Application Design Tips: What to keep in mind when designing your schema Implementation Tips: Programming applications against MongoDB Optimization Tips: Speeding up your applications Data Safety Tips: Using replication and journaling to keep data safe--without sacrificing too much performance Administration Tips: How to configure MongoDB and keep it running smoothly

This volume contains the proceedings of the International Middleware Con- rence, held in Leuven, Belgium during December 1-4, 2008. This year marked the ninth rendition of this annual conference in its current format initially - opted in 1998, aspiring to serve as the premier venue focusing exclusively on important middleware results. A lot has happened over the intervening 10-year span. Middleware has become pervasive in an increasinglyinterconnected world, with its concepts now securely embedded in the notional architectures driving forward the information age. The conference continues to be a focal point for important new initiatives and results for new generations of middleware. With each succeeding year, it has become an even more competitive publishing venue, further extending its selectivity this year as well. Of the 117 submissions, - ly 21 were able to receive acceptance invitations, for an acceptance rate of less than18%. Competitiveindeed. Additionally, thesesubmissionscontinuetocome from all over the globe, spanning authors from 23 countries. A truly world-wide endeavor. But other things have also changed as we turn the corner on the ?rst decade of this conference. In many ways, middleware has achieved signi?cant success where it really counts: in terms of technical innovations, advanced capabilities, successful ideas, and ?elded systems which permeate society, industry, gov- nment, and academia. With this success comes maturity

The FileMaker Pro 10 desktop database lets you do almost anything with the information you give it - especially with this book as your guide. Clear, thorough, and accessible, "FileMaker Pro 10: The Missing Manual" helps you get in, build your database, and get the results you need, whether you're running a business, pursuing a hobby, or planning your retirement. It's the ideal guide for non-technical and experienced folks alike. Each chapter in this fully updated edition covers the latest time-saving features of FileMaker Pro 10, including saved finds and a redesigned toolbar that reveals information and features more clearly than ever. You'll learn how to import information from the new Bento consumer database (Mac only), write scripts to make your database even easier to use, and send email without leaving FileMaker. This book helps you: get your first database running in minutes and perform basic tasks right away; catalog people, processes, and things with streamlined data entry and sorting tools; use your data to generate reports, correspondence, and other documents with ease; create, connect, and manage multiple tables and set up complex relationships that display just the data you need; crunch numbers, search text, or pin down dates and times with dozens of built-in formulas; and, outfit your database for the Web, and import and export data to other formats. You'll also get objective advice on which features are really useful, and which aren't. To make the most of this database, you need "FileMaker Pro 10: The Missing Manual" - the book that should have been in the box.

Businesses today want actionable insights into their datathey want their data to reveal itself to them in a natural and userfriendly form. What could be more natural than human language? Naturallanguage search is at the center of a storm of everincreasing webdriven demand for humancomputer communication and information access. SQL Server 2008 provides the tools to take advantage of the features of its builtin enterpriselevel naturallanguage search engine in the form of integrated fulltext search (iFTS). iFTS uses textaware relational queries to provide your users with fast access to content. Whether you want to set up an enterprisewide Internet or intranet search engine or create less ambitious naturallanguage search applications, this book will teach you how to get the most out of SQL Server 2008 iFTS: Introducing powerful iFTS features in SQL Server, such as the FREETEXT and CONTAINS predicates, custom thesauruses, and stop lists Showing you how to optimize fulltext query performance through features like fulltext indexes and iFilters Providing examples that help you understand and apply the power ofiFTS in your daily projects What you'll learn Harness the power of iFTS for your applicationsAdminister iFTS catalogs and indexesUse new iFTS features such as stop lists and iFTSbased dynamic management functionsOptimize and tune iFTS queriesImplement languageaware, naturallanguage searches for dataSimplify searches of structured and unstructured content Who this book is for

The audience for this book includes SQL Server, SQL and Transact-SQL developers, and also .NET developers, who want to take advantage of the integrated full-text search (iFTS) functionality available in SQL Server 2008.

The first edition of this book has been praised as "the best reference book available on the subject." This new edition, Programming ColdFusion MX, 2nd Edition, goes even further, documenting new techniques for using ColdFusion MX 6.1 to develop and serve dynamic web page content. This exhaustive guide covers everything from the basics to advanced topics, with numerous examples that you can use for your own applications.

This highly regarded and comprehensive reference manual comes directly from the members of the MySQL team. The book covers issues at all stages in MySQL use, from installation problems through performance tuning. Included are suggested uses of privileges to enhance security, many performance tips, and a sophisticated guide to error recovery. It also offers a thorough comparison of MySQL with SQL standards and other databases. No serious MySQL user should be without this book.

This cookbook contains a wealth of solutions to problems that SQL programmers face all the time. Recipes inside range from how to perform simple tasks, like importing external data, to ways of handling issues that are more complicated, like set algebra. Each recipe includes a discussion that explains the logic and concepts underlying the solution. The book covers audit logging, hierarchies, importing data, sets, statistics, temporal data, and data structures.

Learn how to use MySQL, a popular database product that supports key subsets of SQL on Linux and Unix systems. Using C/C++, Java, Perl, PHP, or Python, you can write programs to interact with a MySQL database, either as a stand-alone application or through a web page. This book covers the whole process, from installation to programming interfaces and database administration. It includes ample tutorial material and examples.

Load balancing distributes traffic efficiently among network servers so that no individual server is overburdened. This vendor-neutral guide to the concepts and terminology of load balancing offers practical guidance to planning and implementing the technology in most environments. It includes a configuration guide with diagrams and sample configurations for installing, configuring, and maintaining products from the four major server load balancing vendors.

You don't have to be a techie to use FileMaker Pro 13, but you do need to know what you're doing. With clear, step-by-step instructions, this friendly guide shows you how to create a powerful database that lets you do almost anything with your data. Whether you're running a business, printing a catalog, or planning a wedding, you'll discover how to customize your database and put it to work on several devices.

The important stuff you need to know: Get started. Tour FileMaker Pro's features and create your first database in minutes.Explore the entire platform. Use FileMaker on a desktop, server, WebDirect, or FileMaker Go.Catalog your data. View, sort, and shape information in dozens of ways.Create professional documents. Publish reports, invoices, and other documents with ease.Harness processing power. Use calculations and scripts to crunch numbers, search text, and automate tasks.Add visual power and clarity. Create colorful charts to illustrate and summarize your data.Think like a developer. Dive into advanced topics like relational databases, scripting, and designing for multiple devices.

This bestselling book helps you use FileMaker Pro quickly and efficiently, whether you're experienced with the program or just beginning.

Prepare for Microsoft Exam 70-761-and help demonstrate your real-world mastery of SQL Server 2016 Transact-SQL data management, queries, and database programming. Designed for experienced IT professionals ready to advance their status, Exam Ref focuses on the critical-thinking and decision-making acumen needed for success at the MCSA level. Focus on the expertise measured by these objectives: * Filter, sort, join, aggregate, and modify data * Use subqueries, table expressions, grouping sets, and pivoting * Query temporal and non-relational data, and output XML or JSON * Create views, user-defined functions, and stored procedures * Implement error handling, transactions, data types, and nulls This Microsoft Exam Ref: * Organizes its coverage by exam objectives * Features strategic, what-if scenarios to challenge you * Assumes you have experience working with SQL Server as a database administrator, system engineer, or developer * Includes downloadable sample database and code for SQL Server 2016 SP1 (or later) and Azure SQL Database Querying Data with Transact-SQL About the Exam Exam 70-761 focuses on the skills and knowledge necessary to manage and query data and to program databases with Transact-SQL in SQL Server 2016. About Microsoft Certification Passing this exam earns you credit toward a Microsoft Certified Solutions Associate (MCSA) certification that demonstrates your mastery of essential skills for building and implementing on-premises and cloud-based databases across organizations. Exam 70-762 (Developing SQL Databases) is also required for MCSA: SQL 2016 Database Development certification. See full details at: microsoft.com/learning