Microsoft programming Books

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 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 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 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 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 SynopsisDino Esposito is CTO and co-founder of Crionet, a company that provides innovative software and technology to professional sports organizations. A 16-time Microsoft MVP, he has authored 20+ books, including Introducing Machine Learning; and the Microsoft Press best-seller Microsoft .NET: Architecting Applications for the Enterprise. Francesco Esposito holds a degree in Mathematics, is the co-author of Introducing Machine Learning, and lives suspended between the depth of advanced mathematics and the intrigue of data science. He currently serves as the Head of Engineering and Data at Crionet. As an entrepreneur he founded Youbiquitous, a data analysis and software factory, and KBMS Data Force, a startup in Digital Therapy and intelligent healthcare.Table of ContentsCHAPTER 1 Artificially Intelligent Software CHAPTER 2 An Architectural Perspective of ML.NET CHAPTER 3 The Foundation of ML.NET CHAPTER 4 Prediction Tasks CHAPTER 5 Classification Tasks CHAPTER 6 Clustering Tasks CHAPTER 7 Anomaly Detection Tasks CHAPTER 8 Forecasting Tasks CHAPTER 9 Recommendation Tasks CHAPTER 10 Image Classification Tasks CHAPTER 11 Overview of Neural Networks CHAPTER 12 A Neural Network to Recognize Passports APPENDIX A Model Explainability

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 Synopsis

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 SynopsisOverview of Object-Oriented Programming.- Designing OOP Solutions: Identifying the Class Structure.- Designing OOP Solutions: Modeling the Object Interaction.- Designing OOP Solutions: A Case Study.- Introducing the .NET Framework and Visual Studio.- Creating Classes.- Creating Class Hierarchies.- Implementing Object Collaboration.- Working with Collections.- Implementing the Data Access Layer.- Developing WPF Applications.- Developing Web Applications.- Developing Windows Store Applications.- Developing and Consuming Web Services.- Developing the Office Supply Ordering Application.- Wrapping UpTable of ContentsOverview of Object-Oriented Programming.- Designing OOP Solutions: Identifying the Class Structure.- Designing OOP Solutions: Modeling the Object Interaction.- Designing OOP Solutions: A Case Study.- Introducing the .NET Framework and Visual Studio.- Creating Classes.- Creating Class Hierarchies.- Implementing Object Collaboration.- Working with Collections.- Implementing the Data Access Layer.- Developing WPF Applications.- Developing Web Applications.- Developing Windows Store Applications.- Developing and Consuming Web Services.- Developing the Office Supply Ordering Application.- Wrapping Up

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

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 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 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 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 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 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 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 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 Synopsis1. The Fundamentals.- 2. Introduction to Requirements.- 3. The Language of Data Modeling.- 4. Conceptual and Logical Data Model Production.- 5. Normalization.- 6. Physical Model Case Study.- 7. Physical Model Implementation.- 8. Data Protection Patterns with Check Constraints and Triggers.- 9.  Patterns and Anti-Patterns.- 10. Database Security and Security Patterns.- 11. Data Structures, Indexes, and Their Applications.- 12. Matters of Concurrency.- 13. Coding Architecture.- 14. Appendix A: Scalar Datatype Reference.Table of Contents1. The Fundamentals2. Introduction to Requirements3. The Language of Data Modeling4. Conceptual and Logical Data Model Production5. Normalization6. Physical Model Case Study7. Physical Model Implementation 8. Data Protection Patterns with Check Constraints and Triggers9. Patterns and Anti-Patterns10. Database Security and Security Patterns11. Data Structures, Indexes, and Their Applications12. Matters of Concurrency13. Coding Architecture 14. Appendix A: Scalar Datatype Reference.

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 SynopsisBeginning-Intermediate user levelTable of Contents​Chapter 1: Introduction to Infrastructure as Code Chapter Goal: Understand the basics on Infrastructure as Code paradigm and known about its advantages, principles and tools. Understand the need to convert infrastructure into code. No of pages: 5 Sub -Topics 1. Understanding Configuration Management 2. Understanding Infrastructure as code 3. Principles of Infrastructure as code 4. Benefits and applicability for cloud environments Chapter 2: Azure and Terraform Chapter Goal: Get an overview of Azure as enterprise cloud provider with different paradigm like IaaS, PaaS. Different ways to provision resources in Azure. How Terraform fits within the Azure Landscape and how it can be used to provision Azure resources. Understand the high-level architecture and workflow using Terraform No of pages: 15 Sub - Topics 1. Overview of Azure cloud 2. Overview of Terraform configuration management 3. Terraform workflow for provisioning and de-provisioning of resources 4. Terraform architecture – providers, plugins, resources, repositories Chapter 3: Getting Started with Terraform Chapter Goal: Getting hand dirty with Terraform, writing multiple terraform scripts exploring different concepts of Terraform. No of pages: 45 Sub - Topics: 1. Understand Terraform CLI and using various options 2. State Management in Terraform 3. using Resources, providers, outputs 4. Terraform Data types 5. Dependency graphs in Terraform scripts Chapter 4: Deep Dive into Terraform Chapter Goal: Understanding the advance features of Terraform both from component as well at script level. Write advance Terraform scripts for conditional deployments, multiple resource creation using loops. No of pages: 45 Sub - Topics: 1. Backend, state and workspace management in Terraform 2. dynamic provisioning of resources 3. loops, conditional statements – for, for-each, if 4. using Terraform functions – string, collection, encoding, file Chapter 5: Writing Reusable Modules in Terraform Chapter Goal: Writing reusable Terraform scripts using modules, storing modules in repositories and consuming them in multiple scripts. No of pages: 25 1. Basic of Modules, child and parent modules 2. Passing parameters and getting output from modules 3. Using modules from multiple scripts. Chapter 6: Writing Secure Scripts with Terraform Chapter Goal: Management and administration of sensitive data, secrets and passwords within Terraform code. Usage of Key vaults for storing of secrets. No of pages: 20 1. Secure storage of credentials and sensitive information 2. Usage of Managed Identities, certificates, service principles to connect to Azure 3. Storing secrets in Azure Key vaultChapter 7: Repos, Versioning, CI/CD pipelines for Terraform Chapter Goal: Overview of storing and versioning of Terraform scripts such that each version can be used in isolation without conflicting with others. Using Terraform CLI in Azure DevOps pipelines to automate the process of deployment of Azure Resources. No of pages: 20 1. Storing Terraform scripts in Azure DevOps 2. Versioning of Terraform modules 3. CICD pipelines for deploying resources on Azure using Terraform Chapter 8: Writing Unit and Integration Tests for Terraform Chapter Goal: Testing of Terraform scripts using TerraTest utility. Understanding principles of unit and integrating testing alongside implementing them No of pages: 20 1. Exploring TerraTest and terra-lint 2. Understanding Unit testing and writing unit tests for Terraform scripts 3. Understanding Integration testing and writing Integration tests for Terraform scripts Chapter 9: Terraform Best Practices Chapter Goal: Understanding the best practices of authoring, deploying and managing Terraform scripts in general and in Azure No of pages: 10 1. Understanding Terraform Folder structure and deployment structure 2. Writing testable Terraform scripts 3. Writing Maintainable code – usage of variables, no hard-coding etc

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 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 SynopsisDesign and build the newdesktop service from Microsoft. This book offers a modern framework, design methodology, and best practices of design and deployment for virtual apps and desktops.Microsoft Azure Virtual Desktop (AVD) is a Desktop as a Service (DaaS) which is simple to deploy, accessible from any device, easy to manage, and secure. The book starts with AVD essentials and its critical features, followed by the planning and method of preparing for AVD. You will go through defining the requirements and assessing by setting the AVD application baseline, network requirements, and security requirements. Next, you will learn how to design and deploy the core infrastructure of Microsoft AVD to understand its Access Layer, Control Layer, Resource Layer, Hosting Layer, and User Layer. You will also learn how to design the desktop and Host Pool of AVD. And you will learn the modern way to manage and secure AVD components. After reading this book, you will havetheright blend of knowledge Table of ContentsChapter 1: Microsoft WVD Design Essentials· WVD Essentials · Key foundations of WVD · Terminology of WVD Chapter 2: Preforming Assessment and requirements gathering of Microsoft WVD · Preforming due diligences · Classifying the WVD use cases. · Defining WVD Application baseline. · Defining WVD Network requirements. · Defining WVD Security requirements. Chapter 3: Designing Core Infrastructure of Microsoft WVD · Designing WVD Compute and storage. · Designing WVD Network. · Designing WVD Security requirements. · Designing WVD Access layer. · Designing WVD Control Layer. Chapter 4: Designing Desktop and RDHS Pool of Microsoft WVD · Designing WVD Resource Layer. · Designing WVD RDHS Pool. · Designing WVD Desktop Pool. · Designing WVD User Profile and Personalization Layer · Designing WVD Policy Layer. · Designing WVD Application delivery Layer. Chapter 5: Designing Monitoring and Security Components of Microsoft WVD · Designing WVD Operational Layer. · Designing WVD Monitoring layer. · Designing WVD Security Layer. · Designing WVD Migration Layer. · Designing WVD Automation Layer.

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 SynopsisMaster Excel in less than two weeks with this unique project-based book! Let's face it, we all master skills in our own way, but building a soup-to-nuts project is one of the best ways to make learning stick and get up to speed quickly. Whether you are just getting started with Excel or are an experienced user, this book will elevate your knowledge and skills. For a beginner, the micro examples in each chapter will warm you up before you dive into the projects. For experienced users, the projects, especially those with table setup considerations, will help you become more creative in your interactions with Excel. Readers will benefit from building eight unique projects, each covering a different topic, including a word game, a food nutrition ranking, a payroll (tax withholding) calculation, an encryption, a two-way table, a Kaplan-Meier analysis, a data analysis via a pivot table and the K-means Clustering data mining method. Through these projects, you will experience firsthand how Table of ContentsChapter 1: Master Excel through Projects Chapter 2: Food Nutrition Ranking Chapter 3: Payroll Calculation Chapter 4: Public and Private Key Cryptography Chapter 5: Two-Way Table and Chi-Square Test Chapter 6: Kaplan-Meier Analysis Chapter 7: PivotTable Data Analysis Chapter 8: K-means Clustering and Iterative Calculation

