Microsoft programming Books

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

Book Synopsis Get your daily work done efficiently using this comprehensive guide for SQL Server DBAs that covers all that a practicing database administrator needs to know. Updated for SQL Server 2022, this edition includes coverage of new features, such as Ledger, which provides an immutable record of table history to protect you against malicious data tampering, and integration with cloud providers to support hybrid cloud scenarios. You''ll also find new content on performance optimizations, such as query pan feedback, and security controls, such as new database roles, which are restructured for modern ways of working. Coverage also includes Query Store, installation on Linux, and the use of containerized SQL. Pro SQL Server 2022 Administration takes DBAs on a journey that begins with planning their SQL Server deployment and runs through installing and configuring the instance, administering and optimizing database objects, and ensuring that data iTable of ContentsPart I: Installation and Configuration1. Planning the Deployment2. GUI Installation3. Server Core Installation4. Installation on Heterogeneous Operating Systems5. Configuring the InstancePart II: Database Administration6. Database Configuration7. Table Optimizations8. Indexes and Statistics9. Database ConsistencyPart III: Security, Resilience, and Scaling Workloads10. SQL Server Security Model11. Auditing & Ledger12. Encryption13. Backups and Restores14. High Availability and Disaster Recovery Concepts15. Implementing AlwaysOn Availability Groups16. Implementing Log Shipping17. Scaling WorkloadsPart IV: Performance and Maintenance18. SQL Server Metadata19. Locking and Blocking20. Extended Events21. Monitoring & Managing a Hybrid Environment22. Query Store23. Automating Maintenance Routines24. Policy-Based Management25. Resource Governor

Read more less

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

Read more less

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

Read more less

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

Read more less

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

Read more less

Book SynopsisUse this book to study for the PL-300 Microsoft Power BI Data Analyst exam. The book follows the Skills Measured outline provided by Microsoft to help focus your study. Each topic area from the outline corresponds to an area covered by the exam, and the book helps you build a good base of knowledge in each area. Each topic is presented with a blend of practical explanations, theory, and best practices. Power BI is more than just the Power BI Desktop or the Power BI Service. It is two distinct applications and an online service that, together, enable business users to gather, shape, and analyze data to generate and present insights. This book clearly delineates the purpose of each component and explains the key concepts necessary to use each component effectively. Each chapter provides best practices and tips to help an inexperienced Power BI practitioner develop good habits that will support larger or more complex analyses.Manybusiness analysts come to Power BI with a wealth of experience in Excel and particularly with pivot tables. Some of this experience translates readily into Power BI concepts. This book leverages that overlap in skill sets to help seasoned Excel users overcome the initial learning curve in Power BI, but no prior knowledge of any kind is assumed, terminology is defined in non-technical language, and key concepts are explained using analogies and ideas from experiences common to any reader. After reading this book, you will have the background and capability to learn the skills and concepts necessary both to pass the PL-300 exam and become a confident Power BI practitioner.What You Will LearnCreate user-friendly, responsive reports with drill-throughs, bookmarks, and tool tipsConstruct a star schema with relationships, ensuring that your analysis will be both accurate and responsivePublish reports and datasets to the Power BI Service, enabling the report (and the dataset) to be viewed and used by your colleaguesExtract data from a variety of sources, enabling you to leverage the data that your organization has collected and stored in a variety of sourcesSchedule data refreshes for published datasets so your reports and dashboards stay up to dateDevelop dashboards with visuals from different reports and streaming contentWho This Book Is ForPower BI users who are planning to take the PL-300 exam, Power BI users who want help studying the topic areas listed in Microsoft's outline for the PL-300 exam, and those who are not planning to take the exam but want to close any knowledge gaps they might haveTable of Contents​Part I. Prepare to Study1. Exam Overview2. PL-300 CoveragePart II. Prepare the Data3. Get Data from Different Data Sources4. Clean, Transform, and Load the DataPart III. Model the Data5. Design a Data Model6. Develop a Data Model7. Create Model Calculations using DAX8. Optimize Model PerformancePart IV. Visualize and Analyze the Data9. Create Reports10. Enhance Reports11. Identify Patterns and TrendsPart V. Deploy and Maintain Assets12. Manage Files and Datasets13. Create Dashboards14. Manage WorkspacesPart VI. Continue Your Learning15. Where Do You Go From Here?

Read more less

Book SynopsisPrepare for the Azure AI Fundamentals certification examination. This book covers the basics of implementing various Azure AI services in your business. The book not only helps you get ready for the AI-900 exam, but also helps you get started in the artificial intelligence (AI) world. The book starts with a short overview of the AI-900 exam and takes you through the exam prerequisites and the structure of the exam. You will then learn basic and advanced AI in Azure. Principles of responsible AI, Azure Machine Learning (ML), Azure Cognitive Services, and Bot Services are covered, followed by a practice test. You will go through ML fundamental concepts, model training, and validation along with case studies and a practice test for better preparation. The book includes the fundamentals of Azure and computer vision cognitive services. Various vision services and face services are demonstrated as well as analyzing image and text using OCR. You will unTable of ContentsChapter 1: AI-900 Overview of Exam Preparation Chapter Goal:The chapter introduces the exam to the learners. The exam object- ives are made clear to the readers. Readers gain understanding about exam modules, module weightage, and how much to expect from each module throughout the examination. Links to pertinent resources on Microsoft Learn would be provided for the readers' benefit. No of pages: 2 Subtopics 1. Exam Overview 2. Who is this exam for – Exam prerequisite 3. Modules and weightage in exam 4. Module Description Chapter 2: Fundamentals of Artificial Intelligence Chapter Goal: The chapter's objective is to introduce some foundational, high-level elements. These concepts would be explored in depth over the next chapters of the books. No of pages: 15 Sub - Topics 1. What is Artificial Intelligence? 2. Understanding Artificial Intelligence workloads 3. Principles of Responsible AI 4. Understanding Artificial Intelligence in Microsoft Azure 5. AI Services in Microsoft Azure 1. Azure Machine Learning 2. Azure Cognitive Service 3. Azure Bot Service 4. Azure Cognitive Search 6. Module Review 7. Introspective Practice 8. Solutions to the practice test 9. References: Microsoft Learn Chapter 3: Machine Learning Fundamental Concepts Chapter Goal: This chapter make reader familiar to the Machine Learning fundamentals introducing Machine Learning, Types of Machine Learning, Model training and validation. Here readers will also get to know about various tools used for Machine Learning. No of pages: 30 Sub - Topics: 1. What is Machine Learning? 2. Describing Core Machine Learning Concepts 1. Dataset, Features and Labels 2. Machine Learning Algorithms in brief 3. Machine Learning Workflow 4. Model Evaluation Metrics 3. Types of Machine Learning 1. Regression 2. Classification 3. Clustering 3. The two importance elements: Model Training and Validation 4. Introducing Azure Machine Learning 5. Tools for Azure Machine Learning 1 Azure Machine Learning Studio 2 Azure Machine Learning Designer 6 What is Automated Machine Learning? 7. Practical Labs: Using Azure Machine Learning Designer to build a regression model Using Azure Machine Learning Designer, create a classification model Using Azure Machine Learning Designer to build a clustering model 8. Module Review 9. Introspective Practice 10. Solutions to the practice test 11. References: Microsoft Learn Chapter 4: Computer Vision Chapter Goal: The chapter introduces readers to the fundamentals of Azure Cognitive Services in brief, as well as in depth knowledge of Computer Vision Cognitive Service. No of pages: 50 Sub - Topics: 1. Getting Started with Azure Cognitive Service Benefits of Cognitive Service Azure Cognitive Service: Speech Language Vision Decision Open AI Service 2. What is Computer Vision? 3. Computer Vision Core Elements: Image Classification and Object Detection 3. Computer Vision Application 4. Exploring Various Vision Service 1. Computer Vision 2. Custom Vision 3. Face 4. Form Recognizer 5. Understanding of OCR 6. Practical Labs: 1. Analysing image with Computer Vision 2. Training Models with Custom Vision 3. Using Face Service to analyse faces 4. Analysing text with Computer Vision Service using OCR 7. Introspective Practice Test 8. Solutions to the practice test 9. References: Microsoft Learn Chapter 5: Fundamentals of Natural Language Processing Chapter Goal: This chapter introduces readers with the responsibilities of Natural Language processing such as text analysis, language modelling, entity recognition, sentiment analysis, speech recognition and synthesis and how to leverage Microsoft Azure for NLP. No. of Pages: 50 1. Getting Started with Natural Language Processing 1. What is Natural Language Processing? 2. Core NLP Responsibilities 1. Text analysis and entity recognition 2. Sentiment analysis 3. Speech recognition and synthesis 4. Machine Translation 5. Semantic Language modelling 2. AI for Conversational Interactions 3. Microsoft Azure for NLP 1. Core Azure NLP workloads: Language, Speech and Translator 2. Language: 1. Language Detection 2. Key phrase extraction 3. Entity Detection 4. Sentiment Analysis 5. Question Answering 6. Conversational Language Understanding 3. Speech: 1. Text to speech 2. Speech to text 3. Speech translation 4. Translator 1. Text Translation 2. Microsoft Azure platform for Conversational AI 1. Azure Bot Service 3. Practical Labs: 1. Text analysis with text-analysis-service 2. Using the Speech service's speech-to-text capabilities to transcribe audible speech to text. 3. Using the Speech service's text-to-speech capabilities to generate audible speech from text. 4. Using translator service to convert text 5. Language Understanding Application Development 6. Developing a Q&A generator with Azure Bot Service 7. Provisioning chat bot using Microsoft Azure Bot Service 4. Introspective Test 5. Solutions to the Practice Test 6. References: Microsoft Learn

Read more less

