Microsoft programming Books

Book SynopsisAmazon Web Services (AWS) is the leading public cloud platform. In this book you will learn to use Microsoft PowerShell to create, host, manage, and administer workloads using Amazon Web Services. You will learn how to create virtual machines, provision storage, configure networks, and more-all using your preferred Windows scripting language.CIOs everywhere are leading their organizations to the cloud, but there are few books available to help. This book focuses on moving Microsoft Windows workloads to the cloud using technologies familiar to enterprise Microsoft-based professionals.The completely revised and expanded Pro PowerShell for Amazon Web Services is written specifically for Windows professionals who already know PowerShell and want to learn to host Windows workloads on Amazon Web Services. The cloud offers information technology workers significant cost savings and agility unimaginable even just a few years ago. Tasks that traditionally took weeks of work, costing thousands of dollars, can be completed in minutes for a fraction of a penny.New chapters in this second edition cover: AWS Lambda, Amazon WorkSpaces, Amazon AppStream 2.0, AWS Directory Service, Amazon WorkDocs, and AWS System Manager.What You''ll Learn Create and manage Windows servers on Elastic Compute Cloud (EC2) Configure and secure networks with Virtual Private Cloud (VPC) Leverage autoscaling to adjust resources as load changes Deploy and manage SQL Server using the Relational Database Service (RDS) Manage virtual desktops using WorkSpaces and AppStream Leverage AWS Systems Manager to manage Windows at scale Who This Book Is ForWindows professionals who want to learn more about Amazon Web Services, with a focus on running Windows workloads and automated management at scale using PowerShell tools for AWS. The book assumes you have knowledge of Windows and PowerShell, but are new to AWS.Table of Contents

Read more less

Book SynopsisDESCRIPTION PowerShell provides a single, unified administrative command line from which to control and automate virtually every aspect of a Windows system. It accepts and executes commands immediately, and scripts can be written to manage most Windows servers like Exchange, IIS, and SharePoint. This updated book covers PowerShell features that run on Windows 7, Windows Server 2008 R2, and later. This edition is appropriate for PowerShell version 3 and later. There is coverage for new PowerShell version 5 features like PowerShellGet, however PowerShell fundamentals are unchanged. Learn Windows PowerShell in a Month of Lunches, Third Edition is an innovative tutorial designed for busy IT professionals. With just one hour a day for a month, readers will be automating Windows tasks faster than they ever thought possible. They start with the basics (What is PowerShell and what can be done with it). Then, it moves systematically through the techniques and features that facilitate efficient and effective results. KEY FEATURES• A great start with a great tutorial • Concise and easy-to-follow • Based on years of successful training techniques • Hands-on exercises and labs AUDIENCE Experience with Windows administration is helpful. No programming or scripting experience is assumed. ABOUT THE TECHNOLOGY PowerShell is an automation engine for Windows systems. It is being built into all major Microsoft products and many third party products. PowerShell allows for the automations of day to day administration tasks and is a must learn technology for administrators.

Read more less

Book SynopsisNow in its 7th edition, Visual Basic in easy steps shows how to create Windows applications using the latest Visual Studio Community programming environment. Using examples with free downloadable code, this renowned guide covers:Form controls, application properties, the programming language, live code analysis, problem-solving and debugging techniques.Creating macros for Word and Excel in Microsoft Office, using VBA. Manipulating files and data using VBScript. Incorporating external data into your applications from text files, Excel spreadsheets, XML documents, live RSS web feeds, and SQL databases. Ideal for anyone wanting to quickly understand Visual Basic fundamentals and master the key techniques. By the end of the book, you'll be creating your own interactive applications!Visual Basic in easy steps, 7th edition has an easy-to-follow style that will appeal to anyone who wants to begin Windows programming, including: Programmers who want to quickly learn the latest Visual Basic techniques.Students who are studying computing at school or college. Those seeking a career in Information Technology who need a thorough understanding of Visual Basic programming. Updated for Visual Basic 2022 edition (Visual Basic 17.0).

Read more less

Book Synopsis

Read more less

Book Synopsis Prepare for Microsoft Certification Exam 70-483: Programming in C#. The What, Why, and How of each concept is presented along with quick summaries, code challenges, and exam questions to review and practice key concepts. You will learn how to use: Lambda expressions to write LINQ query expressions Asynchronous programming with the Async and Await keywords to maximize performance of slow applications Regular expressions to validate user input Reflection to create and handle types at runtime  and much more The source code in the book will be available in the form of iCanCSharp notebooks and scripts that allow you to try out examples and extend them in interesting ways. What You Will Learn   Understand the necessary knowledge and skill set to prepare for Microsoft Exam 70-483  Study Table of ContentsChapter 1:Fundamentals of C#.- Chapter 2: Types in C#.- Chapter 3: Getting Started with Object Oriented Programming.- Chapter 4: Advanced C#.- Chapter 5: Implementing Delegates and Events.- Chapter 6: Taking a Deep Dive into LINQ.- Chapter 7: Managing the Object Life Cycle.- Chapter 8: Multi-Threaded, Async, and Parallel Programming.- Chapter 9: Exception Handling and Validating Application Input - Chapter 10: File I/O Operations.- Chapter 11: Serialization ad Deserialization.- Chapter 12: Consuming Data.- Chapter 13: Working with Cryptography.- Chapter 14: Assembly and Reflection.- Chapter 15: Debugging and Diagnostics.- Chapter 16: MCQs.

Read more less

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

Book SynopsisAccelerate your digital transformation and break down silos with Microsoft Dynamics 365 It's no secret that running a business involves several complex parts like managing staff, financials, marketing, and operationsjust to name a few. That's where Microsoft Dynamics 365, the most profitable business management tool, comes in. In Microsoft Dynamics 365 For Dummies, you'll learn the aspects of the program and each of its applications from Customer Service to Financial Management. With expert author Renato Bellu's clear instructions and helpful tips, you'll be managing to your fullest advantage before you know it. Let's get started! Digitally transform your business by connecting CRM and ERPUse data to make decisions across all business functionsIntegrate Dynamics 365 with Office 365 and LinkedInManage financials and operations Are you running a dynamic business? This book shows you how!Table of ContentsIntroduction 1 Who Should Buy This Book 1 About This Book 2 Part 1: Doing Great Things with Microsoft Dynamics 365 2 Part 2: Customer Engagement (formerly Dynamics CRM Online) 2 Part 3: Business Central ERP (formerly Dynamics NAV) 2 Part 4: Finance and Operations ERP (formerly Dynamics AX) 3 Part 5: The Part of Tens 3 Foolish Assumptions 3 Icons Used in This Book 3 Beyond the Book 4 Part 1: Doing Great Things with Microsoft Dynamics 365 5 Chapter 1: Floating on a Secure Cloud 7 Getting Under the Dynamics 365 Umbrella 9 Gaining a little historical perspective 10 Reading the roadmap for Microsoft ERP and CRM 12 Asking what’s in the Dynamics 365 “sausage” 13 Standardizing the tools and terminology 15 Transitioning to the Cloud 16 Understanding the difference between hosted client/server and true SaaS 17 Migrating from Dynamics GP or SL to Dynamics 365 19 Migrating from Dynamics CRM or CRM Online to Dynamics 365 21 Migrating from Dynamics AX to Dynamics 365 Enterprise edition 22 Migrating from Dynamics NAV to Dynamics 365 Business edition 23 Chapter 2: Extending Your Reach with Office 365 25 Working with the Admin Center 25 Managing users 26 Purchasing and managing subscriptions 28 Setting the password expiration 31 Integrating Dynamics 365 with Outlook Email 32 Adding the Excel Add-In for Finance and Operations 37 Organizing Documents with SharePoint and OneDrive 40 Messaging with Skype for Business 45 Chapter 3: Powering Up Your Business Intelligence 49 A Little Pre-History 50 Exploring Data through Power BI 51 Installing Power BI Desktop 54 Connecting to Dynamics 365 with Power BI Desktop 55 Connecting to a file 56 Connecting to a SQL View 56 Connecting to Dynamics 365 57 Connecting Power BI to Business Central 57 Connecting Power BI to Finance and Operations 59 Harnessing the Power of Apps and Content Packs 63 Embedding Dashboards in Dynamics 365 65 Chapter 4: Extending Dynamics 365 with PowerApps 67 Providing Power to Your People with PowerApps 68 Finding out whether PowerApps is right for you 70 Making external PowerApps connections 72 Adding an Option set 74 Adding a data connection 76 Making your app your own with App Settings 78 Connecting PowerApps to Dynamics 365 79 Chapter 5: Going with the Microsoft Flow to Enhance Dynamics 365 83 Setting Up Basic Workflows Using Microsoft Flow 84 Grasping the Relationship Between Document Management and Workflow 87 Seeing How Microsoft Does ECM 88 Understanding Workflow in the ERP and CRM Realms 89 Considering your workflow options in Dynamics 365 90 Comprehending the Microsoft Flow advantage 94 Part 2: Customer Engagement (Formerly Dynamics Crm Online) 97 Chapter 6: Turning Relationships into Revenue with Sales 99 Understanding CRM-Related Terms 99 Navigating the Navigation Bar 103 Working with Leads, Accounts, and Contacts 105 Leading the way with leads 107 Working with accounts 110 Connecting with contacts 111 Tracking Opportunities 114 Creating Quotes, Orders and Invoices 116 Chapter 7: Connecting with Customers Anytime, Anywhere with Customer Service 117 Knowing Your Way Around Dynamics 365 for Customer Service 118 Users 119 Accounts 120 Contacts 120 Cases 120 Posts and notes 121 Activities 121 Tasks 121 Queues 123 Views 123 Working with Cases 125 Finding a case 125 Adding a new case 127 Annotating an existing case 129 Taking action on an existing case 130 Adding knowledge articles (KB records) 132 Relating a case to other information 133 Gaining Control with Dynamics 365 for Customer Service Dashboards 135 Chapter 8: Profiting from Project Service Automation 137 Categorizing Project Software 139 Avoiding complicated project accounting 141 Rules of thumb for selecting project software in Dynamics 365 143 Knowing Your Way around Dynamics 365 for Project Service Automation 144 Connecting remotely with the Project Service Hub 146 Getting familiar with the components of Project Service Automation 147 Recognizing the importance of planning the setup of Project Service 148 Chapter 9: Creating and Nurturing Leads with Marketing 153 Connecting Marketing to Sales 154 Escaping the Doldrums of Drab Emails and Boring Web Pages 156 Using templates to get up to speed quickly 157 Segmenting your contacts for marketing and subscription lists 158 Adding a static marketing segment 159 Listening to the Voice of the Customer 161 Dashing Off to Marketing Dashboards 164 Configuring Advanced Settings in Dynamics 365 for Marketing 164 Chapter 10: Going Mobile with Field Service 167 Assessing Microsoft’s FSM Competitors 169 Taking the Back-office ERP into Consideration 170 Getting Acquainted with the Key Components of Dynamics 365 for Field Service 171 Living the Dream of Efficient Field Service: The Work Order Lifecycle 174 Configuring Administrative Settings for Dynamics 365 for Field Service 175 Working with Work Orders 177 Adding a Customer Asset 179 Transferring Inventory 180 Part 3: Business Central Erp (Formerly Dynamics Nav) 183 Chapter 11: Accounting for Your Business with Business Central 185 Getting to Know the Interface 188 Making Your Way Around the Home Screen 189 Setting Up the Books 191 Adding accounts to the chart of accounts 192 Defining G/L account categories 194 Specifying bank accounts 196 Entering Sales Quotes 198 Creating Sales Orders and Invoices 200 Creating Sales Credit Memos 202 Maintaining Customers 204 Maintaining Vendors 207 Chapter 12: Setting Up Business Central for Optimal Results 211 Migrating from Dynamics NAV to Business Central 213 Navigating in Business Central 215 Searching for screens and reports 215 Navigating by menu 218 Feeling at home in your Role Center 220 Setting Up Business Central 223 Working with manual setup 225 Setting up number series (sequence numbers) 227 Defining number series relationships 229 Managing users and permissions 230 Setting up inventory 233 Part 4: Finance and Operations Erp (Formerly Dynamics Ax) 237 Chapter 13: Going Beyond Crunching Numbers with Financial Management 239 Getting a Bird’s-Eye View of D365O Capabilities 242 Raising the Flag on Microsoft’s Flagship ERP 243 Learning How to Get Around in D365O 246 Navigating with tiles 249 Setting user preferences 250 Harnessing the Power of Financial Dimensions 252 Chapter 14: Becoming a Smooth Operator with Operations 259 Changing Companies 260 Navigating by Module 261 Taking Advantage of Keyboard Shortcuts 263 Taking a Deeper Dive into D365O Capabilities by Module 264 Mastering Master Data in D365O 268 Surveying the vendor record 268 Surveying the customer record 271 Surveying the inventory item (released product) record 273 Using the More Options button 276 Working with List Pages 278 Exporting List Pages to Excel Spreadsheets 281 Chapter 15: Looking Under the Hood (Understanding the D365O Technology) 283 Upgrading from Dynamics AX to Dynamics 365 for Finance and Operations 284 Migrating customizations from over-layering to extensions 285 Rewriting integrations created with AIF 286 Tapping into technology for integrations and data conversions 287 Using a comprehensive design document and a right-sized project plan 289 Personalizing the User Interface 290 Configuring the Global Address Book 297 Creating additional address books 299 Setting global address book default values 299 Creating new party records 300 Transforming Your HR Department with Talent 304 Filing Expense Reports with Expense Management 306 Part 5: The Part of Tens 309 Chapter 16: The Ten Most Exciting Capabilities of Dynamics 365 311 Supercomprehensive Coverage 311 Scalability with Azure 314 Mobile Computing 315 Localization Features 316 Employee Self-Service 318 Common Data Model 321 Team Member License 323 General Data Protection Regulation 323 Unified Interface 324 Categorized and Relevance Search 325 Chapter 17: Ten Dynamic 365 Myths to Dispel 327 Myth 1: Investing in ERP Doesn’t Pay 327 Myth 2: Our ERP Is Too Entrenched 330 Myth 3: ERP Is Too Complex for the Cloud 332 Myth 4: Integrations Are Not Worth It — Just Rekey the Data 333 Myth 5: Software as a Service Is More Expensive than On-Premise 334 Myth 6: The Cloud Is Not Secure Enough for ERP 335 Myth 7: What If the Internet Goes Down 337 Myth 8: I’ll Lose My Data in the Cloud 337 Myth 9: You Won’t Have Control of Your Data 338 Myth 10: Cloud Apps Are Not Customizable 339 Index 341

