This in-depth look at the encryption tools available in SQL Server shows you how to protect data by encrypting it at rest with Transparent Data Encryption (TDE) and in transit with Transport Level Security (TLS). You will know how to add the highest levels of protection for sensitive data using Always Encrypted to encrypt data also in memory and be protected even from users with the highest levels of access to the database. The book demonstrates actions you can take today to start protecting your data without changing any code in your applications, and the steps you can subsequently take to modify your applications to support implementing a gold standard in data protection. The book highlights work that Microsoft has been doing since 2016 to make encryption more accessible, by making TDE available in the standard edition, and the introduction of Always Encrypted that requires minimal work on your part to implement powerful and effective encryption, protecting your data and meeting regulatory requirements. The book teaches you how to work with the encryption technologies in SQL Server with the express goal of helping you understand those technologies on an intuitive level. You'll come away with a deep level of understanding that allows you to answer questions and speak as an expert. The book's aim is to make you as comfortable in deploying encryption in SQL Server as you would be in driving your car to buy groceries. Those with a data security mindset will appreciate the discussion of how each feature protects you and what it protects you from, as well as how to implement things in the most secure manner. Database administrators will appreciate the high level of detail around managing encryption over time and the effect of encryption on database performance. All readers will appreciate the advice on how to avoid common pitfalls, ensuring that your projects to implement encryption run smoothly. What You Will Learn Architect an effective encryption strategy for new applications Retrofit encryption into your existing applications Encrypt data at rest, in memory, and in transit Manage key and certificate life cycles, including backup and restore Recover encrypted databases in case of server failure Work with encryption in cloud-based scenarios Who This Book Is For Database developers, architects, and administrators who want to work with encryption in SQL Server; those who want to maintain encryption whether data is at rest or being transmitted over the network; and those who wish to encrypt their data even when in the server's own memory. Readers should be familiar with SQL Server, but no existing knowledge of encryption is assumed.

This publication sets out considerations for policymakers embarking on planning and implementing a digital transformation of tax administration. Digitalization can play a key role in helping tax authorities lower compliance and administrative costs, collect more revenue more efficiently, enhance transparency and service to taxpayers, and accommodate big data flows. This report explores how tax administrations can use technology and how risks can be identified and reduced. It provides an assessment framework to support policymakers as they begin the planning process and outlines considerations for effective implementation of the tax administration of the future.

This report identifies and examines six key technologies that are transforming fundamental financial market infrastructure and will serve as a springboard for the technological advancement of financial market infrastructure in the region. This report ascertains the most current status of technology adoption by Cross-Border Settlement Infrastructure Forum member organizations. They include central securities depositories and central banks in the Association of Southeast Asian Nations (ASEAN) plus the People's Republic of China, Japan, and the Republic of Korea (collectively known as ASEAN+3) region.

This report illustrates why Southeast Asian countries need big data for recovery from COVID-19 to radically transform the delivery of key services such as health care, social protection, and education. The final of a four-part series, it looks at the impact of the pandemic on Cambodia, Thailand, Indonesia, Myanmar, and the Philippines to determine how big data can help governments analyze the challenges they face. It outlines policy reforms and recommendations to help capture the benefits of big data, including drawing up digital roadmaps, improving technical infrastructure, and ramping up training to create a skilled workforce to lead the digital transformation.

