Build smarter and efficient database application systems for your organization with SQL Server 2017 About This Book ? Build database applications by using the development features of SQL Server 2017 ? Work with temporal tables to get information stored in a table at any time ? Use adaptive querying to enhance the performance of your queries Who This Book Is For Database developers and solution architects looking to design efficient database applications using SQL Server 2017 will find this book very useful. In addition, this book will be valuable to advanced analysis practitioners and business intelligence developers. Database consultants dealing with performance tuning will get a lot of useful information from this book as well. Some basic understanding of database concepts and T-SQL is required to get the best out of this book. What You Will Learn ? Explore the new development features introduced in SQL Server 2017 ? Identify opportunities for In-Memory OLTP technology ? Use columnstore indexes to get storage and performance improvements ? Exchange JSON data between applications and SQL Server ? Use the new security features to encrypt or mask the data ? Control the access to the data on the row levels ? Discover the potential of R and Python integration ? Model complex relationships with the graph databases in SQL Server 2017 In Detail Microsoft SQL Server 2017 is the next big step in the data platform history of Microsoft as it brings in the power of R and Python for machine learning and containerization-based deployment on Windows and Linux. Compared to its predecessor, SQL Server 2017 has evolved into Machine Learning with R services for statistical analysis and Python packages for analytical processing. This book prepares you for more advanced topics by starting with a quick introduction to SQL Server 2017’s new features and a recapitulation of the possibilities you may have already explored with previous versions of SQL Server. The next part introduces you to enhancements in the Transact-SQL language and new database engine capabilities and then switches to a completely new technology inside SQL Server: JSON support. We also take a look at the Stretch database, security enhancements, and temporal tables. Furthermore, the book focuses on implementing advanced topics, including Query Store, columnstore indexes, and In-Memory OLTP. Towards the end of the book, you’ll be introduced to R and how to use the R language with Transact-SQL for data exploration and analysis. You’ll also learn to integrate Python code in SQL Server and graph database implementations along with deployment options on Linux and SQL Server in containers for development and testing. By the end of this book, you will have the required information to design efficient, high-performance database applications without any hassle. Style and approach This book is a detailed guide to mastering the development features offered by SQL Server 2017, with a unique learn-as-you-do approach. All the concepts are explained in a very easy-to-understand manner and are supplemented with examples to ensure that you—the developer—are able to take that next step in building more powerful, robust applications for your organization with ease.

This book is a tutorial guide that covers each topic in depth with examples. The stepbystep approach will help you better understand each task as you will have to perform them frequently when utilizing the services. If you are a Dynamics AX developer, new or experienced who wants to implement services with Microsoft Dynamics AX 2012, then this book is for you. A basic understanding of MorphX and X++ is assumed, but the stepbystep instructions are easy to follow even for beginners. Some examples use C# and .NET, so experience with Visual Studio is a plus but not a must.

This practical cookbook covers a broad range of topics in an easytounderstand manner. Stepbystep instructions guide you through even the most complicated of tools in Minitab. This book is great for anyone who is familiar with statistics and who wants to learn how Minitab works. Whilst you do not need to be an expert in all areas of statistics, you should understand the basics of the chapters you are interested in.

This book is a handson practical guide that provides the reader with a number of clear scenarios and examples, making it easier to understand and apply the new concepts. Each chapter can be used as a reference, or it can be read from beginning to end, allowing consultants/administrators to build a solid and highly available Exchange 2013 environment. If you are a messaging professional who wants to learn to design a highly available Exchange 2013 environment, this book is for you. Although not a definite requirement, practical experience with Exchange 2010 is expected, without being a subject matter expert.

A practical guide packed with stepbystep recipes to design a virtual datacenter using VMware 5.x This book is a guide for anyone interested in designing virtualized datacenters using VMware vSphere 5.x and the supporting components. Current administrators of VMware vSphere environments will find this book useful when interested in becoming a vSphere Architect or are interested in learning more about the virtual datacenter design process. Knowledge of vSphere installation, configuration, and administration is a prerequisite.

This is a practical cookbook that dives into the various methods of programming graphics with a focus on games. It is a perfect package of all the innovative and uptodate 3D rendering techniques supported by numerous illustrations, strong sample code, and concise explanations. Direct3D Rendering Cookbook is for C# .NET developers who want to learn the advanced rendering techniques made possible with DirectX 11.2. It is expected that the reader has at least a cursory knowledge of graphics programming, and although some knowledge of Direct3D 10+ is helpful, it is not necessary. An understanding of vector and matrix algebra is required.

An easytofollow, handson guide that clearly explains the various components of the Heroku platform and provides stepbystep guidance as well as numerous examples on how to build and troubleshoot robust and scalable productionready web applications on the Heroku platform. This book is intended for those who want to learn Heroku the right way. Perhaps you are new to Heroku or are someone who has heard about Heroku but have not built anything significant with it. You should have knowledge or familiarity with cloud computing and basic knowledge of database and network deployment.