Read more less

Book SynopsisWelcome to the most comprehensive foundational guide available on the topic of C# coding and .NET. This book goes beyond do this, to achieve this to drill down into the core stuff that makes a good developer, great. This expanded 11th edition delivers loads of new content on Entity Framework, Razor Pages, Web APIs and more. You will find the latest C# 10 and .NET 6 features served up with plenty of behind the curtain discussion designed to expand developers' critical thinking skills when it comes to their craft. Coverage of ASP.NET Core, Entity Framework Core, and more sits alongside the latest updates to the new unified .NET platform, from performance improvements to Windows Desktop apps on .NET 6, updates in XAML tooling, and expanded coverage of data files and data handling. Going beyond the latest features in C# 10, all code samples are rewritten for this latest release.Dive in and discover why this essential classic is a favorite of C# developers worldwide. Gain a solid fouTable of ContentsPart 1: Introducing C# and .NET 61 Introducing C# and .NET (Core) 62 Building C# ApplicationsPart 2: Core C# Programming3 Core C# Programming Constructs, Part 14 Core C# Programming Constructs, Part 2Part 3: Object Oriented Programming with C#5 Understanding Encapsulation6 Understanding Inheritance and Polymorphism7 Understanding Structured Exception Handling8 Working with Interfaces9 Understanding Object LifetimePart 4: Advanced C# Programming10 Collections and Generics11 Advanced C# Language Features12 Delegates, Events, and Lambda Expressions13 LINQ To Objects14 Processes, AppDomains, and Load Contexts15 Multithreaded, Parallel, and Async ProgrammingPart 5: Programming with .NET Core Assemblies16 Building and Configuring Class Libraries17 Type Reflection, Late Binding, Attributes, and Dynamic Types18 Understanding CIL and the Role of Dynamic AssembliesPart 6: File Handling, Object Serialization, and Data Access19 File I/O and Object Serialization20 Data Access with ADO.NETPart 7: Entity Framework Core21 Introducing Entity Framework Core22 Exploring EF Core 23 Build a Data Access Layer with Entity Framework Core24 Test Driving the Autolot Data Access LayerPart 8: Windows Client Development25 Introducing Windows Presentation Foundation and XAML26 WPF Controls, Layouts, Events, and Data Binding27 WPF Graphics Rendering Services28 WPF Resources, Animations, Styles, and Templates29 WPF Notifications, Validations, Commands, and MVVMPart 9: ASP.NET Core30 Introducing ASP.NET Core31 Diving into ASP.NET Core32 RESTful Services with ASP.NET Core33 Web Applications using MVC34 Web Applications using Razor Pages

Read more less

Book SynopsisThis portable reference to PowerShell summarizes the command shell and scripting language, and provides a concise reference to the many tasks that make PowerShell so useful. If you're a busy administrator and don't have time to plow through huge books or search online, this is the ideal on-the-job tool.

Read more less

Book SynopsisModel, map, and access data effectively with Entity Framework Core 2, the latest evolution of Microsoft''s object-relational mapping framework. You will access data utilizing .NET objects via the most common data access layer used in ASP.NET Core MVC 2 projects.  Best-selling author Adam Freeman explains how to get the most from Entity Framework Core 2 in MVC projects. He begins by describing the different ways that Entity Framework Core 2 can model data and the different types of databases that can be used. He then shows you how to use Entity Framework Core 2 in your own MVC projects, starting from the nuts and bolts and building up to the most advanced and sophisticated features, going in-depth to give you the knowledge you need. Chapters include common problems and how to avoid them. What You''ll Learn Gain a solid architectural understanding of Entity Framework Core 2 CrTable of ContentsPart 1------1 - Entity Framework Core in Context2 - Your First Entity Framework Core Application3 - Working with Databases4 - SportsStore - A Real (Data) Application5 - SportsStore - Storing Data6 - SportsStore - Modifying Data7 - SportsStore - Expanding the Data Model8 - SportsStore - Scaling Up9 - SportsStore - Customer Features10 - SportsStore - Creating An APIPart 2-----11 - Working with Entity Framework Core12 - Performing Data Operations13 - Understanding Migrations14 - Creating Data Relationships15 - Working with Relationships, Part 116 - Working with Relationships, Part 217 - Scaffolding an Existing Database18 - Manually Modelling a DatabasePart 3-----19 - Keys20 - Querying Data21 - Storing Data22 - Deleting Data23 - Using Database Server Features24 - Using Transactions

Read more less

Book SynopsisWelcome to this step-by-step guide for Excel users, data analysts, and finance specialists. It is designed to take you through practical report and development scenarios, including both the approach and the technical challenges. This book will equip you with an understanding of the overall Power Platform use case for addressing common business challenges. While Power BI continues to be an excellent tool of choice in the BI space, Power Platform is the real game changer. Using an integrated architecture, a small team of citizen developers can build solutions for all kinds of business problems. For small businesses, Power Platform can be used to build bespoke CRM, Finance, and Warehouse management tools. For large businesses, it can be used to build an integration point for existing systems to simplify reporting, operation, and approval processes.The author has drawn on his15 years of hands-on analytics experience to help you pivot from the traditional Excel-based rTable of Contents1. Power BI SolutionsGoal: as the introduction chapter, this chapter starts with the most popular tool in Power Platform. It covers the important components relating to the integrated architecture. The same components are also powerful in their own rights in building powerful reports. 2. Data VisualisationGoal: After covering the key components of Power BI, this chapter focus on the design and user experience, which is also a key component in a great report. 3. Power BI GovernanceGoal: The readers will understand that report governance is an enabler not a restrictor. This chapter break governance into 4 key components and discusses the needs in each area. 4. SQL ServerGoal: Most business data stores in SQL Server. SQL is by far the most common data language. The readers will understand the basics of SQL and able to write the most common queries.5. SharePoint ListGoal: The readers will understand how to setup and utilize SharePoint list as a security measure. 6. Power Automate SolutionsGoal: The readers will understand the basic concept of Power Automate as well as some practical applications. 7. Power Apps SolutionsGoal: PowerApps is another critical component in the book. This chapter will spend considerably more time in explaining the concept and construct. The readers will understand how to build PowerApps and how to integrate it with Power BI and Power Automate. 8. Integrated SolutionsGoal: In the final chapter of the book, readers will start to explore the full architecture. How different parts add value to the business application. The readers will understand the full potential of Power Platform. By this stage, the users also have the skillset required to implement such solutions at work.

Read more less

Book Synopsis

Read more less

Book Synopsis

Read more less