Book SynopsisTake a deep dive into the Azure SQL Database Hyperscale Service Tier and discover a new form of cloud architecture from Microsoft that supports massive databases. The new horizontally scalable architecture, formerly code-named Socrates, allows you to decouple compute nodes from storage layers. This radically different approach dramatically increases the scalability of the service. This book shows you how to leverage Hyperscale to provide next-level scalability, high throughput, and fast performance from large databases in your environment. The book begins by showing how Hyperscale helps you eliminate many of the problems of traditional high-availability and disaster recovery architecture. You''ll learn how Hyperscale overcomes storage capacity limitations and issues with scale-up times and costs. With Hyperscale, your costs do not increase linearly with database size and you can manage more data than ever at a lower cost. The book teaches you how tTable of ContentsIntroductionPart I. Architecture.1. The Journey to Hyperscale Architecture in Azure SQL2. Azure SQL Hyperscale Architecture: Concepts and FoundationsPart II. Planning and Deployment3. Planning an Azure SQL DB Hyperscale Environment 4. Deploying a Highly Available Hyperscale Database into a Virtual Network 5. Administering a Hyperscale Database in a Virtual Network in the Azure Portal6. Configuring Transparent Data Encryption to Bring Your Own Key7. Enabling Geo-replication for Disaster Recovery8. Configuring Security Features and Enabling Diagnostic and Audit Logs9. Deploying Azure SQL DB Hyperscale using PowerShell10. Deploying Azure SQL DB Hyperscale using Bash and Azure CLI11. Deploying Azure SQL DB Hyperscale using Azure Bicep12. Testing Hyperscale Database Performance Against Other Azure SQL Deployment OptionsPart III. Operation and Management13. Monitoring and Scaling 14. Backup, Restore and Disaster Recovery15. Security and Updating16. Managing CostsPart IV. Migration17. Determining whether Hyperscale is Appropriate 18. Migrating to Hyperscale19. Reverse Migrating Away from HyperscaleConclusion

Read more less

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

Read more less

Book SynopsisImprove your odds of passing one of the most highly sought-after exams for developers working with Microsoft''s cloud platform: Exam AZ-204: Developing Solutions for Microsoft Azure. This book guides you through practical examples of each of the technologies covered by the exam while exposing you to the settings and interactions between platform solutions that you will need to be in command of to prepare for the exam and to use on your job in Azure development. Chapters in this book correspond directly to the exam skills outline and are delivered in a from-the-ground-up approach, allowing you to build your knowledge as you go. This approach serves to help even novice developers get up to speed quickly, while allowing more experienced developers to find the exact topics and scenarios they need to hone their skill sets as they both prepare for the exam and reference information for real-world solutions. As you work through each chapTable of ContentsIntroductionPart I. Develop for Azure1. Develop Solutions that Use Blob Storage2. Develop Solutions that Use Cosmos DB StoragePart II. Develop Azure Compute Solutions3. Implement IaaS Solutions4. Create Azure App Service Web Apps5. Azure Container Ecosystem6. Implement Azure FunctionsPart III. Implement Azure Security7. Implement User Authentication and Authorization8. Implement Secure Cloud SolutionsPart IV. Monitor, Troubleshoot, and Optimize Azure Solutions9. Implement Caching for Solutions10. Troubleshoot Solutions by Using Metrics and Log Data Part V. Connect to and Consume Azure Services and Third-Party Services11. Implement API Management12. Develop Event-Based Solutions13. Develop Message-Based Solutions

Read more less

Book SynopsisLearn the basics of writing SQL scripts. Using Standard SQL as the starting point, this book teaches writing SQL in various popular dialects, including PostgreSQL, MySQL/MariaDB, Microsoft SQL Server, Oracle, and SQLite. The book starts with a general introduction to writing SQL and covers the basic concepts. Author Mark Simon then covers database principles, and how database tables are designed. He teaches you how to filter data using the WHERE clause, and you will work with NULL, numbers, dates, and strings. You will also understand sorting results using the ORDER BY clause, sorting by calculated columns, and limiting the number of results. By the end of the book, you will know how to insert and update data, and summarize data with aggregate functions and groups. Three appendices cover differences between SQL dialects, working with tables, and a crash course in PDO. What You Will LearnFilter, sort, andcalculate dataSummarize data with aggregate functionsModify data with insert, uTable of ContentsThe appendix will include: Notes on using SQL with PHP “Cultural Notes” - a description of some of the sample data Major Differences between DBMSs Setting up the Sample Database

Read more less

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

Read more less

Book SynopsisThis book provides detailed guidance around architecting and deploying Power BI reporting solutions, including help and best practices for sharing and security. You''ll find chapters on dataflows, shared datasets, composite model and DirectQuery connections to Power BI datasets, deployment pipelines, XMLA endpoints, and many other important features related to the overall Power BI architecture that are new since the first edition. You will gain an understanding of what functionality each of the Power BI components provide (such as Dataflow, Shared Dataset, Datamart, thin reports, and paginated reports), so that you can make an informed decision about what components to use in your solution. You will get to know the pros and cons of each component, and how they all work together within the larger Power BI architecture.Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and bTable of ContentsIntroductionPart I. Getting Started1. Power BI Ecosystem and Components2. Tools and PreparationPart II. Development3. Import Data or Schedule Refresh4. DirectQuery 5. Live Connection6. Composite Mode7. Choosing the Right Connection Type8. Dataflows9. Shared Datasets10. Multi-Developer Architecture11. Hybrid Architecture using other Microsoft Services12. DirectQuery to Power BI Dataset13. Dataflow Development Architecture14. Analyze in Excel15. Development Tools16. Power BI Helper for Developers17. Dataset Types18. Realtime Power BI Solution19. Paginated Reports20. Power BI Templates21. Power BI Desktop Development Templates22. Incremental Refresh23. Big Data Considerations, Hybrid Tables, and PerformancePart III. Deployment24. Power BI Service Content25. Power BI Report Server26. Gateway27. Power BI Licensing Guide28. Power BI Premium29. Premium Per User30. Premium Settings and Configuration31. Tenant Settings32. Administrator Reports and Metrics33. Workspace Structure and Architecture34. Workspace Rules35. Deployment Pipeines36. REST API for Deployment and Architecture37. Power BI Helper for Deployment and Administration38. XMLA EndpointPart IV. Sharing and Security39. Governance40. Dashboard and Report Sharing41. Workspaces as Collaborative Environments42. Power BI Apps43. Embed Code and Publish to Web44. Embed in SharePoint Online45. Microsoft Teams Integration46. Power BI Embedded47. SharePoint Online Integration48. Microsoft Office49. Comparing Power BI Sharing Methods50. Usage Metrics Reports51. Usage Metrics using REST API52. Usage Metrics using Power BI Helper53. Row Level Security54. Dynamic Row Level Security55. Object-Level Security

Read more less

Book SynopsisThis book will help prepare you for the Microsoft DP-420 exam. Whether you are new to Azure Cosmos DB or have experience working with the platform, Designing and Implementing Cloud-Native Applications Using Microsoft Azure Cosmos DB is organized to address the specific skills measured in the DP-420 exam. The topics covered include NoSQL models, code, and real-world scenarios aimed at helping you to understand and solve the case studies included in the exam.Beyond the exam, this book will assist you in your journey to adopt Microsoft Azure Cosmos DB for your own projects. You'll learn what makes Azure Cosmos DB such a robust NoSQL service, as well as how NoSQL approaches help enable modern applications. You'll also get practical guidance for your own implementations. The topics covered in this book are essential to knowing how to leverage the Cosmos DB service and provide best practices that will guide you to success both on the exam and in your career. What You Will LearnUnderstand aTable of Contents1. Scheduling and Taking the DP-420 Exam2. Design and Implement a Non-Relational Data Model3. Design a Data Partitioning Strategy4. Plan and implement Sizing and Scaling5. Implement Client Connectivity Options 6. Implement Data Access with Cosmos DB SQL 7. Implement Data Access with SQL API SDKs8. Implement Server-Side Programming9. Design and Implement a Replication Strategy 10. Design and Implement Multi-Region Write11. Enable Analytical Workloads 12. Implement Solutions Across Services13. Optimize Query Performance 14. Design and Implement Change Feeds 15. Define and Implement an Indexing Strategy 16. Monitor and Troubleshoot17. Implement Backup and Restore 18. Implement Security19. Implement Data Movement 20. Implement a DevOps Process

Read more less

Book SynopsisBeginning-Intermediate user levelTable of ContentsChapter 1: Getting Started with Azure Security o Introduction to Cloud Security o Best practices for securing enterprise cloud o Create an overall security design baseline o Define Security Operations Strategy o Overview of NIST Cybersecurity framework Chapter 2: Design and deploy security for infrastructure, data and apps o Design and deploy a strategy for securing server and client endpoints \ o Design and deploy a strategy for securing SaaS, PaaS, and IaaS services o Design and deploy security for data across Azure enterprise environment o Design and deploy security for application across Azure enterprise environment Chapter 3: Design and deploy Identify solution. o Introduction to Azure identify security services o Design and deploy Azure information protection o Design and deploy Azure network watcher o Design and deploy Azure Policy Chapter 4: Design and deploy Identify solution. o Design and deploy Azure Automation o Design and deploy Azure IoT Hub o Design and deploy Microsoft Intune o Design and deploy Service Map o Enable Security Center Chapter 5: Design and deploy detect solution. o Design and deploy Azure Intelligent Security Graph o Design and deploy Azure monitor o Design and deploy Azure Sentinel Chapter 6: Design and deploy protect solution o Design and deploy Azure Application gateway o Design and deploy Azure Firewall o Design and deploy Azure WAF Chapter 7: Design and deploy protect solution. o Design and deploy Azure AD and AD Identity protection o Design and deploy Azure DDoS o Design and deploy Azure NSG Chapter 8: Design and deploy protect solution. o Design and deploy Azure NSG o Design and deploy Azure Bastion o Design and deploy Azure Encryption Chapter 9: Design and deploy respond solution o Design and deploy Azure Logic Apps o Design and deploy Azure Encryption o Define your security team Chapter 10: Design and deploy recover solution o Design and deploy Azure Backup o Design and deploy Site recovery

