Microsoft programming Books

Book SynopsisAssembly x64 Programming in easy steps shows how to write code to create your own computer programs. It contains separate chapters demonstrating how to store and manipulate data in 64-bit registers, how to control program flow, and how to create reusable blocks of code in program functions. It includes demonstrations of parallel processing with 128-bit Streaming SIMD Extensions (SSE) and 256-bit Advanced Vector Extensions (AVX).Assembly x64 Programming in easy steps has an easy-to-follow style that will appeal to anyone who wants to begin programming in modern x64 Assembly language on Windows. The code in the listed steps within the book is color-coded, making it easier for beginners to grasp. There are complete step-by-step example programs that demonstrate each aspect of coding, together with screenshots that illustrate the actual output when each program is executed.Includes free, downloadable source code to get you started straightaway!

Read more less

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

Read more less

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

Read more less

Book Synopsis

Read more less

Book 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 SynopsisJazz up your iPhone and iPad apps with some slick graphics and animation-and keep users from looking elsewhere. This short and concise cookbook shows developers with even little Cocoa programming experience how to create impressive graphics and animation effects with relatively easy coding.

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

Read more less

Book 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