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

There are many reasons for serving up dynamic content from a web site: to offer an online shopping site, create customized information pages for users, or just manage a large volume of content through a database. Anyone with a modest knowledge of HTML and web site management can learn to create dynamic content through the PHP programming language and the MySQL database. This book gives you the background and tools to do the job safely and reliably.

"Web Database Applications with PHP and MySQL," Second Edition thoroughly reflects the needs of real-world applications. It goes into detail on such practical issues as validating input (do you know what a proper credit card number looks like?), logging in users, and using templates

to give your dynamic web pages a standard look.

But this book goes even further. It shows how JavaScript and PHP can be used in tandem to make a user's experience faster and more pleasant. It shows the correct way to handle errors in user input so that a site looks professional. It introduces the vast collection of powerful tools available in the PEAR repository and shows how to use some of the most popular tools.

Even while it serves as an introduction to new programmers, the book does not omit critical tasks that web sites require. For instance, every site that allows updates must handle the possibility of multiple users accessing data at the same time. This book explains how to solve the problem in detail with locking.

Through a sophisticated sample application--Hugh and Dave's Wine Store--all the important techniques of dynamic content are introduced. Good design is emphasized, such as dividing logic from presentation. The book introducesPHP 5 and MySQL 4.1 features, while providing techniques that can be used on older versions of the software that are still in widespread use.

This new edition has been redesigned around the rich offerings of PEAR. Several of these, including the Template package and the database-independent query API, are fully integrated into examples and thoroughly described in the text. Topics include:

Installation and configuration of Apache, MySQL, and PHP on Unix(R), Windows(R), and Mac OS(R) X systems

Introductions to PHP, SQL, and MySQL administration

Session management, including the use of a custom database for improved efficiency

User input validation, security, and authentication

The PEAR repository, plus details on the use of PEAR DB and Template classes

Production of PDF reports

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.

Breathe new life into older applications by refactoring T-SQL queries and code using modern techniques. This book shows you how to significantly improve the performance of older applications by finding common anti-patterns in T-SQL code, then rewriting those anti-patterns using new functionality that is supported in current versions of SQL Server, including SQL Server 2019. The focus moves through the different types of database objects and the code used to create them, discussing the limitations and anti-patterns commonly found for each object type in your database. Legacy code isn't just found in queries and external applications. It's also found in the definitions of underlying database objects such as views and tables. This book helps you quickly find problematic code throughout the database and points out where and how modern solutions can replace older code, thereby making your legacy applications run faster and extending their lifetimes. Author Lisa Bohm explains the logic behind each anti-pattern, helping you understand why each pattern is a problem and showing how it can be avoided. Good coding habits are discussed, including guidance on topics such as readability and maintainability. What You Will Learn Find specific areas in code to target for performance gains Identify pain points quickly and understand why they are problematic Rewrite legacy T-SQL to reduce or eliminate hidden performance issues Write modern code with an awareness of readability and maintainability Recognize and correlate T-SQL anti-patterns with techniques for better solutions Make a positive impact on application user experience in your organization Who This Book Is For Database administrators or developers who maintain older code, those frustrated with complaints about slow code when there is so much of it to fix, and those who want a head start in making a positive impact on application user experience in their organization

Use MySQL Shell, the first modern and advanced client for connecting to and interacting with MySQL. It supports SQL, Python, and JavaScript. That's right! You can write Python scripts and execute them within the shell interactively, or in batch mode. The level of automation available from Python combined with batch mode is especially helpful to those practicing DevOps methods in their database environments. Introducing MySQL Shell covers everything you need to know about MySQL Shell. You will learn how to use the shell for SQL, as well as the new application programming interfaces for working with a document store and even automating your management of MySQL servers using Python. The book includes a look at the supporting technologies and concepts such as JSON, schema-less documents, NoSQL, MySQL Replication, Group Replication, InnoDB Cluster, and more. MySQL Shell is the client that developers and database administrators have been waiting for. Far more powerful than the legacy client, MySQL Shell enables levels of automation that are useful not only for MySQL, but in the broader context of your career as well. Automate your work and build skills in one of the most in-demand languages. With MySQL Shell, you can do both! What You'll Learn Use MySQL Shell with the newest features in MySQL 8 Discover what a Document Store is and how to manage it with MySQL Shell Configure Group Replication and InnoDB Cluster from MySQL Shell Understand the new MySQL Python application programming interfaces Write Python scripts for managing your data and the MySQL high availability features Who This Book Is For Developers and database professionals who want to automate their work and remain on the cutting edge of what MySQL has to offer. Anyone not happy with the limited automation capabilities of the legacy command-line client will find much to like in this book on the MySQL Shell that supports powerful automation through the Python scripting language.