Read more less

Book SynopsisIntermediate-Advanced user levelTable of ContentsChapter 1: Getting Ready.- Chapter 2: Working with Table Design.- Chapter 3: Table Relationships and Working With Joins.- Chapter 4: Working with Calculated Data.- Chapter 5: Aggregating Data.- Chapter 6: Creating and Using Views and Friends.- Chapter 7: Working With Subqueries and Common Table Expressions.- Chapter 8: Working With Window Functions.-Chapter 9: More on Common Table Expressions.- Chapter 10: More Techniques with SQL: Triggers, Pivot Tables, and Variables.- Appendix A.

Read more less

Book SynopsisIntermediate-Advanced user levelTable of Contents

Read more less

Book SynopsisUnderstand the basics of flow and learn how to implement guidelines in real-life scenarios, including Robotic Process Automation (RPA) capabilities. This book covers the evolution of flow and how it is transformed to a full-fledged RPA (such as Power Automate). The book starts with an introduction to flow and its transformation to Process Automation. You will learn how to create a Power Automate environment and demonstrate different types of flows within it. Author Goloknath Mishra takes you through various types of cloud flows and their best practices. Desktop Flows (RPA) or Power Automate Desktop (PAD) is discussed and the author teaches you its architecture, installation steps, and how to manage, schedule, and share a desktop. You will learn about Business Process Flow, Process Advisors, and AI Builder. You also will go through licensing considerations in Power Automate and AI Builder, and demonstrate all of your learnings through a mini project. After reading thebook, you will Table of Contents

Read more less

Book SynopsisThis book is an exhaustive guide to designing and implementing data solutions on Azure. It covers the process of managing data from end to end, starting from data collection all the way through transformation, distribution, and consumption. Modern Data Architecture on Azure begins with an introduction to the fundaments of data management, followed by a demonstration of how to build relational and non-relational data solutions on Azure. Here, you will learn data processing for complex analysis and how to work with CSV and JSON files. Moving forward, you will learn the foundational concepts of big data architecture, along with data management patterns and technology options offered by Azure. From there, you'll be walked through the data architecture process, including data consortium on Azure, enterprise data governance, and much more. The book culminates with a deep dive into data architecture frameworks with data modeling. After reading this book, you will have a thorough understanTable of ContentsChapter 1: Introduction: Fundamentals of Data Management.- Chapter 2: Build Relational & Non-Relational Data Solutions on Azure.- Chapter 3: Building a Big Data Architecture.- Chapter 4: Data Management Patterns & Technology Choices with Azure.- Chapter 5: Data Architecture Process.- Chapter 6: Data Architecture Framework Explained.

Read more less

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

Read more less

Book SynopsisMaster the skills needed to deploy container services on Microsoft Azure using Terraform. This book will take you through the entire process of designing, deploying, and managing container services such as Azure Kubernetes Service (AKS), Azure Container Instances (ACI), Azure Container Registry (ACR), and Azure Web App for Containers. In this fully updated second edition, Author Shimon Ifrah demonstrates how to use Terraform, PowerShell and Azure CLI to provision and manage container services in Azure. As you'll be using Terraform as the main tool for deployment, a basic knowledge of Terraform is a prerequisite.In addition, you will see how Azure DevOps services can be used to deploy infrastructure and container services with Terraform using Azure Pipelines without using the Azure Portal. The book concludes with a tutorial on how to use Azure Defender for Cloud to safeguard Terraform and infrastructure-as-code against malicious threats, so you can deliver secure applications.Upon comTable of Contents

Read more less

Book SynopsisRapidly implement Internet of Things solutions Creating programs for the Internet of Things offers you an opportunity to build and program custom devices whose functionality is limited only by your imagination. This book teaches you to do exactly that, with solutions presented in a step-by-step format. When you read this book, you not only learn the fundamentals of device programming, you will also be ready to write code for revolutionizing devices and robots. You don’t need to be an expert in low-level programming to benefit from this book. It explains basic concepts and programming techniques before diving into the more complicated topics. Each of the book’s chapters and appendices contains a suitable level of detail to help you quickly master device programming. MCP Dawid Borycki shows you how to: Build Universal Windows Platform (UWP) applications that target interconnected embedded devices Design and implement background apps for seamless integration with hardware components Use intrinsic UWP functionality to detect and track human faces Build artificial auditory, visual, and learning systems Process audio signals to blink LEDs to the rhythm of music Use OpenCV to develop custom image-processing algorithms Communicate with external devices by using serial, USB, Wi-Fi, and AllJoyn connectivity Design and implement applications to control DC, stepper, and servo motors for robotics Use Microsoft Cognitive Services to detect human emotions Build predictive analysis and preventive maintenance systems by using the Azure IoT Suite Table of ContentsPART I ESSENTIALS Chapter 1 Embedded devices programming Chapter 2 Universal Windows Platform on devices Chapter 3 Windows IoT programming essentials Chapter 4 User interface design for headed devices PART II DEVICE PROGRAMMING Chapter 5 Reading data from sensors Chapter 6 Input and output Chapter 7 Audio processing Chapter 8 Image processing Chapter 9 Connecting devices Chapter 10 Motors Chapter 11 Device learning PART III AZURE IOT SUITE Chapter 12 Remote device monitoring Chapter 13 Predictive maintenance Chapter 14 Custom solution Appendix A Code examples for controlling LED using Visual Basic and JavaScript Appendix B Raspberry Pi 2 HDMI modes Appendix C Bits, bytes, and data types Appendix D Class library for Sense HAT sensors Appendix E Visual C++ component extensions Appendix F Setting up Visual Studio 2017 for IoT development

Read more less

Book SynopsisThe Comprehensive, Expert Guide to C# Language Programming “This book has been a classic for years, and remains one of the most venerable and trusted titles in the world of C# content, and probably far beyond! . . . Mark is super smart, insists on understanding everything to the core, and has phenomenal insight into how things affect real developers. . . . He goes right to the essence and communicates with great integrity—no sugarcoating—and has a keen eye for practical value and real-world problems.” –Mads Torgersen, C# Program Manager, Microsoft Essential C# 7.0 is a well-organized, no-fluff guide to C# 7.0 for programmers at all levels of experience. Reflecting the most important C# features from 3.0 through 7.0 and including modern programming patterns, it will help you write code that’s simple, powerful, robust, secure, and maintainable. Author Mark Michaelis is a world-class C# expert: a long-time Microsoft MVP and Regional Director who also has served on Microsoft’s C# design review team. He presents a comprehensive tutorial and reference for the entire language, including expert coverage of key C# 7.0 enhancements, C# 7.0’s use with .NET Core/.NET Standard, and cross-platform compilation. He illustrates key C# constructs with succinct examples, and presents best-practice coding guidelines. To help you maintain existing code, separate indexes provide version-specific answers for C# 5.0, 6.0, and 7.0, and visual icons show when each language innovation was introduced. Make the most of C# 7.0 enhancements, including tuples, deconstructors, pattern matching, local functions, and ref returns Work efficiently with C# data types, operators, control flow, methods, and parameters Write more robust code with C# object-oriented constructs Implement reliable, effective exception handling Reduce code complexity with generics, delegates, lambda expressions, and events Leverage advanced dynamic and declarative programming techniques Query diverse data collections using LINQ with query expressions Create custom collections that operate against business objects Access .NET collections via collection interfaces and standard query operators Master multithreading and synchronization, including the async/await paradigm Optimize performance and interoperability with P/Invoke and unsafe code Run your code on Linux or macOS with C# 7.0 cross-platform compilation Includes C# 7.1, 7.2, and 7.3 language enhancements This guide offers you a complete foundation for successful development with modern versions of the C# language in any project or environment.Table of ContentsFigures xv Tables xvii Foreword xix Preface xxi Acknowledgments xxxiii About the Author xxxv Chapter 1: Introducing C# 1 Hello, World 2 C# Syntax Fundamentals 11 Working with Variables 20 Console Input and Output 24 Managed Execution and the Common Language Infrastructure 32 Multiple .NET Frameworks 37 Chapter 2: Data Types 43 Fundamental Numeric Types 44 More Fundamental Types 53 null and void 67 Conversions between Data Types 69 Chapter 3: More with Data Types 77 Categories of Types 77 Nullable Modifier 80 Tuples 83 Arrays 90 Chapter 4: Operators and Control Flow 109 Operators 110 Introducing Flow Control 126 Code Blocks ({}) 132 Code Blocks, Scopes, and Declaration Spaces 135 Boolean Expressions 137 Bitwise Operators (<<, >>, |, &, ^, ~) 147 Control Flow Statements, Continued 153 Jump Statements 165 C# Preprocessor Directives 171 Chapter 5: Methods and Parameters 181 Calling a Method 182 Declaring a Method 189 The using Directive 195 Returns and Parameters on Main() 200 Advanced Method Parameters 203 Recursion 215 Method Overloading 217 Optional Parameters 220 Basic Error Handling with Exceptions 225 Chapter 6: Classes 241 Declaring and Instantiating a Class 245 Instance Fields 249 Instance Methods 251 Using the this Keyword 252 Access Modifiers 259 Properties 261 Constructors 278 Static Members 289 Extension Methods 299 Encapsulating the Data 301 Nested Classes 304 Partial Classes 307 Chapter 7: Inheritance 313 Derivation 314 Overriding the Base Class 326 Abstract Classes 338 All Classes Derive from System.Object 344 Verifying the Underlying Type with the is Operator 345 Pattern Matching with the is Operator 346 Pattern Matching within a switch Statement 347 Conversion Using the as Operator 349 Chapter 8: Interfaces 353 Introducing Interfaces 354 Polymorphism through Interfaces 355 Interface Implementation 360 Converting between the Implementing Class and Its Interfaces 366 Interface Inheritance 366 Multiple Interface Inheritance 369 Extension Methods on Interfaces 369 Implementing Multiple Inheritance via Interfaces 371 Versioning 374 Interfaces Compared with Classes 375 Interfaces Compared with Attributes 377 Chapter 9: Value Types 379 Structs 383 Boxing 390 Enums 398 Chapter 10: Well-Formed Types 411 Overriding object Members 411 Operator Overloading 424 Referencing Other Assemblies 432 Defining Namespaces 442 XML Comments 445 Garbage Collection 449 Resource Cleanup 452 Lazy Initialization 461 Chapter 11: Exception Handling 465 Multiple Exception Types 465 Catching Exceptions 469 General Catch Block 473 Guidelines for Exception Handling 475 Defining Custom Exceptions 479 Rethrowing a Wrapped Exception 483 Chapter 12: Generics 487 C# without Generics 488 Introducing Generic Types 493 Constraints 506 Generic Methods 519 Covariance and Contravariance 524 Generic Internals 531 Chapter 13: Delegates and Lambda Expressions 537 Introducing Delegates 538 Declaring Delegate Types 542 Lambda Expressions 550 Anonymous Methods 556 Chapter 14: Events 575 Coding the Publish-Subscribe Pattern with Multicast Delegates 576 Understanding Events 591 Chapter 15: Collection Interfaces with Standard Query Operators 603 Collection Initializers 604 What Makes a Class a Collection: IEnumerable 607 Standard Query Operators 613 Anonymous Types with LINQ 646 Chapter 16: LINQ with Query Expressions 657 Introducing Query Expressions 658 Query Expressions Are Just Method Invocations 676 Chapter 17: Building Custom Collections 679 More Collection Interfaces 680 Primary Collection Classes 683 Providing an Indexer 702 Returning Null or an Empty Collection 705 Iterators 705 Chapter 18: Reflection, Attributes, and Dynamic Programming 721 Reflection 722 nameof Operator 733 Attributes 735 Programming with Dynamic Objects 759 Chapter 19: Multithreading 771 Multithreading Basics 774 Working with System.Threading 781 Asynchronous Tasks 789 Canceling a Task 810 The Task-based Asynchronous Pattern 816 Executing Loop Iterations in Parallel 846 Running LINQ Queries in Parallel 856 Chapter 20: Thread Synchronization 863 Why Synchronization? 864 Timers 893 Chapter 21: Platform Interoperability and Unsafe Code 897 Platform Invoke 898 Pointers and Addresses 910 Executing Unsafe Code via a Delegate 920 Chapter 22: The Common Language Infrastructure 923 Defining the Common Language Infrastructure 924 CLI Implementations 925 .NET Standard 928 Base Class Library 929 C# Compilation to Machine Code 929 Runtime 932 Assemblies, Manifests, and Modules 936 Common Intermediate Language 939 Common Type System 939 Common Language Specification 940 Metadata 941 .NET Native and Ahead of Time Compilation 942 Index 945 Index of 7.0 Topics 995 Index of 6.0 Topics 998 Index of 5.0 Topics 1001