Read more less

Book SynopsisImplement cloud security with Azure security tools, configurations and policies that address the needs of businesses and governments alike. This book introduces you to the most important security solutions available in Azure and provides you with step-by-step guidance to effectively set up security and deploy an application on top of Azure platform services, as well as on top of Azure infrastructure.Author Pushpa Herath begins by teaching you the fundamentals of Azure security. An easy to follow exploration of management groups, subscriptions, management locks and Azure policies further elaborate the concepts underlying Azure cloud security. Next, you will learn about Azure Active Directory (AAD) and the utilization of AAD in application and infrastructure security. Essential aspects of maintaining secure application keys and certificates are further explained in the context of Azure Key Vault. New application security implementations such as Azure configuratTable of ContentsChapter 1: Understanding the Importance of Data/Application Security Chapter Goal: Give general overview on importance of data security No of pages: 5 Sub -Topics 1. Introduction to security 2. Introduction to Azure security fundamentals Chapter 2: Overview of Basic Azure Security Components Chapter Goal: Introduction to various security components in Azure and how to utilize them. No of pages: 15 Sub - Topics 1. Introduction to Azure Management groups and subscriptions 2. Azure Management locks 3. Introduction to Azure policies Chapter 3: Introduction to Azure Active Directory Chapter Goal: Lessons to provide hand-on guidance on user access control of the organization using Azure Active Directory. No of pages : 30 Sub - Topics: 1. Adding users and groups to the AD 2. Manage External Identities 3. Enable two factor authentications 4. Roles and Administrative units in Azure AD 5. Managing Enterprise applications 6. Introduction to AD devices 7. Azure AD app registration 8. Adding custom domains Chapter 4: Working with Azure Key vault Chapter Goal: Step by step guidance to setting up and using azure key vault to achieve several security requirements in the organization. No of pages: 15 Sub - Topics: 1. Setting up Key vault 2. Key vault access control 3. Using KV to save Keys 4. Using KV to secure Secrets 5. Using KV to keep certificates 6. Key vault access policies 7. KV networking and security Chapter 5: Ensure Azure Application security Chapter Goal: Step by step guidance to setting up various security components which helps to secure application hosted in Azure No of pages: 40 Sub - Topics: 1. Keep configurations in central location using Azure Configuration 2. Authentication and authorization in Azure App Service 3. How to secure application with web application firewall in Azure 4. Application Security groups Chapter 6: Ensure Data Security with Azure Storages Chapter Goal: Overview on how data storage security works in Azure No of pages: 30 Sub - Topics: 1. Setting up azure storage 2. Azure storage encryption 3. Azure defender for azure storage Chapter 7: Ensure Security using Azure Virtual Networks Chapter Goal: Step by step guide on how to setup virtual networks to enhance the security of the data and infrastructure. No of pages: 40 Sub - Topics: 1. Network security groups 2. Azure VPN gateways 3. Azure Load balancer 4. Azure Subnets Chapter 8: Working with Azure Application Gateway Chapter Goal: Hands on lessons on implementing Azure Application gateway to enhance the security of the data Sub - Topics: 1. Setting up Azure Application gateway 2. Secure Web App using App gateway 3. Secure Virtual Machine using App gateway Chapter 9: Securing data with Azure Firewall Chapter Goal: Step by step guidance to setting up azure firewall and configure it to secure data No of pages: 40 Sub - Topics: 1. Setting up Azure Firewall 2. Setting up policies 3. Setting up rules Chapter 10: Creating App Service Environment to enhance security Chapter Goal: Step by step guidance to setting up App service environment and using it to secure applications No of pages: 50 Sub - Topics: 1. Setting up Azure Application service environment 2. Deploy applications to app service environment Chapter 11: Secure Infrastructures in Azure Chapter Goal: Explains different security features available with few of the azure resources No of pages: 30 Sub - Topics: 1. Secure Azure Virtual machine using Bastian 2. Secure Azure Virtual machine using encrypted firewall rules 3. Azure SQL server security components

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 SynopsisBroaden your developer experience by learning how to use gRPC and ASP.NET Core together on the Microsoft's developer framework, .NET 6 and discover a new way of developing APIs with gRPC. Beginning gRPC with ASP.NET Core6is your guide to quickly and efficiently getting down to the business of building gRPC applications in the Microsoft .NET ecosystem. Readers will dive in and build an application using gRPC and the latest technologies such Angular and ASP.NET Core Razor Pages.This book will teach you how to set up an efficient application using industry best practices such as security, monitoring, logging, and more. You will do this by performing Create, Read, Update, and Delete (CRUD) operations on a SQL Server database with Entity Framework Core. From there you will build web applications using Angular and ASP.NET Core Razor pages combined with gRPC APIs. After reading the book, you'll be able to take advantage of the full range of developer opportunities with gRPC, and come awayTable of ContentsPart I: Getting Started with .NET 6 Chapter 1: Welcome to Modern .NET Chapter 2: Introducing ASP.NET Core 6Part II: gRPC fundamentalsChapter 3 : Understanding the gRPC Specification Chapter 4: Protbufs Chapter 5: Creating an ASP.NET Core gRPC Application Chapter 6: API Versioning Part III: gRPC and ASP.NET Core Chapter 7: Create a gRPC Client Chapter 8: From WCF to gRPC Chapter 9: Import and Display Data with ASP.NET Core Razor Pages, Hosted Services, and gRPC Chapter 10: The gRPC-web Specification Chapter 11: Create a gRPC-web service from a gRPC-service with ASP.NET Core Part IV: gRPC-web and ASP.NET Core Chapter 12: Import and Display Data with Angular 12 and gRPC-webPart V: Security Chapter 13: Secure your Application with OpenId Connect