Book SynopsisTable of ContentsIntroduction xv Chapter 1: Introducing Visual Studio Code 1 Getting Started 1 Installing Visual Studio Code 2 Windows 2 Linux 6 macOS 10 How Cross-Platform Works 11 Summary 12 Chapter 2: Exploring the User Interface 13 Editors 14 Activity Bar 15 Editing Settings Manually 17 Status Bar 18 Other Windows 23 Command Palette 23 Terminal Window 24 Output Window 25 Debug Console 26 Problems Window 27 Summary 29 Chapter 3: Files and Folders and Projects (Oh My) 31 Explorer 31 Project View 32 Decorations 36 Workspaces 37 Saving the Workspace 37 Adding Folders 38 Settings 38 Search 38 Advanced Searches 39 Regular Expression Matching 39 Specifying Files 40 Replacing Text 41 Settings 41 Summary 42 Chapter 4: Editing Code in Your Language of Choice 43 Editor Area 43 Editor Groups and Layouts 45 Open Editors 48 Outline View 51 Editing Functionality 52 Keyboard Shortcuts 53 Choosing Your Language 57 Formatting 58 Code Writing Assistance 59 IntelliSense 61 Method Info 61 Completions 62 Settings 62 Find and Replace 63 Minimap 64 Code Snippets 65 Multiple Cursors 67 Auto Save 67 Hot Exit 68 Editor Settings 68 Summary 71 Chapter 5: Integrating with Source Control 73 Source Control Management 73 Using Git 75 Cloning a Repository 76 Staging and Committing 76 Branches 77 Working with the Tracking Branch 78 Merge Conflicts 80 Miscellaneous Support 82 Git Output 82 Default Git Editor 83 Git Diff Tool 83 Other SCMs 83 Installing the Extension 84 Configuring the Extension 85 Summary 86 Chapter 6: Debugging Code 87 Debugging Node.js 87 Launching the Session 88 Launch Configurations 89 Launch vs. Attach Execution 91 Adding a Configuration 92 Simultaneous Configurations 94 Debug Actions 95 Breakpoints 95 Stepping through Code 97 Data Inspection 97 Advanced Launch Configuration 98 Variable Substitution 98 Launching a Browser on Debug 99 Summary 100 Chapter 7: External Tools and Task Automation 101 Tasks Defined 101 Creating Custom Tasks 104 Compound Tasks 106 Problem Matchers 107 Multiline Matchers 108 Background Patterns 109 Advanced Task Configuration 110 Platform-Specific Properties 110 Variable Substitution 110 Summary 112 Chapter 8: Unit Testing 113 Testing a Unit 113 Python Unit Testing 114 Unittest Framework 115 PyTest Framework 116 JavaScript Unit Testing 118 Jest Extension 118 Refactoring 121 Code Actions 122 Summary 124 Chapter 9: Working with Extensions 125 Extension Marketplace 126 Searching for Extensions 127 Installing Extensions 129 Extension Configuration 133 Updating Extensions 136 Workspace Extensions 137 Command-Line Interface 138 Useful Extensions 138 Linters 139 Keyboard Mappings 139 Snippets and Coding Assistance 140 Miscellaneous Tools 140 Summary 142 Chapter 10: Creating Your Own Extensions 143 Getting Started 143 An Extension Project 147 Activation Event 148 Contribution Points 148 Visual Studio Code API 149 Extension Project Structure 149 Activation Events 151 onCommand 151 onDebug 152 onFileSystem 152 onLanguage 153 onUri 153 onView 154 onWebviewPanel 154 workspaceContains 155 Start Up 155 Contribution Points 155 breakpoints 156 colors 156 configuration 157 configurationDefaults 157 commands 158 debuggers 158 grammars 158 jsonValidation 159 keybindings 159 when Clause 159 languages 160 menus 160 problemMatchers 162 snippets 162 taskDefinitions 163 themes 163 viewsContainers 163 views 164 Visual Studio Code API 165 Common Patterns 165 Promises 165 Cancellation Tokens 165 Events 165 Commands 166 Debug 166 Env 166 Extensions 167 Languages 167 Scm 168 Tasks 168 Window 168 Workspace 169 Summary 169 Index 171

Read more less

Book SynopsisBring mixed reality into your office workplace by building immersive experiences using data and content from your Office 365 platform. Imagine being able to sit at your desk and surround yourself with a 3D chart showing your work relationships as mined from your relationships with others based on how you collaborate together. This book shows you how to access your Office 365 data using the Microsoft Graph API, and then helps you present that data in a 3D modeling visualization using the Microsoft HoloLens 2 as a mixed reality device.  This book covers the growing number of tools and techniques you can use to access and visualize data on a Microsoft HoloLens 2 device. Foremost is the Graph API, giving access to the full range of data in Office 365. Also covered are Unity and Visual Studio, the development environments from which you can create mixed reality applications for Microsoft HoloLens 2. You will learn how to load data from and save data to your Office 365 platTable of Contents1. Immersive Experiences 2. Controlling Data 3. Environment and Configuration 4. Unity 5. Unity Advanced 6. HoloLens 7. HoloLens Development 8. Visualization 9. Building A Social App 10. Model Implementation 11. Interact with the Model

Read more less

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 Contents​Chapter 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.

Read more less

Book SynopsisProfessional developers will produce leaner applications for the ASP.NET Core platform using the guidance in this best-selling book, now in its 9th edition and updated for ASP.NET Core for .NET 6. It contains detailed explanations of the ASP.NET Core platform and the application frameworks it supports. This cornerstone guide puts ASP.NET Core for .NET 6 into context and dives deep into the tools and techniques required to build modern, extensible web applications. New features and capabilities such as MVC, Razor Pages, Blazor Server, and Blazor WebAssembly are covered, along with demonstrations of how they are applied.ASP.NET Core for .NET 6 is the latest evolution of Microsoft's ASP.NET web platform and provides a host-agnostic framework and a high-productivity programming model that promotes cleaner code architecture, test-driven development, and powerful extensibility.Author Adam Freeman has thoroughly revised this market-leading book and explains how to get the mosTable of ContentsPart 1 1. Putting ASP.NET Core into Context 2. Getting Started 3. Your First ASP.NET Core Application 4. Using the Development Tools 5. Essential C# Features 6. Unit Testing ASP.NET Core Applications 7. SportsStore 8. SportsStore: Navigation & Cart 9. SportsStore: Completing the Cart 10. SportsStore: Adminstration 11. SportsStore: Security & Deployment Part 2 12. Understanding the ASP.NET Core Platform 13. Using URL Routing 14. Using Dependency Injection 15. Using the Platform Features, Part 1 16. Using the Platform Features, Part 2 17. Working with Data Part 3 18. Creating the Example Project 19. Creating RESTFul Web Services 20. Advanced Web Service Features 21. Using Controllers with Views 22. Using Controllers with Views, Part 2 23. Using Razor Pages 24. Using View Components 25. Using Tag Helpers 26. Using the Built-In Tag Helpers 27. Using the Forms Tag Helpers 28. Using Model Binding 29. Using Model Validation 30. Using Filters 31. Creating Form Applications Part 4 32. Creating the Example Application 33. Using Blazor Server, Part 1 34. Using Blazor Server Part 2 35. Advanced Blazor Features 36. Blazor Forms and Data 37. Blazor Web Assembly 38. Using ASP.NET Core Identity39. Applying ASP.NET Core Identity

Read more less

Book SynopsisLearn the essential design and deployment skills to utilize Azure VMware Solution to seamlessly move your VMware-based workloads from your datacenter to Azure and to integrate your VMware environment with Azure.  This book will teach you how to manage your existing environments with the same VMware products you already know while modernizing your applications with Azure native services.Design and Deploy Azure VMware Solutions starts by reviewing Azure VMware essentials, followed by a walkthrough of the methods of preparing and expanding to Azure VMware Solution. Here, you will learn about the layers of Microsoft AVS, including the vSphere, vSAN, NSX-T, and assess and migrate on-prem VMware workloads to Azure VMware Solution using HCX. Further, you will understand how to deploy the desktop and learn Hosting Pool using Horizon on Microsoft Azure, a modern approach to managing and securing Horizon components. VMware Tanzu for moderniziTable of ContentsChapter 1: Getting Started with AVS Introduction to Azure VMware Solution Inner engineering of Azure VMware Solution Identify use case for Azure VMware SolutionChapter 2: Datacenter footprint reduction and expansion with Azure VMware Solution Prepare Azure based VMware vSphere, NSX-T, and vSAN. Design Azure based VMware vSphere, NSX-T, and vSAN. Deploy Azure based VMware vSphere, NSX-T, and vSAN. Monitor and Secure Azure based VMware vSphere, NSX-T, and vSAN. Chapter 3: Desktop virtualization with Azure VMware Solution. Prepare Azure based VMware Horizon and it’ suite. Design Azure based VMware Horizon and it’ suite. Deploy Azure based VMware Horizon and it’ suite. Monitor Azure based VMware Horizon and it’ suite. Chapter 4: Application modernization with Azure VMware Solution. Prepare Azure based VMware Tanzu Standard. Design Azure based VMware Tanzu Standard. Deploy Azure based VMware Tanzu Standard. Monitor Azure based VMware Tanzu Standard. Chapter 5: Disaster recovery with Azure VMware Solution. BC/DR Prepare for VMware workload based out of Azure. BC/DR Design for VMware workload based out of Azure. BC/DR Drill for VMware workload based out of Azure. BC/DR Orchestration for VMware workload based out of Azure. Chapter 6: VMware vRealize suite for Azure VMware Solution. Plan, optimize, and scale Azure VMware Solution using VMware vRealize Operations Manager. Build an optimized, highly available, and secure network Azure VMware Solution using VMware vRealize Network Insight. Plan and deploy Infrastructure as a Service (IaaS) for Azure VMware Solution via vRealize Automation. Chapter 7: Assess and migrate on-prem VMware workloads to Azure VMware Solution. Plan HCX deployment Configure Compute and Network profiles Migrate workloads to Azure VMware Solution.

Read more less