Read more less

Book SynopsisBarnaby describes how to use the new .NET technologies to build fast, scalable, and robust distributed applications.Table of ContentsA table of contents is not available for this title.

Read more less

Book SynopsisThe author shows developers with litte or no ADO.NET background how to apply ADO.NET fast to real world scenarios by giving examples and code that really works.Table of ContentsA table of contents is not available for this title.

Read more less

Book Synopsis* Coverage of all three significant .NET code generation mechanisms: Manual code generation, XSL/XML and CodeDom. * Includes a database metadata extraction tool based on SQL-92 standards. * Real solutions to the problem of protecting handcrafted code across regeneration. * Covers code generation in the broader picture of how applications are developed. * Includes real world samples for a complete middle tier and simple User Interface. Table of ContentsA table of contents is not available for this title.

Read more less

Book SynopsisThe Software Factory methodology is based on recognition of these similarities and a drive to extend the concept of "reusability" to the point where we achieve entirely automated product lines. Based on an analysis and understanding of the common features and techniques of a set of applications, a Software Factory defines a tailored, end-to-end methodology for building these applications. At the heart of the Software factory methodology is the concept of Domain Specific Languages (DSLs), which in essence are development environments specifically tailored to the set of applications in hand. It removes a certain degree of flexibility but greatly enhances productivity by removing a lot of the coding complexity (for an analogy, consider the use of the now ubiquitous drag-and-drop controls in Winforms or Visual Basic). Further, in the SF methodology, patterns, process advice, and best practices can be harvested and applied for all applications in the set. There are some good books on the theory of SF already on the market. Up until this point, a lot of these concepts were fairly theoretical and abstract.Trade ReviewFrom the reviews: "The purpose of this work is to introduce and demystify the concept of software factories in the .NET environment. … The book covers both the theory and practice of software factories, including an acknowledgment of the genesis of the term in the late 1960s. … this book is recommended reading for people involved in the management of large software development groups, particularly ones that develop many similar products. It provides a good theoretical discussion, and practical illustration … in the creation of software solutions." (Neil D. Burgess, ACM Computing Reviews, Vol. 49 (3), March, 2008)Table of ContentsA table of contents is not available for this title.

Read more less

Book SynopsisThis book provides a complete A-to-Z reference for using VB with the .NET 2.0 platform and the .NET 3.0 extensions. It contains new chapters that explore the interactions between the existing framework and the new extensions, offering readers an edge when they evaluate and implement .NET 3.0 for the first time. To provide even more support, the book comes with a bonus CD that provides over 500 pages of carefully selected additional content to help broaden a reader's understanding of both .NET 2.0 and .NET 3.0.Table of ContentsIntroducing Visual Basic 2008 and the .NET Platform.- The Philosophy of .NET.- Building Visual Basic 2008 Applications.- Core VB Programming Constructs.- VB 2008 Programming Constructs, Part I.- VB 2008 Programming Constructs, Part II.- Designing Encapsulated Class Types.- Understanding Inheritance and Polymorphism.- Understanding Structured Exception Handling.- Understanding Object Lifetime.- Advanced VB Programming Constructs.- Working with Interface Types.- Collections, Generics, and Nullable Data Types.- Delegates, Events, and Lambdas.- Operator Overloading and Custom Conversion Routines.- VB 2008-Specific Language Features.- An Introduction to LINQ.- Programming with .NET Assemblies.- Introducing .NET Assemblies.- Type Reflection, Late Binding, and Attribute-Based Programming.- Processes, AppDomains, and Object Contexts.- Building Multithreaded Applications.- .NET Interoperability Assemblies.- Introducing the .NET Base Class Libraries.- File and Directory Manipulation.- Introducing Object Serialization.- ADO.NET Part I: The Connected Layer.- ADO.NET Part II: The Disconnected Layer.- Programming with the LINQ APIs.- Introducing Windows Communication Foundation.- Introducing Windows Workflow Foundation.- Desktop Applications with Windows Forms.- Introducing Windows Forms.- Rendering Graphical Data with GDI+.- Programming with Windows Forms Controls.- Desktop Applications with WPF.- Introducing Windows Presentation Foundation and XAML.- Programming with WPF Controls.- WPF 2D Graphical Rendering, Resources, and Themes.- Building Web Applications with ASP.NET.- Building ASP.NET Web Pages.- ASP.NET Web Controls, Themes, and Master Pages.- ASP.NET State Management Techniques.

Read more less

Book SynopsisWritten by a member of Microsoft’s Power BI team, this resource provides a practical step by step guide on creating a financial dashboard. The book covers in detail how to combine and shape the relevant data, build the dashboard in Power BI, providing layout and design tips and tricks, prepare the model to work with fiscal dates, and show values used in many financial reports, including year-to-date, variance-to-target, percentage-of-total, and running totals reports.

Read more less

Book Synopsis 　 DESCRIPTION Most businesses rely on a complex patchwork of client computers, physical and virtual servers, middleware, and, increasingly, mobile devices and cloud services. Microsoft System Center Configuration Manager (SCCM) sits smack in the middle of this tapestry, providing a single administrative control center to deploy and manage Windows servers and applications across your entire infrastructure, including cross-platform management of Mac OS X, Linux, and UNIX. Learn SCCM in a Month of Lunches is a super-practical guide to Microsoft System Center Configuration Manager. This book cuts to the chase and gets readers up to speed with the day-to-day tasks of managing a system with SCCM in a matter of days. Whether readers have just been pressed into service as new sysadmin or are familiar with the inner workings of Active Directory and App-V, they’ll be productive immediately as they work through the 25 self-contained lessons in this handy tutorial. 　 RETAIL SELLING POINTS Covers all aspects of SCCM administration Discusses brand-new SCCM management concepts Shows how to deploy applications from the cloud AUDIENCE Readers need no prior experience with System Center Configuration Manager. ABOUT THE TECHNOLOGY Configuration Manager is one of the flagship products in Microsoft’s System Center 2012 suite. It enables businesses to effectively deploy and manage Windows systems and applications across their entire environment.

Read more less

Book SynopsisThere's a big gap between running machine learning and data processes as prototypes, and deploying them to a production cloud environment. Data Engineering on Azure reveals the architectural, operational, and data management techniques that power cloud-based data infrastructure built on the Microsoft Azure platform. Data Engineering on Azure teaches you to build a scalable and robust data platform to industry-leading standards. All examples are based on the production big data platform that powers Microsoft's customer growth operations. You'll learn techniques and best practices that author Vlad Riscutia and his team use on a daily basis, including automation and DevOps, running a reliable machine learning pipeline, and managing your data inventory. Examples are illustrated with Azure. The patterns and techniques are transferable to other cloud platforms. About the TechnologyBuild secure, stable data platforms that can scale to loads of any size. When a project moves from the lab into production, you need confidence that it can stand up to real-world challenges. This book teaches you to design and implement cloud-based data infrastructure that you can easily monitor, scale, and modify. Trade Review"A definitive and complete guide on data engineering, with clear and easy-to-reproduce examples." Kelum Prabath Senanayake, Echoworx "An all-in-one Azure book, covering all a solutions architect or engineer needs to think about." Albert Nogués, Danone "A meaningful journey through the Azure ecosystem. You'll be building pipelines and joining components quickly!" Todd Cook, Appen "A gateway into the world of Azure for machine learning and DevOps engineers." Krzysztof Kamyczek, Luxoft