Carry out data analysis with PySpark SQL, graphframes, and graph data processing using a problem-solution approach. This book provides solutions to problems related to dataframes, data manipulation summarization, and exploratory analysis. You will improve your skills in graph data analysis using graphframes and see how to optimize your PySpark SQL code. PySpark SQL Recipes starts with recipes on creating dataframes from different types of data source, data aggregation and summarization, and exploratory data analysis using PySpark SQL. You'll also discover how to solve problems in graph analysis using graphframes. On completing this book, you'll have ready-made code for all your PySpark SQL tasks, including creating dataframes using data from different file formats as well as from SQL or NoSQL databases. What You Will Learn Understand PySpark SQL and its advanced features Use SQL and HiveQL with PySpark SQL Work with structured streaming Optimize PySpark SQL Master graphframes and graph processing Who This Book Is ForData scientists, Python programmers, and SQL programmers.

Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to improve efficiency and maintainability. Executing dynamic SQL is key to large-scale searching based on user-entered criteria. Dynamic SQL can generate lists of values and even code with minimal impact on performance. Dynamic SQL enables dynamic pivoting of data for business intelligence solutions as well as customizing of database objects. Yet dynamic SQL is feared by many due to concerns over SQL injection or code maintainability. Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and securely. Your organization's increased ability to respond to rapidly changing business scenarios will build competitive advantage in an increasingly crowded and competitive global marketplace. With a focus on new applications and modern database architecture, this edition illustrates that dynamic SQL continues to evolve and be a valuable tool for administration, performance optimization, and analytics. What You'ill Learn Build flexible applications that respond to changing business needs Take advantage of creative, innovative, and productive uses of dynamic SQL Know about SQL injection and be confident in your defenses against it Address performance concerns in stored procedures and dynamic SQL Troubleshoot and debug dynamic SQL to ensure correct results Automate your administration of features within SQL Server Who This Book is For Developers and database administrators looking to hone and build their T-SQL coding skills. The book is ideal for developers wanting to plumb the depths of application flexibility and troubleshoot performance issues involving dynamic SQL. The book is also ideal for programmers wanting to learn what dynamic SQL is about and how it can help them deliver competitive advantage to their organizations.

Get a Jump Start on working with MySQL today! MySQL is an extremely popular open source relational database management system that that powers many of the applications on the Web. Discover why MySQL's speed, ease of use, and flexibility make it the database of choice for so many developers. In just one weekend with this hands-on tutorial, you'll learn how to: Get started with MySQL Store, modify, and retrieve data Work with multiple tables Connect to your database through code Program the database Back up your data

Data analytics is creeping into the lexicon of our daily language. This book gives the reader a perspective as to the overall data analytics skill set, startingwith a primer on statistics, and works toward the application of those methods.There are a variety of formulas and algorithms used in the data analyticsprocess. These formulas can be plugged into whatever software application thereader uses to obtain the answer they need. There are several demonstrations ofthis process to provide straightforward instruction as to how to bring data analytics skills to your critical thinking. This bookpresents a variety of methods and techniques, as well as case studies, toenrich the knowledge of data analytics for project managers, systems engineers,and cybersecurity professionals. It separates the case studies so that eachprofession can practice some straightforward data analytics specific to their fields. The main purpose of this text is to refresh the statistical knowledgenecessary to build models for data analytics. Along with that, this bookencompasses the analytics thinking that is essential to all three professions. FEATURES: Provides straightforward instruction on data analytics methods Includes methods, techniques, and case studies for project managers, systems engineers, and cybersecurity professionals Refreshes the statistical knowledgeneeded to bring data analytics into your skillset and decision-making Focuses on getting readers up to speed quickly and efficiently to be able to see the impact of data analytics and analytical thinking

Develop RESTful web services using the Flask micro-framework and integrate them using MySQL. Use Flask to develop, deploy, and manage REST APIs with easy-to-read and understand Python code. Solve your problem from a choice of libraries. Learn to use MySQL as the web services database for your Flask API using SQLAlchemy ORM. Building REST APIs with Flask provides a primer on Flask, RESTful services, and working with pip to set up your virtual environment. The key differences between NoSQL and SQL are covered, and you are taught how to connect MySQL and Flask using SQLAlchemy. Author Kunal Relan presents best practices for creating REST APIs and guides you in structuring your app and testing REST endpoints. He teaches you how to set up authentication and render HTML using views. You learn how to write unit tests for your REST APIs, and understand mocks, assertions, and integration testing. You will know how to document your REST APIs, deploy your Flask application on all of the major cloud platforms, and debug and monitor your Flask application. What You'll Learn Use MySQL to create Flask REST APIs Test REST endpoints Create CRUD endpoints with Flask and MySQL Deploy Flask on all of the major cloud platforms Monitor your Flask application Who This Book Is For Python developers interested in REST API development using Flask and web developers with basic programming knowledge who want to learn how Python and REST APIs work together. Readers should be familiar with Python (command line, or at least pip) and MySQL.