Read more less

Book SynopsisModernize your business to make it more agile using Azure Virtual Desktop (AVD). Azure Virtual Desktop is a cloud desktop virtualization platform that securely delivers virtual desktops and remote apps. This book will help you will help you to understand designing, implementing, configuring, and maintaining an Azure Virtual Desktop environment for enterprise and prepare to take the Microsoft AZ-140 certification exam. The book starts with an introduction to Azure Virtual Desktop and its design architecture. You will learn designing Azure Virtual desktop including user identities and profiles. Additionally, you will learn how to implement network for Azure Virtual desktop. Creation and configuration of host pools and session hosts is covered with all steps so that you can understand all options and select appropriate configuration for enterprise deployment. You will also go through session host images creation process and managing the image with image gallery and possible automation oTable of ContentsChapter 1: Introduction to Azure Virtual Desktop Introduction What is Azure Virtual Desktop? Chapter 2: Design the Azure Virtual Desktop Architecture · assess existing physical and virtual desktop environments · assess network capacity and speed requirements for Azure Virtual Desktop · recommend an operating system for an Azure Virtual Desktop implementation · plan and configure name resolution for Active Directory (AD) and Azure Active Directory Domain Services (Azure AD DS) · plan a host pools architecture · recommend resource groups, subscriptions, and management groups · configure a location for the Azure Virtual Desktop metadata · calculate and recommend a configuration for performance requirements · calculate and recommend a configuration for Azure Virtual Machine capacity requirements Chapter 3: Design for user identities and profiles · select an appropriate licensing model for Azure Virtual Desktop based on requirements · recommend an appropriate storage solution (including Azure NetApp Files versus Azure Files) · plan for Azure Virtual Desktop client deployment · plan for user profiles · recommend a solution for network connectivity · plan for Azure AD Connect for user identities Chapter 4: Implement and manage networking for Azure Virtual Desktop · implement Azure virtual network connectivity · manage connectivity to the internet and on-premises networks · implement and manage network security · manage Azure Virtual Desktop session hosts by using Azure Bastion · monitor and troubleshoot network connectivity Chapter 5: Implement and manage storage for Azure Virtual Desktop · configure storage for FSLogix components · configure storage accounts · configure disks · create file shares Chapter 6: Create and configure host pools and session hosts · create a host pool by using the Azure portal · automate creation of Azure Virtual Desktop host and host pools by using PowerShell, Command-Line Interface (CLI), and Azure Resource Manager templates · create a host pool based on Windows client or Windows Server session hosts · configure host pool settings · manage licensing for session hosts that run Windows client or Windows Server · assign users to host pools · apply OS and application updates to a running Azure Virtual Desktop host · apply security and compliance settings to session hosts Chapter 7: Create and manage session host images · create a gold image · modify a session host image · install language packs in Azure Virtual Desktop · deploy a session host by using a custom image · plan for image update and management · create and use a Shared Image Gallery · troubleshoot OS issues related to Azure Virtual Desktop Chapter 8: Manage access · plan and implement Azure roles and role-based access control (RBAC) for Azure Virtual Desktop · manage roles, groups and rights assignment on Azure Virtual Desktop session hosts · configure user restrictions by using AD group policies and Azure policies Chapter 9: Manage security · plan and implement Conditional Access policies for connections to Azure Virtual Desktop · plan and implement multifactor authentication in Azure Virtual Desktop · manage security by using Azure Security Center · configure Microsoft Defender Antivirus for session hosts Chapter 10: Implement and manage FSLogix · plan for FSLogix · install and configure FSLogix · configure Profile Containers · configure Cloud Cache · migrate user profiles to FSLogix Chapter 11: Configure user experience settings · configure Universal Print · configure user settings through group policies and Endpoint Manager policies · configure persistent and non-persistent desktop environments · configure Remote Desktop Protocol (RDP) properties on a host pool · configure session timeout properties · troubleshoot user profile issues · troubleshoot Azure Virtual Desktop clients Chapter 12: Install and configure apps on a session host · configure dynamic application delivery by using MSIX App Attach · implement application masking · deploy an application as a RemoteApp · implement and manage OneDrive for Business for a multi-session environment · implement and manage Microsoft Teams AV Redirect · implement and manage browsers and internet access for Azure Virtual Desktop sessions · create and configure an application group · troubleshoot application issues related to Azure Virtual Desktop Chapter 13: Plan and implement business continuity and disaster recovery · plan and implement a disaster recovery plan for Azure Virtual Desktop · design a backup strategy for Azure Virtual Desktop · configure backup and restore for FSLogix user profiles, personal virtual desktop infrastructures (VDIs), and golden images Chapter 14: Automate Azure Virtual Desktop management tasks · configure automation for Azure Virtual Desktop · automate management of host pools, session hosts, and user sessions by using PowerShell and Azure Command-Line Interface (CLI) · implement autoscaling in host pools Chapter 15: Monitor and manage performance and health · monitor Azure Virtual Desktop by using Azure Monitor · monitor Azure Virtual Desktop by using Azure Advisor · customize Azure Monitor workbooks for Azure Virtual Desktop monitoring · optimize session host capacity and performance · manage active sessions and application groups · monitor and optimize autoscaling results Chapter 16: Azure Virtual Desktop Automation AVD automation for create/delete hostpool / sessionhost AVD pooled advance autoscaling logic to start/stop/add new sessionhost in hostpool automatically based on CPU usage