Read more less

Book SynopsisLearn the basics of using the micro: bit, an open source hardware ARM-based embedded system used to teach computer programming, to build a series of 10 different gadgets from scratch! You'll use the micro: bit to make: a scrolling name tag, animated LED displays a high-tech compass. a handheld tilting game with a buzzer and saved high score a carnival-like strength tester a powered cooling fan helmet an electronic musical instrument a security system that sends alerts to your computer when someone enters the room. a wheeled robot an alert to water your plants You will learn how simple electrical devices like speakers, motors, buzzers and fans work. You'll understand electronic components like resistors, force resistors, photoresistors, LEDs, and Op Amps, as well as Infrared distance sensors and soil moisture sensors. You'll also get a beginner's look at micropython, one of the fastest-growing computer languages. In this book you will combine multiple disciplines -- electronics, programming, and engineering -- to build a series of successful gadgets. Everything is explained with lots and lots of full-color line drawings. No prior experience is necessary. You'll have fun while you learn a t

Read more less

Book SynopsisDESCRIPTION SharePoint is Microsoft’s platform for building portals for managing and sharing content, such as documents, database information, and key business metrics. Web Parts are the core building blocks of all SharePoint applications. SharePoint 2010 Web Parts in Action teaches readers to use and customize SharePoint 2010’s default Web Parts and to build custom Web Parts. Numerous examples illustrate everything from design to development to deployment and more. The book is focused on the SharePoint 2010 release and highlights the new features and tools. KEY POINTS F • Web Parts are required for all SharePoint applications F • The only book to cover SharePoint 2010 Web Parts F • Numerous real-world examples

Read more less

