PostgreSQL Administration Cookbook. Effective database management for administrators - Third Edition

Gabriele Bartolini, Hannu Krosing, Gianni Ciolli, Simon Riggs

PostgreSQL is a powerful opensource database management system; now recognized as the expert's choice for a wide range of applications, it has an enviable reputation for performance and stability. PostgreSQL provides an integrated feature set comprising relational database features, object-relational, text search, Geographical Info Systems, analytical tools for big data and JSON/XML document management.Starting with short and simple recipes, you will soon dive into core features, such as configuration, server control, tables, and data. You will tackle a variety of problems a database administrator usually encounters, from creating tables to managing views, from improving performance to securing your database, and from using monitoring tools to using storage engines. Recipes based on important topics such as high availability, concurrency, replication, backup and recovery, as well as diagnostics and troubleshooting are also given special importance.By the end of this book, you will have all the knowledge you need to run, manage, and maintain PostgreSQL efficiently.

Oracle JD Edwards EnterpriseOne 9.0: Supply Chain Management Cookbook. Over 130 simple but incredibly effective recipes for configuring, supporting, and enhancing EnterpriseOne SCM with this book and

Kashif Rasheed

Oracle's JD Edwards Enterprise One Supply Chain Management (SCM) aids your business in enhancing your interactions with enterprise suppliers, and this practical cookbook provides essential implementation sequences to make the most of the suite. The functionality across the application described in this comprehensive guide allows you to be proactive in reacting to real-time information and developing procurement strategies and best practices.Oracle JD Edwards EnterpriseOne 9.0: Supply Chain Management Cookbook explains with step by step instructions how to fully implement the EnterpriseOne Supply Chain suite, set up Inventory Management, Procurement Management and Sales Order Management, and much more. Each chapter will provide you the details of setup-related information, and instructions which will direct you in configuring your company's business processes.This business-ready cookbook provides you with all the instructions you need to set up the SCM application, and utilize it based on your company's individual business requirements. It begins by demonstrating how to review inventory quantity information and perform physical inventory through cycle count and tag count, and later moves onto how to configure the interactive application, and how to set up the batch versions.Along the way it will also cover the item master information, classification, AAI setup, and system integration. Ultimately, Oracle JD Edwards EnterpriseOne 9.0: Supply Chain Management Cookbook will equip you with the knowledge to configure and take advantage of the entire SCM system.

Learning Salesforce Visual Workflow. Click your way to automating your various business processes using Salesforce Visual Workflow

Rakesh Gupta

SQL Server 2019 Administrator's Guide. A definitive guide for DBAs to implement, monitor, and maintain enterprise database solutions - Second Edition

Marek Chmel, Vladimir Muzny

SQL Server is one of the most popular relational database management systems developed by Microsoft. This second edition of the SQL Server Administrator's Guide will not only teach you how to administer an enterprise database, but also help you become proficient at managing and keeping the database available, secure, and stable.You’ll start by learning how to set up your SQL Server and configure new and existing environments for optimal use. The book then takes you through designing aspects and delves into performance tuning by showing you how to use indexes effectively. You’ll understand certain choices that need to be made about backups, implement security policy, and discover how to keep your environment healthy. Tools available for monitoring and managing a SQL Server database, including automating health reviews, performance checks, and much more, will also be discussed in detail. As you advance, the book covers essential topics such as migration, upgrading, and consolidation, along with the techniques that will help you when things go wrong. Once you’ve got to grips with integration with Azure and streamlining big data pipelines, you’ll learn best practices from industry experts for maintaining a highly reliable database solution.Whether you are an administrator or are looking to get started with database administration, this SQL Server book will help you develop the skills you need to successfully create, design, and deploy database solutions.

Azure Serverless Computing Cookbook. Build and monitor Azure applications hosted on serverless architecture using Azure functions - Third Edition

Praveen Kumar Sreeram

This third edition of Azure Serverless Computing Cookbook guides you through the development of a basic back-end web API that performs simple operations, helping you understand how to persist data in Azure Storage services. You'll cover the integration of Azure Functions with other cloud services, such as notifications (SendGrid and Twilio), Cognitive Services (computer vision), and Logic Apps, to build simple workflow-based applications.With the help of this book, you'll be able to leverage Visual Studio tools to develop, build, test, and deploy Azure functions quickly. It also covers a variety of tools and methods for testing the functionality of Azure functions locally in the developer's workstation and in the cloud environment. Once you're familiar with the core features, you'll explore advanced concepts such as durable functions, starting with a hello world example, and learn about the scalable bulk upload use case, which uses durable function patterns, function chaining, and fan-out/fan-in.By the end of this Azure book, you'll have gained the knowledge and practical experience needed to be able to create and deploy Azure applications on serverless architectures efficiently.

Microsoft 365 and SharePoint Online Cookbook. A complete guide to Microsoft Office 365 apps including SharePoint, Power Platform, Copilot and more - Second Edition

Gaurav Mahajan, Sudeep Ghatak, Nate Chamberlain, Scott Brewster, ...

Microsoft 365 offers tools for content management, communication, process automation, and report creation. Microsoft 365 and SharePoint Online Cookbook maximizes workplace collaboration and productivity using SharePoint Online, Teams, OneDrive, Delve, M365 Search, Copilot, Power Platform, Viva, Planner, and Microsoft Forms.You will find thoroughly updated recipes for SharePoint Online, covering sites, lists, libraries, pages, web parts, and learn SharePoint Framework (SPFx) basics for building solutions. You will explore many Microsoft Teams recipes to prepare it to be your organization’s central collaboration hub. You will be able to unlock Power Platform potential with recipes for Power Apps to enable low-code/no-code app development and learn to automate tasks with Power Automate and Power Automate Desktop. The book teaches you data visualization with Power BI, and chatbot creation with Power Virtual Agents (Copilot Studio). Finally, you will also learn about the cutting-edge Copilot and Gen AI functionality in Microsoft 365 and Power Platform. By the end, you will be equipped with skills to effectively use Microsoft 365, SharePoint Online, and the Power Platform.Whether it's enhancing career prospects or improving business operations, this book is a perfect companion on your journey through the Microsoft Office 365 suite.

Getting Started with DuckDB. A practical guide for accelerating your data science, data analytics, and data engineering workflows

Simon Aubury, Ned Letcher, Kris Jenkins

DuckDB is a fast in-process analytical database. Its ease of use, versatile feature set, and powerful analytical capabilities make DuckDB a valuable addition to the data practitioner’s toolkit.Getting Started with DuckDB offers a practical overview of DuckDB’s fundamentals and guidance for effectively using its powerful capabilities. Through extensive hands-on examples, you’ll learn how to use DuckDB to load, transform, and query a variety of data sources and formats, including CSV, JSON, and Parquet files, semi-structured data, remotely-hosted files, and external databases. You'll also find out how to leverage DuckDB's performance optimizations and friendly SQL enhancements. You'll explore how to use DuckDB’s extensions for specialized applications, such as geospatial analysis and text search over document collections. In addition to working through examples in SQL, Python, and R, you’ll also dive into using DuckDB for analyzing public datasets and discover the wider ecosystem of open-source tools and cloud services that supercharge DuckDB-powered workflows and applications.Whether you’re a seasoned data practitioner or new to working with analytical data, this book will rapidly get you up to speed with DuckDB’s versatile and powerful capabilities, enabling you to apply them in your analytical workflows and projects.

Getting Started with Ghost. Reach out to the world and publish great content with the power of Ghost

Andrew J Boutte, David Balderston, Kezz Bracey