This book describes the next generation of business applications in the innovative new SAP Business Suite 4 SAP HANA (SAP S/4HANA), exploiting the revolutionary capabilities of the SAP HANA in-memory database. Numerous real-world examples are presented illustrating the disruptive potential of this technology and the quantum leap it has facilitated in terms of simplicity, flexibility, and speed for new applications. The intuitive structure of this book offers a straightforward business perspective grounded in technology in order to enable valuable business insights drawn from the wealth of real-world experience of the book's two authors, both prominent figures in the field of business application systems: Hasso Plattner and Bernd Leukert. Hasso Plattner is the co-founder of SAP and the founder of the Hasso Plattner Institute, affiliated with the University of Potsdam, Germany. Bernd Leukert is a member of the SAP Executive Board and the Global Managing Board of SAP.

Expert SQL Server Practices 2012 Edition is an anthology of high-end wisdom from a group of accomplished database administrators who are quietly but relentlessly pushing the performance and feature envelope of Microsoft SQL Server 2012.With an emphasis upon performance--but also branching into release management, auditing, and other issues--the book helps you deliver the most value for your company's investment in Microsoft's flagship database system * Goes beyond the manual to cover good techniques and best practices * Delivers knowledge usually gained only by hard experience * Focuses upon performance, scalability, reliability * Helps achieve the predictability needed to be in control at all times What you'll learn * Migrate to the new Extended Events framework for troubleshooting performance problems * Automate the tracking of key performance indicators such as available disk space, cpu utilization, index fragmentation, and more * Design performance into your database and its applications from the very beginning * Manage staged releases from development to test through to production * Diagnose resource and performance problems via dynamic management views * Analyze I/O patterns and plan reliably to obtain the performance you need Who this book is for Expert SQL Server Practices is aimed at SQL Server professionals who want to further their careers through expert-level practices in performance management, scalability, predictability, and security.Table of Contents * Jesper Johansen. Be Your Developer's Best Friend * Louis Davidson. Getting It Right: Designing for Database Performance * Gail Shaw. Hidden Performance Gotchas * Kellyn Pot'vin. Dynamic Management Views * Mladen Prajdic. From SQL Trace to Extended Events * Chris Shaw. The Utility Database * Jason Strate. Indexing Outside the Bubble * TJay Belt. Release Management * Jonathan Gardner. Compliance and Auditing * Jes Borland. Automating Administration * Wendy Pastrick. The Fluid Dynamics of SQL Server Data Movement * Herve Roggero. Windows Azure Features for DBAs * Jeremy Lowell. I/O: The Untold Story * Bradley Ball. Page and Row Compression * Glenn Berry. Selecting and Sizing the Server * Grant Fritchey. Backups and Restores Using Availability Groups * Carlos Bossy. Big Data for the SQL Server DBA * Ben DeBow. Tuning for Peak Load

Step-by-step lessons for using PHP and MySQL in a unique book-and-video combination Assuming no previous experience with PHP or MySQL, this book-and-video package is ideal reading for anyone who wants to go beyond HTML/CSS in order to provide clients with the most dynamic web sites possible. The approachable tone breaks down the basics of programming and PHP and MySQL in individual lessons starting with the installation of the programs necessary to run PHP. You begin with a static web site and then watch and learn as PHP functionality is added as you work through the lessons. When working with databases, the MySQL database is introduced with demonstrations that show how to interact with it. The accompanying videos enhance your learning experience, as each lesson in the book is portrayed in the video exercises. Lessons include: ? Getting started with PHP ? Setting up your workspace ? Adding PHP to a web page ? Learning PHP syntax ? Working with variables ? Debugging code ? Working with complex data ? Making decisions ? Repeating program steps ? Learning about scope ? Reusing code with functions ? Creating forms ? Introducing object-oriented programming ? Defining classes ? Using classes ? Using advanced techniques ? Handling errors ? Writing secure code ? Introducing databases ? Introducing MySQL ? Creating and connecting to the ? Creating tables ? Entering data ? Selecting data ? Using multiple tables ? Changing data ? Deleting data ? Preventing database security issues ? Creating user logins ? Turn the case study into a content management system Note: As part of the print version of this title, video lessons are included on DVD. For e-book versions, video lessons can be accessed at wrox.com using a link provided in the interior of the e-book.

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. The Definitive Guide to Microsoft SQL Server 2008 Reporting ServicesCreate and deliver data-rich reports across the enterprise using this complete server-based reporting solution. Written by a member of the original Reporting Services development team, Microsoft SQL Server 2008 Reporting Services covers the entire report-building and distribution process, including data extraction, integration with desktop and Web applications, and end-user access. The book explains how to maximize all of the powerful features, including the new Tablix data format, as well as enhanced performance, scalability, and visualization capabilities. Install, configure, and customize SQL Server 2008 Reporting Services Create SELECT queries to extract data Generate reports from the Report Wizard and from scratch Add charts, images, and gauges Build reusable report templates Use the new Tablix data format to create reports with any structure Export reports to Word, Excel, PDF, HTML, XML, and other formats Enable end-user access to reports via the Report Server and its Report Manager web interface