Book SynopsisLeverage the collaboration capabilities of Microsoft Viva Connections as an employee experience platform to build a gateway to your digital workplace. This book helps you set up Microsoft Viva connections via easy-to-follow steps and extend it to target your business scenarios.The book starts with an introduction to Microsoft Viva and its modules and it discusses Viva Connections for desktop and mobile users. You will learn about the intranet landing experience with SharePoint where you will plan, build, and launch a home site. You will know how to use the app bar and global navigation in Viva Connections and understand the importance of the dashboard and dashboard cards. You will learn how to enable Viva Connections in MS Teams and define a rollout strategy. You will gain experience with Viva Connections on mobile devices and go through end-user guidance. And you will learn to extend Viva Connections with the SharePoint Framework and deploy SPFx solutions.&nbsTable of Contents​Chapter 1: Microsoft Viva for EveryoneChapter Goal: Get introduced to Microsoft Viva and modules of Microsoft Viva No of pages 5 Sub -Topics 1. Microsoft Viva Overview 2. Explore Microsoft Viva modules 3. Microsoft Viva Connections Experiencebegins to Chapter 2: Microsoft Viva Connections Experience and Set up Chapter Goal: Understand the Microsoft Viva Connection experience for desktop and mobile users No of pages: 5 Sub - Topics 1. Viva Connections desktop experience 2. Viva Connections mobile experience 3. Branding 4. Understand the setup process Chapter 3: Modern experience in SharePoint Chapter Goal: Understand the modern experience in SharePoint No of pages : 10 Sub - Topics: 1. Modern experience in SharePoint 2. Classic to modern experience journey 3. Features of SharePoint 4. Flat hierarchy structure and its importance 5. Plan for hub sites 6. Navigation experience Chapter 4: Home site superpowers Chapter Goal: Understand the intranet landing experience with SharePoint home site No of pages: 10 Sub - Topics: 1. Plan, build, and launch a home site 2. Home site superpowers 3. SharePoint templates for home site 4. Best practices for home site Chapter 5: App bar and Global Navigation Chapter Goal: Understand the importance of app bar and global navigation. No of pages: 10 Sub - Topics: 1. Enable SharePoint app bar 2. Customize global navigation 3. Localization scenarios Chapter 6: Dashboard and cards Chapter Goal: Understand the importance of dashboard and adding cards to dashboard. No of pages: 10 Sub - Topics: 1. Basics of Dashboard 2. Dashboard anatomy 3. Dashboard authoring 4. Dashboard cards 5. 3rd party support Chapter 7: Define your content feeds Chapter Goal: Get your content ready for feed with SharePoint and Yammer. No of pages: 10 Sub - Topics: 1. Prepare content for your feeds 2. Create engaging experience in feed Chapter 8: Enable Viva Connections in MS Teams Chapter Goal: Prepare strategy to enable Viva Connections and roll out in MS Teams. No of pages: 10 Sub - Topics: 1. Plan for Viva Connections in MS Teams 2. Define roll out strategy Chapter 9: Mobile Settings Chapter Goal: Define Viva connections experience for mobile. No of pages: 3 Sub - Topics: 1. Mobile settings guidance 2. Viva Connections Dashboard on a mobile device Chapter 10: End-user guidance Chapter Goal: Define end user roll out plan and guidance. No of pages: 3 Sub - Topics: 1. Define roll out plan 2. Educate end users for Viva Connections Chapter 11: Extend Viva Connections Chapter Goal: Learn to meet custom business scenarios by extending Viva Connections with SharePoint Framework (SPFx). No of pages: 15 Sub - Topics: 1. SPFx to extend Viva Connections 2. Build Adaptive Card Extensions (ACEs) with SPFx 3. Deploy SPFx solutions

Read more less

Book SynopsisThis book is a comprehensive guide covering modern cloud strategies and leadership approaches for building and scaling organizations to maturity on their cloud adoption journey. The book starts by examining technical topics from the perspective of the cloud leader, who is responsible for cloud teams and accountable for cloud products and platforms within their organization. Through a series of practical insights and real-world examples, you will gain a deep understanding of the key considerations for leading a cloud-driven organization. These considerations include understanding the benefits of digital transformation, managing global tech teams, and delivering excellence through platform ownership. Towards the end of the book, you will explore the latest trends and best practices for strategically innovating and scaling your organization in the cloud. With the knowledge gained from this book, you will be able to harness the poTable of Contents​ Part I: Leadership Essentials.- 1. The Art of Cloud Leadership.- 2. Influencing Change and Driving Cloud Adoption.- 3. Managing Teams in the Digital Age.- 4. Supporting Employee Health & Turnover.- Part II: Innovation Strategies.- 5. Adopting a Cloud Platform.- 6. Democratizing Data & Democratizing Analytics.- 7. Applying DevOps.- 8. New Horizons in Distributed Cloud Computing.- 9. Impacts of Modern AI and ML Trends.- Part III: Platform Ownership.- 10. Owning a Portfolio of Agile Cloud Products.- 11.Designing a Secure Data Lake.- 12. Administering and Auditing the Cloud.- 13. Collaborating with Cloud Vendors and Providers.- Part IV: Delivery Excellence.- 14. Creating a Technology Delivery Roadmap.- 15. Cloud Transformation Roles and Responsibilities.- 16. Delivering Strategic Cloud Innovation and Excellence.- 17. Managing Agile Cloud Projects.- 18. Achieving Digital Transformation Success.

Read more less

Book Synopsis

Read more less

Book SynopsisBecome a self-sufficient citizen developer by learning the tools within the Microsoft Power Platform and how they can be used together to drive change and multiply your productivity. Learn about PowerApps for building applications, Power Automate for automating business processes across those applications, and Power BI for analyzing results and communicating business intelligence through compelling visuals. By understanding the purpose and capabilities of these tools, you will be able to enhance your organization's visibility into key areas and make informed business decisions in a timely matter. This book is divided into four parts and begins in Part I by showing you how to build applications through PowerApps. You will learn about screens and controls, application sharing and administration, and how to make your applications accessible from mobile devices such as phones and tablets. Part II is about creating workflows using Power Automate that implement business logic across your applications. Part III brings in dashboards and data analysis, showing you how to connect to a data source, cleanse the data from that source, and drive decision making through interactive reports and storytelling. Part IV brings together all the pieces by showing the integrations that are possible when all three tools are combined into a single solution.What You Will Learn Understand the need for the citizen developer in today's business environment Organize and plan the building of line-of-business applications with PowerApps solutions  Replace wasteful paper processes with automated applications built in PowerApps Automate workflows across processes with Power Automate Communicate analytical results through visualizations and storytelling Integrate PowerApps, Power Automate, and Power BI into solutions that multiply productivity Who This Book Is ForPower users and analysts with strong Excel skills who need a more comprehensive set of tools that can better help them accomplish their vision on projects, those familiar with one of the Power Platform tools who wish to learn how all three can fit together, and those who are seen as as rogue IT problem solvers who get things done when others have tried but failed Table of ContentsIntroductionPart I. Building Line of Business Applications with PowerApps1. Introduction to PowerApps2. Building Your First PowerApp3. Exploring PowerApps Screens and Controls4. Working with PowerApps Expressions5. Leveraging Variables and Collections6. Securing and Sharing Apps7. Managing Power Apps8. Common Data Services and Model-Driven AppsPart II. Task Automation with Microsoft Flow9. Introduction to Power Automate10. Building Your First Flow11. Exploring Different Trigger Types12. Working with Flow Expressions13. Building Conditional Flows14. Designing Approval Flows15. Administering Power AutomatePart III. Dashboards, Reporting, and Analytics with Power BI16. Introduction to Power BI17. Connecting to Data18. Defining Data Cleansing Business Rules with the Power Query Editor19. Data Model Design20. Extending Your Data Model with DAX Calculations21. Report Writing Basics22. Designing Interactive Reports23. Data Storytelling with Power BI24. Sharing Power BI Solutions25. Administering Power BIPart IV. Integrating the Power Platform Tools Together26. Power Platform Integration in PowerApps27. Power Platform Integration in Microsoft Flow28. Power Platform Integration in Power BI29. Designing a Fully Integrated Power Platform Solution

Read more less

Book SynopsisEnhance and upgrade your Excel knowledge with this comprehensive guide to formulas in Excel. Over 150 of the most useful Excel functions are covered with numerous practical examples of their use. This book is fully updated and includes examples of the most recently released functions in 2022. It is written in a manner that you can read it cover-to-cover or pick it up and learn something new in just 5 minutes.The book begins with a primer on Excel formulas and functions. Starting from a basic level, but diving into intricate detail and building a solid understanding of the fundamentals. It may not always be sexy, but learning why, in addition to how, is important to truly understanding Excel formulas. Having strong fundamentals is the most advanced skill.The book covers all the most popular functions in Excel including VLOOKUP, SUMPRODUCT, COUNTIFS, MATCH, SORT and so much more. You will learn how to return multiple results with a single formula. Harness tTable of ContentsChapter 1: Excel Formulas – A Quick Primer Chapter Goal: Start the journey to mastering formulas in Excel No of pages: 25 This chapter is the first of many on formulas in Excel. It will start with basic mathematical operations, explain the structure of formulas inside-out, look at some basic functions and cover absolute cell addresses. Chapter 2: Logical Formulas Chapter Goal: Learn the important logical functions in Excel. No of pages: 35 This chapter will explain how and when to use logical functions including IF, IFS, AND, OR, XOR, IFERROR, IFNA and SWITCH. These functions are the initial building blocks of automated Excel models and reports. Their importance cannot be understated. Chapter 3: Defined Names Chapter Goal: Understand the use and hidden brilliance of defined names. No of pages: 25 This chapter explores defined names in-depth. This little-known feature has huge benefits in how we use and deploy ranges and formulas in Excel. Chapter 4: You Need to Start Using Tables Chapter Goal: To understand and master the use of Tables No of pages: 30 This chapter will introduce the reader to tables in Excel. It will explain the many benefits to their use and how to use them effectively. Chapter 5: Manipulating Text Chapter Goal: Learn the most useful text functions of Excel No of pages: 40 This chapter will look at the formulas to extract, combine, replace, and format text. These include but are not limited to LEN, MID, SEARCH, DOLLAR, CONCAT and VALUE. Chapter 6: Working with Dates and Times Chapter Goal: Learn the popular date and time functions of Excel No of pages: 40 This chapter will explain how dates and times are stored, and are to be used, in Excel. We will use different date and time functions to perform transformations and various calculations. Chapter 7: The Infamous VLOOKUP Function Chapter Goal: Master this vital function No of pages: 35 This chapter is dedicated to the third most used function in Excel. It fully explains how to use VLOOKUP in a way people have probably not heard before. It will also cover some insider tricks to avoid common VLOOKUP limitations and mistakes. A variety of examples will be shown. Chapter 8: Advanced Lookup Formulas Chapter Goal: Learn more advanced lookup functions. No of pages: 40 In this chapter, we explore functions such as INDEX, OFFSET, MATCH, CHOOSE and INDIRECT to build upon the concepts learnt with VLOOKUP. We will see alternative ways to complete a task dependent upon the scenario. Chapter 9: The Awesome SUMIFS, COUNTIFS and Friends Chapter Goal: Learn how to use these two exceptional functions. No of pages: 40 This chapter will explain these two functions with various examples. They are two of the best and have come to my aid so many times in the past. The chapter also shows the AVERAGEIFS, MINIFS and MAXIFS functions. Chapter 10: Next Level Aggregation Functions Chapter Goal: Learn the SUMPRODUCT and AGGREGATION functions. No of pages: 30 This chapter will look at the SUMPRODUCT and AGGREGATE functions. This chapter follows on nicely from the previous one as these functions have more power than SUMIFS and COUNTIFS. Chapter 11: Dynamic Array Formulas Chapter Goal: Understand how to efficiently use dynamic array formulas No of pages: 40 This chapter introduces the reader to dynamic array formulas. These formulas are available to 365 users only. Therefore, it is essential that it is understood how these formulas are best used, and how they may affect you if you are not a 365 user. Chapter 12: XLOOKUP – The New Kid on the Block Chapter Goal: Learn how and when to use the XLOOKUP function No of pages: 20 This chapter is all about the XLOOKUP function. What does it offer that the other lookup function could not? When is the best time to use it? All will be covered in this chapter. Chapter 13: FILTER Function – The Game Changer Chapter Goal: Learn how to effectively use the FILTER function No of pages: 20 This chapter focuses on the impressive FILTER function. Several examples are shown to demonstrate the FILTER function performing tasks that other functions cannot do. Chapter 14: Table Rankings and Top N Lists Chapter Goal: Learn to create different dynamic table rankings No of pages: 20 This chapter uses functions and skills learnt over previous chapters to create different table ranking and top N lists. These are common tasks, but difficult to perform without advanced Excel formula skills. Chapter 15: Getting Status Information Chapter Goal: Learn how to retrieve status of cells and the Excel environment No of pages: 20 This chapter will look at the CELL, TYPE, and INFO functions of Excel. They are used to return information about cells, data types and the operating environment. We can the utilise this information in other functions. Chapter 16: The LET and LAMBDA Functions Chapter Goal: Understand these two new functions No of pages: 30 This chapter will look the LET and LAMBDA functions introduced to Excel 365 in 2020/2021. They are freshly released and change how Excel users will write complex formulas. This chapter will explain how and when to use these power functions.