Read more less

Book SynopsisGet introduced to Azure Arc-enabled Data Services and the powerful capabilities to deploy and manage local, on-premises, and hybrid cloud data resources using the same centralized management and tooling you get from the Azure cloud. This book shows how you can deploy and manage databases running on SQL Server and Postgres in your corporate data center or any cloud as if they were part of the Azure platform. This second edition has been updated to the latest codebase, allowing you to use this book as your handbook to get started with Azure Arc-enabled Data Services today. Learn how to benefit from Azure's centralized management, the automated rollout of patches and updates, managed backups, and more.This book is the perfect choice for anyone looking for a hybrid or multi-vendor cloud strategy for their data estate. The authors walk you through the possibilities and requirements to get Azure SQL Managed Instance and PostgresSQL Hyperscale deployed outside of Azure, so the services are accessible to companies that cannot move to the cloud or do not want to use the Microsoft cloud exclusively. The technology described in this book will benefit those required to keep sensitive services, such as medical databases, away from the public cloud equally as those who can't move to a public cloud for other reasons such as infrastructure constraints but still want to benefit from the Azure cloud and the centralized management and tooling that it supports. What You Will LearnUnderstand the fundamentals and architecture of Azure Arc-enabled data servicesBuild a multi-cloud strategy based on Azure Data ServicesDeploy Azure Arc-enabled data services on premises or in any cloudDeploy Azure Arc-enabled SQL Managed Instance on premises or in any cloudDeploy Azure Arc-enabled PostgreSQL Hyperscale on premises or in any cloudBackupand Restore your data that is managed by Azure Arc-enabled data servicesManage Azure-enabled data services running outside of AzureMonitor Azure-enabled data services through Grafana and KibanaMonitor Azure-enabled data services running outside of Azure through Azure MonitorWho This Book Is ForDatabase administrators and architects who want to manage on-premises or hybrid cloud data resources from the Microsoft Azure cloud. Especially for those wishing to take advantage of cloud technologies while keeping sensitive data on premises and under physical control.Table of Contents1. A Kubernetes Primer2. Azure Arc-Enabled Data Services3. Getting Ready for Deployment4. Installing Kubernetes5. Deploying a Data Controller in Indirect Mode 6. Deploying a Data Controller in Direct Mode 7. Deploying an Azure Arc-Enabled SQL Managed Instance8. Deploying Azure Arc-Enabled PostgreSQL Hyperscale 9. Monitoring and Management

