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 number of 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.

    Git permits virtually an infinite variety of methods for development and collaboration. Created by Linus Torvalds to manage development of the Linux kernel, it's become the principal tool for distributed version control. But Git's flexibility also means that some users don't understand how to use it to their best advantage. Version Control with Git offers tutorials on the most effective ways to use it, as well as friendly yet rigorous advice to help you navigate Git's many functions. With this book, you will:Learn how to use Git in several real-world development environments Gain insight into Git's common-use cases, initial tasks, and basic functions Understand how to use Git for both centralized and distributed version control Use Git to manage patches, diffs, merges, and conflicts Acquire advanced techniques such as rebasing, hooks, and ways to handle submodules (subprojects) Learn how to use Git with Subversion Git has earned the respect of developers around the world. Find out how you can benefit from this amazing tool with Version Control with Git.

    Almost everything you've read about formatting pictures for Kindle is wrong. The advice offered by Kindle experts and even Amazon itself can give images that are tiny, blocky, noisy, or wildly inconsistent on different Kindles. Aaron Shepard, author of acclaimed books on both Kindle and print publishing, brings his years of experience in book design, webmastering, and photography to bear on a single question: How do you make pictures look great on the Kindle? He answers that question, while also providing beginners a basic course in picture editing. Along the way, he discusses how to keep Microsoft Word from sneakily degrading your pictures; how to adjust HTML code to show images at their best; how to make part of a picture transparent against colored backgrounds; how to boost the power of your cover image as a marketing tool; and how to create anything from children's books to photography books to poetry books within minutes with the Kindle Comic Creator. Nowhere else will you find such in-depth info on working with Kindle images. Whatever kind you're using -- photos, paintings, drawings, diagrams, tables, screenshots -- you'll find -Pictures on Kindle- an essential guide. ///////////////////////////////////////////////// Aaron Shepard is a foremost proponent of the new business of profitable self publishing, which he has practiced and helped develop since 1998. He is the author of -Aiming at Amazon, - -POD for Profit, - -Perfect Pages, - and -From Word to Kindle, - Amazon's #1 bestselling paid book on Kindle formatting. ///////////////////////////////////////////////// REVIEWS -Far and away the best resource I know for self publishers who plan to include photos or other graphics in their Kindle books. From tips on taking photos, through sizing, optimizing, and placing, this book wastes no space in giving you exactly the information you need. Highly recommended.- -- Joel Friedlander, TheBookDesigner.com -A detailed, comprehensive guide to getting the best out of your images on Kindle. From taking photos, to scanning, to optimizing, Aaron covers every possible step in making sure your images display well in Kindle format. In addition, he provides very useful explanations of the Kindle's image handling, for those of us who like to understand the reasons behind the steps. I for one will be adding this to my list of reference materials.- -- Jim Brown, JimandZetta.com (ebook services) ///////////////////////////////////////////////// CONTENTS Getting Started 1 PICTURE BASICS File Formats Resolution Color Mode Color Space 2 PICTURE SOURCES Photography Scanning 3 PICTURE EDITING Cleanup and Repair Cropping Contrast, Brightness, Tint Sizing Sharpening Transparency Lines and Letters 4 PICTURE HANDLING Positioning Pictures in Word Pictures in HTML Fixed Format 5 PICTURE PUBLISHING Submitting and Previewing Cover Images Production FAQ

    In 1985, a new version of the language was developed, incorporating additional features such as multiple input files, dynamic regular expressions, and user-defined functions. This new version is available for both Unix and MS-DOS. This is the first book on AWK. It begins with a tutorial that shows how easy AWK is to use. The tutorial is followed by a comprehensive manual for the new version of AWK. Subsequent chapters illustrate the language by a range of useful applications, such as: Retrieving, transforming, reducing, and validating data Managing small, personal databases Text processing Little languages Experimenting with algorithms The examples illustrates the books three themes: showing how to use AWK well, demonstrating AWKs versatility, and explaining how common computing operations are done. In addition, the book contains two appendixes: summary of the language, and answers to selected exercises.

    This is necessary because, in the words of Michael Polanyi, "we can know more than we can tell." Our design choices are not the result of an ineluctable chain of logic; they come from a deeper place, one which is visceral and inarticulate.Polanyi calls this "tacit knowledge", a thing which we only understand as part of something else. When we speak, we do not focus on making sounds, we focus on our words. We understand the muscular act of speech, but would struggle to explain it.To write software, we must learn where to draw boundaries. Good software is built through effective indirection. We seem to have decided that this skill can only be learned through practice; it cannot be taught, except by example. Our decisions may improve with time, but not our ability to explain them. It's true that the study of these questions cannot yield a closed-form solution for judging software design. We can make our software simple, but we cannot do the same to its problem domain, its users, or the physical world. Our tacit knowledge of this environment will always inform our designs.This doesn't mean that we can simply ignore our design process. Polanyi tells us that tacit knowledge only suffices until we fail, and the software industry is awash with failure. Our designs may never be provably correct, but we can give voice to the intuition that shaped them. Our process may always be visceral, but it doesn't have to be inarticulate.And so this book does not offer knowledge, it offers clarity. It is aimed at readers who know Clojure, but struggle to articulate the rationale of their designs to themselves and others. Readers who use other languages, but have a passing familiarity with Clojure, may also find this book useful.

    This practical guide not only shows you how to search, analyze, and explore data with Elasticsearch, but also helps you deal with the complexities of human language, geolocation, and relationships.If you're a newcomer to both search and distributed systems, you'll quickly learn how to integrate Elasticsearch into your application. More experienced users will pick up lots of advanced techniques. Throughout the book, you'll follow a problem-based approach to learn why, when, and how to use Elasticsearch features.Understand how Elasticsearch interprets data in your documentsIndex and query your data to take advantage of search concepts such as relevance and word proximityHandle human language through the effective use of analyzers and queriesSummarize and group data to show overall trends, with aggregations and analyticsUse geo-points and geo-shapes--Elasticsearch's approaches to geolocationModel your data to take advantage of Elasticsearch's horizontal scalabilityLearn how to configure and monitor your cluster in production

    It runs on PCs rather than servers and is ideal for small- to mid-sized businesses and households. But Access is still intimidating to learn. It doesn't help that each new version crammed in yet another set of features; so many, in fact, that even the pros don't know where to find them all. Access 2007 breaks this pattern with some of the most dramatic changes users have seen since Office 95. Most obvious is the thoroughly redesigned user interface, with its tabbed toolbar (or "Ribbon") that makes features easy to locate and use. The features list also includes several long-awaited changes. One thing that hasn't improved is Microsoft's documentation. To learn the ins and outs of all the features in Access 2007, Microsoft merely offers online help.Access 2007: The Missing Manual was written from the ground up for this redesigned application. You will learn how to design complete databases, maintain them, search for valuable nuggets of information, and build attractive forms for quick-and-easy data entry. You'll even delve into the black art of Access programming (including macros and Visual Basic), and pick up valuable tricks and techniques to automate common tasks -- even if you've never touched a line of code before. You will also learn all about the new prebuilt databases you can customize to fit your needs, and how the new complex data feature will simplify your life. With plenty of downloadable examples, this objective and witty book will turn an Access neophyte into a true master.

    TCP/IP Protocol Suite teaches students and professionals, with no prior knowledge of TCP/IP, everything they need to know about the subject. This comprehensive book uses hundreds of figures to make technical concepts easy to grasp, as well as many examples, which help tie the material to the real-world. The second edition of TCP/IP Protocol Suite has been fully updated to include all of the recent technology changes in the field. Many new chapters have been added such as one on Mobile IP, Multimedia and Internet, Network Security, and IP over ATM. Additionally, out-of-date material has been overhauled to reflect recent changes in technology.

    You will save 33% with this offer. Please hurry up!Have you ever considered signing up to Amazon Prime or Kindle Unlimited? Are you already a member of one of these schemes but want to learn how to make the most of your membership? If so then look no further than this book, which offers readers first-hand advice on the benefits and pitfalls of Amazon Prime, as well as a comprehensive guide to how to make the most of your membership.In today's age it can be a daunting prospect when faced with various different offers, subscriptions and devices to know which will provide the best value for money as well as deliver the most high quality service. As our lives becoming increasingly technological, and we move towards using electronic devices, we face even more choice. These choices can have a significant impact on our finances, and choosing the best option will avoid the risk of signing up to expensive or hard to break contracts.This book includes: Introduction The History of Amazon An Overview of Amazon Prime Amazon Instant Video Prime Music Kindle Unlimited Conclusion Download your copy of "Amazon Prime and Kindle Lending Library" by scrolling up and clicking "Buy Now With 1-Click" button. Tags: Amazon Prime, amazon prime lending library, amazon prime membership, lending library for prime members, lending library, prime lending library, free books, Prime Subscription, Kindle Owners With Amazon Prime, Kindle Owners, Free Ebooks, free TV Series, free Movie, ULTIMATE Guide for Beginners, ULTIMATE Guide, Beginners Guide, Prime Music, Amazon Prime and Kindle Lending Library

    The twelve-factor app is a methodology for building software-as-a-service apps that: - Use declarative formats for setup automation, to minimize time and cost for new developers joining the project; - Have a clean contract with the underlying operating system, offering maximum portability between execution environments; - Are suitable for deployment on modern cloud platforms, obviating the need for servers and systems administration; - Minimize divergence between development and production, enabling continuous deployment for maximum agility; - And can scale up without significant changes to tooling, architecture, or development practices.The twelve-factor methodology can be applied to apps written in any programming language, and which use any combination of backing services (database, queue, memory cache, etc).

    Do you want to get the most out of your new Kindle Fire HDX? If you are looking for a top-notch tutorial at a reasonable cost, you've come to the right place! Here is the book that will teach you 100% of what you need to know. Kindle Fire HDX Tips, Tricks, and Traps: A How-To Tutorial for the Kindle Fire HDX is your detailed guide to getting the maximum benefit from your Kindle Fire HDX.In this comprehensive guide, you'll learn tips (ways to effectively use your Kindle Fire), tricks (ways to improve the operation of your Kindle Fire), and traps (things to avoid to prevent problems while using your Kindle Fire). You will learn-• How to get around within the user interface, the home screen, and the carousel more efficiently• How to make your Kindle Fire HDX your own, customizing its display and operation for fastest and easiest use• How to use features that are new to the HDX line, including Google or Outlook Calendar and Contacts synchronization, Microsoft Exchange corporate e-mail support, and Amazon’s ‘Mayday’ online technical support• How to use the built-in cameras (front-facing in the 7-inch model, front-and-rear facing in the 8.9-inch model) to take photos and videos• How to setup the security options to protect your account information• How you can provide a safe environment for children using parental controls and Kindle FreeTime• How you can move your iTunes or other music library to your Kindle Fire HDX• How you can download YouTube videos to your Kindle Fire HDX• Suggested apps that no Kindle Fire owner should be withoutYou will learn all of the above and more, with Kindle Fire Tips, Tricks, and Traps: A How-To Tutorial for the Kindle Fire HDX as a part of your library. With this book, you will learn 100% of what you need to know to get the most out of your new Kindle Fire HDX! Kindle Fire HDX Tips, Tricks, and Traps: A How-To Tutorial for the Kindle Fire HDX comes from the pen of Edward Jones, the principal technology writer behind the "Get-it-Done" series of computer books. Jones is an experienced computer and technology writer, database applications development analyst, consultant, and trainer who understands the issues faced by people dealing with technology, day in and day out. His career spans years of technology training, database development, and consulting services for major law firms and government agencies in the Washington, DC area, and he currently resides in Charlotte, NC where he is concentrating on providing publications to the rapidly growing digital marketplace. Jones is also a best-selling author whose printed titles have sold over one million copies, and he has served as a technical editor on numerous computer books.

    With this hands-on reference, you'll focus on implementation rather than theory, and discover why the RESTful method is far better than technologies like CORBA and SOAP. It's easy to get started with services based on the REST architecture. RESTful Java with JAX-RS includes a technical guide that explains REST and JAX-RS, how they work, and when to use them. With the RESTEasy workbook that follows, you get step-by-step instructions for installing, configuring, and running several working JAX-RS examples using the JBoss RESTEasy implementation of JAX-RS.Work on the design of a distributed RESTful interface, and develop it in Java as a JAX-RS serviceDispatch HTTP requests in JAX-RS, and learn how to extract information from themDeploy your web services within Java Enterprise Edition using the Application class, Default Component Model, EJB Integration, Spring Integration, and JPADiscover several options for securing your web servicesLearn how to implement RESTful design patterns using JAX-RSWrite RESTful clients in Java using libraries and frameworks such as java.net.URL, Apache HTTP Client, and RESTEasy Proxy

    It is a testament to the remarkable and mysterious work during World War II that made it a place worth saving. It is a book about campaigners, veterans, enthusiasts, computer geeks, technology, Twitter, trees and Stephen Fry stuck in a lift.And finally, it is a story about preserving the past for the generations of tomorrow.

    This practical guide shows how Apache ZooKeeper helps you manage distributed systems, so you can focus mainly on application logic. Even with ZooKeeper, implementing coordination tasks is not trivial, but this book provides good practices to give you a head start, and points out caveats that developers and administrators alike need to watch for along the way.In three separate sections, ZooKeeper contributors Flavio Junqueira and Benjamin Reed introduce the principles of distributed systems, provide ZooKeeper programming techniques, and include the information you need to administer this service.Learn how ZooKeeper solves common coordination tasksExplore the ZooKeeper API’s Java and C implementations and how they differUse methods to track and react to ZooKeeper state changesHandle failures of the network, application processes, and ZooKeeper itselfLearn about ZooKeeper’s trickier aspects dealing with concurrency, ordering, and configurationUse the Curator high-level interface for connection managementBecome familiar with ZooKeeper internals and administration tools