Read more less

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

Read more less

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

Book SynopsisCustomize and ramp-up Office 365 applications NOTE:Please click Downloads (located in the menu on the left) to download Full Code Download.The revised 2019 edition of Mastering VBA Microsoft Office 365 offers an accessible guide that shows how to extend the capabilities of Office 365 applications with VBA programming. Written in clear terms and understandable language, the book includes systematic tutorials and contains both intermediate and advanced content for experienced VB developers. Designed to be comprehensive, the book addresses not just one Office application, but the entire Office suite. To enhance understanding, the content is explored in real-world projects in Word, Excel, Outlook, and PowerPoint. Since the technical programming methods in the Office applications continue to evolve, the updated 2019 edition reviews the changes to the program. Code libraries, the API, and the object model for each Office program have bTable of ContentsIntroduction xxix Part 1 Recording Macros and Getting Started with VBA 1 Chapter 1 Recording and Running Macros in the Office Applications 3 What Is VBA and What Can You Do with It? 3 The Difference between Visual Basic and Visual Basic for Applications 4 What Are Visual Basic NET and Visual Basic Express? 5 Understanding Macro Basics 5 Recording a Macro 6 Displaying the Developer Tab on the Ribbon 7 Planning the Macro 8 Starting the Macro Recorder 10 Naming a Macro 13 Running a Macro 24 Recording a Sample Word Macro 25 Recording a Sample Excel Macro 27 Create a Personal Macro Workbook If You Don’t Have One Yet 28 Record the Macro 29 Specifying How to Trigger an Existing Macro 30 Assigning a Macro to a Quick Access Toolbar Button in Word 30 Assigning a Macro to a Shortcut Key Combination 31 Deleting a Macro 31 The Bottom Line 33 Chapter 2 Getting Started with the Visual Basic Editor 35 Opening the Visual Basic Editor 35 Opening the Visual Basic Editor with a Macro Selected 36 Opening the Visual Basic Editor Directly 37 Navigating to a Macro 37 Using the Visual Basic Editor’s Main Windows 38 The Project Explorer 39 The Object Browser 42 The Code Window 43 The Properties Window 48 The Immediate Window 50 Setting Properties for a Project 51 Customizing the Visual Basic Editor 53 Choosing Editor and View Preferences 54 Choosing and Laying Out the Editor Windows 61 Customizing the Toolbar and Menu Bar 61 Customizing the Toolbox 62 The Bottom Line 66 Chapter 3 Editing Recorded Macros 69 Testing a Macro in the Visual Basic Editor 70 Stepping Through a Macro 71 Setting Breakpoints 73 Commenting Out Lines 74 Stepping Out of a Macro 75 Editing a Word Macro 75 Stepping Through the Transpose_Word_Right Macro 77 Running the Transpose_Word_Right Macro 77 Creating a Transpose_Word_Left Macro 77 Saving Your Work 79 Editing an Excel Macro 79 Unhiding the Personal Macro Workbook 79 Opening a Macro for Editing 81 Editing a Macro 82 Editing a PowerPoint Macro 84 Reducing the Size of Your Macro 88 Saving Your Work 89 The Bottom Line 90 Chapter 4 Creating Code from Scratch in the Visual Basic Editor 93 Setting Up the Visual Basic Editor to Create Macros 93 Creating a Procedure for Word 95 Creating a Macro for Excel 101 Creating a Procedure for PowerPoint 106 Creating a Procedure for Access 112 The Bottom Line 113 Part 2 Learning How to Work with VBA 115 Chapter 5 Understanding the Essentials of VBA Syntax 117 Getting Ready 117 Procedures 118 Functions 119 Subprocedures 119 Statements 119 Keywords 123 Expressions 124 Operators 124 Variables 124 Constants 126 Arguments 126 Specifying Argument Names vs Omitting Argument Names 127 When to Include the Parentheses around an Argument List 128 Objects 129 Collections 129 Properties 130 Methods 130 Events 130 The Bottom Line 132 Chapter 6 Working with Variables, Constants, and Enumerations 135 Working with Variables 136 Choosing Names for Variables 136 Declaring a Variable 138 Choosing the Scope and Lifetime of a Variable 141 Specifying the Data Type for a Variable 148 Working with Constants 155 Declaring Your Own Constants 155 Choosing the Scope or Lifetime for Constants 156 Working with Enumerations 156 The Bottom Line 157 Chapter 7 Using Array Variables 159 What Is an Array? 159 Declaring an Array 161 Storing Values in an Array 163 Multidimensional Arrays 164 Declaring a Dynamic Array 165 Redimensioning an Array 165 Returning Information from an Array 166 Erasing an Array 166 Determining Whether a Variable Is an Array 166 Finding the Bounds of an Array 167 Sorting an Array 167 Searching an Array 171 Performing a Linear Search Through an Array 172 Binary Searching an Array 177 The Bottom Line 182 Chapter 8 Finding the Objects, Methods, and Properties You Need 185 What Is an Object? 185 The Benefits of OOP 185 Understanding Creatable Objects 187 Properties 187 Methods 188 Working with Collections 190 Working with an Object in a Collection 191 Adding an Object to a Collection 192 Finding the Objects You Need 192 Using the Macro Recorder to Add Code for the Objects You Need 192 Using the Object Browser 195 Using Help to Find the Object You Need 201 Using the Auto List Members Feature 205 Using Object Variables to Represent Objects 206 Team Programming and OOP 209 The Bottom Line 211 Part 3 Making Decisions and Using Loops and Functions 213 Chapter 9 Using Built-In Functions 215 What Is a Function? 215 Using Functions 217 Passing Arguments to a Function 219 Using Functions to Convert Data 220 Using the Asc Function to Return a Character Code 221 Using the Val Function to Extract a Number from the Start of a String 221 Using the Str Function to Convert a Number into a String 223 Using the Format Function to Format an Expression 224 Using Predefined Numeric Formats 225 Creating a Numeric Format 226 Creating a Date or Time Format 227 Creating a String Format 228 Using the Chr Function and Constants to Enter Special Characters in a String 229 Using Functions to Manipulate Strings 230 Using the Left, Right, and Mid Functions to Return Part of a String 230 Using the Left Function 232 Using the Right Function 232 Using the Mid Function 233 Using InStr and InStrRev to Find a String Within Another String 235 Using LTrim, RTrim, and Trim to Remove Spaces from a String 237 Using Len to Check the Length of a String 238 Using StrConv, LCase, and UCase to Change the Case of a String 240 Using the StrComp Function to Compare Apples to Apples 241 Using VBA’s Mathematical Functions 242 Using VBA’s Date and Time Functions 244 Using the DatePart t Function to Parse Dates 244 Calculating Time Intervals Using the DateDiff f Function 245 Using the DateAdd d Function to Add or Subtract Time from a Date 246 Using File-Management Functions 246 Checking Whether a File Exists Using the Dir Function 246 Returning the Current Path 248 The Bottom Line 248 Chapter 10 Creating Your Own Functions 251 Components of a Function 252 Creating a Function 254 Starting a Function Manually 254 Starting a Function by Using the Add Procedure Dialog Box 254 Passing Arguments to a Function 256 Declaring the Data Types of Arguments 257 Specifying an Optional Argument 257 Controlling the Scope of a Function 258 Examples of Functions for All VBA-Enabled Office Applications 258 How Functions Return Information 260 Returning Text Data from a Function 260 Creating a Function for Word 263 Creating a Function for Excel 265 Creating a Function for PowerPoint 267 Creating a Function for Access 269 The Bottom Line 271 Chapter 11 Making Decisions in Your Code 273 How Do You Compare Things in VBA? 274 Testing Multiple Conditions by Using Logical Operators 275 If Blocks 278 If Then 278 If Then Else Statements 280 If Then ElseIf Else Statements 282 Creating Loops with If and GoTo 287 Nesting If Blocks 289 Select Case Blocks 291 Syntax 291 Example 292 When Order Matters 294 The Bottom Line 294 Chapter 12 Using Loops to Repeat Actions 297 When Should You Use a Loop? 297 Understanding the Basics of Loops 298 Using For Loops for Fixed Repetitions 299 For Next Loops 299 For Each Next Loops 308 Using an Exit For Statement 308 Using Do Loops for Variable Numbers of Repetitions 309 Do While Loop Loops 310 Do Loop While Loops 314 Do Until Loop Loops 316 Do Loop Until Loops 318 Using an Exit Do Statement 319 Is the Exit Do Statement Bad Practice? 320 While Wend Loops 321 Nesting Loops 322 Avoiding Infinite Loops 325 The Bottom Line 326 Part 4 Using Message Boxes, Input Boxes, and Dialog Boxes 327 Chapter 13 Getting User Input with Message Boxes and Input Boxes 329 Opening a Macro 330 Displaying Status-Bar Messages in Word and Excel 331 Message Boxes 333 The Pros and Cons of Message Boxes 333 Message-Box Syntax 334 Displaying a Simple Message Box 335 Displaying a Multiline Message Box 336 Choosing Buttons for a Message Box 337 Choosing an Icon for a Message Box 338 Setting a Default Button for a Message Box 339 Controlling the Modality of a Message Box 340 Specifying a Title for a Message Box 341 Title Bars Can Provide Useful Information 342 Adding a Help Button to a Message Box 342 Specifying a Help File for a Message Box 343 Using Some Arguments Without Others 344 Retrieving a Value from a Message Box 344 Input Boxes 345 Input-Box Syntax 346 Retrieving Input from an Input Box 348 Forms: When Message Boxes and Input Boxes Won’t Suffice 348 The Bottom Line 349 Chapter 14 Creating Simple Custom Dialog Boxes 351 When Should You Use a Custom Dialog Box? 351 Creating a Custom Dialog Box 352 Designing a Dialog Box 354 Inserting a User Form 354 Choosing User-Form Grid Settings 355 Renaming a User Form 358 Adding Controls to the User Form 360 Grouping Controls 363 Renaming Controls 364 Moving a Control 365 Changing the Caption on a Control 367 Key Properties of the Toolbox Controls 368 Working with Groups of Controls 386 How to Group Controls 386 Ungrouping Controls 386 Sizing Grouped Controls 387 Deleting Grouped Controls 387 Working with One Control in a Group 387 Aligning Controls 388 Placing Controls 389 Adjusting the Tab Order of a Form 389 Linking a Form to a Procedure 391 Loading and Unloading a Form 392 Displaying and Hiding a Form 392 Setting a Default Command Button 393 Retrieving the User’s Choices from a Dialog Box 393 Returning a String from a Text Box 393 Returning a Value from an Option Button 394 Returning a Value from a Check Box 395 Returning a Value from a List Box 395 Returning a Value from a Combo Box 396 Examples Showing How to Connect Forms to Procedures 397 Word Example: The Move-Paragraph Procedure 397 General Example: Opening a File from a List Box 409 Building the User Form 409 Creating the Code for the User Form 411 Using an Application’s Built-In Dialog Boxes 415 Displaying a Built-In Dialog Box 415 Setting and Restoring Options in a Built-In Dialog Box 419 Which Button Did the User Choose in a Dialog Box? 419 Specifying a Time-Out for a Dialog Box 420 The Bottom Line 421 Chapter 15 Creating Complex Forms 423 Creating and Working with Complex Dialog Boxes 424 Updating a Dialog Box to Reflect the User’s Choices 424 Revealing a Hidden Part of a Form 424 Tracking a Procedure in a Form 429 Using Multipage Dialog Boxes and TabStrip Controls 432 Creating a Modeless Dialog Box 443 Specifying a Form’s Location Onscreen 444 Using Events to Control Forms 445 Events Unique to the UserForm Object 448 Events That Apply to Both UserForms and Container Controls 453 Events That Apply to Many or Most Controls 458 Events That Apply Only to a Few Controls 471 The Bottom Line 472 Part 5 Creating Effective Code 473 Chapter 16 Building Modular Code and Using Classes 475 Creating Modular Code 475 What Is Modular Code? 476 Advantages of Using Modular Code 476 The Bottom Line 503 Chapter 17 Debugging Your Code and Handling Errors 505 Principles of Debugging 505 The Different Types of Errors 507 Language Errors 507 Compile Errors 507 The Bottom Line 551 Chapter 18 Building Well-Behaved Code 537 What Is a Well-Behaved Macro? 537 Retaining or Restoring the User Environment 539 Chapter 19 Exploring VBA’s Security Features 553 Understanding How VBA Implements Security 553 Signing Your Macro Projects with Digital Signatures 557 What Is a Digital Certificate? 557 The Bottom Line 574 Part 6 Programming the Office Applications 575 Chapter 20 Understanding the Word Object Model and Key Objects 577 Examining the Word Object Model 577 Working with the Documents Collection and the Document Object 581 Creating a Document 581 The Bottom Line 609 Chapter 21 Working with Widely Used Objects in Word 611 Using Find and Replace via VBA 611 Understanding the Syntax of the Execute Method 613 Putting Find and Replace to Work 616 Working with Headers, Footers, and Page Numbers 617 The Bottom Line 642 Chapter 22 Understanding the Excel Object Model and Key Objects 645 Getting an Overview of the Excel Object Model 645 Understanding Excel’s Creatable Objects 646 Managing Workbooks 647 Creating a Workbook 647 The Bottom Line 670 Chapter 23 Working with Widely Used Objects in Excel 671 Working with Charts 671 Creating a Chart 671 Specifying the Source Data for the Chart 673 The Bottom Line 685 Chapter 24 Understanding the PowerPoint Object Model and Key Objects 687 Getting an Overview of the PowerPoint Object Model 687 Understanding PowerPoint’s Creatable Objects 688 Working with Presentations 689 The Bottom Line 707 Chapter 25 Working with Shapes and Running Slide Shows 709 Working with Shapes 709 Adding Shapes to Slides 709 Deleting a Shape 715 The Bottom Line 729 Chapter 26 Understanding the Outlook Object Model and Key Objects 731 Getting an Overview of the Outlook Object Model 731 The Outlook Object Model 732 Understanding Where Outlook Stores VBA Macros 733 Understanding Outlook’s Most Common Creatable Objects 734 The Bottom Line 752 Chapter 27 Working with Events in Outlook 755 How Event-Handler Procedures Differ from Ordinary Macros 755 Working with Application-Level Events 756 Using the Startup Event 758 The Bottom Line 773 Chapter 28 Understanding the Access Object Model and Key Objects 775 Getting Started with VBA in Access 775 Creating a Module in the VBA Editor 778 Creating a Function 778 The Bottom Line 800 Chapter 29 Accessing One Application from Another Application 801 Understanding the Tools Used to Communicate Between Applications 801 Using Automation to Transfer Information 802 Understanding Early and Late Binding 803 The Bottom Line 830 Appendix A The Bottom Line 833 Chapter 1: Recording and Running Macros in the Office Applications 833 Chapter 2: Getting Started with the Visual Basic Editor 835 Chapter 3: Editing Recorded Macros 836 Chapter 4: Creating Code from Scratch in the Visual Basic Editor 836 Chapter 5: Understanding the Essentials of VBA Syntax 839 Chapter 6: Working with Variables, Constants, and Enumerations 840 Chapter 7: Using Array Variables 842 Chapter 8: Finding the Objects, Methods, and Properties You Need 843 Chapter 9: Using Built-in Functions 844 Chapter 10: Creating Your Own Functions 846 Chapter 11: Making Decisions in Your Code 847 Chapter 12: Using Loops to Repeat Actions 849 Chapter 13: Getting User Input with Message Boxes and Input Boxes 850 Chapter 14: Creating Simple Custom Dialog Boxes 851 Chapter 15: Creating Complex Forms 855 Chapter 16: Building Modular Code and Using Classes 856 Chapter 17: Debugging Your Code and Handling Errors 858 Chapter 18: Building Well-Behaved Code 859 Chapter 19: Exploring VBA’s Security Features 860 Chapter 20: Understanding the Word Object Model and Key Objects 862 Chapter 21: Working with Widely Used Objects in Word 863 Chapter 22: Understanding the Excel Object Model and Key Objects 864 Chapter 23: Working with Widely Used Objects in Excel 865 Chapter 24: Understanding the PowerPoint Object Model and Key Objects 866 Chapter 25: Working with Shapes and Running Slide Shows 867 Chapter 26: Understanding the Outlook Object Model and Key Objects 868 Chapter 27: Working with Events in Outlook 869 Chapter 28: Understanding the Access Object Model and Key Objects 870 Chapter 29: Accessing One Application from Another Application 871 Index 873