Pro Server 2008 Policy-Based Management is critical for database administrators seeking in-depth knowledge on administering servers using the new policy-based management features introduced in SQL Server 2008. This book will cover everything from a basic introduction to policy-based management to creating your own custom policies to enforce consistent rules across your organization. * Provides in-depth treatment of policy-based management in a single source* Provides practical usage scenarios for policy-based management* Provides guidance to help meet growing regulatory compliance needsWhat you'll learn* Learn about policy-based management and why you should implement it.* Create policies to maintain a consistent, predictable environment throughout your organization.* Audit organizational compliance with policies automatically, across any number of servers.* Help ensure compliance with PCI rules, HIPAA rules, and other government regulations.* Configure and receive alerts for policy violations.* View and report on the state of your policies.Who this book is for This book is for database administrators who wish to apply consistent management practices across dozens and even hundreds of database servers.

Expert SQL Server 2008 Development is aimed at SQL Server developers ready to move beyond Books Online. Author and experienced developer Alastair Aitchison shows you how to think about SQL Server development as if it were any other type of development. You'll learn to manage testing in SQL Server and to properly deal with errors and exceptions. The book also covers critical, database-centric topics such as managing concurrency and securing your data and code through proper privileges and authorization.

Alastair places focus on sound development and architectural practices that will help you become a better developer, capable of designing high-performance, robust, maintainable database applications. He shows you how to apply notable features in SQL Server such as encryption and support for hierarchical data. If developing for SQL Server is what puts the bread on your table, you can do no better than to read this book and to assimilate the expert-level practices that it provides.Promotes expert-level practices Leads to high performance, scalable code Improves productivity, getting you home in time for dinner What you'll learn How to productively handle errors and exceptions. How to exploit features for managing spatial and temporal data. How to manage tree-structured data using the new, hierarchid type. How to write code that easily survives high concurrency. How to program defensively. How to create proper and reusable test environments for your code. How to secure code and data through encryption and proper application of privilege. Who this book is for

SQL Server developers and administrators. Table of Contents Software Development Methodologies for the Database World Best Practices for Database Programming Testing Database Routines Errors and Exceptions Privilege and Authorization Encryption SQLCLR: Architecture and Design Considerations Dynamic T-SQL Designing Systems for Application Concurrency Working with Spatial Data Working with Temporal Data Trees, Hierarchies, and Graphs

* An essential book for new and migration projects for SQL Server 2005: will ensure that that such projects have a well-designed database and secure, optimized data access strategies right from the start. * Describes all new SQL Server 2005 features related to physical database design and provides completely new chapters on designing for fast data access, and exploiting .NET code in the database for optimum distribution of application logic. * An excellent foundation for MCAD/MCSE/MCDBA Database Design and Implementation exam. * Deep experience and advice, along with many tips or tricks, from an MVP lead author with over ten years of experience with SQL Server.