Troubleshoot slow-performing queries and make them run faster. Database administrators and SQL developers are constantly under pressure to provide more speed. This new edition has been redesigned and rewritten from scratch based on the last 15 years of learning, knowledge, and experience accumulated by the author. The book Includes expanded information on using extended events, automatic execution plan correction, and other advanced features now available in SQL Server. These modern features are covered while still providing the necessary fundamentals to better understand how statistics and indexes affect query performance. The book gives you knowledge and tools to help you identify poorly performing queries and understand the possible causes of that poor performance. The book also provides mechanisms for resolving the issues identified, whether on-premises, in containers, or on cloud platform providers. You'll learn about key fundamentals, such as statistics, data distribution, cardinality, and parameter sniffing. You'll learn to analyze and design your indexes and your queries using best practices that ward off performance problems before they occur. You'll also learn to use important modern features, such as Query Store to manage and control execution plans, the automated performance tuning feature set, and memory-optimized OLTP tables and procedures. You will be able to troubleshoot in a systematic way. Query tuning doesn't have to be difficult. This book helps you to make it much easier. What You Will Learn Use Query Store to understand and easily change query performance Recognize and eliminate bottlenecks leading to slow performance Tune queries whether on-premises, in containers, or on cloud platform providers Implement best practices in T-SQL to minimize performance risk Design in the performance that you need through careful query and index design Understand how built-in, automatic tuning can assist your performance enhancement efforts Protect query performance during upgrades to the newer versions of SQL Server Who This Book Is For Developers and database administrators with responsibility for query performance in SQL Server environments, and anyone responsible for writing or creating T-SQL queries and in need of insight into bottlenecks (including how to identify them, understand them, and eliminate them)

This report explores how Asia and the Pacific can capitalize on growing opportunities in digital services through structural reforms and international cooperation. Another year into the coronavirus disease (COVID-19) pandemic, the report describes an Asia and Pacific region that has more experience in tackling pandemic hardships, better data showing positive integration trends, and greater confidence in regional cooperation to address shared concerns. The publication gives an overview of changes in trade and global value chains, cross-border investment, financial integration, and the movement of people since the pandemic began.

This book shows Oracle Application Express (APEX) developers how to take advantage of Oracle Cloud Infrastructure (OCI) features for APEX that might otherwise go missed. You will learn how to use OCI features for data science tasks such as detecting anomalies in your data, training machine learning models, and much more. The book provides an in-depth look at Oracle Cloud features and demonstrates how they can be easily integrated into an APEX application. While the book focuses on developing for APEX, the approaches covered in the book are also applicable to any other modern web developer framework for applications running on the OCI platform. For many organizations, the database is the heart of operations. Those who opt to invest in the Oracle Database can learn from this book how to maximize their return on investment. The book begins with an introduction to OCI and help on setting up your OCI developer environment. From there you'll begin with security by learning to provide single sign-on via the Oracle Identity Cloud Service. Subsequent chapters take you through cloud-focused features such as Object Storage, Oracle Function, Oracle Machine Learning REST Services, and Oracle Cloud Anomaly Detection. You'll even learn to troubleshoot email delivery services. What You Will Learn Be aware of Oracle Cloud Infrastructure features for developers Integrate with cloud native services such as cloud-based object storage and serverless functions Enhance APEX applications with machine learning features Implement Natural Language Processing and Anomaly Detection Algorithms Troubleshoot email delivery services when sending emails using the APEX_MAIL package Design and implement an APEX environment that is secure Who This Book Is For APEX developers who are looking to extend their application's capabilities using features and resources available through the Oracle Cloud, and cloud solutions architects who support development teams and help design and implement architectures that benefit business operations

This report explores digital solutions that can support the core business processes of public health insurance operators in Asia and the Pacific. Examples from low- and middle-income countries in the region and beyond are drawn to demonstrate how digital solutions have improved health insurance management and administration. To support decision-making on potential investments, the report identifies key success factors for integrating new technologies into public health insurance schemes.

This book examines the scope, potential benefits, and challenges of digital platforms in Asia and the Pacific. It proposes measures and policies to help maximize social and economic gains while alleviating adverse effects. The coronavirus disease (COVID-19) pandemic is accelerating digital transformation across Asia and the Pacific. Digital platforms have become prominent intermediaries or marketplaces that allow the exchange of goods, services, and information. They are opening new transaction channels while lowering service costs and enhancing market efficiency. This volume explores topics that include trade and e-commerce, fintech payments, the digital divide, promoting competition, the digitalization of work and the role of universal basic income, and international taxation.