Read more less

Book SynopsisUse a simple programming model and the .NET language of your choice to build large distributed systems. This book teaches you the Microsoft Orleans framework.Even well-versed professional software developers with expertise in C# (or another language) find themselves unequipped to meet the challenges of distributed systems as infrastructure moves to multi-core; multiple computers are being used for scale, redundancy, and cloud computing; and multi-region deployment is taking place.Orleans handles many of the concerns of distributed computing and cloud infrastructure, allowing you to concentrate on writing application logic.What You Will Learn Know the key concepts for building distributed systems Gain a background in the origin and evolution of Orleans, and why it is important for your projects Dive into each of the features available in Orleans by building an example application Develop troubleshootingTable of Contents1. Fundamentals2. Grains and Silos3. Hello World 4. Debugging an Orleans Application5. Orleans Dashboard6. Adding Persistence7. Adding ASP.NET Core8. Unit Testing9. Streams10. Timer and Reminders11. Transactions12. Event Sourced Grains13. Updating Grains14. Optimizations15. Advanced Features16. Interviews

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

Book SynopsisProduce high-quality, visually attractive analysis quickly and effectively with Microsoft''s key BI tool. This book teaches analysts, managers, power users, and developers how to harness the power of Microsoft''s self-service business intelligence flagship product to deliver compelling and interactive insight with remarkable ease. It then shows you the essential techniques needed to go from source data to dashboards that seize your audience''s attention and provide them with clear and accurate information.  As well as producing elegant and visually arresting output, you learn how to enhance the user experience through adding polished interactivity. This book shows you how to make interactive dashboards that allow you to guide users through the meaning of the data that they are exploring. Drill down features are also covered that allow you and your audience to dig deeper and uncover new insights by exploring anomalous and interesting data points. <Table of Contents1. Dashboard Basics2. Table Visuals3. Advanced Table Visual Techniques4. Matrix Visuals5. Card Visual Types6. Charts in Power BI Desktop7. Advanced Chart Types8. Formatting Charts9. Other Types of Visuals10. Third Party Visuals11. Drilldown and Drillup12. Maps in Power BI Desktop13. Filtering Data14. Slicers and Cross-Filtering15. Enhancing Dashboards16. Multi-Page Dashboards17. Bookmarks and ButtonsA. Sample DataB. Visualization IconsC. Blank Visual Representations

