Microsoft programming Books
APress Developing Solutions for Microsoft Azure
Book SynopsisImprove your odds of passing one of the most highly sought-after exams for developers working with Microsoft''s cloud platform: Exam AZ-204: Developing Solutions for Microsoft Azure. This book guides you through practical examples of each of the technologies covered by the exam while exposing you to the settings and interactions between platform solutions that you will need to be in command of to prepare for the exam and to use on your job in Azure development. Chapters in this book correspond directly to the exam skills outline and are delivered in a from-the-ground-up approach, allowing you to build your knowledge as you go. This approach serves to help even novice developers get up to speed quickly, while allowing more experienced developers to find the exact topics and scenarios they need to hone their skill sets as they both prepare for the exam and reference information for real-world solutions. As you work through each chapTable of ContentsIntroductionPart I. Develop for Azure1. Develop Solutions that Use Blob Storage2. Develop Solutions that Use Cosmos DB StoragePart II. Develop Azure Compute Solutions3. Implement IaaS Solutions4. Create Azure App Service Web Apps5. Azure Container Ecosystem6. Implement Azure FunctionsPart III. Implement Azure Security7. Implement User Authentication and Authorization8. Implement Secure Cloud SolutionsPart IV. Monitor, Troubleshoot, and Optimize Azure Solutions9. Implement Caching for Solutions10. Troubleshoot Solutions by Using Metrics and Log Data Part V. Connect to and Consume Azure Services and Third-Party Services11. Implement API Management12. Develop Event-Based Solutions13. Develop Message-Based Solutions
£41.24
APress Getting Started with SQL and Databases
Book SynopsisLearn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite. The book starts with a general introduction to writing SQL and covers the basic concepts. Author Mark Simon then covers database principles, and how database tables are designed. He teaches you how to filter data using the WHERE clause, and you will work with NULL, numbers, dates, and strings. You will also understand sorting results using the ORDER BY clause, sorting by calculated columns, and limiting the number of results. By the end of the book, you will know how to insert and update data, and summarize data with aggregate functions and groups. Three appendices cover differences between SQL dialects, working with tables, and a crash course in PDO. What You Will LearnFilter, sort, andcalculate dataSummarize data with aggregate functionsModify data with insert, uTable of ContentsThe appendix will include: Notes on using SQL with PHP “Cultural Notes” - a description of some of the sample data Major Differences between DBMSs Setting up the Sample Database
£41.24
APress Design and Deploy a Secure Azure Environment
Book SynopsisBeginning-Intermediate user levelTable of ContentsChapter 1: Getting Started with Azure Security o Introduction to Cloud Security o Best practices for securing enterprise cloud o Create an overall security design baseline o Define Security Operations Strategy o Overview of NIST Cybersecurity framework Chapter 2: Design and deploy security for infrastructure, data and apps o Design and deploy a strategy for securing server and client endpoints \ o Design and deploy a strategy for securing SaaS, PaaS, and IaaS services o Design and deploy security for data across Azure enterprise environment o Design and deploy security for application across Azure enterprise environment Chapter 3: Design and deploy Identify solution. o Introduction to Azure identify security services o Design and deploy Azure information protection o Design and deploy Azure network watcher o Design and deploy Azure Policy Chapter 4: Design and deploy Identify solution. o Design and deploy Azure Automation o Design and deploy Azure IoT Hub o Design and deploy Microsoft Intune o Design and deploy Service Map o Enable Security Center Chapter 5: Design and deploy detect solution. o Design and deploy Azure Intelligent Security Graph o Design and deploy Azure monitor o Design and deploy Azure Sentinel Chapter 6: Design and deploy protect solution o Design and deploy Azure Application gateway o Design and deploy Azure Firewall o Design and deploy Azure WAF Chapter 7: Design and deploy protect solution. o Design and deploy Azure AD and AD Identity protection o Design and deploy Azure DDoS o Design and deploy Azure NSG Chapter 8: Design and deploy protect solution. o Design and deploy Azure NSG o Design and deploy Azure Bastion o Design and deploy Azure Encryption Chapter 9: Design and deploy respond solution o Design and deploy Azure Logic Apps o Design and deploy Azure Encryption o Define your security team Chapter 10: Design and deploy recover solution o Design and deploy Azure Backup o Design and deploy Site recovery
£44.99
APress Leveling Up with SQL
Book SynopsisIntermediate-Advanced user levelTable of ContentsChapter 1: Getting Ready.- Chapter 2: Working with Table Design.- Chapter 3: Table Relationships and Working With Joins.- Chapter 4: Working with Calculated Data.- Chapter 5: Aggregating Data.- Chapter 6: Creating and Using Views and Friends.- Chapter 7: Working With Subqueries and Common Table Expressions.- Chapter 8: Working With Window Functions.-Chapter 9: More on Common Table Expressions.- Chapter 10: More Techniques with SQL: Triggers, Pivot Tables, and Variables.- Appendix A.
£33.74
APress Introducing Functional Programming Using C
Book SynopsisIntermediate-Advanced user levelTable of Contents
£33.74
APress Pro VB 2008 and the .NET 3.5 Platform
Book SynopsisThis book provides a complete A-to-Z reference for using VB with the .NET 2.0 platform and the .NET 3.0 extensions. It contains new chapters that explore the interactions between the existing framework and the new extensions, offering readers an edge when they evaluate and implement .NET 3.0 for the first time. To provide even more support, the book comes with a bonus CD that provides over 500 pages of carefully selected additional content to help broaden a reader's understanding of both .NET 2.0 and .NET 3.0.Table of ContentsIntroducing Visual Basic 2008 and the .NET Platform.- The Philosophy of .NET.- Building Visual Basic 2008 Applications.- Core VB Programming Constructs.- VB 2008 Programming Constructs, Part I.- VB 2008 Programming Constructs, Part II.- Designing Encapsulated Class Types.- Understanding Inheritance and Polymorphism.- Understanding Structured Exception Handling.- Understanding Object Lifetime.- Advanced VB Programming Constructs.- Working with Interface Types.- Collections, Generics, and Nullable Data Types.- Delegates, Events, and Lambdas.- Operator Overloading and Custom Conversion Routines.- VB 2008-Specific Language Features.- An Introduction to LINQ.- Programming with .NET Assemblies.- Introducing .NET Assemblies.- Type Reflection, Late Binding, and Attribute-Based Programming.- Processes, AppDomains, and Object Contexts.- Building Multithreaded Applications.- .NET Interoperability Assemblies.- Introducing the .NET Base Class Libraries.- File and Directory Manipulation.- Introducing Object Serialization.- ADO.NET Part I: The Connected Layer.- ADO.NET Part II: The Disconnected Layer.- Programming with the LINQ APIs.- Introducing Windows Communication Foundation.- Introducing Windows Workflow Foundation.- Desktop Applications with Windows Forms.- Introducing Windows Forms.- Rendering Graphical Data with GDI+.- Programming with Windows Forms Controls.- Desktop Applications with WPF.- Introducing Windows Presentation Foundation and XAML.- Programming with WPF Controls.- WPF 2D Graphical Rendering, Resources, and Themes.- Building Web Applications with ASP.NET.- Building ASP.NET Web Pages.- ASP.NET Web Controls, Themes, and Master Pages.- ASP.NET State Management Techniques.
£49.99
Holy Macro! Books The Absolute Guide to Dashboarding and Reporting
Book SynopsisWritten by a member of Microsoft’s Power BI team, this resource provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Power BI, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports, including year-to-date, variance-to-target, percentage-of-total, and running totals reports.
£24.26
O'Reilly Media Easy micro – bit Projects
Book SynopsisLearn the basics of using the micro: bit, an open source hardware ARM-based embedded system used to teach computer programming, to build a series of 10 different gadgets from scratch! You'll use the micro: bit to make: a scrolling name tag, animated LED displays a high-tech compass. a handheld tilting game with a buzzer and saved high score a carnival-like strength tester a powered cooling fan helmet an electronic musical instrument a security system that sends alerts to your computer when someone enters the room. a wheeled robot an alert to water your plants You will learn how simple electrical devices like speakers, motors, buzzers and fans work. You'll understand electronic components like resistors, force resistors, photoresistors, LEDs, and Op Amps, as well as Infrared distance sensors and soil moisture sensors. You'll also get a beginner's look at micropython, one of the fastest-growing computer languages. In this book you will combine multiple disciplines -- electronics, programming, and engineering -- to build a series of successful gadgets. Everything is explained with lots and lots of full-color line drawings. No prior experience is necessary. You'll have fun while you learn a t
£7.59
Apress Mastering Microsoft Fabric
£46.74
Apress The Agentic AI Revolution
Book SynopsisChapter 1: The AI Landscape and Its Evolving Impact.- Chapter 2: Challenges and Gaps in Current AI Adoption.- Chapter 3: Understanding Agency - what makes Agentic AI a teammate, not a tool - Chapter 4: Why Agentic Capabilities Outperform Traditional AI.- Chapter 5: Microsoft’s AI Stack and Agentic Evolution.- Chapter 6: Governing Agentic AI – Principles, Practices, and Playbooks? - Chapter 7: Embracing the Agentic Workforce.- Chapter 8: Beyond the Horizon.
£39.99
APress MVVM in Delphi
Book SynopsisTable of Contents1: MVVM as Design Pattern2: Setting up the POSApp3: MVVM as Design Philosophy4: Two-way Communication5: Converting the Invoice Form6: User Interaction7: Input Validation
£28.49
APress Pro .NET Memory Management
Book SynopsisUnderstand .NET memory management internal workings, pitfalls, and techniques in order to effectively avoid a wide range of performance and scalability problems in your software. Despite automatic memory management in .NET, there are many advantages to be found in understanding how .NET memory works and how you can best write software that interacts with it efficiently and effectively. Pro .NET Memory Management is your comprehensive guide to writing better software by understanding and working with memory management in .NET.Thoroughly vetted by the .NET Team at Microsoft, this book contains 25 valuable troubleshooting scenarios designed to help diagnose challenging memory problems. Readers will also benefit from a multitude of .NET memory management rules to live by that introduce methods for writing memory-aware code and the means for avoiding common, destructive pitfalls.What You''ll LearnTable of Contents1. Basic Concepts 2. Low-Level Memory Management 3. Memory Measurements 4. .NET Fundamentals 5. Memory Partitioning 6. Memory Allocation 7. Garbage Collection: Introduction 8. Garbage Collection: Mark Phase 9. Garbage Collection: Plan Phase 10. Garbage Collection: Sweep and Compact 11. GC Flavors 12. Finalization13. Miscellaneous Topics 14. Advanced Techniques 15. Programmatical APIs
£85.49
Apress Exploring Blazor Creating Hosted Serverside and Clientside Applications with C
a huge range and FREE tracked UK delivery on ALL orders.
£999.99
APress Building Single Page Applications in .NET Core 3
Book SynopsisBeginning-Intermediate user levelTable of ContentsChapter 1: The Case for BlazorChapter 2: Blazor Server vs Blazor WebAssemblyChapter 3: Create Your Single Page ApplicationChapter 4: Build Your Reusable Blazor LibraryChapter 5: Deploy Your Application
£37.49
APress Understanding Hybrid Environments in SharePoint
Book SynopsisIntermediate-Advanced user levelTable of ContentsChapter 1, Setup SharePoint 2019 Developer VM in MS AzureChapter Goal: · Hardware and Software Requirements · Microsoft Azure VM Setup Options · Setup Server 2019 Trial VM in MS Azure Chapter 2, Configure SharePoint Server 2019 Chapter Goal: · Setup Active Directory · Setup AD Users · Configure SharePoint 2019 with AutoSPInstaller · Convert SharePoint Trial to RTM License Chapter 3, SharePoint Server 2019 User Experience Chapter Goal: · SharePoint 2019 User Experience · Modern User Experience Chapter 4, SharePoint Server 2019 Features Overview Chapter Goal: · SharePoint 2019 Focus Areas · Improved Features · Features Leaving Behind / Does Not make to On-Premise Chapter 5, SharePoint 2019 PowerApps Integration Chapter Goal: · PowerApps Overview · Install Gateway · Build PowerApps Canvas App · Gateway Windows Service · Publish the PowerApps App Chapter 6, SharePoint 2019 MS Flow Integration Chapter Goal: · MS Flow Overview · On-premises Data Gateway · Configure MS Flow Connection · Create Microsoft Flow · Test the MS Flow Chapter 7, SharePoint 2019 - Power BI Reporting Chapter Goal: · Power BI Overview · On-premises Data Gateway · Manage Gateway · Create Data Source · Install Personal Gateway · Power BI Reports · Publish the Power BI Report · Scheduled Refresh of Datasets Chapter 8, SharePoint 2019 - Configure Home Page Chapter Goal: · SharePoint Home · Features of Home Page · Supporting Services Chapter 9, SharePoint 2019 - Enable Hybrid Experience Chapter Goal: · SharePoint Hybrid · Enable Hybrid Experience · SPO365 Link Settings Overview · Re-run SharePoint Hybrid Configuration Wizard · Configuration Summary Chapter 10. Register Public Domain with Office 365 Chapter Goal: · Need for Public Domain · Buy a new domain · Use an existing domain · Set Default Office 365 Domain · Edit Active Users Chapter 11, Configure Office 365 for SharePoint Hybrid · Prerequisites · Add UPN suffix to the Local AD · Manage Office 365 Directory from Azure Active Directory · Verify User Sync · Assign Licenses to Users Chapter 12, SharePoint 2019 - Cloud Hybrid Search Chapter Goal: · Cloud Hybrid Search Overview · Enable Hybrid Search Experience · PowerShell Script Approach · On-Premises Cloud Search Service Application Configuration · Verify Hybrid Search Chapter 13, SharePoint 2019 Hybrid Self-Service Site Creation Chapter Goal: · Hybrid Self-Service Site Creation · Enable Hybrid Experience · Create Site Collection Page · Enable Hybrid Self-Service Site Creation from SharePoint Hybrid Configuration Wizard · Manage hybrid self-service site creation · Test Hybrid Self-Service Site Creation Chapter 14, SharePoint 2019 Configure Hybrid Taxonomy · SharePoint Hybrid Taxonomy · Copy SharePoint Server Taxonomy to SharePoint Online · Configure hybrid SharePoint taxonomy · Timer Job · Verify Taxonomy Groups Replication Chapter 15, SharePoint 2019 Configure Hybrid Content Types Chapter Goal: · SharePoint Hybrid Content Types · Content Type Hub in SharePoint Online · Copy SharePoint Server Content Types to SharePoint Online · Configure hybrid SharePoint Content Types · Timer Job · Verify Content Types Replication Chapter 16, SharePoint Framework Development with SharePoint 2019 · Decide Upon SharePoint Framework Version · Get SharePoint Server 2019 Ready for SPFx · Develop SharePoint Framework Web Part · Run the SPFx WebPart · Troubleshooting Chapter 17, Office Online Server for SharePoint Server 2019 Chapter Goal: · Introduction to Office Online Server · Download and Install Office Online Server · Install Office Online Server · Setup Office Online Farm · Verify the Office Online Server working · Connecting to SharePoint 2019 Farm Chapter 18, SharePoint Server 2019 Upgrade Scenarios Chapter Goal: · Upgrade Scenarios · High Level Upgrade Scenarios
£37.49
Apress Design Patterns in NET Core 3 Reusable Approaches
Book Synopsis Part I: Introduction.- Chapter 1: The SOLID Design Principles Chapter 2: The Functional Perspective Part II: Creational Patterns Chapter 3: Builder Chapter 4: Factories Chapter 5: Prototype Chapter 6: Singleton Part III: Structural Patterns Chapter 7: Adapter Chapter 8: Bridge Chapter 9: Composite Chapter 10: DecoratorChapter 11: Façade Chapter 12: Flyweight Chapter 13: Proxy Part IV: Behavioral Patterns Chapter 14: Chain of Responsibility Chapter 15: Command Chapter 16: Interpreter Chapter 17: Iterator Chapter 18: Mediator Chapter 19: Memento Chapter 20: Nu
£28.04
APress Essential Excel 2019
Book Synopsis Create, edit, sort, analyze, summarize, and format data as well as graph it in Excel 2019. Chock full of visuals, user-friendly instructions, and reader exercises, this in-depth guide makes it easy for you to get on the bandwagon taking advantage of this powerful software and what it can do. Essential Excel 2019 doesn''t mess around. It provides the most clear and concise, but complete, information you need to successfully use the expansive features of Excel in your work environment. The second edition of this soup-to-nuts book delivers essential how-to and reference information for users who are new to Excel, those who want to continue building their Excel skills, or anyone who wants to get up to speed on the latest changes and features in Excel 2019. It is heavy on the practical examples and light on the theory, providing a step-by-step process of what you need to do when you are working with Excel. You will begin with the basics, advancing as each chapterTable of Contents Chapter 1 – Becoming Acquainted with ExcelChapter 2 – Navigating and Working with WorksheetsChapter 3 – Best Ways to Enter Data and Edit Data Chapter 4: Formatting and Aligning Data Chapter 5: Different Ways of Viewing and Printing Your Workbook Chapter 6: Understanding Backstage Chapter 7: Creating and Using Formulas Chapter 8: Excel’s Pre-existing FunctionsChapter 9: Auditing, Validating, and Protecting Your Data Chapter 10: Using Hyperlinks, Combining Text, and Working with the Status Bar Chapter 11: Transferring and Duplicating Data to Other Locations Chapter 12: Working with Tables Chapter 13: Working with Charts Chapter 14: Importing Data Chapter 15: Using PivotTables and PivotCharts Chapter 16: Geography and Stock Data Types Chapter 17: Enhancing Workbooks with Multimedia Chapter 18: Icons, 3D Images and Object Grouping Chapter 19: Automating Tasks with Macros
£48.74
APress Data Science Solutions on Azure
Book SynopsisUnderstand and learn the skills needed to use modern tools in Microsoft Azure. This book discusses how to practically apply these tools in the industry, and help drive the transformation of organizations into a knowledge and data-driven entity. It provides an end-to-end understanding of data science life cycle and the techniques to efficiently productionize workloads. The book starts with an introduction to data science and discusses the statistical techniques data scientists should know. You''ll then move on to machine learning in Azure where you will review the basics of data preparation and engineering, along with Azure ML service and automated machine learning. You''ll also explore Azure Databricks and learn how to deploy, create and manage the same. In the final chapters you''ll go through machine learning operations in Azure followed by the practical implementation of artificial intelligence through machine learning. Table of ContentsPart I - Introduction to Data Science and its rise to prominence Chapter 1 Data Science in the modern enterprise What is Data Science The Data Scientists' tools and lingo Ethics and ethical AI Significance of Data Science in organizations Case Studies of applied Data Science Chapter 2 Most important Statistical Tehniques in Data Science Top Statistical Tehniques Data Scientists need to know Supervised Learning Unsupervised Learning Regression/Classification/ Forecasting Bayesian method Time series analysis Linear regression Sampling methods Reinforcement Learning Part 2 - Machine Learning in Microsoft Azure Chapter 3 Basics of data preparation and data engineering Ingesting disparate data sources Preparing data for analysis Data Exploration Feature Engineering Chapter 4 Introducing Azure Machine Learning AzureML- DataStores/ Datasets Azure ML Compute/CLusters/inference/batch-realtime Azure ML Service- Training and Building Azure ML Service- Deploying Azure ML Service- Pipelines Azure ML Studio/Designer Azure Automated Machine Learning (AutoML) Hyperparameter Training Azure ML- Security Case Study Part 3 - Azure Databricks Chapter 5 Spark and Big Data Spark and Hadoop What is Big Data? Why Spark is the platform of choice for Big Data Challenges with Big Data Chapter 6 Azure Databricks Basics What is Azure Databricks Azure Databricks from the Data Engineers' perspective Azure Databricks from the Data Scientists' perspective Chapter 7 Azure Databricks Deploying the Azure Databricks workspace Creating and Managing Clusters Creating and managing users and groups Managing Databricks Notebooks Using Databricks Notebooks DBFS Connecting to ADLS Sample Notebook(s) Part 4 - Operationalizing Data Science Chapter 8 Machine Learning Operations Operationalization concepts and DevOps MLOps in Azure MLFlow in Azure Databricks Git Chapter 9 Practical ML Introducing use cases in the different industries Democratizing AI through ML
£44.99
APress Advanced Excel Success
Book SynopsisExplore advanced skills in Excel and gain an amazing array of tricks and tools to increase your productivity. This book discusses new techniques such as power functions, chart tricks, and many more to master Excel.Advanced Excel Success starts with a few useful data tools in Excel followed by advanced formulas that will help you increase productivity. Here, you will learn power functions that aggregate, return ranges, and much more. Further, you will look at custom formatting tricks along with advanced charting tricks. These include automatically changing the color of key metrics, dynamically sorting chart data, and building creative labels. Next, you will understand the role of Power Query which is one of the most important upgrades in Excel. Power Query is the Microsoft Data Connectivity and Data Preparation technology that enables business users to seamlessly access data stored in hundreds of data sources and reshape it to fit their needs, wiTable of ContentsChapter 1: Excel Tricks and Data ToolsChapter Goal: A look at the most useful Data tools in Excel. No of pages: 40 This chapter shows tricks and Excel tools to boost productivity. Features such as Text to Columns and Find and Replace that are known by many Excel users. But not a way shown in this chapter. It also covers some lesser known Data tools. Chapter 2: The 10 Power Functions of Excel Chapter Goal: Learn advanced Excel formulas like never before understanding them intimately. Then covering the 10 power functions behind dynamic reports and Excel models with ‘real world’ examples. No of pages: 60 The chapter begins looking at ranges and Boolean expressions in detail. Functions are then categorised – some aggregate, some return ranges. We then move into the power functions and get creative with scenarios they can be used. Chapter 3: Advanced Formatting Techniques Chapter Goal: Learn advanced formatting tricks to add more meaning to your data. No of pages: 30 This chapter will start with some advanced Conditional Formatting techniques. And then take formatting up another step with some very creative uses and unleash the power of Custom Formatting. Chapter 4: Advanced Chart Tricks Chapter Goal: Learn advanced chart tricks to make them pop. No of pages: 40 This chapter will cover a variety of advanced charting tricks. These include automatically changing the color of key metrics, dynamically sort chart data and make them time relative and build creative labels. Chapter 5: Power Query – You Will Never Work the Same Way Chapter Goal: To understand the role of Power Query and how it will change the way you work with data. No of pages: 60 This chapter is a guide to Power Query, one of the most important upgrades in Excel history. The chapter walks through several examples using Power Query to streamline coming data tasks and preparing data for analysis. Chapter 6: Power Pivot – The Internal Data Model of Excel Chapter Goal: An introduction guide to Power Pivot. No of pages: 60 This chapter is a guide to Power Pivot, a feature that goes beyond the Excel spreadsheet. With Power Pivot we can store huge volumes of data, model it and perform powerful calculations. This is all covered in the chapter.
£999.99
APress Pro SQL Server Relational Database Design and
Book Synopsis1. The Fundamentals.- 2. Introduction to Requirements.- 3. The Language of Data Modeling.- 4. Conceptual and Logical Data Model Production.- 5. Normalization.- 6. Physical Model Case Study.- 7. Physical Model Implementation.- 8. Data Protection Patterns with Check Constraints and Triggers.- 9. Patterns and Anti-Patterns.- 10. Database Security and Security Patterns.- 11. Data Structures, Indexes, and Their Applications.- 12. Matters of Concurrency.- 13. Coding Architecture.- 14. Appendix A: Scalar Datatype Reference.Table of Contents1. The Fundamentals2. Introduction to Requirements3. The Language of Data Modeling4. Conceptual and Logical Data Model Production5. Normalization6. Physical Model Case Study7. Physical Model Implementation 8. Data Protection Patterns with Check Constraints and Triggers9. Patterns and Anti-Patterns10. Database Security and Security Patterns11. Data Structures, Indexes, and Their Applications12. Matters of Concurrency13. Coding Architecture 14. Appendix A: Scalar Datatype Reference.
£55.24
APress Microsoft Excel Functions Quick Reference
Book SynopsisThis condensed syntax reference presents the essential Excel function syntax in a well-organized format that can be used as a quick and handy reference. You can use it to improve your Excel knowledge and increase your productivity. It will help you upgrade the quality of your data analysis, dashboards, models, and templates.The Microsoft Excel Functions Quick Reference helps you set up workbooks, enter data, and format it for easier viewing. It starts by giving an overview of Excel functions explaining the different types of Excel functions available followed by an understanding of string functions and date functions. It then covers time, lookup, aggregate, and logical functions along with practice problems. Further, you will see math functions and information functions in Excel. You will also be able to create sophisticated forecast worksheets, key performance indicators (KPIs), and timelines. Each function in the text is illustrateTable of ContentsChapter 1 – What is an Excel function? · Excel formula definition · How to use an Excel formula · Different types of Excel functions Chapter 2 –TEXT functions · LEFT · RIGHT · MID · UPPER · LOWER · PROPER · TRIM · LEN · FIND · SEARCH · CONCATENATE/& · VALUE · TEXT · EXACT · REPLACE · SUBSTITUTE Chapter 3 – DATE functions · TODAY · DAY · MONTH · YEAR · DATE · EDATE · EOMONTH · WEEKDAY · WEEKNUM · DATEVALUE · NETWORKDAYS · DATEDIF Chapter 4 – TIME functions · NOW · HOUR · MINUTE · SECOND · TIMEVALUE Chapter 5 – LOOKUP functions · VLOOKUP · HLOOKUP · MATCH · INDEX · CHOOSE Chapter 6 – AGGREGATE functions · SUM · SUMIF · SUMIFS · SUMPRODUCT · SUBTOTAL · COUNT · COUNTIF · COUNTIFS · AVERAGE · AVERAGEIF · AVERAGEIFS · AGGREGATE Chapter 7 – LOGICAL functions · IF · IFS · AND · OR · NOT · IFERROR · IFNA · SWITCH Chapter 8 – REFERENCE functions · INDIRECT · ADDRESS · OFFSET · ROW · ROWS · COLUMN · COLUMNS Chapter 9 – MATH functions · ABS · INT · TRUNC · ROUND · ODD · EVEN · POWER · PRODUCT Chapter 10 – INFORMATION functions · CELL · ISBLANK · ISERROR · ISEVEN · ISODD · ISFORMULA · ISLOGICAL · ISNA · ISNONTEXT · ISNUMBER · ISTEXT · N · TYPE Chapter 11 – MEGA-Formula · What is Mega formula? · How to create a mega formula · Examples Chapter 12 – Array formula · What is an array formula? · Advantages and disadvantages · Examples Appendix A – Formula Reference ready reckoner
£37.99
APress Pro Azure Administration and Automation
Book SynopsisLearn best practices and the proper use of Azure management tools, such as Azure Portal, Azure PowerShell, Azure CLI, and ARM templates, which are time-saving tools that support daily administration tasks such as monitoring, alerting, backups, security, and more. This book explores common Azure services, including Azure networking, virtual machines, app services, backup, monitoring, and other tools of the trade that IT professionals use on a regular basis. And you will come away with a strong understanding of these services and how to use them.While Microsoft Azure is no longer the new cloud on the block, it continues to be one of the fastest-growing platforms with regard to features, integrations, and capabilities. Over the last decade, it has undergone significant changes and amassed a large following, but many of its users, especially those who transitioned from traditional admin tasks to modern cloud computing, are not reaping its full benefits.Management in tTable of ContentsChapter 01: Foundations in Cloud Computing Chapter 02: Azure Administration Chapter 03: Virtual Networks in Azure Chapter 04: Virtual Machine: Virtual Machine Scale Sets in Azure Compute Chapter 05: App Services and Containers in Azure Compute Chapter 06: Azure Storage Chapter 07: Advanced Azure Networking Chapter 08: Monitoring and Data Protection Chapter 09: Network Traffic Management Chapter 10: Azure Security and Compliance
£52.24
APress DeepDive Terraform on Azure
Book SynopsisBeginning-Intermediate user levelTable of ContentsChapter 1: Introduction to Infrastructure as Code Chapter Goal: Understand the basics on Infrastructure as Code paradigm and known about its advantages, principles and tools. Understand the need to convert infrastructure into code. No of pages: 5 Sub -Topics 1. Understanding Configuration Management 2. Understanding Infrastructure as code 3. Principles of Infrastructure as code 4. Benefits and applicability for cloud environments Chapter 2: Azure and Terraform Chapter Goal: Get an overview of Azure as enterprise cloud provider with different paradigm like IaaS, PaaS. Different ways to provision resources in Azure. How Terraform fits within the Azure Landscape and how it can be used to provision Azure resources. Understand the high-level architecture and workflow using Terraform No of pages: 15 Sub - Topics 1. Overview of Azure cloud 2. Overview of Terraform configuration management 3. Terraform workflow for provisioning and de-provisioning of resources 4. Terraform architecture – providers, plugins, resources, repositories Chapter 3: Getting Started with Terraform Chapter Goal: Getting hand dirty with Terraform, writing multiple terraform scripts exploring different concepts of Terraform. No of pages: 45 Sub - Topics: 1. Understand Terraform CLI and using various options 2. State Management in Terraform 3. using Resources, providers, outputs 4. Terraform Data types 5. Dependency graphs in Terraform scripts Chapter 4: Deep Dive into Terraform Chapter Goal: Understanding the advance features of Terraform both from component as well at script level. Write advance Terraform scripts for conditional deployments, multiple resource creation using loops. No of pages: 45 Sub - Topics: 1. Backend, state and workspace management in Terraform 2. dynamic provisioning of resources 3. loops, conditional statements – for, for-each, if 4. using Terraform functions – string, collection, encoding, file Chapter 5: Writing Reusable Modules in Terraform Chapter Goal: Writing reusable Terraform scripts using modules, storing modules in repositories and consuming them in multiple scripts. No of pages: 25 1. Basic of Modules, child and parent modules 2. Passing parameters and getting output from modules 3. Using modules from multiple scripts. Chapter 6: Writing Secure Scripts with Terraform Chapter Goal: Management and administration of sensitive data, secrets and passwords within Terraform code. Usage of Key vaults for storing of secrets. No of pages: 20 1. Secure storage of credentials and sensitive information 2. Usage of Managed Identities, certificates, service principles to connect to Azure 3. Storing secrets in Azure Key vaultChapter 7: Repos, Versioning, CI/CD pipelines for Terraform Chapter Goal: Overview of storing and versioning of Terraform scripts such that each version can be used in isolation without conflicting with others. Using Terraform CLI in Azure DevOps pipelines to automate the process of deployment of Azure Resources. No of pages: 20 1. Storing Terraform scripts in Azure DevOps 2. Versioning of Terraform modules 3. CICD pipelines for deploying resources on Azure using Terraform Chapter 8: Writing Unit and Integration Tests for Terraform Chapter Goal: Testing of Terraform scripts using TerraTest utility. Understanding principles of unit and integrating testing alongside implementing them No of pages: 20 1. Exploring TerraTest and terra-lint 2. Understanding Unit testing and writing unit tests for Terraform scripts 3. Understanding Integration testing and writing Integration tests for Terraform scripts Chapter 9: Terraform Best Practices Chapter Goal: Understanding the best practices of authoring, deploying and managing Terraform scripts in general and in Azure No of pages: 10 1. Understanding Terraform Folder structure and deployment structure 2. Writing testable Terraform scripts 3. Writing Maintainable code – usage of variables, no hard-coding etc
£999.99
APress Optimizing Visual Studio Code for Python
Book SynopsisLearn Visual Studio Code and implement its features in Python coding, debugging, linting, and overall project management. This book addresses custom scenarios for writing programs in Python frameworks, such as Django and Flask.The book starts with an introduction to Visual Studio Code followed by code editing in Python. Here, you will learn about the required extensions of Visual Studio Code to perform various functions such as linting and debugging in Python. Next, you will set up the environment and run your projects along with the support for Jupyter. You will also work with Python frameworks such as Django and go through data science specific-information and tutorials. Finally, you will learn how to integrate Azure for Python and how to use containers in Visual Studio Code. Optimizing Visual Studio Code for Python Development is your ticket to writing Python scripts with this versatile code editor. Table of ContentsOptimizing Visual Studio Code for Python Development Chapter One – Introduction to Visual Studio Code o Basic introduction to Visual Studio Code Chapter Two – Getting Started with Python Programs in VS Code o Getting started with code editing o Required extensions o Linting o Debugging Chapter Three – Setting up the Environment and Testing o Setting up your environment o Running your projects o Support for Jupyter Chapter Four – Working with Python Frameworks o Django Development o Flask Development o Data Science specific information and tutorials Chapter Five – Working with Containers and MS Azure o Integrating Azure for your Python projects o Using containers in VS Code o Conclusion
£46.74
APress Implementing Always On VPN
Book SynopsisImplement and support Windows 10 Always On VPN, the successor to Microsoft''s popular DirectAccess. This book teaches you everything you need to know to test and adopt the technology at your organization that is widely deployed around the world.The book starts with an introduction to Always On VPN and discusses fundamental concepts and use cases to compare and contrast it with DirectAccess. You will learn the prerequisites required for implementation and deployment scenarios. The book presents the details of recommended VPN protocols, client IP address assignment, and firewall requirements. Also covered is how to configure Routing and Remote Access Service (RRAS) along with security and performance optimizations. The Configuration Service Provider (CSP) is discussed, and you will go through provisioning Always On VPN to Windows 10 clients using PowerShell and XML as well as Microsoft Intune. Details about advanced client configuration and integration with Azure secuTable of ContentsChapter 1 – Always On VPN Overviewo This chapter will introduce Always On VPN as a technology and cover the concepts and underlying technologies used by the solution. We will discuss the high-level use cases and compare with its predecessor, DirectAccess.Chapter 2 – Plan an Always On VPN Deploymento In this chapter we will dive more deeply into the implementation prerequisites. We will identify infrastructure requirements, discuss networking and authentication requirements, and learn about various deployment scenarios. Guidance will be provided for certificate services configuration and networking models will be covered. Details about VPN protocols, client IP address assignment, and firewall requirements will also be covered.Chapter 3 – Configure Windows Server for Always On VPNIn this chapter, configuring Windows Server Routing and Remote Access Service (RRAS) will be covered in detail. In addition, we will cover Remote Access Service (RRAS) configuration and perform server security and performance optimizations.Chapter 4 – Provision Always On VPN ClientsThis chapter will provide guidance for provisioning Always On VPN to Windows 10 clients. The Configuration Service Provider (CSP) mode will be discussed, and readers will learn to create a configuration XML file and provision it locally using PowerShell. In addition, Intune deployment using custom XML and native VPN profiles will be covered.Chapter 5 – Cloud Deploymentso For those organizations deploying infrastructure in a public cloud, this chapter will outline how to deploy an Always On VPN infrastructure in Microsoft Azure. Deploying RRAS in Azure and leveraging native cloud VPN infrastructure such as Azure Virtual Network Gateway and Azure Virtual WAN will be discussed.Chapter 6 – Azure Integrationo This chapter will provide guidance for advanced client configuration and integration with Azure security services. Azure MFA integration with on-premises NPS will be covered in detail. Also, Azure Conditional Access will be covered.Chapter 7 – High Availabilityo This chapter will describe in detail how to implement an Always On VPN infrastructure in a redundant and highly available configuration. Locally redundancy NPS and VPN servers will be covered. Guidance for multisite deployment with geographic redundancy for VPN servers will be included.Chapter 8 – Monitor and Reporto This chapter will cover ongoing system maintenance and operational support for the VPN and NPS infrastructure. It will include guidance for ensuring automatic certificate management, how to renew certificates that cannot be managed automatically, how to find logging details, and which monitoring tools can be effective for daily operation.Chapter 9 – Troubleshootingo This chapter will provide detailed guidance for troubleshooting and resolving common configuration and operational errors for the VPN and authentication infrastructure, from both the client and server perspective. Common failure scenarios will be covered, and detailed resolution steps will be provided.Chapter 10 – Migrate from DirectAccess to Always On VPNo Always On VPN is most commonly deployed to replace existing DirectAccess infrastructure. In this chapter I’ll provide guidance and share experience for migrating from DirectAccess to Always On VPN seamlessly and without disruption.
£999.99
APress Design and Deploy Microsoft Azure Virtual Desktop
Book SynopsisDesign and build the newdesktop service from Microsoft. This book offers a modern framework, design methodology, and best practices of design and deployment for virtual apps and desktops.Microsoft Azure Virtual Desktop (AVD) is a Desktop as a Service (DaaS) which is simple to deploy, accessible from any device, easy to manage, and secure. The book starts with AVD essentials and its critical features, followed by the planning and method of preparing for AVD. You will go through defining the requirements and assessing by setting the AVD application baseline, network requirements, and security requirements. Next, you will learn how to design and deploy the core infrastructure of Microsoft AVD to understand its Access Layer, Control Layer, Resource Layer, Hosting Layer, and User Layer. You will also learn how to design the desktop and Host Pool of AVD. And you will learn the modern way to manage and secure AVD components. After reading this book, you will havetheright blend of knowledge Table of ContentsChapter 1: Microsoft WVD Design Essentials· WVD Essentials · Key foundations of WVD · Terminology of WVD Chapter 2: Preforming Assessment and requirements gathering of Microsoft WVD · Preforming due diligences · Classifying the WVD use cases. · Defining WVD Application baseline. · Defining WVD Network requirements. · Defining WVD Security requirements. Chapter 3: Designing Core Infrastructure of Microsoft WVD · Designing WVD Compute and storage. · Designing WVD Network. · Designing WVD Security requirements. · Designing WVD Access layer. · Designing WVD Control Layer. Chapter 4: Designing Desktop and RDHS Pool of Microsoft WVD · Designing WVD Resource Layer. · Designing WVD RDHS Pool. · Designing WVD Desktop Pool. · Designing WVD User Profile and Personalization Layer · Designing WVD Policy Layer. · Designing WVD Application delivery Layer. Chapter 5: Designing Monitoring and Security Components of Microsoft WVD · Designing WVD Operational Layer. · Designing WVD Monitoring layer. · Designing WVD Security Layer. · Designing WVD Migration Layer. · Designing WVD Automation Layer.
£999.99
APress Mastering Excel Through Projects
Book SynopsisMaster Excel in less than two weeks with this unique project-based book! Let's face it, we all master skills in our own way, but building a soup-to-nuts project is one of the best ways to make learning stick and get up to speed quickly. Whether you are just getting started with Excel or are an experienced user, this book will elevate your knowledge and skills. For a beginner, the micro examples in each chapter will warm you up before you dive into the projects. For experienced users, the projects, especially those with table setup considerations, will help you become more creative in your interactions with Excel. Readers will benefit from building eight unique projects, each covering a different topic, including a word game, a food nutrition ranking, a payroll (tax withholding) calculation, an encryption, a two-way table, a Kaplan-Meier analysis, a data analysis via a pivot table and the K-means Clustering data mining method. Through these projects, you will experience firsthand how Table of ContentsChapter 1: Master Excel through Projects Chapter 2: Food Nutrition Ranking Chapter 3: Payroll Calculation Chapter 4: Public and Private Key Cryptography Chapter 5: Two-Way Table and Chi-Square Test Chapter 6: Kaplan-Meier Analysis Chapter 7: PivotTable Data Analysis Chapter 8: K-means Clustering and Iterative Calculation
£999.99
APress Microsoft Blazor
Book Synopsis1. Introduction to WebAssembly and Blazor.- 2. Data Binding.- 3. Components and Structure for Blazor Applications.- 4. Advanced Components.- 5. Services and Dependency Injection.- 6. Data Storage and Microservices.-7. Communication with Microservices.- 8. Unit Testing.- 9. Single Page Applications and Routing.-10. JavaScript Interoperability .- 11. Blazor State Management.- 12. Building Real-Time Applications with Blazor and SignalR.- 13. Efficient Communication with gRPC .- 14. Supporting Multiple Languages in your Blazor Application.- 15. Deploying your Blazor Application.- 16. Security with OpenID Connect.-17. Securing Blazor WebAssembly.Table of Contents1. Introduction to WebAssembly and Blazor2. Data Binding3. Components and Structure for Blazor Applications4. Advanced Components5. Services and Dependency Injection6. Data Storage and Microservices7. Communication with Microservices8. Unit Testing9. Single Page Applications and Routing10. JavaScript Interoperability 11. Blazor State Management12. Building Real-Time Applications with Blazor and SignalR13. Efficient Communication with gRPC 14. Supporting Multiple Languages in your Blazor Application15. Deploying your Blazor Application16. Security with OpenID Connect17. Securing Blazor WebAssembly
£49.49
APress Azure Cloud Security for Absolute Beginners
Book SynopsisImplement cloud security with Azure security tools, configurations and policies that address the needs of businesses and governments alike. This book introduces you to the most important security solutions available in Azure and provides you with step-by-step guidance to effectively set up security and deploy an application on top of Azure platform services, as well as on top of Azure infrastructure.Author Pushpa Herath begins by teaching you the fundamentals of Azure security. An easy to follow exploration of management groups, subscriptions, management locks and Azure policies further elaborate the concepts underlying Azure cloud security. Next, you will learn about Azure Active Directory (AAD) and the utilization of AAD in application and infrastructure security. Essential aspects of maintaining secure application keys and certificates are further explained in the context of Azure Key Vault. New application security implementations such as Azure configuratTable of ContentsChapter 1: Understanding the Importance of Data/Application Security Chapter Goal: Give general overview on importance of data security No of pages: 5 Sub -Topics 1. Introduction to security 2. Introduction to Azure security fundamentals Chapter 2: Overview of Basic Azure Security Components Chapter Goal: Introduction to various security components in Azure and how to utilize them. No of pages: 15 Sub - Topics 1. Introduction to Azure Management groups and subscriptions 2. Azure Management locks 3. Introduction to Azure policies Chapter 3: Introduction to Azure Active Directory Chapter Goal: Lessons to provide hand-on guidance on user access control of the organization using Azure Active Directory. No of pages : 30 Sub - Topics: 1. Adding users and groups to the AD 2. Manage External Identities 3. Enable two factor authentications 4. Roles and Administrative units in Azure AD 5. Managing Enterprise applications 6. Introduction to AD devices 7. Azure AD app registration 8. Adding custom domains Chapter 4: Working with Azure Key vault Chapter Goal: Step by step guidance to setting up and using azure key vault to achieve several security requirements in the organization. No of pages: 15 Sub - Topics: 1. Setting up Key vault 2. Key vault access control 3. Using KV to save Keys 4. Using KV to secure Secrets 5. Using KV to keep certificates 6. Key vault access policies 7. KV networking and security Chapter 5: Ensure Azure Application security Chapter Goal: Step by step guidance to setting up various security components which helps to secure application hosted in Azure No of pages: 40 Sub - Topics: 1. Keep configurations in central location using Azure Configuration 2. Authentication and authorization in Azure App Service 3. How to secure application with web application firewall in Azure 4. Application Security groups Chapter 6: Ensure Data Security with Azure Storages Chapter Goal: Overview on how data storage security works in Azure No of pages: 30 Sub - Topics: 1. Setting up azure storage 2. Azure storage encryption 3. Azure defender for azure storage Chapter 7: Ensure Security using Azure Virtual Networks Chapter Goal: Step by step guide on how to setup virtual networks to enhance the security of the data and infrastructure. No of pages: 40 Sub - Topics: 1. Network security groups 2. Azure VPN gateways 3. Azure Load balancer 4. Azure Subnets Chapter 8: Working with Azure Application Gateway Chapter Goal: Hands on lessons on implementing Azure Application gateway to enhance the security of the data Sub - Topics: 1. Setting up Azure Application gateway 2. Secure Web App using App gateway 3. Secure Virtual Machine using App gateway Chapter 9: Securing data with Azure Firewall Chapter Goal: Step by step guidance to setting up azure firewall and configure it to secure data No of pages: 40 Sub - Topics: 1. Setting up Azure Firewall 2. Setting up policies 3. Setting up rules Chapter 10: Creating App Service Environment to enhance security Chapter Goal: Step by step guidance to setting up App service environment and using it to secure applications No of pages: 50 Sub - Topics: 1. Setting up Azure Application service environment 2. Deploy applications to app service environment Chapter 11: Secure Infrastructures in Azure Chapter Goal: Explains different security features available with few of the azure resources No of pages: 30 Sub - Topics: 1. Secure Azure Virtual machine using Bastian 2. Secure Azure Virtual machine using encrypted firewall rules 3. Azure SQL server security components
£999.99
APress Beginning gRPC with ASP.NET Core 6
Book SynopsisBroaden your developer experience by learning how to use gRPC and ASP.NET Core together on the Microsoft's developer framework, .NET 6 and discover a new way of developing APIs with gRPC. Beginning gRPC with ASP.NET Core6is your guide to quickly and efficiently getting down to the business of building gRPC applications in the Microsoft .NET ecosystem. Readers will dive in and build an application using gRPC and the latest technologies such Angular and ASP.NET Core Razor Pages.This book will teach you how to set up an efficient application using industry best practices such as security, monitoring, logging, and more. You will do this by performing Create, Read, Update, and Delete (CRUD) operations on a SQL Server database with Entity Framework Core. From there you will build web applications using Angular and ASP.NET Core Razor pages combined with gRPC APIs. After reading the book, you'll be able to take advantage of the full range of developer opportunities with gRPC, and come awayTable of ContentsPart I: Getting Started with .NET 6 Chapter 1: Welcome to Modern .NET Chapter 2: Introducing ASP.NET Core 6Part II: gRPC fundamentalsChapter 3 : Understanding the gRPC Specification Chapter 4: Protbufs Chapter 5: Creating an ASP.NET Core gRPC Application Chapter 6: API Versioning Part III: gRPC and ASP.NET Core Chapter 7: Create a gRPC Client Chapter 8: From WCF to gRPC Chapter 9: Import and Display Data with ASP.NET Core Razor Pages, Hosted Services, and gRPC Chapter 10: The gRPC-web Specification Chapter 11: Create a gRPC-web service from a gRPC-service with ASP.NET Core Part IV: gRPC-web and ASP.NET Core Chapter 12: Import and Display Data with Angular 12 and gRPC-webPart V: Security Chapter 13: Secure your Application with OpenId Connect
£999.99
APress Mastering Azure API Management
Book SynopsisUnsure of how or where to get started with Azure API Management, Microsoft's managed service for securing, maintaining, and monitoring APIs? Then this guide is for you.Azure API Managementintegrates services like Azure Kubernetes Services (AKS), Function Apps, Logic Apps, and many others with the cloud and provides users with a single, unified, and well-structured façade in the cloud.Mastering Azure API Managementis designed to help API developers and cloud engineers learn all aspects of Azure API Management, including security and compliance. It provides a pathway for getting started and learning valuable management and administration skills. You will learn what tools you need to publish a unified API façade towards backend services, independent of where and what they run on. You will begin with an overview of web APIs. You will learn about today's challenges and how a unified API management approach can help you address them. From there you'll dive into the key concepts of Azure APTable of ContentsPart I: Getting Started Chapter 1: Quick Start Chapter 2: OverviewPart II: Key Concepts Chapter 3: APIs and Products Chapter 4: APIs and products Chapter 5: Versions and Revisions Chapter 6: Subscriptions Chapter 7: Policies and Named Values Chapter 8: Developer Portal Part III: WorkflowChapter 9: API Development in Context Chapter 10: Developing policiesChapter 11: Deploying APIs Chapter 12: Power AppsPart IV: Enterprise Integration Chapter 13: Networking Chapter 14: Self-hosted API Gateway Part V: Maintenance Chapter 15: Security Chapter 16: Logging & MonitoringChapter 17: Administration
£42.74
APress Azure Arcenabled Data Services Revealed
Book SynopsisGet introduced to Azure Arc-enabled Data Services and the powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from the Azure cloud. This book shows how you can deploy and manage databases running on SQL Server and Postgres in your corporate data center or any cloud as if they were part of the Azure platform. This second edition has been updated to the latest codebase, allowing you to use this book as your handbook to get started with Azure Arc-enabled Data Services today. Learn how to benefit from Azure's centralized management, the automated rollout of patches and updates, managed backups, and more.This book is the perfect choice for anyone looking for a hybrid or multi-vendor cloud strategy for their data estate. The authors walk you through the possibilities and requirements to get Azure SQL Managed Instance and PostgresSQL Hyperscale deployed outside of Azure, so the services are accessible to companies that cannot move to the cloud or do not want to use the Microsoft cloud exclusively. The technology described in this book will benefit those required to keep sensitive services, such as medical databases, away from the public cloud equally as those who can't move to a public cloud for other reasons such as infrastructure constraints but still want to benefit from the Azure cloud and the centralized management and tooling that it supports. What You Will LearnUnderstand the fundamentals and architecture of Azure Arc-enabled data servicesBuild a multi-cloud strategy based on Azure Data ServicesDeploy Azure Arc-enabled data services on premises or in any cloudDeploy Azure Arc-enabled SQL Managed Instance on premises or in any cloudDeploy Azure Arc-enabled PostgreSQL Hyperscale on premises or in any cloudBackupand Restore your data that is managed by Azure Arc-enabled data servicesManage Azure-enabled data services running outside of AzureMonitor Azure-enabled data services through Grafana and KibanaMonitor Azure-enabled data services running outside of Azure through Azure MonitorWho This Book Is ForDatabase administrators and architects who want to manage on-premises or hybrid cloud data resources from the Microsoft Azure cloud. Especially for those wishing to take advantage of cloud technologies while keeping sensitive data on premises and under physical control.Table of Contents1. A Kubernetes Primer2. Azure Arc-Enabled Data Services3. Getting Ready for Deployment4. Installing Kubernetes5. Deploying a Data Controller in Indirect Mode 6. Deploying a Data Controller in Direct Mode 7. Deploying an Azure Arc-Enabled SQL Managed Instance8. Deploying Azure Arc-Enabled PostgreSQL Hyperscale 9. Monitoring and Management
£999.99
APress Microsoft Orleans for Developers
Book SynopsisUse a simple programming model and the .NET language of your choice to build large distributed systems. This book teaches you the Microsoft Orleans framework.Even well-versed professional software developers with expertise in C# (or another language) find themselves unequipped to meet the challenges of distributed systems as infrastructure moves to multi-core; multiple computers are being used for scale, redundancy, and cloud computing; and multi-region deployment is taking place.Orleans handles many of the concerns of distributed computing and cloud infrastructure, allowing you to concentrate on writing application logic.What You Will Learn Know the key concepts for building distributed systems Gain a background in the origin and evolution of Orleans, and why it is important for your projects Dive into each of the features available in Orleans by building an example application Develop troubleshootingTable of Contents1. Fundamentals2. Grains and Silos3. Hello World 4. Debugging an Orleans Application5. Orleans Dashboard6. Adding Persistence7. Adding ASP.NET Core8. Unit Testing9. Streams10. Timer and Reminders11. Transactions12. Event Sourced Grains13. Updating Grains14. Optimizations15. Advanced Features16. Interviews
£999.99
APress Up and Running with DAX for Power BI
Book SynopsisTake a concise approach to learning how DAX, the function language of Power BI and PowerPivot, works. This book focuses on explaining the core concepts of DAX so that ordinary folks can gain the skills required to tackle complex data analysis problems. But make no mistake, this is in no way an introductory book on DAX. A number of the topics you will learn, such as the concepts of context transition and table expansion, are considered advanced and challenging areas of DAX.While there are numerous resources on DAX, most are written with developers in mind, making learning DAX appear an overwhelming challenge, especially for those who are coming from an Excel background or with limited coding experience. The reality is, to hit the ground running with DAX, it''s not necessary to wade through copious pages on rarified DAX functions and the technical aspects of the language. There are just a few mandatory concepts that must be fully understood before DAX can be mastered. Table of ContentsChapter 1: Show Me the Data Chapter 2: DAX Objects, Syntax & Formatting Chapter 3: Calculated Columns & Measures Chapter 4: Evaluation Context Chapter 5: Iterators Chapter 6: The CALCULATE Function Chapter 7: DAX Table Functions Chapter 8: The ALL Function and All its Variations Chapter 9: Calculations on Dates: Using DAX Time Intelligence Chapter 10: Empty Values Versus Zero Chapter 11: Using Variables: Making Our Code More Readable Chapter 12: Returning Values in the Current Filter Chapter 13: Controlling the Direction of Filter Propagation Chapter 14: Working with Multiple Relationships Between Tables Chapter 15: Understanding Context Transition Chapter 16: Leveraging Context Transition Chapter 17: Virtual Relationships: the LOOKUPVALUE and TREATAS Functions Chapter 18: Table Expansion Chapter 19: The CALCULATETABLE Function
£999.99
APress Getting Started with Microsoft Viva
Book SynopsisUse the power of analytics, knowledge management, and discovery for improved employee retention and insight to the unique collaborative and learning needs of your organization using Viva, Microsoft''s new employee experience platform.This book introduces you to the four central tenets of Microsoft Viva, a platform designed to improve communication, knowledge, learning, and insight within an organization. The authors, all Microsoft MVPs and early users of Viva, share their first-hand experiences and knowledge to teach you how to configure, utilize, and adopt Viva Topics, Viva Connections, Viva Learning, and Viva Insights to drive knowledge management and discovery within an organization. In Part I, you will learn how to classify data and topics within your organization, and learn how the use of AI can bring to life the discovery of knowledge and information related to people and other topics, allowing for better understanding and clarity of the content you see every dayTable of ContentsPart 1: Microsoft Viva IntroductionChapter 1: Introduction to Microsoft VivaChapter 2: The Gears That Deliver Microsoft VivaChapter 3: Features & LicensingPart II: Microsoft Viva LearningChapter 4: Microsoft 365 AdoptionChapter 5: Introduction to Microsoft Viva LearningChapter 6: Viva Learning for AdministratorsChapter 7: Viva Learning for Employees & Managers Part 3: Microsoft Viva ConnectionsChapter 8: The IntranetChapter 9: Introduction to Microsoft Viva ConnectionsChapter 10: Preparation and SetupPart 4: Microsoft Viva TopicsChapter 11: Introduction to Viva TopicsChapter 12: Configuring Viva Topics Chapter 13: Topics Role in Knowledge ManagementChapter 14: Viva Topics Roles and ResponsibilitiesChapter 15: Creating and Working with Topics and Topic PagesPart 5: Microsoft Viva InsightsChapter 16: Employee WellbeingChapter 17: Licensing Viva Insights and Viva Insights CapacityChapter 18: Personal InsightsChapter 19: Manager InsightsChapter 20: Leader InsightsChapter 21: Advanced InsightsAppendix: Hyperlink Resources for Book
£43.99
APress Target C
Book SynopsisSo, you want to learn C# and Visual Studio 2022, but are a bit intimidated? Don''t be. Programming is within your grasp! Programmers at any level have to fully understand, and more importantly, be able to code the core constructs. It is impossible to use complex programming concepts such as classes before understanding what methods and variables and their data types are. Once there is a foundation built on the basics, then all other topics can fall in line.While it is a forgone conclusion that languages change with the introduction of new features, the core concepts do not. Even large enterprises do not always update to the latest versions of languages and frameworks; their backbone applications have been developed to work, regardless. More than ever, enterprises need developers who can master and apply the core programming concepts and then be up-skilled with newer language levels and features as they integrate into the company.This book builds from the ground up. You wTable of ContentsChapter 1. .NET Chapter 2. Software Installation Chapter 3. Introduction Chapter 4. Input and Output Chapter 5. Commenting Code Chapter 6. Data TypesChapter 7. Casting and Parsing Chapter 8. Arithmetic Chapter 9. Selection Chapter 10. Iteration Chapter 11. Arrays Chapter 12. Methods Chapter 13. Classes Chapter 14. Interfaces Chapter 15. String HandlingChapter 16. File HandlingChapter 17. Exception HandlingChapter 18. SerializationChapter 19. StructsChapter 20. EnumerationsChapter 21. DelegatesChapter 22. EventsChapter 23. GenericsChapter 24. Common RoutinesChapter 25. Programming LabsChapter 26. C# 11
£999.99
APress Troubleshooting Microsoft Teams
Book SynopsisLearn and understand Microsoft Teams functionality, potential issues, and the tools available to troubleshoot Teams. This book provides a complete overview of Teams Phone system (PSTN) connectivity, call routing and quality troubleshooting, and best practices to support a Teams environment.The book begins with an introduction to Microsoft Teams and it provides a troubleshooting terminology. You will understand how to identify and develop a systematic approach for troubleshooting Teams. You will learn Teams Phone (voice) management and how to handle issues related to: Direct Routing connectivity, call routing, emergency calling, and much more. The book covers issues related to Teams client-side and external access along with Teams call quality troubleshooting. You will gain knowledge of real-world issues and use Teams troubleshooting tools such as the: Connectivity Analyzer, call diagnostic tool, SBC Syslog, Call Quality Dashboard, and quality analytics tool. You will go Table of ContentsChapter 1: Introduction (Troubleshooting) Chapter Goal: Troubleshooting introduction No of pages 20-30 Sub -Topics 1. Introduction 2. What is Microsoft Teams? 3. Why are Teams so popular? 4. Understand troubleshoot approaches 5. Discuss a systematic approach to troubleshooting 6. Summary Chapter 2: Microsoft Teams Overview Chapter Goal: Whats new in Microsoft Teams and management No of pages: 30-40 Sub - Topics 1. Introduction 2. Microsoft Teams Service architecture 3. Teams, Team, Channel, file, and Tab 4. Microsoft Teams different client 5. Teams Phone system 6. Teams live Event 7. Introduction of Microsoft Teams admin center 8. Summary Chapter 3: Identify and Develop Systemic Approach for Teams Troubleshooting Chapter Goal: No of pages : 30 -35 Sub - Topics: 1. Introduction 2. Understand Microsoft Teams administration 3. Teams diagnostic logs and collecting process 4. Diagnose common Teams problem 5. Use a troubleshooting methodology using 6. Create and implement a plan of action 7. Summary Chapter 4: Troubleshoot Teams Identity and Sign-in Issues Chapter Goal: No of pages: 30-40 Sub - Topics: 1. Introduction 2. Understand and review Teams network configuration 3. Evaluate and design conditional access policies 4. Understand Teams Identity and troubleshoot Teams account issues 5. Capture and Analyze Teams sign-in logs 6. Troubleshoot issues with Teams apps (first and 3rd party) 7. Troubleshoot problems with public and private channels 8. Troubleshoot file issues for private and public channels 9. Summary Chapter 5: Troubleshoot Microsoft Teams Call Quality Issue. Chapter Goal: 1. Introduction 2. Understand and troubleshoot Teams signaling and media flow. 3. Learn and troubleshoot Teams One-to-One and multi-party call flow problem 4. Troubleshoot Teams meeting creation and recording issues 5. Examine Teams content sharing and attendee access problems 6. Effectively manage and troubleshoot Teams live events issues 7. Troubleshoot Teams messaging and reporting problems 8. Troubleshoot file sharing in person-to-person private chat 9. Summary Chapter 6: Troubleshoot Microsoft Teams Phone System (Calling plan & Direct routing) issue Chapter Goal: No of pages: 30-40 Sub - Topics: 1. Introduction 2. Understand Microsoft Teams phone system a. Teams calling plan b. Teams Direct Routing 3. Troubleshoot Teams Direct routing (connectivity) issue 4. Troubleshoot emergency calling issues. 5. Troubleshoot Teams Call (PSTN) routing issues. 6. Configure and troubleshoot audio conferencing 7. Troubleshoot dial-plan, voice routing, and emergency call routing policies 8. Troubleshoot phone system issues 9. Summary Chapter 7: Troubleshooting Teams client-side and external access issues Chapter Goal: No of pages: 20-30 Sub - Topics: 1. Introduction 2. Deploy and update Teams client software 3. Troubleshoot Teams client startup and configuration 4. Troubleshoot audio and video devices 5. Troubleshoot Teams desktop client performance issues 6. Understand Teams external and Troubleshoot external (federation) access issues 7. Enable and Troubleshoot Teams Guest access issues 8. Troubleshoot issues interoperating with Skype for Business 9. Summary Chapter 8: Apply best practices and Teams Optimal Management Using PowerShell Chapter Goal: No of pages: 30-40 Sub - Topics: · Introduction · Best practices for Implementation QoS · Best practices for Implementing VPN split tunnel · Lesson learning for applying Location-Based Routing (LBR) · Implementations inbound and outbound normalization rules · Frequently used PowerShell command and script · Summary Chapter 9: Teams real-world issue using troubleshooting tools Chapter Goal: No of pages: 20-30 Sub - Topics: 1. Introduction 2. Identify and Review Teams troubleshooting tools a. Connectivity analyzer b. Call diagnostic tool 3. Understand and use Teams call quality analytics tool a. Troubleshoot single user call quality issues 4. Use the Call Quality Dashboard to investigate audio and video issues. a. Investigate organization call quality issues 5. Log parsing tool 6. Diagnose and resolve Teams real-world issues 7. Summary Chapter 10: PowerBI based Teams call Quality dashboard for call quality troubleshooting Chapter Goal: No of pages: 30-40 Sub - Topics: 1. Introduction 2. PowerBI and Microsoft Teams 3. Design PowerBI based Teams Reports 4. Design Teams Call Quality dashboard to identify poor audio and video call 5. Use Call quality dashboard for call quality troubleshooting 6. Summary 7. Knowledge check
£999.99
APress Test Your Skills in C Programming
Book SynopsisReview the fundamental constructs in C# using Q&As and program segments to boost your confidence and gain expertise. This book will help you analyze your programs more efficiently and enhance your programming skills.The book is divided into three parts, where you will learn the fundamentals, object-oriented programming, and some advanced features of C#. In the first part, you will review C# and .NET basics along with the important constructs such as strings, arrays, and structures. In the second part, you''ll review the concepts of object-oriented programming in detail. Here, you will go through various program segments in class and objects, inheritance, polymorphism, abstraction, encapsulation, and much more. You will also analyze the output of the given programs with the help of Q&A sections. The uses of interfaces, static class, and exception handling are discussed in the book along with some other important concepts in C#. In the third and last part, you will learn aTable of ContentsPart I Fundamentals Chapter 1: Language Basics Chapter Goal: This chapter discusses the following topics: The important concepts in .NET The basic programming constructs in C#. Use of some useful data types including the var type. Use of some useful operators and explicit-casting. Use of the selection statements and case guards. Use of iteration statements. Use of the jump statements. Use of the ternary operator. No of pages: 28 Sub - Topics N Chapter 2: String and Arrays Chapter Goal: Once you finish this chapter, you can answer the following questions and related areas: How can you use string datatype in your program? How can you use the common in-built methods from the String class? How a String variable is different from a StringBuilder? How can you convert a string to an int? How can you use nullable reference type in a program? How to create arrays in C#? What are the different types of C# arrays and how to use them? How to use common in-built methods from the System.Array class? How can you iterate over a string or an array? No of pages 23 Sub - Topics NA Chapter 3: Enumeration and Structures Chapter Goal: This chapter discusses the following topics: The enum fundamentals Flags enumeration Defaut value expressions The struct fundamentals Non-destructive mutations No of pages: 26 Sub - Topics NA Part II Object-Oriented Programming Chapter 4: Class and Objects Chapter Goal: This chapter focuses on the following topics: Classes and objects creations. Instance fields and methods. Constructors and their usage. Optional parameters. Object initializers. Nested classes. The uses of private, internal, and public modifiers inside a class. No of pages: 17 Sub - Topics NA Chapter 5: Inheritance Chapter Goal: This chapter covers the following topics: Inheritance and types. Method and constructor overloading. Method overriding. Use of virtual, override, and new keywords. Use of the sealed keyword. Introductory discussion on covariance and contravariance No of pages 33 Sub - Topics NA Chapter 6: Polymorphism Chapter Goal: This chapter helps you to review: Polymorphism and its benefits. Abstract classes and their uses. Interfaces and their uses. Different types of interfaces. Writing polymorphic codes using abstract classes and interfaces No of pages: 30 Sub - Topics NA Chapter 7: Encapsulation Chapter Goal: This chapter covers the following topics: What is encapsulation? How is it different from an abstraction? Properties and their usage. Different ways to create a property. The usage of the get and set accessors. Virtual and abstract properties. The discussion of the init accessor. Indexers and their usage. How can the indexers and properties work with an interface? Discussion on different aspects of properties and indexers. No of pages: 26 Sub - Topics NA Chapter 8: Exception Handling Chapter Goal: This chapter covers the following topics: Exception and its uses in C# programming. Use of the try, catch, and finally blocks. Use of multiple catch blocks in a program. Use of a general catch block. How to throw and re-throw an exception. Use of exception filters. Custom exception class and its usage. No of pages: 23 Sub - Topics NA Chapter 9: Useful Concepts Chapter Goal: Q&A and program segments on some useful constructs such as casting and boxing, static class and methods, passing value type by value, passing value type by references(using ref and out keyword), extension methods, and so on. No of pages: 15-25+ Sub - Topics NA Part III Advanced Features Chapter 10: Delegates Chapter Goal: This chapter covers the following topics: Delegates and their uses Multicast delegates Some commonly used in-built delegates Covariance and contravariance using delegates No of pages: 20 Sub - Topics NA Chapter 11: Events Chapter Goal: This chapter helps you to review your understanding of events and discusses the following: Events creation and their uses. How to pass the event data. Use of event accessors. Use of interface events (both implicit and explicit). Simplified coding with events. No of pages: 22 Sub - Topics NA Chapter 12: Lambdas Chapter Goal: This chapter focuses on this and covers the following topics: Lambda expressions and their use Expression-bodied members Use of local variables inside lambda expressions. Event handling using lambda expressions. Use of a static lambda. Understanding natural type. No of pages: 22 Sub - Topics NA Chapter 13: Generics Chapter Goal: This chapter focuses on the following topics: The motivation behind generics. The fundamentals of generic programs. Use of generic interfaces. Use of generic constraints. Use of covariance and contravariance using generics. Self-referencing generic type. Experimenting with generic method’s overloading and overriding. Analyzing the static data in the context of generics. No of pages: 35 Sub - Topics NA Chapter 14: Multithreading Chapter Goal: Upon completion of this chapter, you’ll be able to answer the following questions: What are the threads and how can you create them? What is a multithreaded program? How does it differ from a single-threaded application? Why are the ThreadStart and ParameterizedThreadStart delegates important in thread programming? How to block a thread using Sleep or Join methods? How can you use lambda expressions in a multithreaded program? How to use important Thread class members? How a foreground thread is different from a background thread? What is synchronization and why is it needed? How can you implement thread safety in C# using lock statements? How can you implement an alternative approach to lock statements using Monitor’s Entry and Exit Method? What is a deadlock and how can you detect the deadlock in your system? What is the purpose of using the ThreadPool class? What are the associative pros and cons of using it? How to cancel a running thread in the managed environment? And many more. No of pages: 40 Sub - Topics NA Chapter 15: Miscellaneous Chapter Goal: Q&A and program segments on the related latest features that are covered in the previous chapters and any other important topics(if any). No of pages: 10-20+ Sub - Topics NA
£999.99
APress The Art of Site Reliability Engineering SRE with
Book SynopsisGain a foundational understanding of SRE and learn its basic concepts and architectural best practices for deploying Azure IaaS, PaaS, and microservices-based resilient architectures.The book starts with the base concepts of SRE operations and developer needs, followed by definitions and acronyms of Service Level Agreements in real-world scenarios. Moving forward, you will learn how to build resilient IaaS solutions, PaaS solutions, and microservices architecture in Azure. Here you will go through Azure reference architecture for high-available storage, networking and virtual machine computing, describing Availability Sets and Zones and Scale Sets as main scenarios. You will explore similar reference architectures for Platform Services such as App Services with Web Apps, and work with data solutions like Azure SQL and Azure Cosmos DB. Next, you will learn automation to enable SRE with Azure DevOps Pipelines and GitHub Actions. You''ll also gain an undersTable of ContentsChapter 1: The foundation of SREThis chapter lays out the foundation of Site Resiliency Engineering, founded by Google. From the base concepts of how IT Operations and Developers need to collaborate, to how SRE helps organizations in running business-critical workloads without major downtimeChapter 2: Service Level Management definitions and acronyms and their meaning in a real-life contextThis Chapter describes all common Service Level Agreements (SLA) definitions and acronyms, looked at from a real-world scenario to provide a clear understandingo Some examples, SLA, SLO, MTTF, MTBF, MTTR,…Chapter 3: Architecting Resilient Infrastructure as a Service (IaaS) Solutions in AzureSRE is all about providing ultimate uptime of your organization’s workloads, and this chapter will cover that in relation to Azure IaaS Compute solutions. Explaining the Azure reference architecture for high-available storage, networking and Virtual Machine computing, describing Availability Sets and Zones and ScaleSets as main scenarios. It will also touch on preparing for Disaster Recovery with Azure Backup and Azure Site Recovery, helping you to quickly mitigate outages in case of a failureChapter 4: Architecting Resilient Platform as a Service (PaaS) Solutions in AzureFollowing on the scenario of Virtual Machines, this chapter details similar reference architectures for Platform Services such as App Services with Web Apps, but also touching on data solutions like Azure SQL and Azure Cosmos DBChapter 5: Architecting Resilient Serverless and Microservices architectures in AzureThis third chapter in the reference architecture topic describes how to build high-available, business-critical scenarios using Serverless Functions and Azure LogicApps, as well as Microservices scenarios using Azure Container Instance and Azure Kubernetes Service (AKS).Chapter 6: Automation to enable SRE with Azure DevOps Pipelines / GitHub ActionsAutomation is the cornerstone to SRE, allowing businesses to not only deploy new workloads in a easy way, but also relying on SRE to avoid critical outages or, when an outage occurs, relying on automation to mitigate the problem as fast as possible. Sharing several examples from both Azure DevOps Pipelines and GitHub Actions, this chapter provides the reader a lot of real-life examples to reuse in their own environmentChapter 7: Efficiently handling blameless post-mortems Post-Mortems are the way to look back at what caused the outage, and describe any lessons learned for the future, helping in avoiding a similar outage in the future, or assist in quickly fixing an identical incident. Blameless is where the focus is on finding the root-cause of the problem, without pinpointing any individual or team as being the victim. This chapter describes how an open culture around post-mortems dramatically helps in optimizing SRE and the overall company culture around managing and running IT systems and application workloads. Chapter 8: Monitoring as the key to knowledge Besides the automated deployments, monitoring is the 2nd big technical topic in any SRE scenario. You can’t manage what you don’t know. This chapter provides an overview of Azure Monitor and Log Analytics, which forms the foundation of monitoring Azure and Hybrid-running workloads. Starting from metrics for the different Azure services touched on in earlier chapters, this chapter also covers how to export logs to 3rd party solutions such as Splunk or integrating dashboarding tools like Grafana
£28.49
APress Pro SQL Server 2022 Wait Statistics
Book SynopsisUse this practical guide to analyze and troubleshoot SQL Server performance using wait statistics. You''ll learn to identify precisely why your queries are running slowly. And you''ll know how to measure the amount of time consumed by each bottleneck so you can focus attention on making the largest improvements first. This edition is updated to cover analysis of wait statistics current with SQL Server 2022. Whether you are new to wait statistics, or already familiar with them, this book provides a deeper understanding on how wait statistics are generated and what they mean for your SQL Server instance''s performance. The book goes beyond the most common wait types into the more complex and performance-threatening wait types. You''ll learn about per-query wait statistics and session-based wait statistics, and the types of problems they can help you solve. The different wait types are categorized by their area of impact, including CPU, IO, Latching, Locking, and many more.Clear examples are included to help you gain practical knowledge of why and how specific wait times increase or decrease, how they impact your SQL Server''s performance, and what you can do to improve performance. After reading this book, you won''t want to be without the valuable information that wait statistics provide regarding where you should be spending your limited tuning time to maximize performance and value to your business. What You''ll Learn Understand how the SQL Server engine processes requests Identify resource bottlenecks in a running SQL Server instance Locate wait statistics information inside DMVs and Query Store Analyze the root cause of sub-optimal performance Diagnose I/O contention and locking contention Benchmark SQL Server performance Improve database performance by lowering overall wait time Who This Book Is ForDatabase administrators who want to identify and resolve performance bottlenecks, those who want to learn more about how the SQL Server engine accesses and uses resources inside SQL Server, and administrators concerned with achieving-and knowing they have achieved-optimal performanceTable of ContentsPart I: Foundations of Wait Statistics Analysis1. Wait Statistics Internals2. Querying SQL Server Wait Statistics3. The Query Store4. Building a Solid BaselinePart II: Wait Types5. CPU-Related Wait Types6. IO-Related Wait Types7. Backup-Related Wait Types8. Lock-Related Wait Types9. Latch-Related Wait Types10. High-Availability and Disaster-Recovery Wait Types11: Preemptive Wait Types12: Background and Miscellaneous Wait Types13. In-Memory OLTP-Related Wait Types14. Appendix I. Example SQL Server Machine Configurations15. Appendix II. Spinlocks16. Appendix III. Latch Classes
£49.49
APress Pro SQL Server 2022 Administration
Book Synopsis Get your daily work done efficiently using this comprehensive guide for SQL Server DBAs that covers all that a practicing database administrator needs to know. Updated for SQL Server 2022, this edition includes coverage of new features, such as Ledger, which provides an immutable record of table history to protect you against malicious data tampering, and integration with cloud providers to support hybrid cloud scenarios. You''ll also find new content on performance optimizations, such as query pan feedback, and security controls, such as new database roles, which are restructured for modern ways of working. Coverage also includes Query Store, installation on Linux, and the use of containerized SQL. Pro SQL Server 2022 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data iTable of ContentsPart I: Installation and Configuration1. Planning the Deployment2. GUI Installation3. Server Core Installation4. Installation on Heterogeneous Operating Systems5. Configuring the InstancePart II: Database Administration6. Database Configuration7. Table Optimizations8. Indexes and Statistics9. Database ConsistencyPart III: Security, Resilience, and Scaling Workloads10. SQL Server Security Model11. Auditing & Ledger12. Encryption13. Backups and Restores14. High Availability and Disaster Recovery Concepts15. Implementing AlwaysOn Availability Groups16. Implementing Log Shipping17. Scaling WorkloadsPart IV: Performance and Maintenance18. SQL Server Metadata19. Locking and Blocking20. Extended Events21. Monitoring & Managing a Hybrid Environment22. Query Store23. Automating Maintenance Routines24. Policy-Based Management25. Resource Governor
£999.99
APress Azure SQL Hyperscale Revealed
Book SynopsisTake a deep dive into the Azure SQL Database Hyperscale Service Tier and discover a new form of cloud architecture from Microsoft that supports massive databases. The new horizontally scalable architecture, formerly code-named Socrates, allows you to decouple compute nodes from storage layers. This radically different approach dramatically increases the scalability of the service. This book shows you how to leverage Hyperscale to provide next-level scalability, high throughput, and fast performance from large databases in your environment. The book begins by showing how Hyperscale helps you eliminate many of the problems of traditional high-availability and disaster recovery architecture. You''ll learn how Hyperscale overcomes storage capacity limitations and issues with scale-up times and costs. With Hyperscale, your costs do not increase linearly with database size and you can manage more data than ever at a lower cost. The book teaches you how tTable of ContentsIntroductionPart I. Architecture.1. The Journey to Hyperscale Architecture in Azure SQL2. Azure SQL Hyperscale Architecture: Concepts and FoundationsPart II. Planning and Deployment3. Planning an Azure SQL DB Hyperscale Environment 4. Deploying a Highly Available Hyperscale Database into a Virtual Network 5. Administering a Hyperscale Database in a Virtual Network in the Azure Portal6. Configuring Transparent Data Encryption to Bring Your Own Key7. Enabling Geo-replication for Disaster Recovery8. Configuring Security Features and Enabling Diagnostic and Audit Logs9. Deploying Azure SQL DB Hyperscale using PowerShell10. Deploying Azure SQL DB Hyperscale using Bash and Azure CLI11. Deploying Azure SQL DB Hyperscale using Azure Bicep12. Testing Hyperscale Database Performance Against Other Azure SQL Deployment OptionsPart III. Operation and Management13. Monitoring and Scaling 14. Backup, Restore and Disaster Recovery15. Security and Updating16. Managing CostsPart IV. Migration17. Determining whether Hyperscale is Appropriate 18. Migrating to Hyperscale19. Reverse Migrating Away from HyperscaleConclusion
£999.99
APress Beginning Microsoft Dataverse
Book SynopsisUnderstand the role that Dataverse plays in the low-code revolution that helps businesses gain advantage from being more agile with technology. This book shows you how to use Dataverse to solve business problems by describing the layers of a solution in the Power Platform and the options that exist at each layer so you can make informed decisions as you develop your solutions. The book shows how Dataverse is a central piece of the Microsoft Power Platform and helps tech-savvy professionals move nimbly and seize the day when opportunities present themselves. The book starts out by covering the platform in terms of its layers so you can orient yourself with the features that exist at each level and what that means to you as a developer. You will learn how to work inside the data layer to design tables to store data and relationships and manage how it all works together. You will learn how to apply business logic and validation in the business layerto ensure data integrity and enforce Table of Contents1. Microsoft Power Platform2. Planning Your Solution Design3. Data Layer4. Business Logic Layer5. Presentation Layer6. Security 7. Integration with Third-Party Tools8. Dataverse for Teams
£49.49
APress Pro Power BI Architecture
Book SynopsisThis book provides detailed guidance around architecting and deploying Power BI reporting solutions, including help and best practices for sharing and security. You''ll find chapters on dataflows, shared datasets, composite model and DirectQuery connections to Power BI datasets, deployment pipelines, XMLA endpoints, and many other important features related to the overall Power BI architecture that are new since the first edition. You will gain an understanding of what functionality each of the Power BI components provide (such as Dataflow, Shared Dataset, Datamart, thin reports, and paginated reports), so that you can make an informed decision about what components to use in your solution. You will get to know the pros and cons of each component, and how they all work together within the larger Power BI architecture.Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and bTable of ContentsIntroductionPart I. Getting Started1. Power BI Ecosystem and Components2. Tools and PreparationPart II. Development3. Import Data or Schedule Refresh4. DirectQuery 5. Live Connection6. Composite Mode7. Choosing the Right Connection Type8. Dataflows9. Shared Datasets10. Multi-Developer Architecture11. Hybrid Architecture using other Microsoft Services12. DirectQuery to Power BI Dataset13. Dataflow Development Architecture14. Analyze in Excel15. Development Tools16. Power BI Helper for Developers17. Dataset Types18. Realtime Power BI Solution19. Paginated Reports20. Power BI Templates21. Power BI Desktop Development Templates22. Incremental Refresh23. Big Data Considerations, Hybrid Tables, and PerformancePart III. Deployment24. Power BI Service Content25. Power BI Report Server26. Gateway27. Power BI Licensing Guide28. Power BI Premium29. Premium Per User30. Premium Settings and Configuration31. Tenant Settings32. Administrator Reports and Metrics33. Workspace Structure and Architecture34. Workspace Rules35. Deployment Pipeines36. REST API for Deployment and Architecture37. Power BI Helper for Deployment and Administration38. XMLA EndpointPart IV. Sharing and Security39. Governance40. Dashboard and Report Sharing41. Workspaces as Collaborative Environments42. Power BI Apps43. Embed Code and Publish to Web44. Embed in SharePoint Online45. Microsoft Teams Integration46. Power BI Embedded47. SharePoint Online Integration48. Microsoft Office49. Comparing Power BI Sharing Methods50. Usage Metrics Reports51. Usage Metrics using REST API52. Usage Metrics using Power BI Helper53. Row Level Security54. Dynamic Row Level Security55. Object-Level Security
£999.99
APress Pro Exchange Administration
Book SynopsisMove to the current version of Exchange Server, whether it be stand-alone, on-premises, or in a hybrid configuration with Exchange Online.Table of ContentsChapter 1. Infrastructure and Exchange Server 1.1. Exchange and Active Directory 1.2. Exchange Online and Azure Active Directory 1.3. Exchange introduction 1.4. Designing Exchange server 1.5. Installing Exchange server 1.6. High Availability 1.7. Managing Exchange server 1.7.1. Managing recipients 1.7.2. Exchange Transport 1.7.3. Upgrading from Exchange 2013 or Exchange 2016 1.7.4. Cumulative Updates and Security Updates 1.7.5. Monitoring and Reporting Chapter 2 .Microsoft 365 Integration 2.1. Azure AD Containers and Identities 2.2. Azure AD Connect 2.3. Exchange Online 2.4. Moving to Exchange Online 2.4.1. Exchange Hybrid 2.4.2. Managing hybrid recipients 2.4.3. Exchange Online Archiving 2.5. Hybrid Transport 2.5.1. Edge Transport Server 2.5.2. Mail Flow 2.5.3. Centralized Mail Flow 2.5.4. Enhanced Filtering 2.5.5. Authentication Chapter 3.Security 3.1. Publishing 3.1.1. Azure App Proxy 3.1.2. Frontdoor 3.2. Email Authentication 3.2.1. SPF, DKIM and DMARC 3.2.2. DANE 3.2.3. MTA-STS 3.3. Message hygiene 3.3.1. Anti-Malware 3.3.2. Anti-Phishing 3.3.3. Defender for Office 365 3.3.4. Security Defaults 3.3.5. Business E-mail Compromise 3.4. Hybrid Modern Authentication 3.5. Multi-Factor Authentication 3.6. Access Rules 3.7. Conditional Access 3.8. SMTP AUTH 3.9. S/MIME 3.10. Role Based Access Control 3.11. Split Permissions 3.12. Windows Antimalware Scan InterfaceChapter 4.Compliance 4.1. Backup and Restore 4.2. In-place archiving 4.3. eDiscovery 4.4. Online Hold 4.5. Message Records Management 4.6. Data Loss Prevention 4.7. Transport Rules 4.8. Auditing 4.9. Information Rights Management
£28.04
Microsoft Press,U.S. Programming for the Internet of Things: Using
Book SynopsisRapidly implement Internet of Things solutions Creating programs for the Internet of Things offers you an opportunity to build and program custom devices whose functionality is limited only by your imagination. This book teaches you to do exactly that, with solutions presented in a step-by-step format. When you read this book, you not only learn the fundamentals of device programming, you will also be ready to write code for revolutionizing devices and robots. You don’t need to be an expert in low-level programming to benefit from this book. It explains basic concepts and programming techniques before diving into the more complicated topics. Each of the book’s chapters and appendices contains a suitable level of detail to help you quickly master device programming. MCP Dawid Borycki shows you how to: Build Universal Windows Platform (UWP) applications that target interconnected embedded devices Design and implement background apps for seamless integration with hardware components Use intrinsic UWP functionality to detect and track human faces Build artificial auditory, visual, and learning systems Process audio signals to blink LEDs to the rhythm of music Use OpenCV to develop custom image-processing algorithms Communicate with external devices by using serial, USB, Wi-Fi, and AllJoyn connectivity Design and implement applications to control DC, stepper, and servo motors for robotics Use Microsoft Cognitive Services to detect human emotions Build predictive analysis and preventive maintenance systems by using the Azure IoT Suite Table of ContentsPART I ESSENTIALS Chapter 1 Embedded devices programming Chapter 2 Universal Windows Platform on devices Chapter 3 Windows IoT programming essentials Chapter 4 User interface design for headed devices PART II DEVICE PROGRAMMING Chapter 5 Reading data from sensors Chapter 6 Input and output Chapter 7 Audio processing Chapter 8 Image processing Chapter 9 Connecting devices Chapter 10 Motors Chapter 11 Device learning PART III AZURE IOT SUITE Chapter 12 Remote device monitoring Chapter 13 Predictive maintenance Chapter 14 Custom solution Appendix A Code examples for controlling LED using Visual Basic and JavaScript Appendix B Raspberry Pi 2 HDMI modes Appendix C Bits, bytes, and data types Appendix D Class library for Sense HAT sensors Appendix E Visual C++ component extensions Appendix F Setting up Visual Studio 2017 for IoT development
£46.70
APress Distributed .NET Programming in C#
Book SynopsisBarnaby describes how to use the new .NET technologies to build fast, scalable, and robust distributed applications.Table of ContentsA table of contents is not available for this title.
£999.99
APress Visual Basic .NET Class Design Handbook: Coding
Book Synopsis* Learn how to create robust, flexible, reusable classes with Visual Basic .NET. * Understand the different kinds of types and how classes relate to the .NET type framework. * See how .NET’s delegate-based event system works, and how to control and exploit inheritance in types. Table of ContentsA table of contents is not available for this title.
£28.34