Book SynopsisUm noch mehr aus Excel herauszuholen, sind Kenntnisse der VBA-Programmierung von großem Vorteil: Dann können Sie Excel auf Ihre Bedürfnisse zuschneiden und langweilige Routinearbeiten automatisieren. Dieses Buch zeigt Ihnen zunächst den Umgang mit dem VBA-Editor und gibt einen Einblick in die wichtigsten Programmiertechniken, wie Sie Fehler beseitigen, Range-Objekte einsetzen und den Programmfluss steuern. Lernen Sie dann die vielfältigen Programmiermöglichkeiten kennen. Alle Beispielprogramme und Arbeitsblätter stehen zum Download zur Verfügung. Sie werden staunen: Mit VBA können Sie sich selbst Dialogboxen, Werkzeugleisten und Menüs schneidern. Und das schon nach kurzer Zeit!Table of ContentsÜber den Autor 9 Einführung 25 Über dieses Buch 25 Konventionen in diesem Buch 26 Makrosicherheit 27 Törichte Annahmen über die Leser 28 Symbole, die in diesem Buch verwendet werden 29 Wie es weitergeht 29 Teil I: Excel VBA – die ersten Schritte 31 Kapitel 1 VBA kennenlernen 33 Die VBA-Grundlagen verstehen 33 Wissen, was mit VBA möglich ist 34 Text einfügen 35 Eine häufig ausgeführte Aufgabe automatisieren 35 Automatisierung wiederholter Operationen 35 Einen benutzerdefinierten Befehl anlegen 35 Eine benutzerdefinierte Schaltfläche erstellen 36 Neue Funktionen für die Arbeitsmappe entwickeln 36 Benutzerdefinierte Add-Ins für Excel erstellen 36 Das meiste aus VBA herausholen 36 Wissen, was VBA am besten kann 36 Erkennen, welche Nachteile die Verwendung von VBA mit sich bringt 37 VBA-Konzepte verstehen 38 Sicherstellen der Excel-Kompatibilität 40 Kapitel 2 Einfache Makros erstellen 41 Die Registerkarte »Entwicklertools« anzeigen 41 Ein Makro erstellen 42 Die Umgebung vorbereiten 42 Ein Makro aufzeichnen 43 Das Makro ausführen 45 Ein Makro im Visual Basic-Editor anzeigen 46 Das Makro abändern 48 Arbeitsmappen speichern, die Makros enthalten 49 Makro-Sicherheit verstehen 50 Teil II: Die Zusammenarbeit von VBA und Excel 53 Kapitel 3 Der Visual Basic-Editor 55 Den Visual Basic-Editor kennenlernen 55 Den VBE aktivieren 55 VBE-Komponenten erforschen 56 Arbeiten im Projekt-Explorer 58 Ein neues VBA-Modul hinzufügen 59 Arbeiten im Codebereich 60 Fenster minimieren und maximieren 60 Die Bestandteile eines Moduls erkunden 61 VBA-Code in ein Modul einfügen 61 Code direkt eingeben 62 Verwendung des Makro-Rekorders 65 VBA-Code kopieren 67 Anpassung des VBE 68 Die Registerkarte »Editor« 68 Die Registerkarte »Editorformat« 70 Die Registerkarte »Allgemein« 71 Die Registerkarte »Verankern« 72 Kapitel 4 Einführung in das Excel-Objektmodell 73 Arbeiten mit dem Excel-Objektmodell 73 Die Objekthierarchie verstehen 74 Auf Objekte verweisen 75 In Objekteigenschaften und Methoden eintauchen 78 Objekteigenschaften festlegen 80 Mit Objektmethoden Aktionen unternehmen 81 Objekte reagieren auf Ereignisse 83 VBA-Ressourcen zu weiterführenden Informationen 83 Das VBA-Hilfesystem verwenden 83 Den Objektkatalog verwenden 84 Automatische Auflistung von Eigenschaften und Methoden 85 Kapitel 5 Sub-und Funktionsprozeduren in VBA 87 Sub-Prozeduren im Vergleich zu Funktionsprozeduren 87 Einen Blick auf Sub-Prozeduren werfen 88 Einen Blick auf Funktionsprozeduren werfen 88 Namen für Sub-Prozeduren und Funktionsprozeduren 89 Sub-Prozeduren ausführen 90 Die Sub-Prozedur direkt ausführen 92 Die Prozedur vom Dialogfeld Makro aus ausführen 92 Ein Makro mithilfe einer Tastenkombination ausführen 93 Die Prozedur über eine Schaltfläche oder eine Form ausführen 94 Die Prozedur von einer anderen Prozedur aus ausführen 96 Die Prozedur vom Direktfenster aus ausführen 97 Funktionsprozeduren ausführen 97 Die Funktionsprozedur aus einer Sub-Prozedur aufrufen 98 Aufruf der Funktion im Direktfenster 98 Aufruf einer Funktion von einer Formel in einer Tabelle aus 99 Kapitel 6 Mit dem Makro-Rekorder arbeiten 103 Grundlagen der Aufzeichnung 103 Vorbereitung auf die Aufzeichnung 105 Zwischen relativem und absolutem Modus wählen 105 Aufzeichnung im absoluten Modus 106 Aufzeichnung im relativen Modus 107 Dem Makro-Rekorder bei der Arbeit zusehen 109 Aufzeichnungsoptionen für Ihr Makro angeben 110 Code aufräumen, den der Makro-Rekorder aufgezeichnet hat 112 Teil III: Programmierkonzepte 115 Kapitel 7 Wichtige Elemente der Sprache VBA 117 Kommentare in Ihrem VBA-Code 117 Variablen, Konstanten und Datentypen 119 Variablen verstehen 119 Was sind die Datentypen in VBA? 121 Variablen deklarieren und ihnen einen Gültigkeitsbereich zuweisen 122 Mit Konstanten arbeiten 127 Vorgefertigte Konstanten verwenden 128 Mit Zeichenfolgen arbeiten 129 Mit Datumswerten arbeiten 130 Zuweisungsbefehle verwenden 131 Beispiele für den Zuweisungsbefehl 131 Das Gleichheitszeichen 132 Hilfreiche Operatoren 132 Arrays 133 Arrays deklarieren 134 Mehrdimensionale Arrays 134 Dynamische Arrays 135 Die Verwendung von Zeilenmarken (Labels) 136 Kapitel 8 Mit Range-Objekten arbeiten 137 Auf »Range«-Objekte verweisen 137 Auf einen Bereich mithilfe von Eigenschaften verweisen 139 Die »Cells«-Eigenschaft 139 Die »Offset«-Eigenschaft 140 Die »Resize«-Eigenschaft 141 Mit Eigenschaften des »Range«-Objekts arbeiten 141 Die »Value«-Eigenschaft 142 Die »Text«-Eigenschaft 143 Die »Count«-Eigenschaft 143 Die »Column«-und die »Row«-Eigenschaft 143 Die »Address«-Eigenschaft 144 Die »HasFormula«-Eigenschaft 144 Die »Font«-Eigenschaft 145 Die »Interior«-Eigenschaft 146 Die »Formula«-Eigenschaft 147 Die »NumberFormat«-Eigenschaft 148 Aktionen mit Methoden des »Range«-Objekts unternehmen 148 Die »Select«-Methode 149 Die Methoden »Copy« und »Paste« 149 Die »Clear«-Methode 150 Die »Delete«-Methode 150 Kapitel 9 VBA-und Arbeitsblattfunktionen 151 Funktionen verstehen 151 Eingebaute VBA-Funktionen verwenden 152 Arbeiten mit Datum und Uhrzeit 152 Arbeiten mit Zeichenfolgen 154 Objekte und Daten identifizieren 155 VBA-Funktionen, die mehr tun, als einen Wert zurückzugeben 156 VBA-Funktionen finden 156 Arbeitsblattfunktionen in VBA verwenden 159 Beispiele für Arbeitsblattfunktionen 160 Eingabe von Arbeitsblattfunktionen 162 Weitere Informationen über die Verwendung von Arbeitsblattfunktionen 163 Benutzerdefinierte Funktionen verwenden 164 Kapitel 10 Steuerung des Programmablaufs und Entscheidungen 165 Schwimmen mit dem Strom 165 Die »GoTo«-Anweisung 166 Entscheidungen, Entscheidungen! 168 Die »If-Then «-Struktur 168 Die »Select Case«-Struktur 172 Ihr Code für eine Schleife 175 »For-Next «-Schleifen 175 »Do While«-Schleifen 180 »Do Until«-Schleifen 181 »For Each-Next «-Schleifen für Collections ausführen 181 Kapitel 11 Automatische Prozeduren und Ereignisse 185 Vorbereitung auf das große Ereignis 185 Lernen, wann Sie Ereignisprozeduren einsetzen 187 Programmierung von Prozeduren zur Ereignisverarbeitung 188 Wissen, wo man den Ereigniscode einfügt 188 Eine Prozedur zur Ereignisverarbeitung schreiben 189 »Workbook«-Ereignisse auslösen 190 Das »Open«-Ereignis für eine Arbeitsmappe 191 Das »BeforeClose«-Ereignis für eine Arbeitsmappe 193 Das »BeforeSave«-Ereignis für eine Arbeitsmappe 194 Aktivierungsereignisse verwenden 195 Aktivierungs-und Deaktivierungsereignisse in einem Arbeitsblatt 195 Aktivierungs-und Deaktivierungsereignisse in einer Arbeitsmappe 196 Arbeitsmappen-Aktivierungsereignisse 197 Programmierung von Arbeitsblattereignissen 198 Das »BeforeDoubleClick«-Ereignis 198 Das »BeforeRightClick«-Ereignis 198 Das »Change«-Ereignis 199 Ereignisse verstehen, die keinen Objekten zugeordnet sind 201 Das »OnTime«-Ereignis 201 Tastenaktionen 203 Kapitel 12 Techniken zur Fehlerverarbeitung 205 Fehlertypen 205 Ein fehlerhaftes Beispielmakro 206 Nicht ganz perfekte Makros 207 Das Makro noch perfekter machen 208 Verabschieden Sie sich von der Perfektion! 209 Alternative Wege der Fehlerverarbeitung 210 Noch einmal die Prozedur »EnterSquareRoot« 210 Fehler mit der »On-Error «-Anweisung abfangen 211 Fehlerverarbeitung: die Details 212 Fortsetzung nach einem Fehler 212 Fehlerverarbeitung im Überblick 214 Ein beabsichtigter Fehler 214 Kapitel 13 Techniken, mit denen Sie Fehler loswerden 217 Verschiedene Fehlerarten 217 Programmierfehler identifizieren 219 Debugging-Techniken 220 Ihren Code überprüfen 220 Die »MsgBox«-Funktion verwenden 220 »Debug.Print«-Anweisungen einfügen 222 Verwendung des VBA-Debuggers 222 Debugging-Tools verwenden 223 Haltepunkte in Ihrem Code setzen 223 Das Überwachungsfenster verwenden 226 Das Lokal-Fenster 228 Tipps, wie Sie weniger Programmierfehler machen 229 Kapitel 14 VBA-Programmierbeispiele 231 Mit Bereichen arbeiten 231 Einen Bereich kopieren 232 Einen variablen Bereich kopieren 233 Auswahl bis zum Ende einer Zeile oder Spalte 235 Eine Zeile oder Spalte auswählen 236 Einen Bereich verschieben 236 Einen Bereich effizient durchlaufen 236 Einen Bereich effizient durchlaufen (Teil II) 238 Einen Zellwert anfordern 239 Den Auswahltyp bestimmen 240 Eine Mehrfachauswahl erkennen 240 Excel-Einstellungen abändern 241 Boolesche Einstellungen ändern 241 Nicht-boolesche Einstellungen ändern 242 Diagramme 242 »AddChart« im Vergleich zu »AddChart2« 243 Den Diagrammtyp ändern 245 Die »ChartObjects«-Collection durchlaufen 245 Diagrammeigenschaften ändern 246 Diagrammformatierungen anwenden 246 VBA-Geschwindigkeitstipps 248 Die Bildschirmaktualisierung abschalten 248 Die automatische Berechnung ausschalten 249 Lästige Warnungen deaktivieren 249 Objektreferenzen vereinfachen 251 Variablentypen deklarieren 251 Die »With-End With«-Struktur 252 Kapitel 15 Einfache Dialogfelder 253 In VBA mit dem Benutzer interagieren 253 Meldungen mit der »MsgBox«-Funktion anzeigen 254 Ein einfaches Meldungsfeld anzeigen 255 Eine Antwort aus einem Meldungsfeld erhalten 256 Meldungsfelder anpassen 257 Daten mit der Funktion »InputBox« abfragen 260 Die Syntax von »InputBox« verstehen 260 Die Funktion »InputBox« verwenden 260 Die Methode »InputBox« verwenden 262 Den Benutzer eine Datei oder einen Ordner auswählen lassen 263 Eine »GetOpenFilename«-Anweisung erstellen 264 Eine Datei mit »GetOpenFilename« auswählen 264 Pfad und Dateinamen mit »GetSaveAsFilename« ermitteln 266 Einen Ordnernamen ermitteln 267 Eingebaute Excel-Dialogfelder anzeigen 267 Teil IV: Kommunikation mit Ihren Benutzern 271 Kapitel 16 UserForm-Grundlagen 273 Erkennen, wann man ein UserForm braucht 273 UserForms erstellen: ein Überblick 275 Mit UserForms arbeiten 276 Ein neues UserForm einfügen 276 Einem UserForm Steuerelemente hinzufügen 277 Die Eigenschaften eines UserForm-Steuerelements ändern 277 Den Codebereich für ein UserForm anzeigen 279 Ein UserForm anzeigen 279 Informationen aus einem UserForm verarbeiten 280 Ein UserForm-Beispiel 280 Das UserForm erstellen 281 Die Befehlsschaltflächen hinzufügen 281 Optionsfelder einfügen 283 Prozeduren zur Ereignisverarbeitung einfügen 284 Ein Makro anlegen, das das Dialogfeld anzeigt 286 Das Makro für den Benutzer bereitstellen 286 Das Makro testen 288 Kapitel 17 UserForm-Steuerelemente verwenden 291 Steuerelemente im Dialogfeld – die ersten Schritte 291 Steuerelemente hinzufügen 292 Eigenschaften von Steuerelementen – Grundlagen 293 Details zu den Steuerelementen in einem Dialogfeld kennenlernen 295 Das »CheckBox«-Steuerelement – Kontrollkästchen 296 Das »ComboBox«-Steuerelement – Kombinationsfeld 296 Das »CommandButton«-Steuerelement – Befehlsschaltfläche 297 Das »Frame«-Steuerelement – Rahmen 298 Das »Image«-Steuerelement (Bildfeld) 298 Das »Label«-Steuerelement (Bezeichnungsfeld) 299 Das »ListBox«-Steuerelement (Listenfeld) 300 Das »MultiPage«-Steuerelement – Multiseiten 301 Das »OptionButton«-Steuerelement – Optionsfelder 302 Das »RefEdit«-Steuerelement 302 Das »ScrollBar«-Steuerelement – Bildlaufleiste 303 Das »SpinButton«-Steuerelement – Drehfeld 304 Das »TabStrip«-Steuerelement – Register 305 Das »TextBox«-Steuerelement – Textfeld 305 Das »ToggleButton«-Steuerelement – Umschaltfeld 306 Die Arbeit mit Steuerelementen in Dialogfeldern 306 Steuerelemente verschieben und ihre Größe ändern 307 Steuerelemente ausrichten und Abstände einhalten 307 Tastaturbenutzern helfen 308 Ein UserForm testen 310 Dialogfeld-Ästhetik 310 Kapitel 18 UserForms – Techniken und Tricks 311 Dialogfelder verwenden 311 Ein UserForm-Beispiel 312 Das Dialogfeld erstellen 312 Code für die Anzeige des Dialogfelds 315 Das Makro bereitstellen 315 Ihr Dialogfeld ausprobieren 316 Prozeduren zur Ereignisverarbeitung einfügen 316 Die Daten auswerten 318 Jetzt funktioniert das Dialogfeld 319 Beispiel für ein Listenfeld-Steuerelement 319 Ein Listenfeld füllen 320 Das ausgewählte Element bestimmen 321 Mehrfachauswahlen bestimmen 322 Einen Bereich auswählen 323 Mehrere Gruppen von Optionsfeldern verwenden 325 Ein Drehfeld und ein Textfeld verwenden 326 Ein UserForm als Fortschrittsanzeige verwenden 328 Ein Dialogfeld als Fortschrittsanzeige einrichten 329 Die Prozeduren 330 Wie dieses Beispiel funktioniert 331 Ein nicht modales Dialogfeld mit Registerkarten erstellen 332 Ein Diagramm in einem UserForm anzeigen 334 Eine Checkliste für Dialogfelder 335 Kapitel 19 Zugriff auf Ihre Makros über die Benutzeroberfläche 337 Das Menüband anpassen 337 Das Menüband manuell anpassen 338 Dem Menüband ein Makro hinzufügen 340 Anpassung des Menübands mit XML 340 Die Excel-Benutzeroberfläche mit VBA anpassen 345 Befehle zur Registerkarte »Add-Ins « des Menübands hinzufügen 346 Dem Kontextmenü »Cell« einen neuen Eintrag hinzufügen 347 Anpassungen automatisch hinzufügen 349 Kontextmenüs und das Single Document Interface verstehen 349 Teil V: Das große Ganze 351 Kapitel 20 Arbeitsblattfunktionen erstellen 353 Vereinfachen Sie mit benutzerdefinierten Funktionen Ihre Arbeit 353 Grundlagen der VBA-Funktionen 354 Funktionen schreiben 355 Mit Funktionsargumenten arbeiten 356 Eine Funktion ohne Argumente 356 Eine Funktion mit einem Argument 357 Eine Funktion mit zwei Argumenten 359 Eine Funktion mit einem Bereichsargument 360 Eine Funktion mit einem optionalen Argument 362 Wrapper-Funktionen 364 Die »NumberFormat«-Funktion 364 Die »ExtractElement«-Funktion 364 Die »SayIt«-Funktion 365 Die »IsLike«-Funktion 366 Funktionen, die ein Array zurückgeben 366 Ein Array mit Monatsnamen zurückgeben 366 Eine sortierte Liste zurückgeben 367 Das Dialogfeld »Funktion einfügen« verwenden 369 Die Funktionsbeschreibung anzeigen 369 Argumentbeschreibungen 371 Kapitel 21 Add-Ins in Excel erstellen 373 Was ist ein Add-In? 373 Gründe für die Erstellung von Add-Ins 374 Die Arbeit mit Add-Ins 375 Add-In-Grundlagen 376 Sehen Sie sich ein Beispiel für ein Add-In an 377 Einrichtung der Arbeitsmappe 377 Die Arbeitsmappe testen 379 Beschreibende Informationen hinzufügen 380 Den VBA-Code schützen 381 Das Add-In anlegen 381 Das Add-In öffnen 382 Das Add-In weitergeben 383 Das Add-In ändern 383 Teil VI: Der Top-Ten-Teil 385 Kapitel 22 Zehn nützliche Tipps für den Visual Basic-Editor 387 Kommentarblöcke verwenden 387 Mehrere Codezeilen kopieren 389 Zwischen Modulen und Prozeduren springen 389 Beamen Sie sich zu Ihren Funktionen 389 In der richtigen Prozedur bleiben 390 Den Code schrittweise ausführen 391 Zu einer bestimmten Codezeile springen 392 Die Codeausführung an einer bestimmten Stelle unterbrechen 392 Den Anfang und das Ende des Variablenwerts anzeigen 393 Die automatische Syntaxüberprüfung ausschalten 394 Kapitel 23 Ressourcen mit Hilfe zu VBA 397 Lassen Sie Excel die Makros für Sie schreiben 397 Nutzen Sie das Hilfesystem 398 Stibitzen Sie Code im Internet 398 Userforen optimal nutzen 399 Besuchen Sie Experten-Blogs 400 Suchen Sie auf YouTube nach Schulungsvideos 400 Nehmen Sie an Onlinekursen teil 401 Vom Office Dev Center lernen 401 Analysieren Sie andere Excel-Dateien in Ihrem Unternehmen 401 Fragen Sie die Excel-Experten vor Ort 402 Kapitel 24 Zehn Dinge, die Sie beherzigen oder vermeiden sollten 403 Deklarieren Sie alle Variablen 403 Verwechseln Sie Passwörter nicht mit Sicherheit 404 Bereinigen Sie Ihren Code 404 Schreiben Sie nicht alles in eine Prozedur 405 Denken Sie daran, dass es noch andere Software gibt 405 Gehen Sie nicht davon aus, dass alle Benutzer Makros aktivieren 405 Gewöhnen Sie sich an, zu experimentieren 405 Gehen Sie nicht davon aus, dass Ihr Code in anderen Excel-Versionen funktioniert 406 Denken Sie immer an Ihre Benutzer 406 Vergessen Sie die Datensicherung nicht! 406 Abbildungsverzeichnis 407 Stichwortverzeichnis 415