Read more less

Book SynopsisDesign and implement a modern data lakehouse on the Azure Data Platform using Delta Lake, Apache Spark, Azure Databricks, Azure Synapse Analytics, and Snowflake. This book teaches you the intricate details of the Data Lakehouse Paradigm and how to efficiently design a cloud-based data lakehouse using highly performant and cutting-edge Apache Spark capabilities using Azure Databricks, Azure Synapse Analytics, and Snowflake. You will learn to write efficient PySpark code for batch and streaming ELT jobs on Azure. And you will follow along with practical, scenario-based examples showing how to apply the capabilities of Delta Lake and Apache Spark to optimize performance, and secure, share, and manage a high volume, high velocity, and high variety of data in your lakehouse with ease. The patterns of success that you acquire from reading this book will help you hone your skills to build high-performing and scalable ACID-compliant lakehouses using flexible and cost-efficient decoupled storTable of ContentsIntroductionPart I. Getting Started1. The Lakehouse Paradigm2. Mount Lakes to DatabricksPart II. Lakehouse Platforms3. Snowflake Data Warehouse4. Synapse Analytics Serverless Pools5. Databricks SQL AnalyticsPart III. Apache Spark6. PySpark7. Extract, Load, Transform JobsPart IV. Delta Lake8. Delta Schema Evolution9. Delta Change Feed10. Delta Clones11. Delta Live Tables12. Delta SharingPart V. Optimizing Performance13. Dynamic Partition Pruning for Querying Star Schemas14. Z-Ordering and Data Skipping15. Adaptive Query Execution16. Bloom Filter Index17. HyperspacePart VI. Lakehouse Capabilities18. Auto Loader Resource Management19. Advanced Schema Evolution with Auto Loader 20. Python Wheels21. Security and Controls22. Unity Catalog

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 SynopsisSo, you want to learn C# and Visual Studio 2022, but are a bit intimidated? Don''t be. Programming is within your grasp! Programmers at any level have to fully understand, and more importantly, be able to code the core constructs. It is impossible to use complex programming concepts such as classes before understanding what methods and variables and their data types are. Once there is a foundation built on the basics, then all other topics can fall in line.While it is a forgone conclusion that languages change with the introduction of new features, the core concepts do not. Even large enterprises do not always update to the latest versions of languages and frameworks; their backbone applications have been developed to work, regardless. More than ever, enterprises need developers who can master and apply the core programming concepts and then be up-skilled with newer language levels and features as they integrate into the company.This book builds from the ground up. You wTable of ContentsChapter 1. .NET Chapter 2. Software Installation Chapter 3. Introduction Chapter 4. Input and Output Chapter 5. Commenting Code Chapter 6. Data TypesChapter 7. Casting and Parsing Chapter 8. Arithmetic Chapter 9. Selection Chapter 10. Iteration Chapter 11. Arrays Chapter 12. Methods Chapter 13. Classes Chapter 14. Interfaces Chapter 15. String HandlingChapter 16. File HandlingChapter 17. Exception HandlingChapter 18. SerializationChapter 19. StructsChapter 20. EnumerationsChapter 21. DelegatesChapter 22. EventsChapter 23. GenericsChapter 24. Common RoutinesChapter 25. Programming LabsChapter 26. C# 11

Read more less

