Verleger: K-i-s-publishing
SQL Server 2017 Machine Learning Services with R. Data exploration, modeling, and advanced analytics
Julie Koesmarno, Toma?ae Ka?°trun
R Services was one of the most anticipated features in SQL Server 2016, improved significantly and rebranded as SQL Server 2017 Machine Learning Services. Prior to SQL Server 2016, many developers and data scientists were already using R to connect to SQL Server in siloed environments that left a lot to be desired, in order to do additional data analysis, superseding SSAS Data Mining or additional CLR programming functions. With R integrated within SQL Server 2017, these developers and data scientists can now benefit from its integrated, effective, efficient, and more streamlined analytics environment. This book gives you foundational knowledge and insights to help you understand SQL Server 2017 Machine Learning Services with R. First and foremost, the book provides practical examples on how to implement, use, and understand SQL Server and R integration in corporate environments, and also provides explanations and underlying motivations. It covers installing Machine Learning Services;maintaining, deploying, and managing code;and monitoring your services. Delving more deeply into predictive modeling and the RevoScaleR package, this book also provides insights into operationalizing code and exploring and visualizing data. To complete the journey, this book covers the new features in SQL Server 2017 and how they are compatible with R, amplifying their combined power.
Marek Chmel, Vladimir Muzny
SQL Server is one of the most popular relational database management systems developed by Microsoft. This second edition of the SQL Server Administrator's Guide will not only teach you how to administer an enterprise database, but also help you become proficient at managing and keeping the database available, secure, and stable.You’ll start by learning how to set up your SQL Server and configure new and existing environments for optimal use. The book then takes you through designing aspects and delves into performance tuning by showing you how to use indexes effectively. You’ll understand certain choices that need to be made about backups, implement security policy, and discover how to keep your environment healthy. Tools available for monitoring and managing a SQL Server database, including automating health reviews, performance checks, and much more, will also be discussed in detail. As you advance, the book covers essential topics such as migration, upgrading, and consolidation, along with the techniques that will help you when things go wrong. Once you’ve got to grips with integration with Azure and streamlining big data pipelines, you’ll learn best practices from industry experts for maintaining a highly reliable database solution.Whether you are an administrator or are looking to get started with database administration, this SQL Server book will help you develop the skills you need to successfully create, design, and deploy database solutions.
Steve Hughes, Baya Dewald, Paul Turley
Microsoft SQL Server is a relational database management system. As a database, it is a software product whose primary function is to store and retrieve data as requested by other software applications. SQL Server Analysis Services adds OLAP and data mining capabilities for SQL Server databases. OLAP (online analytical processing) is a technique for analyzing business data for effective business intelligence.This practical guide teaches you how to build business intelligence solutions using Microsoft’s core product – SQL Server Analysis Services. The book covers the traditional multi-dimensional model which has been around for over a decade as well as the tabular model introduced with SQL Server 2012.Starting with comparing MultiDimensional and tabular models – discussing the values and limitations of each, you will then cover the essential techniques for building dimensions and cubes. Following on from this, you will be introduced to more advanced topics, such as designing partitions and aggregations, implementing security, and synchronizing databases for solutions serving many users.The book also covers administrative material, such as database backups, server configuration options, and monitoring and tuning performance. We also provide a primer on MultiDimensional eXpressions (MDX) as well as Data Analysis expressions (DAX) languages.This book provides you with data cube development techniques, and also the ongoing monitoring and tuning for Analysis Services.
Joey D'Antoni, Louis Davidson, Allan Hirt, John...
Deploying SQL Server on Azure virtual machines allows you to work on full versions of SQL Server in the cloud without having to maintain on-premises hardware. The book begins by introducing you to the SQL portfolio in Azure and takes you through SQL Server IaaS scenarios, before explaining the factors that you need to consider while choosing an OS for SQL Server in Azure VMs. As you progress through the book, you'll explore different VM options and deployment choices for IaaS and understand platform availability, migration tools, and best practices in Azure. In later chapters, you'll learn how to configure storage to achieve optimized performance. Finally, you'll get to grips with the concept of Azure Hybrid Benefit and find out how you can use it to maximize the value of your existing on-premises SQL Server.By the end of this book, you'll be proficient in administering SQL Server on Microsoft Azure and leveraging the tools required for its deployment.
SQL Server on Linux. Configuring and administering your SQL Server solution on Linux
Jasmin Azemovifá
Microsoft's launch of SQL Server on Linux has made SQL Server a truly versatile platform across different operating systems and data-types, both on-premise and on-cloud.This book is your handy guide to setting up and implementing your SQL Server solution on the open source Linux platform. You will start by understanding how SQL Server can be installed on supported and unsupported Linux distributions. Then you will brush up your SQL Server skills by creating and querying database objects and implementing basic administration tasks to support business continuity, including security and performance optimization. This book will also take you beyond the basics and highlight some advanced topics such as in-memory OLTP and temporal tables.By the end of this book, you will be able to recognize and utilize the full potential of setting up an efficient SQL Server database solution in your Linux environment.
Benjamin Nevarez
SQL Server is a relational database management system developed by Microsoft. As a database server, it is a software product with the primary function of storing and retrieving data as requested by other software applications.This book starts by describing the inner workings of the query optimizer, and will enable you to use this knowledge to write better queries and provide the query engine with all the information it needs to produce efficient execution plans. As you progress, you’ll get practical query optimization tips for troubleshooting underperforming queries. The book will also guide you through intelligent query processing and what is new in SQL Server 2022. Query performance topics such as the Query Store, In-Memory OLTP and columnstore indexes are covered as well.By the end of this book, you’ll be able to get the best possible performance for your queries and applications.
Kelsey Gilbert Kreiling, Mallory Ulaszek
You may have heard about Squarespace and even started a trial site, but launching it can be a real challenge for new users. While the basic features look simple enough, shaping Squarespace to fit your business needs requires expert help. That’s where author and Squarespace expert Kelsey Gilbert Kreiling can help. Squarespace from Signup to Launch is a comprehensive resource for customizing the most design-focused and user-friendly website builder in the no-code world.Enriched with insights and resources from Squarespace experts such as Christy Price, Will Myers, David Iskander, Kristine Neil, Kathryn Joachim, Beatriz Caraballo, Justin Mabee, Shelly Morse, and more, this book goes beyond a technical manual. It prepares you to build a website, explains the foundational knowledge behind Squarespace 7.1 and Fluid Engine, and fosters a professional designer's mindset. Throughout the book, you’ll learn how to build forms, use content blocks, optimize websites for mobile, build an online store, and become proficient in Squarespace's built-in SEO, marketing, and analytics tools.By the end of this Squarespace book, you’ll have the confidence to build professional websites with a developer's technical knowledge, project organization, and design intuition. You won’t just launch your site; you’ll be proud to share it with the world.
Michael Steppig
This book is an introduction to modeling and an in-depth look at topology in Blender, written by a Blender topology specialist with years of experience with the software. As you progress through its chapters, you’ll conquer the basics of quad-based topology using triangles and Ngons, and learn best practices and things to avoid while modeling and retopologizing. The pages are full of illustrations and examples with in-depth explanations that showcase each step in an easy-to-follow format.Squeaky Clean Topology in Blender starts by introducing you to the user interface and navigation. It then goes through an overview of the modeling techniques and hotkeys that will be necessary to understand the examples. With the modeling basics out of the way, the next stop on our journey is topology. Working through projects like a character and a sci-fi blaster, the book will illustrate and work through complex topology problems, and present solutions to those problems. These examples focus on deforming character models, non-deforming hard surface models, and optimizing these models by reducing the triangle count.By the end of this book, you will be able to identify the general flow of a shape's topology, identify and solve issues in your topology, and come out with a model ready for UV unwrapping, materials, and rigging.