Read more less

Book SynopsisUse the valuable Entity Framework Core 2.0 tool in ASP.NET and the .NET Framework to eliminate the tedium around accessing databases and the data they contain. Entity Framework Core 2.0 greatly simplifies access to relational databases such as SQL Server that are commonly deployed in corporate settings.Table of ContentsIntroduction1. Getting Started2. Working with Multiple Tables3. Stepping Beyond the Basics4. Data Validation and POCO's5. Stored Procedures, Table Design and Modifications6. ASP.NET MVC and EF Core 2.07. Finishing our ASP.NET MVC .NET Core 2.0 Project8. Wrap-up and Where to Go Next9. Appendix A: Database Script for Chapter 6

Read more less

Book Synopsis Use ASP.NET Core 2 to create durable and cross-platform web APIs through a series of applied, practical scenarios. Examples in this book help you build APIs that are fast and scalable. You''ll progress from the basics of the framework through to solving the complex problems encountered in implementing secure RESTful services. The book is packed full of examples showing how Microsoft''s ground-up rewrite of ASP.NET Core 2 enables native cross-platform applications that are fast and modular, allowing your cloud-ready server applications to scale as your business grows.  Major topics covered in the book include the fundamentals and core concepts of ASP.NET Core 2. You''ll learn about building RESTful APIs with the MVC pattern using proven best practices and following the six principles of REST. Examples in the book help in learning to develop world-class web APIs and applications that can run on any platform, including Windows, Linux, and MacOS. YouTable of Contents1. API Design Demystified2. Introduction to ASP.NET Core3. Your First API Application4. Extensibility Architecture5. MVC 6. The Configuration Model7. Logging and Error Handling8. Securing APIs9. Bells & Whistles10. Testing & Debugging11. Hosting & Deployment

Read more less

Book SynopsisUse this one-stop resource for both basic and advanced administration of Exchange Server 2019 and 2016. It will help you in running an Exchange environment, whether it be 100% on-premises or a hybrid configuration with Exchange Online (as part of Office 365). This revised version is divided into four parts, describing Exchange infrastructure, upgrading Exchange server, integration with Office 365, and security and compliance. In the first part, you will go through a short introduction of Exchange server followed by its installation and configuration. You will learn client access along with Exchange mailbox and managing Exchange recipients. In the second part, you will learn how to upgrade from Exchange 2010 to 2016 and from 2013 to Exchange 2019. The third part is dedicated to the Exchange integration with Office 365, followed by the last part that teaches you how to secure your Exchange environment and its compliance. After reading this book, you will understand best practices, doTable of ContentsSection 1 - Exchange Infrastructure 1. Introduction 1.1. History of Exchange server 1.2. Exchange 2016 or Exchange 2019? 1.3. Exchange Admin Center 1.4. PowerShell 1.5. Exchange and Active Directory 2. Installing and configuring Exchange 2.1. Designing the Exchange environment 2.2. Testing the Exchange environment 2.3. Building the Exchange environment 2.4. Exchange Edge Transport Server 2.5. Cumulative Updates 3. Exchange and Client Access 3.1. Clients 3.2. Outlook on the Web 3.3. Outlook 3.4. Autodiscover 3.5. Exchange Web Services 3.6. ActiveSync 3.7. Namespaces 3.8. Virtual Directories 3.9. Certificates 3.10. Client Access High Availability 4. Exchange Mailbox and Mailbox server 4.1. Mailbox databases 4.2. Backup and Restore 4.3. High Availability 4.4. Mailbox database High Availability 5. Managing Exchange Recipients 5.1. Managing Recipients 5.2. Mailboxes 5.3. Distribution Groups 5.4. Contacts 5.5. Public Folders 5.6. Address Lists 5.7. Global Address List 5.8. Custom Address List 5.9. Offline Address Books 5.10. Address Book Policies 6. Exchange Transport 6.1. Transport pipeline 6.2. Send and Receive Connectors 6.3. SMTP Relay 6.4. Edge Transport server 6.5. Load balancing transport Section 2 - Upgrading Exchange server 7. Upgrading from Exchange 2010 to Exchange 2016 7.1. Preparing Active Directory 7.2. Installing the Exchange servers 7.3. Change client access 7.4. Move Mailboxes 7.5. Move Public Folders 7.6. Decommission Exchange 2010 8. Upgrading from Exchange 2013 to Exchange 2019 8.1. Preparing AD en Installing Exchange is identical to 7.1 and 7.2 8.2. Client access in 2013/2019 coexistence 8.3. Move Mailboxes and Public Folders 8.4. Decommission Exchange 2013 Section 3 - integration with Office 365 9. Exchange Hybrid 9.1. Identities and source of authority 9.2. Managing Hybrid Recipients 9.3. Federation 9.4. Federation with other organizations 9.5. Organizational relationships 9.6. Sharing policies 9.7. Directory Synchronization 9.8. Exchange Hybrid Configuration Wizard 9.9. Autodiscover continued 9.10. Mailflow in coexistence 9.11. Exchange Online Protection 9.12. Modern Authentication 9.13. Bulk Email Section 4 - Security and Compliance 10. Securing your Exchange environment 10.1. Hybrid Modern Authentication 10.2. Message hygiene 10.3. Multi Factor Authentication 10.4. Role Based Access Control 11. Compliance 11.1. Archiving 11.2. Journaling 11.3. In-place hold 11.4. In-place eDiscovery 11.5. Messaging Records management 11.6. Data Loss Prevention 11.7. Auditing 11.8. Reporting