Get up to speed with Oracle's Autonomous Databases and implementation strategies for any workload or use case, including transactional, data warehousing, and non-relational databases Key Features Explore ADB, its business benefits, and architectural considerations Migrate the existing workload to ADB, explore high availability, and use cloud native methods for monitoring and event notifications Leverage APEX, JSON, the REST API, and SQL Developer Web features for rapid development Book DescriptionOracle Autonomous Database (ADB) is built on the world's fastest Oracle Database Platform, Exadata, and is delivered on Oracle Cloud Infrastructure (OCI), customer data center (ExaCC), and Oracle Dedicated Region Cloud. This book is a fast-paced, hands-on introduction to the most important aspects of OCI Autonomous Databases. You'll get to grips with concepts needed for designing disaster recovery using standby database deployment for Autonomous Databases. As you progress, you'll understand how you can take advantage of automatic backup and restore. The concluding chapters will cover topics such as the security aspects of databases to help you learn about managing Autonomous Databases, along with exploring the features of Autonomous Database security such as Data Safe and customer-managed keys for Vaults. By the end of this Oracle book, you'll be able to build and deploy an Autonomous Database in OCI, migrate databases to ADB, comfortably set up additional high-availability features such as Autonomous Data Guard, and understand end-to-end operations with ADBs. What you will learn Explore migration methods available for Autonomous Databases, using both online and offline methods Create standby databases, RTO and RPO objectives, and Autonomous Data Guard operations Become well-versed with automatic and manual backups available in ADB Implement best practices relating to network, security, and IAM policies Manage database performance and log management in ADB Understand how to perform data masking and manage encryption keys in OCI's Autonomous Databases Who this book is forThis book is for decision makers, enterprise cloud architects, solution consultants, cloud engineers, implementation partners, and technology students, as well as anyone who wants to learn about Oracle's Autonomous Databases delivered on Oracle Cloud Infrastructure (OCI). Beginner-level knowledge of Linux and OCI and networking concepts and databases, along with hands-on experience in OCI environments is required before getting started with this book.

SQL Server 2012 Data Integration Recipes provides focused and practical solutions to real world problems of data integration. Need to import data into SQL Server from an outside source? Need to export data and send it to another system? SQL Server 2012 Data Integration Recipes has your back. You'll find solutions for importing from Microsoft Office data stores such as Excel and Access, from text files such as CSV files, from XML, from other database brands such as Oracle and MySQL, and even from other SQL Server databases. You'll learn techniques for managing metadata, transforming data to meet the needs of the target system, handling exceptions and errors, and much more. What DBA or developer isn't faced with the need to move data back and forth? Author Adam Aspin brings 10 years of extensive ETL experience involving SQL Server, and especially satellite products such as Data Transformation Services and SQL Server Integration Services. Extensive coverage is given to Integration Services, Microsoft's flagship tool for data integration in SQL Server environments.Coverage is also given to the broader range of tools such as OPENDATASOURCE, linked servers, OPENROWSET, Migration Assistant for Access, BCP Import, and BULK INSERT just to name a few. If you're looking for a resource to cover data integration and ETL across the gamut of Microsoft's SQL Server toolset, SQL Server 2012 Data Integration Recipes is the one book that will meet your needs. * Provides practical and proven solutions towards creating resilient ETL environments * Clearly answers the tough questions which professionals ask * Goes beyond the tools to a thorough discussion of the underlying techniques * Covers the gamut of data integration, beyond just SSIS * Includes example databases and files to allow readers to test the recipes What you'll learn * Import and export to and from CSV files, XML files, and other text-based sources. * Move data between SQL databases, including SQL Server and others such as Oracle Database and MySQL. * Discover and manage metadata held in various database systems. * Remove duplicates and consolidate from multiple sources. * Transform data to meet the needs of target systems. * Profile source data as part of the discovery process.* Log and manage errors and exceptions during an ETL process. * Improve efficiency by detecting and processing only changed data. Who this book is for SQL Server 2012 Data Integration Recipes is written for developers wishing to find fast and reliable solutions for importing and exporting to and from SQL Server. The book appeals to DBAs as well, who are often tasked with implementing ETL processes. Developers and DBAs moving to SQL Server from other platforms will find the succinct, example-based approach ideal for quickly applying their general ETL knowledge to the specific tools provided as part of a SQL Server environment. Table of Contents * MS Office Data Sources * Flat File Sources * XML Data Sources * SQL Database Sources * SQL Server Sources * Miscellaneous Data Sources * Exporting Data from SQL Server * Metadata * Data Transformation * Data Profiling * Delta Data Management * Change Tracking and Change Data Capture * Optimising Data Import * ET Process Acceleration * Logging and Auditing * Appendix A: Data Types * Appendix B: Sample Databases and Scripts

This report reviews the impact of trade facilitation initiatives in Asia and the Pacific since the coronavirus disease (COVID-19) pandemic began and discusses how to increase supply chain resilience. Supply chain disruptions caused by the pandemic have underscored the need for digital and paperless trade procedures. A special chapter examines the pandemic's impact on the supply chains of critical goods such as vaccines, personal protective equipment, and food, and provides policy suggestions for enhancing supply chain resilience and trade facilitation. This is the third biennial progress report on trade facilitation implementation in Asia and the Pacific jointly prepared by the Asian Development Bank and the United Nations Economic and Social Commission for Asia and the Pacific.