Analytics Optimization with Columnstore Indexes in Microsoft SQL ServerMeet the challenge of storing and accessing analytic data in SQL Server in a fast and performant manner. This book illustrates how columnstore indexes can provide an ideal solution for storing analytic data that leads to faster performing analytic queries and the ability to ask and answer business intelligence questions with alacrity. The book provides a complete walk through of columnstore indexing that encompasses an introduction, best practices, hands-on demonstrations, explanations of common mistakes, and presents a detailed architecture that is suitable for professionals of all skill levels.
With little or no knowledge of columnstore indexing you can become proficient with columnstore indexes as used in SQL Server, and apply that knowledge in development, test, and production environments. This book serves as a comprehensive guide to the use of columnstore indexes and provides definitive guidelines. You will learn when columnstore indexes should be used, and the performance ga ...
Microsoft Blazor, 3rd EditionBuild web applications in C# and Microsoft .NET 6 that run in any modern browser and become a full-stack web developer!. Do all these things using the Microsoft Blazor framework and the techniques shown in this book. New in this edition is coverage of the new and improved Razor syntax, communication with the server using SignalR and/or gRPC, the use of virtualization to load large quantities of data efficiently, deployment and ahead-of-time compilation into WASM, new unit testing features, security using OpenID Connect, and more.
Reading this book helps you learn to build user interfaces and present data to a user for display and modification, capturing the user's changes via data binding. The book shows how to access a rich library of .NET functionality such as a component model for building a composable user interface, including how to develop reusable components that can be used across many pages and websites. Also covered is data exchange with a server using REST, ...
Pro Active Directory Certificate ServicesIn order to deploy and use Microsoft Certificate Services, you need to understand the fundamentals of cryptography, digital signatures, encryption, TLS, and S/MIME. It is also important to understand the concepts behind public key infrastructure (PKI). This book teaches you all the required background knowledge you need. Then it takes you deeper, step by step, teaching you how to deploy Certificate Services and configure it to issue various digital certificate types, complete with examples of using these certificates with IIS, Outlook, and Windows.
Microsoft-based networks - on-premises, hybrid, and cloud-based networks - are used in companies of all sizes. Within them, there are many applications of digital certificates that can be created and managed by Microsoft Certificate Services. As security is more important than ever, and cryptography and PKI are fundamental to so many of these defenses, understanding Microsoft Certificate Services is becoming an increa ...
Leadership in a Zoom Economy with Microsoft TeamsManage and lead a team remotely by intertwining leadership principles with the many robust tools of Microsoft Teams. This book shows you how to utilize Microsoft Teams in an effective way to achieve your global team goals.
Leading a team is a challenge, but leading a team in the zoom economy can make you stressed out and overworked. Peter Ward gives the reader a communication and organization centered approach for the dynamic, hardworking, successful employee who wants to step into a leadership role and vastly improve their organization with the aid of Microsoft Teams. Ward shares his own "rules" for successful leadership of teams and small companies, to scale at a steady pace, creating a culture of accountability and responsibility, with a remote workforce, not using venture capital, and applying minimal bureaucracy. Ward says teamwork, right hires, diversity, and work balance are equally important as profitability. Leadership in a Zoom Economy with Microsof ...
Pro Serverless Data Handling with Microsoft AzureDesign and build architectures on the Microsoft Azure platform specifically for data-driven and ETL applications. Modern cloud architectures rely on serverless components more than ever, and this book helps you identify those components of data-driven or ETL applications that can be tackled using the technologies available on the Azure platform. The book shows you which Azure components are best suited to form a strong foundation for data-driven applications in the Microsoft Azure Cloud.
If you are a solution architect or a decision maker, the conceptual aspects of this book will help you gain a deeper understanding of the underlying technology and its capabilities. You will understand how to develop using Azure Functions, Azure Data Factory, Logic Apps, and to employ serverless databases in your application to achieve the best scalability and design. If you are a developer, you will benefit from the hands-on approach used throughout this book. Many practical examples ...
Mastering the Microsoft KinectKnow how to program the Microsoft Kinect and use the device for applications that interact directly with humans through gestures and motion. This book covers the mathematics and theoretical background needed for depth sensing, motion tracking, and object recognition while maintaining a practical focus on getting things done. You will learn to track the human body in three-dimensional space, analyze the human motion, and remove the background to isolate the person being tracked. You will see how to recognize objects and voice, and transform between the three-dimensional physical space and a computer's two-dimensional screen.
The book is written with real-world applications in mind. It provides step-by-step tutorials and source code for common use cases. The author has worked with startups and Fortune 500 companies, and all of the examples are taken directly from the industry. The book's practical focus simplifies the core principles, removes the clutter, and allows developers ...
Practical Paint.NETLearn to use the most up-to-date version of Paint.NET, the free, Windows-based program for image editing. This book is ideal for PC users who find Microsoft Paint too lacking, and Photoshop or GIMP too overwhelming. ​Paint.NET is a lightweight yet capable program that's easy to navigate and is regularly updated.
You'll quickly become acquainted with this powerful, yet easy-to-learn program's features; tools, layers, adjustments, and effects. See how to correct exposure, digitally retouch and repair damaged photos, and handle a broad spectrum of photo editing tasks - even how to colorize a black-and-white image. You'll also learn how to create digital art using the Paint.NET drawing tools and effects. Practice files are provided with step-by-step instructions to jump into photo editing and art creation.
Practical Paint.NET highlights this powerful program's rich set of features and capabilities providing you the pathway for just about any kind of image editing. Join the ...
Extreme DAXThis book helps business analysts generate powerful and sophisticated analyses from their data using DAX and get the most out of Microsoft Business Intelligence tools.
Extreme DAX will first teach you the principles of business intelligence, good model design, and how DAX fits into it all. Then, you'll launch into detailed examples of DAX in real-world business scenarios such as inventory calculations, forecasting, intercompany business, and data security. At each step, senior DAX experts will walk you through the subtleties involved in working with Power BI models and common mistakes to look out for as you build advanced data aggregations.
You'll deepen your understanding of DAX functions, filters, and measures, and how and when they can be used to derive effective insights. You'll also be provided with PBIX files for each chapter, so that you can follow along and explore in your own time. ...
Microsoft Visual C# Step by Step, 10th EditionExpand your expertiseand teach yourself the fundamentals of programming the latest version of Visual C# with Visual Studio 2022. This book provides software developers all the guidance, exercises, and code needed to start building responsive, scalable, cloud-connected applications that can run almost anywhere.
Discover how to: Quickly start creating Visual C# code and projects with Visual Studio; Work with variables, operators, expressions, methods, and program flow; Build more robust apps with error, exception, and resource management; Spot problems fast with the integrated Visual Studio 2022 debugger; Master new default interface methods, static local functions, async disposable types, and other enhancements; Make the most of the C# object model, and create functional data structures; Leverage advanced properties, indexers, generics, and collection classes; Create Windows 11 apps that share data, collaborate, and use cloud services; Use lightweight records to build immutable ref ...
Microsoft Excel Formulas and FunctionsUse Excel 365 and Excel 2021 core features to build spreadsheets that solve business problems and deliver reliable answers. Drawing on his unsurpassed experience, Paul McFedries helps you make the most of formulas and functions, including recent improvements ranging from dynamic arrays to XLOOKUP and LET. McFedries step-by-step projects walk you through handling key tasks, from building timesheets to projecting cash flow and aging receivables. His practical examples and clear instructions demystify intermediate-to-advanced-level formula construction, and help you leverage Excels most useful functions in your everyday work.
By reading this book, you will: Improve business analyses by adding intelligence and knowledge to your models; Replace cumbersome formulas with convenient predefined functions; Use modern lookups to make your formulas more powerful and flexible; Simplify complex calculations with dynamic arrays in Excel 365 and Excel 2021; Use conditional formatting to reveal anom ...
Microsoft Excel VBA and MacrosUse this guide to automate virtually any routine Excel task: save yourself hours, days, maybe even weeks. Make Excel do things you thought were impossible, discover macro techniques you wont find anywhere else, and create automated reports that are amazingly powerful. Bill Jelen and Tracy Syrstad help you instantly visualize information to make it actionable; capture data from anywhere, and use it anywhere; and automate the best new features in Microsoft Excel. Youll find simple, step-by-step instructions, real-world case studies, and 50 workbooks packed with examples and complete, easy-to-adapt solutions.
By reading this book, you will: Quickly master Excel macro development; Work more efficiently with ranges, cells, and formulas; Generate automated reports and quickly adapt them for new requirements; Learn to automate PivotTables to summarize, analyze, explore, and present data; Leverage more of Excel VBAs power with classes, collections, and Advanced Filter; Make the most ...