This publication identifies financial inclusion priorities to stimulate economic recovery and explores the challenges and opportunities of accelerated digital transformation. The coronavirus disease (COVID-19) pandemic has highlighted the vital role of financial inclusion in supporting resilience and economic recovery among the most vulnerable populations in Asia and the Pacific. This publication proposes recommendations to aid policy makers and regulators. It shares insights from the 2021 Asia-Pacific Financial Inclusion Forum, a policy initiative of the Asia-Pacific Economic Cooperation (APEC) Finance Ministers' Process. It was prepared in collaboration with the APEC Business Advisory Council, the Asian Development Bank Institute, and the Foundation for Development Cooperation.

This study examines the development and describes the advanced technology used for the construction and operation of the New Khanki Barrage in Punjab, Pakistan. It highlights the socioeconomic benefits of the project to communities. Among the notable impacts of the project is an increase in agricultural outputs and income of over half a million farming families. Communities, particularly women and girls, have also benefited from new health, education, recreation, and other infrastructure. The study also presents challenges identified in the process, which offers valuable lessons in the design and implementation of other infrastructure projects. The New Khanki Barrage was financed by the Asian Development Bank through the Punjab Irrigated Agriculture Investment Program, Project 2.

This report underscores the dynamic partnership of the People's Republic of China (PRC) and ADB in environmental protection and ecological conservation, rural economy, green livable cities, and climate change mitigation and adaptation. The green development partnership between the PRC and ADB has evolved over the years. In the report, best practices, innovations, and lessons learned from this partnership offer insights for ADB, its developing member countries, and other development partners. The report also presents forward-looking directions for further collaboration by the PRC and ADB in pursuit of a more sustainable future.

This publication aims to inform and influence the strategic deployment of digital technologies in developing Asia to help tackle climate change, build climate and disaster resilience, and enhance environmental sustainability. It provides an overview of the available technology types and their applications and assesses opportunities and barriers for their uptake. The publication provides insights on how digital technologies can be operationalized in the Asian Development Bank's developing member countries, including to support nationally determined contributions and green recovery efforts.

This joint publication explores how big data and digitalization can support sustainable tourism development and help revitalize and reshape the sector as it emerges from the pandemic. The report, co-published with the World Tourism Organization, examines trends, challenges and opportunities in the use of big data in tourism. It highlights the need for investment in big data systems, partnerships with private and public sector big data providers, the adoption of proven measurement systems for sustainable tourism, and regional policy cooperation. Case studies from Asia and the Pacific illustrate ways of tapping big data in tourism development.

This volume constitutes the proceedings of the 18th International Conference on Services Computing 2021, held as Part of SCF 2021 in December 2021 as a virtual event due to COVID-19. The 5 full papers and 2 short papers presented in this volume were carefully reviewed and selected from 21 submissions. It covers the science and technology of leveraging computing and information technology to model, create, operate, and manage business services.

Now in its fourth edition and covering Oracle Database 21c, this best-selling book continues to bring you some of the best thinking on how to apply Oracle Database to produce scalable applications that perform well and deliver correct results. Tom Kyte and Darl Kuhn share a simple philosophy: "you can treat Oracle as a black box and just stick data into it, or you can understand how it works and exploit it as a powerful computing environment." If you choose the latter, then you'll find that there are few information management problems that you cannot solve quickly and elegantly. This fully revised fourth edition covers the developments and new features up to Oracle Database 21c. Up-to-date features are covered for tables, indexes, data types, sequences, partitioning, data loading, temporary tables, and more. All the examples are demonstrated using modern techniques and are executed in container and pluggable databases. The book's proof-by-example approach encourages you to let evidence be your guide. Try something. See the result. Understand why the result is what it is. Apply your newfound knowledge with confidence. The book covers features by explaining how each one works, how to implement software using it, and the common pitfalls associated with it. Don't treat Oracle Database as a black box. Get this book. Dive deeply into Oracle Database's most powerful features that many do not invest the time to learn about. Set yourself apart from your competition and turbo-charge your career. What You Will Learn Identify and effectively resolve application performance issues and bottlenecks Architect systems to leverage the full power and feature set of Oracle's database engine Configure a database to maximize the use of memory structures and background processes Understand internal locking and latching technology and how it impacts your system Proactively recommend best practices around performance for table and index structures Take advantage of advanced features such as table partitioning and parallel execution Who This Book Is For Oracle developers and Oracle DBAs. If you're a developer and want a stronger understanding of Oracle features and architecture that will enable your applications to scale regardless of the workload, this book is for you. If you're a DBA and want to intelligently work with developers to design applications that effectively leverage Oracle technology, then look no further.