This is a stepbystep, taskbased, practical guide to learning and getting your basic XenDesktop 7.x site up and running. It is fast, easy, and makes learning desktop and application virtualization simple. If you are a system administrator, consultant, or beginner who wants to implement and administer Citrix XenDesktop sites, then this book is for you. Familiarity with virtualization of desktops and applications and datacenter concepts will be helpful. The ability to read network diagrams and understand servers, data flow, clients, devices, and the interworking of these pieces will be beneficial.

Write efficient, clean, and reusable code with ScalaAbout This BookUnleash the power of Scala and apply it in the real worldIncrease your efficiency by leveraging the power of Creational, Structural, Behavioural, and Functional design patternsBuild object oriented and functional applications quickly and effectivelyWho This Book Is ForIf you want to increase your understanding of Scala and apply it to real-life application development, then this book is for you. We’ve also designed the book to be used as a quick reference guide while creating applications. Previous Scala programming knowledge is expected.What You Will LearnImmerse yourself in industry-standard design patterns—structural, creational, and behavioral—to create extraordinary applicationsFeel the power of traits and their application in ScalaImplement abstract and self types and build clean design patternsBuild complex entity relationships using structural design patternsCreate applications faster by applying functional design patternsIn DetailScala has become increasingly popular in many different IT sectors. The language is exceptionally feature-rich which helps developers write less code and get faster results. Design patterns make developer’s lives easier by helping them write great software that is easy to maintain, runs efficiently and is valuable to the company or people concerned.You will learn about the various features of Scala and be able to apply well-known, industry-proven design patterns in your work. The book starts off by focusing on some of the most interesting features of Scala while using practical real-world examples. We will also cover the popular "Gang of Four" design patterns and show you how to incorporate functional patterns effectively. By the end of this book, you will have enough knowledge and understanding to quickly assess problems and come up with elegant solutions.Style and approachThe design patterns in the book will be explained using real-world, step-by-step examples. For each design pattern, there will be hints about when to use it and when to look for something more suitable. This book can also be used as a practical guide, showing you how to leverage design patterns effectively.

Install, configure, and support your XenApp systems with the power of Citrix XenAppAbout This BookFamiliarize yourself with Citrix applications and desktop virtualizationMaintain and troubleshoot your XenApp environment to minimize system downtimeA hands-on, step-by-step guide with a practical approach and real-world examples to get you up and running with XenApp systemsWho This Book Is ForThis book is intended for IT administrators and consultants who want to build application and desktop virtualization solutions for their employers and customers. No prior knowledge of Citrix technologies is required.What You Will LearnMake the use case for Citrix XenApp and design your first systemPrepare your existing IT infrastructure for XenApp and learn what licenses you needInstall and configure the XenApp infrastructureEnable access with StoreFront and NetScaler GatewayEnable load balancing with NetScalerMaintain servers and publish applications and desktopsManage printing in a Citrix environmentTroubleshoot your environment using advanced tools and methodologies employed by Citrix Escalation TeamsIn DetailIf you want to effectively deploy the various components of Citrix XenApp to create an enterprise environment for application and desktop delivery, this hands-on guide is perfect for you. You start off by understanding the need and benefits of Citrix XenApp with respect to Virtualization technology. After this, you will get to grips with the requirement analysis and designing aspect of building XenApp systems and all the necessary installation and configuration procedures for Citrix XenApp, StoreFront and NetScalar Gateway are explained one by one in detail.Step-by-step, you will learn to deploy your first XenApp with the Machine Creation Services method and Provisioning Services method. After this, you will explore the administering part of applications and systems, followed by printing in the XenApp environment. Next, you will learn all the trips and tricks required to troubleshoot and support the XenApp environment. By the end of this book, you will be ready to go live with your new XenApp environment.Style and approachThis is a step-by-step guide to technical implementations in a conversational and easy-to-follow style. Each component is deployed sequentially until a full solution is built. Basic as well as advanced features of the product are explored to appeal to the widest possible audience interested in the topic.

Explore the capabilities of Dynamics NAV 2016 and discover all you need to implement it About This Book Learn the key roles of your Dynamics NAV partner and the roles within your customer’s organization Create configuration packages and perform data migration on your own Find out how to troubleshoot your problems effectively with your Dynamics NAV partner Who This Book Is For This book is for Dynamics NAV partners and end users who want to know everything about Dynamics NAV implementations. It is aimed at those who want to be project managers or get involved with Dynamics NAV, but do not have the expertise to write code themselves. What You Will Learn Study the roles within a Dynamics NAV partner and within a customer’s company Create reusable data migration packages Work with the debugger to pinpoint error messages Get to grips with the key tables used in data reporting and analysis Successfully upgrade your installation to the latest version Manage and expand your existing installation with additional functionalities Explore the free third-party add-ons that can leverage your existing installation In Detail Microsoft Dynamics NAV 2016 is an Enterprise Resource Planning (ERP) application used in all kinds of organizations around the world. It provides a great variety of functionality out-of-the-box in different topics such as accounting, sales, purchase processing, logistics, or manufacturing. It also allows companies to grow the application by customizing the solution to meet specific requirements. This book is a hands-on tutorial on working with a real Dynamics NAV implementation. You will learn about the team from your Microsoft Dynamics NAV partner as well as the team within the customer’s company. This book provides an insight into the different tools available to migrate data from the client’s legacy system into Microsoft Dynamics NAV. If you are already live with Microsoft Dynamics NAV, this books talks about upgrades and what to expect from them. We’ll also show you how to implement additional or expanding functionalities within your existing Microsoft Dynamics NAV installation, perform data analysis, debug error messages, and implement free third-party add-ons to your existing installation. This book will empower you with all the skills and knowledge you need for a successful implementation. Style and approach This book is step-by-step guide to implementing Dynamics NAV from start to finish.

