Your cart is empty
Quickly find solutions to dozens of common problems encountered while using XML and JSON features that are built into SQL Server. Content is presented in the popular problem-solution format. Look up the problem that you want to solve. Read the solution. Apply the solution directly in your own code. Problem solved! This book shows how to take advantage of XML and JSON to share data and automate tasks. JSON is commonly used to move data back and forth between the database and front-end applications, often running in a browser. This book shows all you need to know about transforming query results into JSON format, and back again. Also covered are the processes and techniques for moving data into and out of XML format for business intelligence and other purposes, such as when transferring data from a reporting system into a data warehouse, or between different database brands such as between SQL Server and Oracle. Microsoft intensively implements XML in SQL Server, and in many related products. Execution plans are generated in XML format, and this book shows you how to parse those plans and automate the detection of performance problems. The relatively new Extended Events feature writes tracing data into XML files, and the recipes in this book help in parsing those files. XML is also used in SQL Server's BI tool set, including in SSIS, SSR, and SSAS. XML is used in many configuration files, and is even behind the construction of DDL triggers. In reading this book you'll dive deeply into the features that allow you to build and parse XML, and also JSON, which is a specific format of XML used to transmit objects in a web-friendly format between a database and its front-end applications. What You Will Learn Build XML and JSON objects in support of automation and data transfer Import and parse XML and JSON from operating system files Build appropriate indexes on XML objects to improve query performance Move data from query result sets into JSON format, and back again Automate the detection of database performance problems by querying and parsing the database's own execution plans Replace external and manual JSON processes with SQL Server's internal, JSON functionality Who This Book Is For Database administrators, .NET developers, business intelligence developers, and other professionals who want a deep and detailed skill set around working with XML and JSON in a SQL Server database environment. Web developers will particularly find the book useful for its coverage of transforming database result sets into JSON text that can be transmitted to front-end web applications.
This friendly, easy-to-use guide shows experienced Access users how to use VBA (Visual Basic for Applications) to build Access databases and applications, but also covers programming fundamentals for nonprogrammers Includes practical, ready-to-use VBA code examples that readers can type or copy and paste from the Web into their own database projects Explains basic VBA skills and concepts for nonprogrammers, such as procedures, variables, and loops Covers more advanced topics, such as record sets and other programming activities that are unique to Access programming Author has written more than ninety computer books and has been working with databases since the early 1980s
For all the buzz about trendy IT techniques, data processing is still at the core of our systems, especially now that enterprises all over the world are confronted with exploding volumes of data. Database performance has become a major headache, and most IT departments believe that developers should provide simple SQL code to solve immediate problems and let DBAs tune any "bad SQL" later.
In "The Art of SQL," author and SQL expert Stephane Faroult argues that this "safe approach" only leads to disaster. His insightful book, named after Art of War by Sun Tzu, contends that writing quick inefficient code is sweeping the dirt under the rug. SQL code may run for 5 to 10 years, surviving several major releases of the database management system and on several generations of hardware. The code must be fast and sound from the start, and that requires a firm understanding of SQL and relational theory.
"The Art of SQL" offers best practices that teach experienced SQL users to focus on strategy rather than specifics. Faroult's approach takes a page from Sun Tzu's classic treatise by viewing database design as a military campaign. You need knowledge, skills, and talent. Talent can't be taught, but every strategist from Sun Tzu to modern-day generals believed that it can be nurtured through the experience of others. They passed on their experience acquired in the field through basic principles that served as guiding stars amid the sound and fury of battle. This is what Faroult does with SQL.
Like a successful battle plan, good architectural choices are based on contingencies. What if the volume of this or that table increases unexpectedly? What if, following a merger, the numberof users doubles? What if you want to keep several years of data online? Faroult's way of looking at SQL performance may be unconventional and unique, but he's deadly serious about writing good SQL and using SQL well. "The Art of SQL" is not a cookbook, listing problems and giving recipes. The aim is to get you-and your manager-to raise good questions.
Providing expert knowledge about the features in the new release of DB2 for z/OS, this extensive guide details the innovations of DB2 10's SQL and pureXML enhancements--which increase productivity, enhance performance, and simplify application ports. DB2 for z/OS continues to be the undisputed leader in total system availability, scalability, security, and reliability at the lowest cost per transaction. This resource focuses on the features and functions of DB2 10 for IT, including improving operational efficiencies and reducing costs, as well as covering innovations in resiliency for business-critical information, rapid application and warehouse deployment for business growth, and enhanced business analytics and mathematical functions with QMF.
Loved by instructors for its visual and flexible way to build computer skills, the Illustrated Series is ideal for teaching Microsoft Office Access 2010 to both computer rookies and hotshots. Each two-page spread focuses on a single skill, making information easy to follow and absorb. Large, full-color illustrations represent how the students' screen should look. Concise text introduces the basic principles of the lesson and integrates a case study for further application.
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.
Agile Oracle Application Express shows how skilled, motivated, and self-organizing developers can realize extraordinary commercial benefits from Oracle Application Express. The secret is to couple Application Express with an agile software development approach. This book leads the way.
Agile Oracle Application Express is a must-read for highly skilled and highly motivated Application Express (APEX) developers who are comfortable taking responsibility within a self-organizing team environment. These APEX developers want to raise themselves to a higher level of organizational maturity that will position them to improve on APEX's already highly productive software development platform. Table of Contents Agile Software Development Agile and APEX Core APEXvs. Enhanced APEX Supporting Technologies Project Management Team Development Rules and Guidelines Documentation Quality Assurance Summary
Written by an "in-the-trenches" consultant, this guide hails the newest version of DB2 as a major release, highlighting the large number of totally new features, most notably the addition of XML capabilities. Packed with the information DB2 developers and administrators need to know when implementing version 9, the discussion covers upgrading from prior releases of DB2, converting relational data to XML data, and how DB2 supports industry standard schemas. With detailed examples and useful scripts, users learn how to develop DB2 XML applications, design an XML database, and tune the DB2 XML hybrid database. Extensive information on DB2 optimization of SQL and XML is a particularly useful feature of the book and includes a rundown on import and export utilities that database managers can use in their own installations. Going far beyond the standard manuals and certification guides, this is a truly comprehensive resource that teaches the "why" and "how" of a well-designed and well-implemented DB2 database.
Organizations increasingly need to deal with unstructured processes that traditional business process management (BPM) suites are not designed to deal with. High-risk, yet high-value, loan origination or credit approvals, police investigations, and healthcare patient treatment are just a few examples of areas where a level of uncertainty makes outcome and execution of work flow non-deterministic. Case management is a way to govern and control these unstructured processes and non-deterministic outcomes. Oracle recently completed its BPM technology stack with broad case management functionality and is now able to deliver case management capabilities in a variety of flavors that combine packaged applications and middleware technology. Oracle Case Management Solutions is the first book to translate case management from a business problem perspective into appropriate Oracle product usage. Covering the key Oracle technologies that support case management solution components, it explains how to conceptualize and implement quality case management solutions with these products. The team of authors consists of leading industry consultants engaged in providing case management solutions as well as veteran software product management professionals dealing with tools for building case management applications. The authors share insights gained through their extensive case management experience in terms of its use in solving real-world business problems and in applying technologies to create efficient fit-for-purpose computer applications that embody modern computing trends. Detailing a proven solution architecture and reliable roadmap for case management implementation and adoption, the book includes tutorials with step-by-step instructions on building case management solutions using Oracle Siebel and Oracle BPM suites.
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
MySQL's popularity has brought a flood of questions about how to solve specific problems, and that's where this cookbook is essential. When you need quick solutions or techniques, this handy resource provides scores of short, focused pieces of code, hundreds of worked-out examples, and clear, concise explanations for programmers who don't have the time (or expertise) to solve MySQL problems from scratch. Ideal for beginners and professional database and web developers, this updated third edition covers powerful features in MySQL 5.6 (and some in 5.7). The book focuses on programming APIs in Python, PHP, Java, Perl, and Ruby. With more than 200+ recipes, you'll learn how to: Use the mysql client and write MySQL-based programs Create, populate, and select data from tables Store, retrieve, and manipulate strings Work with dates and times Sort query results and generate summaries Use stored routines, triggers, and scheduled events Import, export, validate, and reformat data Perform transactions and work with statistics Process web input, and generate web content from query results Use MySQL-based web session management Provide security and server administration
The 9th International Conference on Database Systems for Advanced Appli- tions (DASFAA 2004) was held during March 17-19, 2004 on the beautiful Jeju island of Korea. The DASFAA conference provides an international forum for technical discussions among researchers, developers, and users of database - stems from academia, business, and industry. The main focus of DASFAA is on research in database theory, development of advanced DBMS technologies, and their advanced applications. A premier database conference in the Asia/Paci?c region, DASFAA has been held every two years, and in many countries in the - gion. To promote the area further and to answer the needs of many participants, the steering committee decided to hold the conference annually. DASFAA 2004 was the ?rst such annual conference. The conference was organized by the Special Interest Group on Databases (SIGDB) of the Korea Information Science Society and the Advanced Infor- tion Technology Research Center (AITrc) at KAIST - an engineering research center of excellence (ERC) supported by the Korea Science and Engineering Foundation (KOSEF). We had a number of sponsors who made generous cont- butionstomaketheconferencesuccessful. TheyareOracleKorea, SamsungSDS, Korea Telecom Data, Inc., the United States Air Force O?ce of Scienti?c Re- arch, theAsianO?ceofAerospaceResearch&Development, theArmyResearch O?ce-Far East, and the Korea Advanced Institute of Science and Technology (KAIST).
Your hands-on, step-by-step guide to building applications with Microsoft SQL Server 2012
Teach yourself the programming fundamentals of SQL Server 2012--one step at a time. Ideal for beginning SQL Server database administrators and developers, this tutorial provides clear guidance and practical, learn-by-doing exercises for building database solutions that solve real-world business problems.
Discover how to: Install and work with core components and tools Create tables and index structures Manipulate and retrieve data Secure, manage, back up, and recover databases Apply techniques for building high-performing applications Use clustering, database mirroring, and log shipping
You may like...
Tim Tinius Paperback R687 Discovery Miles 6 870
Database Systems: Pearson New…
Hector Garcia-Molina, Jeffrey Ullman, … Paperback R1,722 Discovery Miles 17 220
Oracle Database 10g RMAN Backup…
Matthew Hart, Robert Freeman Paperback
Portable DBA Oracle
Robert Freeman Paperback
Oracle Exalogic Elastic Cloud Handbook
Tom Plunkett, Tj Palazzolo, … Paperback
Professional Microsoft SQL Server 2016…
Paul Turley Paperback
Oracle Business Process Management Suite…
Manoj Das, Manas Deb, … Paperback
Oracle Database Administration for…
Michelle Malcher Paperback
Robin Nixon Paperback
SAP HANA XSA - Native Development for…
Francesco Alborghetti, Jonas Kohlbrenner, … Hardcover