The new edition of the successful previous version is 25 per cent revised and packed with more than 200 pages of new material on the 2008 release of SQL Server Integration Services (SSIS). Renowned author Brian Knight and his expert coauthors show developers how to master the 2008 release of SSIS, which is both more powerful and more complex than ever. Case studies and tutorial examples acquired over the three years since the previous edition will contribute to helping illustrate advanced concepts and techniques. New chapters include coverage of data warehousing using SSIS, new methods for managing the SSIS platform, and improved techniques for ETL operations.

Updates the premier textbook for students and librarians needing to know the landscape of current databases and how to search them. Librarians need to know of existing databases, and they must be able to teach search capabilities and strategies to library users. This practical guide introduces librarians to a broad spectrum of fee-based and freely available databases and explains how to teach them. The updated 6th edition of this well-regarded text covers new databases on the market as well as updates to older databases. It also explains underlying information structures and demonstrates how to search most effectively. It introduces readers to several recent changes, such as the move away from metadata-based indexing to full text indexing by vendors covering newspaper content. Business databases receive greater emphasis. As in the previous edition, this book takes a real-world approach, covering topics from basic and advanced search tools to online subject databases. Each chapter includes a thorough discussion, a recap, concrete examples, exercises, and points to consider, making it an ideal text for courses in database searching as well as a trustworthy professional resource. Helps librarians and students understand the latest developments in library databases Looks not only at textual databases but also numerical, image, video, and social media resources Includes changes and trends in database functionality since the 5th edition

Know how locks work in MySQL and how they relate to transactions. This book explains the major role that locks play in database systems, showing how locks are essential in allowing high-concurrency workloads. You will learn about lock access levels and lock granularities from the user level as well as table locks to record and gap locks. Most importantly, the book covers troubleshooting techniques when locking becomes a pain point. Several of the lock types in MySQL have a duration of a transaction. For this reason, it is important to understand how transactions work. This book covers the basics of transactions as well as transaction isolation levels and how they affect locking. The book is meant to be your go-to resource for solving locking contention and similar problems in high-performance MySQL database applications. Detecting locking issues when they occur is the first key to resolving such issues. MySQL Concurrency provides techniques for detecting locking issues such as contention. The book shows how to analyze locks that are causing contention to see why those locks are in place. A collection of six comprehensive case studies combine locking and transactional theory with realistic lock conflicts. The case studies walk you through the symptoms to look for in order to identify which issue you are facing, the cause of the conflict, its analysis, solution, and how to prevent the issue in the future. What You Will Learn Understand which lock types exist in MySQL and how they are used Choose the best transaction isolation level for a given transaction Detect and analyze lock contention when it occurs Reduce locking issues in your applications Resolve deadlocks between transactions Resolve InnoDB record-level locking issues Resolve issues from metadata and schema locks Who This Book Is For Database administrators and SQL developers who are familiar with MySQL and want to gain a better understanding of locking and transactions as well as how to work with them. While some experience with MySQL is required, no prior knowledge of locks and transactions is needed.

Are you a seasoned system administrator charged with setting up an Oracle database? Or did you suddenly become a DBA by default? If database administration with Oracle is part of your job, you'll be glad to have "Oracle 11g For Dummies" in your cubicle.

This nuts-and-bolts guide walks you through the mysteries of Oracle and database administration. You'll learn how to understand Oracle database architecture, set up and manage an Oracle database, and keep it running in tiptop form. "Oracle 11g For Dummies" covers: The building blocks behind the database engine as well as Oracle's physical and logical structuresHardware, software, system, and storage requirements for implementationHow to recognize and accommodate the differences between Oracle installations on Windows and on Linux/UNIXDaily and intermittent tasks necessary to keep your database running properlyHow to assess potential threats to your database, configure Oracle Recovery Manager, and set up backup and recovery proceduresWhen to use online, offline, controlfile, and archivelog backupsTroubleshooting methodology and how to use Oracle database logs and other diagnostic utilitiesDifferent ways to manage your databaseHow to automate jobs with the Oracle SchedulerUsing SQL in Oracle, and a great deal more