This easy-to-understand tutorial covers Oracle Warehouse Builder from the ground up, and taps into the author's wide experience as a software and database engineer. Written in a relaxed style with step-by-step explanations, lots of screenshots are provided throughout the book. There are numerous tips and helpful hints throughout that are not found in the original documentation. By following this book, you can use Oracle Warehouse Builder in the best possible way and maximize your learning potential. This book is a good starting point for database engineers, administrators, and architects who are responsible for data warehouse projects and need to design them and load data into them. If you are someone who wants to learn Oracle Warehouse Builder and expand your knowledge of the tool and data warehousing, this is an ideal book for you. No prior data warehouse or database experience is presumed with all new database and data warehouse technical terms and concepts explained in clear easy-to-understand language.

If you have some experience with App-V but are overwhelmed by the range of features on offer, then this book is for you. A basic understanding of App-V and common Windows Server technologies (Active Directory/Group Policy/PowerShell) is necessary.

This book is perfect for people who have never used Odoo and for those who would like to learn about more advanced concepts of Odoo. In order to get the most out of this book, you should be comfortable with understanding basic business concepts such as sales, purchasing, inventory management, and basic accounting.

If you are a system administrator or an experienced IT professional who wants to refer to a centralized container of procedures and advanced tasks in XenDesktop, this is the book for you. Experience of the virtualized environment and an understanding of the general concepts of desktop virtualization (VDI) are required.

If you are a Python developer who wants to master the world of data science, then this book is for you. Some knowledge of data science is assumed.

With this book you will explore WebSphere Application Server security concepts, which you can expand upon while working on mini-projects. With the author's style of writing you will gain the knowledge and confidence needed to implement WebSphere Application Servers securely. Right from the basics of securing your WebSphere Application Server to advanced security features, the author utilizes exercises, screenshots, and clear instructions. If you are a system administrator or an IT professional who wants to learn about the security side of the IBM WebSphere Application Server v7.0, this book will walk you through the key aspects of security and show you how to implement them. You do not need any previous experience in WebSphere Application Server, but some understanding of Java EE technologies will be helpful. In addition, Java EE application developers and architects who want to understand how the security of a WebSphere environment affects Java EE enterprise applications will find this book useful.

More than just a step-by-step guide, this book offers examples, tips, and tricks that are all discussed in detail, providing the reader with the knowledge and confidence to implement them. Supporting diagrams, illustrations, and screenshots promote understanding and enhance the overall reading experience. The author's onsite experience in implementing Oracle GoldenGate in the financial sector is thoroughly reflected in this book. This book is for Solution Architects and Database Architects who wish to learn about the functionality and efforts required in implementing a data replication, migration or integration solution using GoldenGate. It is also designed for System Administrators and Database Administrators who want to implement, or those who have already implemented, Goldengate and who want to explore its advanced features. An intermediate understanding of Oracle database technology is assumed.

This is a practical, tutorial-style book that includes many examples that demonstrate how to develop EJB 3.0 database persistence applications with Oracle Fusion Middleware 11g. Every chapter starts with setting the environment for the chapter and includes an example application illustrated with figures at milestone stages. This book is aimed at EJB 3.0 application developers who want to learn about the practical use of EJB 3.0 database persistence with Oracle Fusion Middleware. Those who are already using EJB 3.0 database persistence will learn about using EJB 3.0 database persistence with Oracle Fusion Middleware 11g. The target audience is expected to have some prior knowledge about Java EE, EJBs, EJB 3.0, JSF, AJAX, web services, and XML. This book is ideal for those developers who have working knowledge of JDeveloper and WebLogic server, and wish to learn about the practical use of EJB 3.0 with Oracle Fusion Middleware.

Written in an engaging, easy-to-follow style, the recipes will help you to extend the capabilities of ElasticSearch to manage your data effectively.If you are a developer who implements ElasticSearch in your web applications, manage data, or have decided to start using ElasticSearch, this book is ideal for you. This book assumes that you’ve got working knowledge of JSON and Java

Written in a cookbook style, this book will teach you through the use of recipes with examples and illustrations. Each recipe contains step-by-step instructions about everything necessary to execute a particular task.This book is intended for both BI and database developers who want to expand their knowledge of MicroStrategy. It is also useful for advanced data analysts who are evaluating different technologies. You do not need to be an SQL master to read this book, yet knowledge of some concepts like foreign keys and many-to-many relationships is assumed. Some knowledge of basic concepts such as dimensional modeling (fact tables, dimensions) will also help your comprehension of this book. No previous MicroStrategy knowledge is needed.