Book SynopsisLearn and understand Microsoft Teams functionality, potential issues, and the tools available to troubleshoot Teams. This book provides a complete overview of Teams Phone system (PSTN) connectivity, call routing and quality troubleshooting, and best practices to support a Teams environment.The book begins with an introduction to Microsoft Teams and it provides a troubleshooting terminology. You will understand how to identify and develop a systematic approach for troubleshooting Teams. You will learn Teams Phone (voice) management and how to handle issues related to: Direct Routing connectivity, call routing, emergency calling, and much more. The book covers issues related to Teams client-side and external access along with Teams call quality troubleshooting. You will gain knowledge of real-world issues and use Teams troubleshooting tools such as the: Connectivity Analyzer, call diagnostic tool, SBC Syslog, Call Quality Dashboard, and quality analytics tool. You will go Table of ContentsChapter 1: Introduction (Troubleshooting) Chapter Goal: Troubleshooting introduction No of pages 20-30 Sub -Topics 1. Introduction 2. What is Microsoft Teams? 3. Why are Teams so popular? 4. Understand troubleshoot approaches 5. Discuss a systematic approach to troubleshooting 6. Summary Chapter 2: Microsoft Teams Overview Chapter Goal: Whats new in Microsoft Teams and management No of pages: 30-40 Sub - Topics 1. Introduction 2. Microsoft Teams Service architecture 3. Teams, Team, Channel, file, and Tab 4. Microsoft Teams different client 5. Teams Phone system 6. Teams live Event 7. Introduction of Microsoft Teams admin center 8. Summary Chapter 3: Identify and Develop Systemic Approach for Teams Troubleshooting Chapter Goal: No of pages : 30 -35 Sub - Topics: 1. Introduction 2. Understand Microsoft Teams administration 3. Teams diagnostic logs and collecting process 4. Diagnose common Teams problem 5. Use a troubleshooting methodology using 6. Create and implement a plan of action 7. Summary Chapter 4: Troubleshoot Teams Identity and Sign-in Issues Chapter Goal: No of pages: 30-40 Sub - Topics: 1. Introduction 2. Understand and review Teams network configuration 3. Evaluate and design conditional access policies 4. Understand Teams Identity and troubleshoot Teams account issues 5. Capture and Analyze Teams sign-in logs 6. Troubleshoot issues with Teams apps (first and 3rd party) 7. Troubleshoot problems with public and private channels 8. Troubleshoot file issues for private and public channels 9. Summary Chapter 5: Troubleshoot Microsoft Teams Call Quality Issue. Chapter Goal: 1. Introduction 2. Understand and troubleshoot Teams signaling and media flow. 3. Learn and troubleshoot Teams One-to-One and multi-party call flow problem 4. Troubleshoot Teams meeting creation and recording issues 5. Examine Teams content sharing and attendee access problems 6. Effectively manage and troubleshoot Teams live events issues 7. Troubleshoot Teams messaging and reporting problems 8. Troubleshoot file sharing in person-to-person private chat 9. Summary Chapter 6: Troubleshoot Microsoft Teams Phone System (Calling plan & Direct routing) issue Chapter Goal: No of pages: 30-40 Sub - Topics: 1. Introduction 2. Understand Microsoft Teams phone system a. Teams calling plan b. Teams Direct Routing 3. Troubleshoot Teams Direct routing (connectivity) issue 4. Troubleshoot emergency calling issues. 5. Troubleshoot Teams Call (PSTN) routing issues. 6. Configure and troubleshoot audio conferencing 7. Troubleshoot dial-plan, voice routing, and emergency call routing policies 8. Troubleshoot phone system issues 9. Summary Chapter 7: Troubleshooting Teams client-side and external access issues Chapter Goal: No of pages: 20-30 Sub - Topics: 1. Introduction 2. Deploy and update Teams client software 3. Troubleshoot Teams client startup and configuration 4. Troubleshoot audio and video devices 5. Troubleshoot Teams desktop client performance issues 6. Understand Teams external and Troubleshoot external (federation) access issues 7. Enable and Troubleshoot Teams Guest access issues 8. Troubleshoot issues interoperating with Skype for Business 9. Summary Chapter 8: Apply best practices and Teams Optimal Management Using PowerShell Chapter Goal: No of pages: 30-40 Sub - Topics: · Introduction · Best practices for Implementation QoS · Best practices for Implementing VPN split tunnel · Lesson learning for applying Location-Based Routing (LBR) · Implementations inbound and outbound normalization rules · Frequently used PowerShell command and script · Summary Chapter 9: Teams real-world issue using troubleshooting tools Chapter Goal: No of pages: 20-30 Sub - Topics: 1. Introduction 2. Identify and Review Teams troubleshooting tools a. Connectivity analyzer b. Call diagnostic tool 3. Understand and use Teams call quality analytics tool a. Troubleshoot single user call quality issues 4. Use the Call Quality Dashboard to investigate audio and video issues. a. Investigate organization call quality issues 5. Log parsing tool 6. Diagnose and resolve Teams real-world issues 7. Summary Chapter 10: PowerBI based Teams call Quality dashboard for call quality troubleshooting Chapter Goal: No of pages: 30-40 Sub - Topics: 1. Introduction 2. PowerBI and Microsoft Teams 3. Design PowerBI based Teams Reports 4. Design Teams Call Quality dashboard to identify poor audio and video call 5. Use Call quality dashboard for call quality troubleshooting 6. Summary 7. Knowledge check

Read more less