Completely up to date for the newest release of Oracle, "Oracle 11g For Dummies" will give you both the information and the confidence to set up and maintain an Oracle database for your organization.

Identify, analyze, and improve poorly performing queries that damage user experience and lead to lost revenue for your business. This book will help you make query tuning an integral part of your daily routine through a multi-step process that includes monitoring of execution times, identifying candidate queries for optimization, analyzing their current performance, and improving them to deliver results faster and with less overhead. Author Jesper Krogh systematically discusses each of these steps along with the data sources and the tools used to perform them. MySQL 8 Query Performance Tuning aims to help you improve query performance using a wide range of strategies. You will know how to analyze queries using both the traditional EXPLAIN command as well as the new EXPLAIN ANALYZE tool. You also will see how to use the Visual Explain feature to provide a visually-oriented view of an execution plan. Coverage of indexes includes indexing strategies and index statistics, and you will learn how histograms can be used to provide input on skewed data distributions that the optimizer can use to improve query performance. You will learn about locks, and how to investigate locking issues. And you will come away with an understanding of how the MySQL optimizer works, including the new hash join algorithm, and how to change the optimizer's behavior when needed to deliver faster execution times. You will gain the tools and skills needed to delight application users and to squeeze the most value from corporate computing resources. What You Will Learn Monitor query performance to identify poor performers Choose queries to optimize that will provide the greatest gain Analyze queries using tools such as EXPLAIN ANALYZE and Visual Explain Improve slow queries through a wide range of strategies Properly deploy indexes and histograms to aid in creating fast execution plans Understand and analyze locks to resolve contention and increase throughput Who This Book Is For Database administrators and SQL developers who are familiar with MySQL and need to participate in query tuning. While some experience with MySQL is required, no prior knowledge of query performance tuning is needed.

Use this fast-paced and comprehensive guide to build cloud-based solutions on Oracle Cloud Infrastructure. You will understand cloud infrastructure, and learn how to launch new applications and move existing applications to Oracle Cloud. Emerging trends in software architecture are covered such as autonomous platforms, infrastructure as code, containerized applications, cloud-based container orchestration with managed Kubernetes, and running serverless workloads using open-source tools. Practical examples are provided. This book teaches you how to self-provision the cloud resources you require to run and scale your custom cloud-based applications using a convenient web console and programmable APIs, and you will learn how to manage your infrastructure as code with Terraform. You will be able to plan, design, implement, deploy, run, and monitor your production-grade and fault-tolerant cloud software solutions in Oracle's data centers across the world, paying only for the resources you actually use. Oracle Cloud Infrastructure is part of Oracle's new generation cloud that delivers a complete and well-integrated set of Infrastructure as a Service (IaaS) capabilities (compute, storage, networking), edge services (DNS, web application firewall), and Platform as a Service (PaaS) capabilities (such as Oracle Autonomous Database which supports both transactional and analytical workloads, the certified and fully managed Oracle Kubernetes Engine, and a serverless platform based on an open-source Fn Project). What You Will Learn Build software solutions on Oracle Cloud Automate cloud infrastructure with CLI and Terraform Follow best practices for architecting on Oracle Cloud Employ Oracle Autonomous Database to obtain valuable data insights Run containerized applications on Oracle's Container Engine for Kubernetes Understand the emerging Cloud Native ecosystem Who This Book Is For Cloud architects, developers, DevOps engineers, and technology students and others who want to learn how to build cloud-based systems on Oracle Cloud Infrastructure (OCI) leveraging a broad range of OCI Infrastructure as a Service (IAAS) capabilities, Oracle Autonomous Database, and Oracle's Container Engine for Kubernetes. Readers should have a working knowledge of Linux, exposure to programming, and a basic understanding of networking concepts. All exercises in the book can be done at no cost with a 30-day Oracle Cloud trial.