Böcker i Developer Reference-serien

Marco Russo and Alberto Ferrari walk students step-by-step through creating powerful data models, and then illuminate advanced features such as optimization, deployment, and scalability. Tabular Modeling in Microsoft SQL Server Analysis Services will be indispensable for everyone moving to Analysis Services Tabular, regardless of their previous experience with tabular-style models or with Microsoft's older Analysis Services offerings. It will also be an essential follow-up for every reader of the authors' highly-praised Microsoft SQL Server 2012 Analysis Services: The BISM Tabular Model.

Comprehensive hands-on reference focuses on advanced querying techniques using Transact-SQL (T-SQL). For database developers & adminstrators. Includes code & table examples.

Delve inside Windows architecture and internals - and see how core components work behind the scenes. This classic guide has been fully updated for Windows 10 and Windows Server 2016.

Use window functions to optimize your T-SQL queries for greater simplicity, elegance, and performance Discover the surprising power of window functions, and learn how to use them far more widely The most advanced coverage of T-SQL window functions — including new techniques invented by author Itzik Ben-Gan, one of the world's top T-SQL experts Covers T-SQL for all recent versions of Microsoft SQL Server (including 2019) and Microsoft Azure SQL Database — including important new window function optimizations Ideal for DBAs, developers, and anyone who uses T-SQL to solve business problems Most T-SQL developers recognize the value of window functions for data analysis calculation. But window functions can do far more than that, and optimizations in recent versions of SQL Server have made them more powerful than ever. In T-SQL Window Functions: For Data Analysis and Beyond, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using window functions to handle many common T-SQL querying tasks with unprecedented elegance and power.Ben-Gan first explains why window functions can often be a far better solution than traditional predicate-based approaches. Next, using extensive code examples, he guides you through each type of window function: Aggregate, Ranking, Distribution and Offset. You'll find detailed coverage of ordered set functions (including SQL Server 2017's STRING_AGG); plus an extensive section on optimization. The book concludes with roughly 100 pages of real T-SQL solutions using window function approaches — including techniques invented by the author and available in no other book.

Use LLMs to build better business software applications Autonomously communicate with users and optimize business tasks with applications built to make the interaction between humans and computers smooth and natural. Artificial Intelligence expert Francesco Esposito illustrates several scenarios for which a LLM is effective: crafting sophisticated business solutions, shortening the gap between humans and software-equipped machines, and building powerful reasoning engines. Insight into prompting and conversational programming-with specific techniques for patterns and frameworks-unlock how natural language can also lead to a new, advanced approach to coding. Concrete end-to-end demonstrations (featuring Python and ASP.NET Core) showcase versatile patterns of interaction between existing processes, APIs, data, and human input.  Artificial Intelligence expert Francesco Esposito helps you: Understand the history of large language models and conversational programmingApply prompting as a new way of codingLearn core prompting techniques and fundamental use-casesEngineer advanced prompts, including connecting LLMs to data and function calling to build reasoning enginesUse natural language in code to define workflows and orchestrate existing APIsMaster external LLM frameworksEvaluate responsible AI security, privacy, and accuracy concernsExplore the AI regulatory landscapeBuild and implement a personal assistantApply a retrieval augmented generation (RAG) pattern to formulate responses based on a knowledge baseConstruct a conversational user interface For IT Professionals and Consultants For software professionals, architects, lead developers, programmers, and Machine Learning enthusiastsFor anyone else interested in natural language processing or real-world applications of human-like language in software

Professional Scrum Development with Azure DevOps stands apart from all other Scrum and Azure guides by focusing on the fusion of today's most popular agile framework (Scrum) and ALM/DevOps toolset (Azure DevOps). Hundhausen shows how a professional Scrum team can more effectively plan, track, and manage its work with Azure Boards, Azure Test Plans, and related Azure DevOps features. He offers detailed coverage of team formation, backlogs, sprints, test plans, collaboration, flow, continuous improvement, and the real-world tradeoffs between using tools and interacting directly with other team members. To make this guide even more valuable, Hundhausen has crafted it to complement Scrum.org's popular Professional Scrum Developer (PSD) program, which he personally created with Scrum.org's Ken Schwaber. Powerful techniques for the 80-90% of modern software teams that use Scrum and its variants Reflects state-of-the-art tools built into Azure DevOps, as well as its integration with GitHub Introduces high-productivity features for Scrum teams in Azure Boards and Azure Test Plans Complements Scrum.org's Professional Scrum Developer (PSD) program -- created by this book's author together with Ken SchwaberRichard Hundhausen helps software organizations and teams deliver better products by understanding and leveraging Azure DevOps and Scrum. He is a Professional Scrum Trainer, Professional Scrum Developer, author of Professional Scrum Development with Microsoft Visual Studio(Microsoft Press), and co-creator of the Nexus Scaled Scrum Framework with Ken Schwaber. As a software developer and consultant with 30+ years of experience, he understands that software is built and delivered by people, not by processes or tools.

The complete developer's introduction to machine learning and artificial intelligence Demystifies basic machine learning techniques, algorithms, operations, and tools Walks through building two complete solutions with Microsoft's ML.NET Guides you from collecting and fine-tuning source data to building and testing solutions Unique programmer-focused insights from best-selling software development author Dino Esposito Today, machine learning offers software professionals unparalleled opportunity for career growth. In Introducing Machine Learning, best-selling software development author, trainer, and consultant Dino Esposito offers a complete introduction to the field for programmers, architects, lead developers, and managers alike.Esposito begins by illuminating what's known about how humans and machines learn, introducing the most important classes of machine learning algorithms, and explaining what each of them can do. Esposito demystifies key concepts ranging from neural networks to supervised and unsupervised learning. Next, he explains each step needed to build a successful machine learning solution, from collecting and fine-tuning source data to building and testing your solution.Then, building on these essentials, he guides you through constructing two complete solutions with ML.NET, Microsoft's powerful open source and cross-platform machine learning framework. Step by step, you'll create systems for performing sentiment analysis on social feeds, and analyzing traffic to predict accidents. By the time you're finished, you'll be ready to participate in data science projects and build working solutions of your own.

Drill down into Windows architecture and internals, discover how core Windows components work behind the scenes, and master information you can continually apply to improve architecture, development, system administration, and support.Led by three renowned Windows internals experts, this classic guide is now fully updated for Windows 10 and 8.x. As always, it combines unparalleled insider perspectives on how Windows behaves ?under the hood? with hands-on experiments that let you experience these hidden behaviours first hand.Part 2 examines these and other key Windows 10 OS components and capabilities: Startup and shutdown The Windows Registry Windows management mechanisms WMI System mechanisms ALPC ETW Cache Manager Windows file systems The hypervisor and virtualization UWP ActivationRevised throughout, this edition also contains three entirely new chapters: Virtualization technologies Management diagnostics and tracing Caching and file system support

This is the first start-to-finish guide to programming AI-powered mixed reality apps and games using today's breakthrough technologies -- including Microsoft Cognitive Services, Unity, Vuforia, Xamarin UrhoSharp, and the Universal Windows Platform. Pioneering mixed reality developer Dawid Borycki guides you through every aspect and phase of mixed reality development, from simple 2D apps to cutting-edge apps that run on Microsoft HoloLens and today's newest immersive headsets. One step at a time, you'll learn how to: Set up a mixed reality development environment with all the tools you'll need, including HoloLens and Mixed Reality simulators Write Universal Windows 2D apps for all Windows 10 devices, and adjust their views and capabilities to specific hardware Acquire, display and process audio and video Send images from world-facing headset cameras to Microsoft's computer vision machine learning modules Generate descriptions of what the user sees, and present them via text or speech Use mobile sensor readings to control content displayed through mixed reality headsets Master core concepts and techniques for building 3D mixed reality apps with Unity Format 3D objects with materials to create holograms Add interactions to holograms based on user input Integrate HoloLens-specific capabilities, including air gestures, spatial sound, and mapping Connect mixed reality experiences with real objects in the environment via the Vuforia Unity extension Write cross-platform 3D mixed reality apps with Xamarin UrhoSharp

For most .NET programmers, Node.js represents a radically different way to build scalable, high-traffic web sites and applications. Now, there's a practical, straight-to-the-point introduction to Node.js specifically for experienced Microsoft developers. Drawing on his immense experience with both Microsoft and JavaScript technologies, David Gaynes guides you through the entire Node.js website development process, from start to finish. Using Visual Studio examples, Gaynes covers everything from setting up servers and authorization through delivering rich CSS pages packed with graphics and data-driven content. Gaynes begins by showing you how to quickly set up Node.js and each of these complementary tools: Express (Ease of Use); Body-Parser (Form values); EJS (Views); CodeMon (Code Changes / Run Updates); Bower (UI); Bootstrap (styling), Passport (Auth); Memory-Cache (persistence); and databases (MSSQL and MySQL). Next, using clear examples, he explains Node.js's async model, coding approach, and request/response paradigm; site structure, data management, security, and more. He concludes with a full chapter of solutions to common errors Microsoft developers make when they first adopt Node.js. Node.js for .NET Developers will help you apply all hard-won .NET skills to Node.js -- building web solutions that are more responsive, perform better, and cost less.

Modern Authentication with Active Directory delivers comprehensive guidance for building complete solutions. Balancing theory with concrete code-level guidance, the author paints a complete picture -- placing individual tasks in context, explaining how disparate tasks fit together, helping students choose and design solutions, and demonstrating how to implement it reliably, safely, and efficiently.

Your essential guide to developing applications with the common language runtime (CLR) and Microsoft .NET Framework 4.5, with examples in Microsoft Visual C# 2012.