Book SynopsisReview the fundamental constructs in C# using Q&As and program segments to boost your confidence and gain expertise. This book will help you analyze your programs more efficiently and enhance your programming skills.The book is divided into three parts, where you will learn the fundamentals, object-oriented programming, and some advanced features of C#. In the first part, you will review C# and .NET basics along with the important constructs such as strings, arrays, and structures. In the second part, you''ll review the concepts of object-oriented programming in detail. Here, you will go through various program segments in class and objects, inheritance, polymorphism, abstraction, encapsulation, and much more. You will also analyze the output of the given programs with the help of Q&A sections. The uses of interfaces, static class, and exception handling are discussed in the book along with some other important concepts in C#. In the third and last part, you will learn aTable of ContentsPart I Fundamentals Chapter 1: Language Basics Chapter Goal: This chapter discusses the following topics: The important concepts in .NET The basic programming constructs in C#. Use of some useful data types including the var type. Use of some useful operators and explicit-casting. Use of the selection statements and case guards. Use of iteration statements. Use of the jump statements. Use of the ternary operator. No of pages: 28 Sub - Topics N Chapter 2: String and Arrays Chapter Goal: Once you finish this chapter, you can answer the following questions and related areas: How can you use string datatype in your program? How can you use the common in-built methods from the String class? How a String variable is different from a StringBuilder? How can you convert a string to an int? How can you use nullable reference type in a program? How to create arrays in C#? What are the different types of C# arrays and how to use them? How to use common in-built methods from the System.Array class? How can you iterate over a string or an array? No of pages 23 Sub - Topics NA Chapter 3: Enumeration and Structures Chapter Goal: This chapter discusses the following topics: The enum fundamentals Flags enumeration Defaut value expressions The struct fundamentals Non-destructive mutations No of pages: 26 Sub - Topics NA Part II Object-Oriented Programming Chapter 4: Class and Objects Chapter Goal: This chapter focuses on the following topics: Classes and objects creations. Instance fields and methods. Constructors and their usage. Optional parameters. Object initializers. Nested classes. The uses of private, internal, and public modifiers inside a class. No of pages: 17 Sub - Topics NA Chapter 5: Inheritance Chapter Goal: This chapter covers the following topics: Inheritance and types. Method and constructor overloading. Method overriding. Use of virtual, override, and new keywords. Use of the sealed keyword. Introductory discussion on covariance and contravariance No of pages 33 Sub - Topics NA Chapter 6: Polymorphism Chapter Goal: This chapter helps you to review: Polymorphism and its benefits. Abstract classes and their uses. Interfaces and their uses. Different types of interfaces. Writing polymorphic codes using abstract classes and interfaces No of pages: 30 Sub - Topics NA Chapter 7: Encapsulation Chapter Goal: This chapter covers the following topics: What is encapsulation? How is it different from an abstraction? Properties and their usage. Different ways to create a property. The usage of the get and set accessors. Virtual and abstract properties. The discussion of the init accessor. Indexers and their usage. How can the indexers and properties work with an interface? Discussion on different aspects of properties and indexers. No of pages: 26 Sub - Topics NA Chapter 8: Exception Handling Chapter Goal: This chapter covers the following topics: Exception and its uses in C# programming. Use of the try, catch, and finally blocks. Use of multiple catch blocks in a program. Use of a general catch block. How to throw and re-throw an exception. Use of exception filters. Custom exception class and its usage. No of pages: 23 Sub - Topics NA Chapter 9: Useful Concepts Chapter Goal: Q&A and program segments on some useful constructs such as casting and boxing, static class and methods, passing value type by value, passing value type by references(using ref and out keyword), extension methods, and so on. No of pages: 15-25+ Sub - Topics NA Part III Advanced Features Chapter 10: Delegates Chapter Goal: This chapter covers the following topics: Delegates and their uses Multicast delegates Some commonly used in-built delegates Covariance and contravariance using delegates No of pages: 20 Sub - Topics NA Chapter 11: Events Chapter Goal: This chapter helps you to review your understanding of events and discusses the following: Events creation and their uses. How to pass the event data. Use of event accessors. Use of interface events (both implicit and explicit). Simplified coding with events. No of pages: 22 Sub - Topics NA Chapter 12: Lambdas Chapter Goal: This chapter focuses on this and covers the following topics: Lambda expressions and their use Expression-bodied members Use of local variables inside lambda expressions. Event handling using lambda expressions. Use of a static lambda. Understanding natural type. No of pages: 22 Sub - Topics NA Chapter 13: Generics Chapter Goal: This chapter focuses on the following topics: The motivation behind generics. The fundamentals of generic programs. Use of generic interfaces. Use of generic constraints. Use of covariance and contravariance using generics. Self-referencing generic type. Experimenting with generic method’s overloading and overriding. Analyzing the static data in the context of generics. No of pages: 35 Sub - Topics NA Chapter 14: Multithreading Chapter Goal: Upon completion of this chapter, you’ll be able to answer the following questions: What are the threads and how can you create them? What is a multithreaded program? How does it differ from a single-threaded application? Why are the ThreadStart and ParameterizedThreadStart delegates important in thread programming? How to block a thread using Sleep or Join methods? How can you use lambda expressions in a multithreaded program? How to use important Thread class members? How a foreground thread is different from a background thread? What is synchronization and why is it needed? How can you implement thread safety in C# using lock statements? How can you implement an alternative approach to lock statements using Monitor’s Entry and Exit Method? What is a deadlock and how can you detect the deadlock in your system? What is the purpose of using the ThreadPool class? What are the associative pros and cons of using it? How to cancel a running thread in the managed environment? And many more. No of pages: 40 Sub - Topics NA Chapter 15: Miscellaneous Chapter Goal: Q&A and program segments on the related latest features that are covered in the previous chapters and any other important topics(if any). No of pages: 10-20+ Sub - Topics NA

Read more less