Read more less

Book SynopsisKnow the fundamentals of creating and deploying microservices using .NET 6 and gain insight from prescriptive guidance in this book on the when and why to incorporate them.The microservices architecture is a way of distributing process workloads to independent applications. This distribution allows for the independent applications to scale and evolve separately. It also enables developers to dismantle large applications into smaller, easier-to-maintain, scalable parts. While the return is valuable and the concept straightforward, applying it to an application is far more complicated. Where do you start? How do you find the optimal dividing point for your app, and strategically, how should your app be parceled out into separate services?Pro Microservices in .NET 6 will introduce you to all that and more. The authors get you started with an overview of microservices, .NET 6, event storming, and domain-driven design. You will use that foundational infTable of Contents 1. Introducing Microservices - Sean 2. ASP.NET Core Overview- Sean 3. Searching for Microservices- Sean 4. First Microservice- Sean 5. Microservice Messaging- Sean 6. Decentralizing Data - Josh 7. Testing Microservices - Sean 8. Containerization - Matthew 9. Healthy Microservices – Rob

Read more less

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

Read more less

Book SynopsisChapter 1: Introduction to Microsoft Project: Understanding the Platform.- Chapter 2: Getting Started with Microsoft Project.- Chapter 3: Managing tasks with Microsoft Project.- Chapter 4: Resource Management using Microsoft Project.- Chapter 5: Fine Tuning Project Schedule.- Chapter 6: Budget and Cost Management using Microsoft Project.- Chapter 7: Seamless integration of Microsoft Project with Microsoft 365 family.- Chapter 8: Agile Project Management using Microsoft Project.- Chapter 9: Microsoft Project Reports and Analytics.- Chapter 10: Advanced Features of Microsoft Project and Future Trends in Project Management.

Read more less

Book SynopsisLearn to automate SQL Server operations using frameworks built from metadata-driven stored procedures and SQL Server Integration Services (SSIS). Bring all the power of Transact-SQL (T-SQL) and Microsoft .NET to bear on your repetitive data, data integration, and ETL processes. Do this for no added cost over what you''ve already spent on licensing SQL Server. The tools and methods from this book may be applied to on-premises and Azure SQL Server instances. The SSIS framework from this book works in Azure Data Factory (ADF) and provides DevOps personnel the ability to execute child packages outside a project-functionality not natively available in SSIS.Frameworks not only reduce the time required to deliver enterprise functionality, but can also accelerate troubleshooting and problem resolution. You''ll learn in this book how frameworks also improve code quality by using metadata to drive processes. Much of the work performed by data professionals can be classiTable of ContentsPart I: Stored Procedure-Based Database Frameworks1. Stored Procedures 1012. Automation with Stored Procedures3. Stored Procedure Orchestrators4. A Stored Procedure-Base Metadata-Driven FrameworkPart II: SSIS Frameworks5. A Simple Custom File-Based SSIS Framework6. Framework Execution Engine7. Framework Logging8. Azure-SSIS Integration Runtime9. Deploy A Simple Custom File-Based Azure-SSIS Framework10. Framework Logging in ADF11. Fault Tolerance in the ADF Framework

Read more less

Book SynopsisAre you a reasonably competent Power BI user but still struggling to generate reports that truly tell the story of your data? Or do you simply want to extend your knowledge of Power BI by exploring more complex areas of visualizations, data modelling, DAX, and Power Query? If so, this book is for you. This book serves as a comprehensive resource for users to implement more challenging visuals, build better data models, use DAX with more confidence, and execute more complex queries so they can find and share important insights into their data. The contents of the chapters are in a question-and-answer format that explore everyday data analysis scenarios in Power BI. These questions have been generated from the author's own client base and from commonly sought-for information from the Power BI community.They cover a wide and diverse range of topics that many Power BI users often struggle to get to grips with or don't fully understand.Examples of suchquestions are:How can I generate dynamiTable of ContentsChapter 1: Working with Visualizations.- Chapter 2: Slicers and Filtering.- Chapter 3: The Matrix.- Chapter 4: Date Calculations.- Chapter 5: Data Modelling.- Chapter 6: DAX Conundrums.- Chapter 7: Customers and Products.- Chapter 8: Employees.- Chapter 9: Power Query.

Read more less

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 Contents​Chapter 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.

Read more less

Book Synopsis

Read more less

Book SynopsisUse various defense strategies with Azure Sentinel to enhance your cloud security. This book will help you get hands-on experience, including threat hunting inside Azure cloud logs and metrics from services such as Azure Platform, Azure Active Directory, Azure Monitor, Azure Security Center, and others such as Azure Defender''s many security layers.This book is divided into three parts. Part I helps you gain a clear understanding of Azure Sentinel and its features along with Azure Security Services, including Azure Monitor, Azure Security Center, and Azure Defender. Part II covers integration with third-party security appliances and you learn configuration support, including AWS. You will go through multi-Azure Tenant deployment best practices and its challenges. In Part III you learn how to improve cyber security threat hunting skills while increasing your ability to defend against attacks, stop data loss, prevent business disruption, and expose hidden maTable of ContentsPart I (page count 100) Goals: Introduction to Azure Sentinel es with technical featurthat benefit the business. Initial configuration using Azure subscription data connectors, discuss 3rd party integration and alignment with other Azure Security Services. XDR introduction, why it is an industry standard and how to use it in Sentinel. Sub-Topics 1. Overview of Technical Features 2. Benefit and cost support for the business, initial configuration 3. Azure Defender support into Azure Sentinel 4. Azure Security Center support into Azure Sentinel Chapter 1 Azure Sentinel OverviewPlatform benefits, SOC security reference, alignment to Cyber framework, Log Analytics planning, cost structure Chapter 2 Other Azure Security Services Azure Monitor, Azure Security Center, Azure Defender, working together to support Azure Sentinel Chapter 3 Azure Sentinel XDR Capabilities Integration with Azure Security standards, protection for additional Azure workloads, guidance for XDR and how it should be used to modernize security operations. Part II (page count 100) Goals: Deployment best practices, platform integration and support for AWS Sub - Topics 1. Enable integration with 3rd party security appliances 2. Configure support for AWS 3. Multi-Azure Tenant deployment best practices Chapter 4 Data Connection Single Tenant: Data connectors native, Log Analytics storage options, 3rd party data, KQL validation processes, AWS connection, Service NOW integration Chapter 5 Threat Intelligence (TI) TI connectors and feeds, Sentinel Workbooks introduction, Sentinel Notebook usage, Python integration Chapter 6 Multi-Tenant Architecture Challenges and cost of Azure log analytics workspace, KQL modification requirements, SOC alignment needed Part III (page count 100) Goals: Improve Cyber Security Threat Hunting Techniques Sub - Topics: 1. Threat Hunting with KQL Language deep dive with examples 2. Integration with MITRE attack Matrix and support for TAXII 3. Data flow examples: User logon, track and validate. Stop network connection to China, etc. 4. Configuration changes needed for multiple Sentinel deployments Chapter 7 Threat Hunting with Azure Sentinel KQL Hunting introduction, custom queries, Sentinel bookmarks, Sentinel notebooks Chapter 8 Introduction to MITRE Matrix MITRE Attack Matrix overview and usage, STIX defined, TAXII defined, free TI -vs- service SLA Chapter 9 Azure Sentinel Operations Daily, Weekly, Monthly tasks, SOC engineer alignment, Continued SOC operations support from official Microsoft supported forum Chapter Appendix: Chapter Goal: Where to gain additional knowledge for Azure Sentinel No of pages: 20 Sub - Topics: 1. Guidance to continue Azure Sentinel skill improvement 2. Relating information to Cyber Security standards

Read more less

Book SynopsisGet started with Azure Cognitive Services and its APIs that expose machine learning as a service. This book introduces the suite of Azure Cognitive Services and helps you take advantage of the proven machine learning algorithms that have been developed by experts and made available through Cognitive Services, easily integrating those algorithms into your own applications without having to develop the algorithms from scratch. The book also shows you how to use the algorithms provided by Cognitive Services to accelerate data analysis and development within your organization.   The authors begin by introducing the tools and describing the steps needed to invoke libraries to analyze structured and unstructured text, speech, and pictures, and you will learn to create interactive chatbots using the Cognitive Services libraries. Each chapter contains the information you need to implement artificial intelligence (AI) via Azure Cognitive Services in your peTable of Contents1. Introducing Cognitive Services2. Prerequisites and Tools3. Vision4. Language in Cognitive Services5. Speech Services6. Power Platform & Cognitive Services7. Chatbots8. Ethics in AI

Read more less

Book SynopsisChapter 1. Introduction to Cloud Security Architecture.- Chapter 2. Identity and Access Management .- Chapter 3. Logging and Monitoring .- Chapter 4. Network Security.- Chapter 5. Workload Protection- Data.- Chapter 6. Workload Protection- Platform-as-a-Service.- Chapter 7. Workload Protection- Containers.- Chapter 8. Workload Protection- IaaS.Table of Contents1. Introduction to Cloud Security Architecture 2. Identity and Access Management 3. Logging and Monitoring 4. Network Security 5. Workload Protection- Data 6. Workload Protection- Platform-as-a-Service 7. Workload Protection- Containers8 Workload Protection- IaaS

Read more less

Book SynopsisPart I Basics  Chapter 1:  Avoid Unnecessary Code Comments Chapter Goal: To show you the proper use of comments. It also discusses the side-effects of bad/redundant comments. No of pages: 5-10+ Chapter 2:  Use Polymorphism Chapter Goal: To show why a polymorphic code can perform better. No of pages    5-10+ Sub - Topics   2.1 Initial Program: Demo 1 2.2 Output and Analysis 2.3  Making efficient programs: Demo 2 2.4  Analysis 2.5  Conclusion Chapter 3:  Abstract Class, or Interface? Chapter Goal: In this chapter, we do not compare the basic differences between an abstract class or an interface. Instead, we discuss the code segments where you can use either of them, but the compiler does not raise any issue. Then we will analyze how to write efficient code using both these techniques for some

Read more less