Read more less

Book SynopsisEin überquellendes Postfach, zu viele Meetings, nie genügend Zeit? Nutzen Sie Outlook richtig - nicht nur zum Mailen, sondern auch und vor allem zur Organisation Ihrer Kontakte, Termine und Aufgaben. Christine Peyton und Andre Möller zeigen Ihnen, wie Ihnen Outlook hilft, sich zu organisieren, Prioritäten zu setzen und vieles mehr. Planen Sie Besprechungen mit mehreren Teilnehmern und nutzen Sie die Funktionen von Microsoft 365 für die Zusammenarbeit. Halten Sie Ihren Posteingang aufgeräumt, finden Sie Mails und Unterlagen schnell wieder, lassen Sie sich Terminüberschneidungen anzeigen, reservieren Sie Räume und Geräte und archivieren Sie mit System. Beherrschen Sie das Chaos!Table of ContentsÜber die Autoren 9 Einleitung 19 Teil I: Outlook kennenlernen: die Grundlagen 23 Kapitel 1: Outlook als Alleskönner – die Module im Überblick 25 Kapitel 2: Outlook als E- Mail- Programm 33 Kapitel 3: E- Mails mit und ohne Anhang verschicken 65 Kapitel 4: E- Mails mit Pfiff 83 Kapitel 5: Nachrichten empfangen 101 Teil II: Daten verwalten, archivieren und verschlüsseln 139 Kapitel 6: PST- Dateien, mehrere Konten und Mails archivieren 141 Kapitel 7: Sicherheit und Sicherheitsrisiken 161 Teil III: So organisieren Sie Ihren Arbeitsalltag mit Outlook 189 Kapitel 8: Termine in Outlook 191 Kapitel 9: Termine eingeben, bearbeiten und verwalten 213 Kapitel 10: Aufgaben erstellen 265 Kapitel 11: Kontakte managen 281 Kapitel 12: Outlook- Kontakte für den Serienbrief nutzen 305 Kapitel 13: Praktische Gedächtnisstützen – Notizen 319 Kapitel 14: Importieren, exportieren und synchronisieren 325 Kapitel 15: Kollaboration in einer Organisation 357 Teil IV: Top-Ten-Teil 373 Kapitel 16: Zehn Tipps für den geschickten Umgang mit Outlook 375 Abbildungsverzeichnis 385 Stichwortverzeichnis 399

Read more less

Book Synopsis

Read more less

Book SynopsisThis book provides solutions, best practices, tips, and workarounds to plan, design, customize, implement, and manage Microsoft Teams in any environment. This revised edition has been updated to reflect all the latest techniques and products, including migration from Skype for Business On-Prem to Microsoft Teams, along with Teams for Education, which includes a range of features and tools that enable teachers and students to collaborate, communicate, and learn in a virtual environment.The book begins with an overview of Microsoft Teams, including its architecture, teams/channels, audio/video meetings, and the phone system. The authors then take you deeper into deployment and management of teams, clients, guests and external access, and live events, followed by a walk-through of network assessment and bandwidth planning for Teams. Here, you will learn about deployment of quality of service and how to configure your phone systems using direct routing and calling plans. Moving forward, you will learn Microsoft Teams administration and policy management along with the migration process of Skype from Business On-Prem to Microsoft Teams. To wrap things up, the authors demonstrate some troubleshooting techniques for call quality issues in Teams, and walk you through various features of Teams for Education and how to utilize them. By the time you turn the last page of Understanding Microsoft Teams Administration, you'll be fully equipped to configure, customize, and control Teams with confidence. Don't just adapt to the future of collaboration—lead it. What You Will Learn Kickstart your journey: Get acquainted with the Teams architecture, from teams and channels to audio/video conferencing and beyond Master the mechanics: Dive deep into deployment, including crucial aspects like guest access, such as events, and network assessment Elevate call quality: Learn the nuts and bolts of Quality of Service (QoS) and phone systems, including direct routing and calling plans Admin like a pro: Gain insights into robust policy management, and understand how to navigate the Teams admin portal with finesse Get a grip on network assessment and bandwidth planning tailored specifically for Teams Unlock secrets of quality of service, direct routing, and customized calling plans Migration simplified: Seamlessly shift from Skype for Business On-Prem to Teams without missing a beat Edu-tech unveiled: Explore Teams for Education and how its myriad features can enrich virtual learning experiences for teachers and students alike What's new: A dedicated chapter exclusively covering Microsoft Teams for Education, focusing on empowering both educators and students Who This Book Is For Administrators and technical consultants focused on Microsoft Teams. This book serves as an invaluable resource for those looking to optimize team collaboration and communication within their organizations.Table of ContentsChapter 1: Microsoft Teams Overview.- Chapter 2: Managing and controlling Microsoft Teams.- Chapter 3: Organization Readiness for Microsoft Teams.- Chapter 4: Teams Audio Conferencing and Phone system management.- Chapter 5: Microsoft Teams Governance and lifecycle management.- Chapter 6: Migration from Skype for Business (Lync) on-prem and online to Microsoft Teams.- Chapter 7: Microsoft Teams troubleshooting approaches.- Chapter 8: Teams Reporting and Monitoring. – Chapter 9: Microsoft Teams for Education. - Chapter 10: Microsoft Teams Learning to the Next Level and Get Certified.

Read more less

Book SynopsisUnderstand .NET memory management internal workings, pitfalls, and techniques in order to effectively avoid a wide range of performance and scalability problems in your software. Despite automatic memory management in .NET, there are many advantages to be found in understanding how .NET memory works and how you can best write software that interacts with it efficiently and effectively. This book is your comprehensive guide to writing better software by understanding and working with memory management in .NET, from Framework up to .NET 8. Thoroughly vetted by the .NET Team at Microsoft, this book contains valuable troubleshooting scenarios designed to help diagnose challenging memory problems. You will also benefit from a multitude of .NET memory management rules to live by that introduce methods for writing memory-aware code and the means for avoiding common, destructive pitfalls. What You'll LearnUnderstand the theoretical underpinnings of automatic memory managementTake a deep dive into every aspect of .NET memory management, including detailed coverage of garbage collection (GC) implementation, that would otherwise take years of experience to acquireGet practical advice on how this knowledge can be applied in real-world software developmentUse practical knowledge of tools related to .NET memory management to diagnose various memory-related issuesExplore various aspects of advanced memory management, including use of Span and Memory typesWho This Book Is For.NET developers, solution architects, and performance engineers

Read more less

Book SynopsisThis book is a comprehensive guide that aims to revolutionize how developers approach app creation using Microsoft PowerApps, with a special emphasis on harnessing Copilot, an AI-powered coding assistant. The book is an essential resource for both novice and experienced developers, offering an in-depth exploration of integrating artificial intelligence in app development. The integration of AI in app development, particularly through tools such as Copilot, is more relevant now than ever before due to the rapid evolution of technology and the increasing demand for efficient, innovative, and user-friendly applications. Copilot for PowerApps represents a significant advance in this direction, offering developers a unique combination of AI-powered efficiency and the versatility of PowerApps. What You Will LearnUnderstandcomplex AI concepts and AI-assisted developmentKnow how to use Copilot effectively and create sophisticated and reliable apps fasterStayabreast of the latest tools and techniques so you remaincompetitive and relevant in the ever-changing landscape of app developmentBenefit fromcase studies and real-world examples thatdemonstrate the practical application and benefits of using Copilot in PowerAppsWho This Book Is ForAnyone interested in the intersection of AI and app development. It will not only educate but also inspire and prepare readers for the future of this dynamic field.

Read more less

Book SynopsisThis book is designed to help you prepare for Exam MS-721, which is required for Microsoft 365 Certified: Collaboration Communications Systems Engineer Associate certification. The book starts with an introduction to Exam MS -721 and Microsoft Teams. It discusses how to plan and design collaboration communications systems followed by configuration and management of Teams meetings and events. You will learn about Teams Phone and acquire the skills required to configure Direct Routing with Teams Phone. You will go through the configuration of Teams Phone and learn its user settings and features. Teams Meeting Rooms and devices, from deployment to troubleshooting, are discussed along with their Intune policies. And you will learn the configuration of MTRs based on Windows and Surface Hub. What You Will LearnUnderstandMicrosoft TeamsPlanand designmeetings and collaborationConfigureand manageTeams PhoneOptimizethe network for Teams and Teams certified devicesTroubleshootTeams calls and meetingsWho This Book ForIndividuals aiming to earn the Microsoft 365 Certified: Collaboration Communications Systems Engineer Associate certification, for which Exam MS-721 is a requirement

Read more less

Book SynopsisUnderstand the full potential of Microsoft Power Platform with this comprehensive guide, designed to provide you with the knowledge and tools needed to create intelligent business applications, automate workflows, and drive data-driven insights for business growth. Whether you're a novice or an experienced professional, this book offers a step-by-step approach to mastering the Power Platform.This book comes with an extensive array of essential concepts, architectural patterns and techniques. It will also guide you with practical insights to navigate the Power Platform effortlessly while integrating on Azure. Starting with exploring Power Apps for building enterprise applications, the book delves into Dataverse, Copilot Studio, AI Builder, managing platforms and Application life cycle management. You will then demonstrate testing strategy followed by a detailed examination of Dataverse and intelligent AI-powered Applications. Additionally, you will cover Power pages for external websites and AI-infused solutions. Each section is meticulously structured, offering step-by-step guidance, hands-on exercises, and real-world scenarios to reinforce learning. After reading the book, you will be able to optimize your utilization of the Power Platform for creating effective business solutions. What You Will Learn:Understand the core components and capabilities of Power PlatformExplore how Power Platform integrates with Azure servicesUnderstand the key features and benefits of using Power Platform for business applicationsDiscover best practices for governance to ensure compliance and efficient managementExplore techniques for optimizing the performance of data integration and export processes on AzureWho This Book Is For:Application developers, Enterprise Architects and business decision-makers.

Read more less

Book SynopsisUnlock the potential of IoT with Microsoft Azure through this comprehensive guide, designed to elevate your understanding and implementation of cutting-edge IoT network and security solutions. Whether you are a beginner or a seasoned professional, this book offers clear, actionable insights to help you master the intricacies of IoT with Azure.This book equips you with the expertise to design and deploy secure, efficient, and scalable IoT networks using Microsoft Azure. It is your key to becoming a proficient IoT architect and security specialist. What You Will LearnKnow the fundamentals of IoT networks and security, including key concepts, terminologies, and the importance of securing IoT deploymentsDive into Azure Edge Services to design and deploy edge solutions that bring computation and data storage closer to the data source, enhancing speed and efficiencyExplore the architecture and deployment of Azure IoT networks to gain practical knowledge on setting up scalable, reliable, and secure IoT networks tailored to your needsStudy best practices and strategies for securing your IoT environment and ensuring robust protection against emerging threatsMonitor and manage your IoT solutions effectively via tools and techniques for maintaining optimal performance, diagnosing issues, and ensuring seamless operation of your IoT networksWho This Book Is ForIoT network and security engineers,architects, and Azure IoT developers

Read more less

Book SynopsisThis revamped and updated book focuses on the latest in AI technologyGenerative AI.It builds on the first edition by moving away from traditional data science into the area of applied AI using the latest breakthroughs in Generative AI. Based on real-world projects, this edition takes a deep look into new concepts and approaches such as Prompt Engineering, testing and grounding of Large Language Models, fine tuning, and implementing new solution architectures such as Retrieval Augmented Generation (RAG). You will learn about new embedded AI technologies in Search, such as Semantic and Vector Search. Written with a view on how to implement Generative AI in software, this book contains examples and sample code. In addition to traditional Data Science experimentation in Azure Machine Learning (AML) that was covered in the first edition, the authors cover new tools such as Azure AI Studio, specifically for testing and experimentation with Generative AI models. What's New in this BookProvides new concepts, tools, and technologies such as Large and Small Language Models, Semantic Kernel, and Automatic Function CallingTakes a deeper dive into using AzureAI Studio for RAG and Prompt Engineering designIncludes new and updated case studies for Azure OpenAITeaches about Copilots,plugins, and agentsWhat You'll LearnGet up to date on the important technical aspects of Large Language Models, based on Azure OpenAI as the reference platformKnow about the different types of models:GPT3.5 Turbo, GPT4, GPT4o, Codex, DALL-E, and Small Language Models such as Phi-3Develop new skills such as Prompt Engineering and fine tuning of Large/Small Language ModelsUnderstandand implementnew architectures such as RAG and Automatic Function CallingUnderstand approaches forimplementing Generative AI using LangChain and Semantic KernelSee how real-world projects help you identify great candidates for Applied AI projects, including Large/Small Language ModelsWho This Book Is ForSoftware engineers and architects looking to deploy end-to-end Generative AI solutions on Azure with the latest tools and techniques.

Read more less

Book SynopsisEmbark on a journey into Dynamics 365 Business Central development with this comprehensive guide to the MB-820 certification exam. This book will help you prepare for the examination and also help you understand Dynamics 365 Business Central betterwith real-world examples, exercises, and tips.The book starts with an introduction to the Exam pattern to help you understand the overall requirements. Next, you will delve into the fundamentals of Dynamics 365 Business Central Development, exploring its development tools and environment. After that, you will explore the installation, development, and deployment processes for Dynamics 365 Business Central.AL objects for Dynamics 365 Business Central are discussed next and you will go through creating and modifying AL objects along with their best practices. Further coverage is given to development tools essential for Dynamics 365 Business Central, followed by their integration with other applications. To end your journey, you will be guided with practice tests and exercises to help you prepare for the exam. After reading this book, you will be able to prepare yourself for the MB-820 Exam and be equipped with the basics of Dynamics 365 Business Central. What You Will LearnUnderstandapplication life cycle management principles and techniquesGain proficiency in debugging and troubleshooting Dynamics 365 Business Central solutionsApplyadvanced development techniques and concepts in real-world scenariosUnderstandAL language syntax and best practicesWho This Book Is ForNew Dynamics 365 Business Central developers andIndividuals preparing for the MB-820 certification exam

Read more less

Book SynopsisBreak the vicious circle of designs perpetuating the errors of the past and just click next and accept the defaults implementations preventing a secure and reliable future. This book looks at the typical patterns and antipatterns in Active Directory (AD) design, deployment, and operations and provides an approach to building and operating AD that is based on engineering (analyzing and fulfilling requirements) rather than design (formulating requirements). The book starts with an historical overview of AD and its future 25 years later. You then learn about the challenges that organizations running AD are facing today followed by understanding how to avoid them while learning modern requirements for more efficient and effective AD performance. After that, you go through business requirements influencing the AD topology along with ways to engineer information lookup to protect high-value objects. The book looks at two main protocols and the many dialects that AD offers to engineer an authentication service that fulfills modern requirements while leaving insecure legacy configurations behind. ManagingAD from both the security and usability perspectives is discussed next in the book. Building, operating, and transitioning to a modern AD is demonstrated in detail. The book guides you with the next steps of your journey to achieve a secure and reliable AD. After reading this book, you will be able to bridge the gap between the two approaches by analyzing real-world business requirements, explaining the decision-making process in both design and engineering, and ultimately providing concrete engineering guidelines for typical implementation scenarios. What Will You LearnBuilda modern Active Directory (AD), leaving behind design antipatterns that are not valid anymoreBuild a secure by design AD and accommodate legacy technology without compromising the overall securityUnderstandadvanced AD functionality such ascontrolling object visibility and partitioning Kerberos authentication by Authentication PoliciesOperate a modern AD, react to changing business requirements, and respond to ever-evolving security threatsWho This Book Is ForActive Directory (AD) architects and consultants who need to provide design and engineering advice to customers;AD administrators tasked with modernizing and securing AD in their organizations; security architects wishing to learn the AD design patterns to watch out for

Read more less