Book SynopsisCreate complex scripts in PowerShell and learn how to connect them to cloud services like Azure and Azure AD. This book will help you learn PowerShell by providing small cheat snippets that you can combine to write efficient and effective scripts.PowerShell Fast Track starts with the basics of PowerShell before moving on to discuss functions like date and logs, along with concepts such as inputs for your scripts. Author Vikas Sukhija then walks you through interactive input and Snapins modules, where you will learn GUI button prompts and how to import sessions. He''ll then show you how to report errors through email and log errors to a text file. Reporting CSV (Comma Separate Value) is discussed next, followed by a demonstration of miscellaneous functions, including how to connect your PowerShell scripts with Azure, SharePoint, Teams and other services. As you progress further, you''ll see how PowerShell provides powerful features for automation that can be leveraged fTable of ContentsChapter 1. PowerShell Basics Variables & Printing If Else/ switch Conditional / Logical Operators Loops For –Loop While –Loop Functions Chapter 2. Date & logs Define Logs First day & Last day of Month Midnight Create Folders based on Date Recycle Logs Progress bar Chapter 3. Input to your scripts Import CSV Import from text file Input from Array Chapter 4. Interactive Input Read-host Parameters GUI Button Prompt Chapter 5. Adding Snap ins/ Modules PowerShell Snapins Modules Import Session Example: Chapter 6. Sending Email Chapter 7. Error Reporting Reporting Error thru Email Logging Everything including Error Logging error to Text file Chapter 8. Reporting CSV Report HTML Reporting Chapter 9. Miscellaneous Keywords Split Replace Select-String Compare-Object Chapter 10. Product Examples (Daily Use) Microsoft Exchange Clean Database so that mailboxes appear in disconnected state Find Disconnected Mailboxes Clustered Mailbox Status (2007) Extract Message accept from Active Sync Stats Message Tracking Search mailbox / Delete Messages Exchange Quota Report Set Quota Active Directory Export Group members Set values for Ad attributes Export Active Directory attributes Add members to the group from text file Remove members to the group from text file Office 365 Exchange Online Mailbox Report Exchange Online Message Tracking Searching Unified Log 11. Appendix

Read more less

Book SynopsisAudience Level: Intermediate to AdvancedTable of ContentsPart I. Getting Started1. The Core Essentials2. AWS Tools for .NET3. Additional ToolsPart II. Hosting Your Applications4. Virtual Machines5. Containers6. ServerlessPart III. Storing Your Data7. S3 Object Storage8. Microsoft SQL Server9. Other RDS Databases10. NoSQL Databases and AWS11. Purpose-built DatabasesPart IV. Moving Existing Apps to AWS12. Moving to Virtual Machines.13. Containerizing 14. Migrating your Data15. Re-platforming and RefactoringPart V. Building Cloud Native Applications16. Events and Messaging17. Monitoring and Observability

Read more less

Book SynopsisUp your game developer skills by learning game backend development with Microsoft Azure and PlayFab. Robust backend infrastructure support is essential for all modern games. Implementing game backend features became easier with the emergence of GBaaS (Game Backend-as-a-Service) providers and the advance of the cloud. Multiplayer gaming, leaderboards, game analytics, and virtual economies are all backed by cloud services. As a game developer, understanding core game backend features and implementation techniques is an important addition to your game developer skill set. Understanding game backend development will not only give you a competitive advantage, it will also eventually allow you to create better games. This book will help you get started. It teaches all the core concepts, using downloadable source code, so that you can experiment right away following a learning-by-doing approach. After reading this book, you will have a solid grasp of key game backend services and knoTable of Contents

Read more less

Book SynopsisThis is a crisp, practical, and hands-on guide to movingmission-critical workloads to Azure. This book focuses on the process and technology aspects of Azuresecurity coupled with pattern-oriented, real-world examples. You will implement modernized security controls,catering to the needs of authentication, authorization, and auditing, thereby protecting the confidentialityand integrity of your infrastructure, applications, and data. The book starts with an introduction to the various dimensions of cloud security, including pattern-based security and Azure's defense security architecture. You will then move on to identity and access management with Azure Active Directory. Here, you will learn the AAD security model, application proxy, and explore AAD B2B and B2C for external partners. Network security patterns and infrastructure security patterns are discussed next, followed by application and data security patterns. Finally, you will learn howto set up security policies and work with Table of Contents​Chapter 1: Introduction: Dimensions of cloud securityHistory about security and public cloudCloud security boundaries and responsibilitiesPattern-based securityAzure's defence-in-depth security architecture30 pagesChapter 2: Identity and Access Management with Azure Active DirectoryIdentity protocols and application typesAzure active directory security modelActive directory federation servicesAzure AD Application proxyExploring Azure AD B2B and B2C for external partnersPIM Azure AD Identity protection hybrid implementationSingle sign on with Azure AD60 pagesChapter 3: Network Security PatternsSoftware defined networksNetwork topologiesSegmenting subnetsControlling routing behaviourUsing gateways and firewalls30 pagesChapter 4: Infrastructure Security PatternsPhysical securityBuilt in Azure security controlsAzure tenant securityContainer securitySecuring Azure resources30 pagesChapter 5: Application and Data Security PatternsSecuring the application accessData classificationSecuring the data accessData encryption patterns30 pagesChapter 6: Security ProcessesComplete mediation with threat modellingSecuring the infrastructure and application deploymentSecurity testingKey Management - Vulnerability managementDisaster recovery40 pagesChapter 7: Automated Security MonitoringSetting up security policiesAdvanced observabilityAzure MonitorAzure Sentinel30 pagesChapter 8: Creating a Security CultureLeadership supportTraining10 pages

Read more less

Book SynopsisBuild and deploy applications by leveraging Azure PaaS and serverless services using Azure DevOps and GitHub Actions. This bookprovides step-by-step explanations of essential concepts, practical examples, and self-assessment questions thatwill help you gain the necessary expertise to build cloud-native solutions using Microsoft Azure and .NET. The book starts with essential topics that will help get you familiar with the fundamental concepts of Azure, followed by example-based guides on building distributed solutions using Azure Web App, Azure Messaging, and communication services. You will then learn how to implement the knowledge you've thus far gained to build containerized workloads using Azure Container-based services. Next, you will focus on building solutions by using Azure Storage and Data services, where you will go through Azure Blob Storage and learnhow to interact with Azure Cosmos DB from applications using the .NET SDK.Moving forward, you will explore how to build intelTable of ContentsUpdated TOC Chapter 1: Introduction Chapter Goal: To provide an overview of the various azure services that we are going to use in this book to build scalable, enterprise-grade applications. No of pages 10-20 Sub -Topics 1. Introduction to Cloud Computing 2. Cloud Deployment Models 3. Serverless Computing 4. Quick tour of Azure Services 5. Summary Chapter 2: Build a Web API to send messages to Azure Service Bus Chapter Goal: To Develop and Deploy a Web API to send messages to Azure Service Bus Queue No of pages: 25-30 Sub - Topics 1. Introduction to Azure Service Bus 2. What is Azure Service Bus Queue and Topic 3. Create an Azure Service Bus instance 4. Build an ASP.NET 6 Web API to send messages to Azure Service Bus Queue 5. Test the API using Postman 6. Summary Chapter 3: Build a Worker Service to process messages from Azure Service Bus Chapter Goal: To build a worker service to process messages enqueues in Azure Service Bus No of pages: 25-30 Sub - Topics: 1. Getting Started with Worker Service 2. Building a worker service with ASP.NET 6 3. Explore ways to consume messages from Azure Service Bus Queue 4. Build a worker service to process messages 5. Summary Chapter 4: Building a Microservice using .NET and AKS Chapter Goal: To build a microservice application using .NET, containerize the microservice and run it on Azure Kubernetes Service No of pages: 30-40 Sub - Topics: 1. Introduction to Azure Kubernetes Service and Azure Container Registry 2. Build a Microservice using .NET 3. Create an Azure Kubernetes Service and Azure Container Registry 4. Containerize the Microservice and push it to Azure Container Registry 5. Run the Microservice on Azure Kubernetes Service 6. Summary Chapter 5: Secure Microservice with Azure AD Chapter Goal: To implement role-based authentication and authorization with Azure AD to secure our .NET Applications No of pages: 20-30 Sub - Topics: 1. Introduction to Azure AD 2. Register an application in the Azure AD Tenant 3. Configure Authentication for the Microservice application running on AKS 4. Configure Role based Authorization for the Microservice application running on AKS 5. Summary Chapter 6: Running APIs on Azure Container Apps Chapter Goal: To deploy our .NET workloads to Azure with Azure Container Apps No of pages: 20-30 Sub - Topics: 1. Introduction to Azure Container Apps 2. Build and containerize .NET API 3. Push the container to Azure Container Registry 4. Create a Azure Container App and run the Container on Azure Container Apps 5. Summary Chapter 7: Implement Monitoring and Logging for Microservice running on AKS with Azure Monitor and Azure Application Insights Chapter Goal: To configure metrics, logs and alerts for the Microservice application running inside the Azure Kubernetes Service Cluster No of pages: 30-40 Sub - Topics: 1. Introduction to Application Insights, Log Analytics Workspace and Azure Monitor 2. Create Application Insights, Log Analytics Workspace and Azure Monitor 3. Configure logging and metrics for .NET based Microservice 4. Configure alerts for .NET based Microservice application 5. Query Logs from Log Analytics Workspace using KQL 6. Summary Chapter 8: Build an IoT solution with Azure IoT Hub, Azure Functions and Azure Cosmos DB Chapter Goal: To design and build an IoT solution using Azure IoT Hub, Azure Functions and Azure Cosmos DB No of pages: 30-40 Sub - Topics: 1. Getting started with Azure IoT Hub 2. Create an Azure IoT hub instance 3. Build virtual device to send messages to IoT hub 4. Getting Started with Azure Functions 5. Build an IoT hub Triggered Azure Function to process messages from Azure IoT hub and store the data in Azure Cosmos DB 6. Summary Chapter 9: Build a Desktop application for speech to text conversation using Azure Cognitive Service Chapter Goal: To build a .NET 6 Desktop application and use Azure Cognitive Services to convert a speech to a text transcript in English language. No of pages: 30 Sub - Topics: 1. Introduction to Azure Cognitive Services Speech to Text API 2. Provision a Speech to Text API to perform speech to text conversion 3. Build a .NET 6 Desktop application to convert speech to text 4. Summary Chapter 10: Build a multi-language text translator using Azure Cognitive Service Chapter Goal: To build a .NET 6 Web API and use Azure Cognitive Services to translate text No of pages: 20-30 Sub - Topics: 1. Introduction to Azure Cognitive Services Language Translation API 2. Provision a Language Translation API to perform translation 3. Build a .NET 6 Web API application and integrate with Language Translation API 4. Summary Chapter 11: Deploy a ASP.NET 6 Web application to Azure WebApp using GitHub actions Chapter Goal: To build a ASP.NET 6 Web app and deploy it on Azure Web App using Azure GitHub Actions No of pages: 20 Sub - Topics: 1. Introduction to GitHub Actions 2. Provision Azure WebApp using ARM Template 3. Build .NET 6 Web application using GitHub Actions 4. Deploy the .NET 6 Web application on Azure WebApp using GitHub Actions 5. Summary

Read more less