Dynamic SQL, 2nd Edition
Take a deep dive into the many uses of dynamic SQL in Microsoft SQL Server. This edition has been updated to use the newest features in SQL Server 2016 and SQL Server 2017 as well as incorporating the changing landscape of analytics and database administration. Code examples have been updated with new system objects and functions to improve efficiency and maintainability.
Executing dynamic SQL is key to large-scale searching based on user-entered criteria. Dynamic SQL can generate lists of values and even code with minimal impact on performance. Dynamic SQL enables dynamic pivoting of data for business intelligence solutions as well as customizing of database objects. Yet dynamic SQL is feared by many due to concerns over SQL injection or code maintainability.
Dynamic SQL: Applications, Performance, and Security in Microsoft SQL Server helps you bring the productivity and user-satisfaction of flexible and responsive applications to your organization safely and secu ...
Developing Bots with QnA Maker Service
Learn to develop bots with zero coding knowledge using the Azure Cognitive QnA Maker service, a GUI cognitive service from Microsoft. This book shows you how to integrate QnA Maker with the Azure Bot Service and Microsoft Bot Framework, along with how to integrate your bot with social channels such as Web Chat, and Telegram.
You will learn what QnA Maker is, why you should use this service in enterprise settings, when you should use this service, and how you should use the service. Developing Bots with QnA Maker Service takes you through the QnA Maker FAQ knowledge base with Azure Bot Service, where you will discover how to get started with a web app bot using the Azure portal. This section culminates in deploying your bot on Azure Web App, making your bot live.
Next, you will learn QnA Maker with the .NET Framework and Visual Studio 2017 along with ways to manage QnA Maker service post deployment. Finally, you will learn how to add media content including videos and image ...
Implementing Microsoft Dynamics 365 Business Central On-Premise, 4th Edition
Microsoft Dynamics Business Central is a full business solution suite and a complete ERP solution, which contains a robust set of development tools; these tools can help you to gain control over your business and can simplify supply chains, manufacturing, and operations. Implementing Microsoft Dynamics 365 Business Central On-Premise covers the latest features of Dynamics Business Central and NAV from the end users' and developers' perspectives. It also provides an insight into different tools available for implementation, whether it's a new installation or migrating from the previous version of Dynamics NAV.
This book will take you from an introduction to Dynamics NAV 2018 through to exploring all the techniques related to implementation and migration. You will also learn to expand functionalities within your existing Microsoft Dynamics NAV installation, perform data analysis, and implement free third-party add-ons to your existing installation. As you progress ...
Pro Power BI Architecture
Architect and deploy a Power BI solution. This book will help you understand the many available options and choose the best combination for hosting, developing, sharing, and deploying a Power BI solution within your organization.
Pro Power BI Architecture provides detailed examples and explains the different methods available for sharing and securing Power BI content so that only intended recipients can see it. Commonly encountered problems you will learn to handle include content unexpectedly changing while users are in the process of creating reports and building analysis, methods of sharing analyses that don't cover all the requirements of your business or organization, and inconsistent security models.
The knowledge provided in this book will allow you to choose an architecture and deployment model that suits the needs of your organization, ensuring that you do not spend your time maintaining your solution but on using it for its intended purpose and gaining business value fr ...
Pro Microsoft Hyper-V 2019
Successfully create and manage your Hyper-V environment without any of the marketing fluff. This book's lab-driven, hands-on approach will get you up and running as quickly and efficiently as possible.
Virtualization is the cornerstone of today's data center. As a modern-day IT pro, you are required to manage environments that are in a regular state of flux and increasing in both size and complexity. To keep up, you need practical information in a format that is succinct, yet comprehensive and highly applicable.
Pro Hyper-V 2019 breaks down critical and time-saving topics into a series of easy-to-digest chapters, showing you how to perform Hyper-V management tasks using both GUI and PowerShell-based tools. Building on your existing knowledge of Windows Server management, Active Directory, networking, and storage, experts and Microsoft MVPs Syrewicze and Siddaway begin with a foundation of why computing workloads are virtualized. This is followed by chapters covering the ran ...
Office 2019 For Dummies
The world's leading suite of business productivity software, Microsoft Office helps users complete common business tasks, including word processing, email, presentations, data management and analysis, and much more. Whether you need accessible instruction on Word, Excel, PowerPoint, Outlook, or Access - or all of the above - this handy reference makes it easier.
In Office X For Dummies, you'll get help with typing and formatting text in Word, creating and navigating an Excel spreadsheet, creating a powerful PowerPoint presentation, adding color, pictures, and sound to a presentation, configuring email with Outlook, designing an Access database, and more. Information is presented in the straightforward but fun language that has defined the Dummies series for more than twenty years.
Get insight into common tasks and advanced tools; Find full coverage of each application in the suite; Benefit from updated information based on the newest software release; Make your work life ...
Word 2019 For Dummies
Whether you've used older versions of this popular program or have never processed a single word, this hands-on guide gets you going with the latest version of Microsoft Word. In no time, you'll begin editing, formatting, proofing, and dressing up your Word documents like a pro.
In this leading book about the world's number one word processing application, Dan Gookin talks about using Microsoft Word in friendly, easy-to-follow terms. Focusing on the needs of the beginning Word user, it provides everything you need to know about Word - without any painful jargon.
Covers the new and improved features found in the latest version of Word; Create your own templates; Explains why you can't always trust the spell checker; Offers little-known keyboard shortcuts.
If you're new to Word and want to spend more time on your actual work rather than figuring out how to make it work for you, this new edition of Word X For Dummies has you covered. ...
Microsoft Dynamics 365 For Dummies
It's no secret that running a business involves several complex parts like managing staff, financials, marketing, and operations - just to name a few. That's where Microsoft Dynamics 365, the most profitable business management tool, comes in.
In Microsoft Dynamics 365 For Dummies, you'll learn the aspects of the program and each of its applications from Customer Service to Financial Management. With expert author Renato Bellu's clear instructions and helpful tips, you'll be managing to your fullest advantage before you know it. Let's get started!
Digitally transform your business by connecting CRM and ERP; Use data to make decisions across all business functions; Integrate Dynamics 365 with Office 365 and LinkedIn; Manage financials and operations.
Are you running a dynamic business? This book shows you how! ...
Microsoft Excel 2019 Inside Out
Dive into Microsoft Excel 2019 - and really put your spreadsheet expertise to work. This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to make the most of Excel's most powerful tools for analyzing data and making better decisions. Renowned Excel expert Bill Jelen offers a complete tour of Excel 2019 and Excel in Office 365, from efficient interface customizations to advanced analysis, visualizations, and dashboards. Discover how experts tackle today's key tasks - and challenge yourself to new levels of mastery.
Enter formulas more efficiently, and fully control operators and dates; Master the most widely-used functions in Excel; Integrate external data from the web and other sources; Easily transform complex datasets with Power Query; Quickly summarize millions of records with Pivot Tables; Perform ad hoc analyses with slicers and other filters; Create advanced data mashups with Power Pivot; Solve complex problems w ...
Microsoft Office 2019 Inside Out
Dive into Microsoft Office 2019 - and really put its productivity toolsand services to work! This supremely organized reference packs hundreds of timesaving solutions, tips, and workarounds - all you need to make the most of Office's most powerful tools for productivity and decision-making. Renowned Office expert Joe Habraken offers a complete tour of Office 2019 and Office 365, with cutting-edge techniques and shortcuts for Word, Excel, PowerPoint, Outlook, Publisher, online Office apps, and more. Discover how experts tackle today's key tasks - and challenge yourself to new levels of mastery.
Create amazing content faster with Office's new features, tools, and shortcuts; Share, collaborate with, and secure Office files in the cloud; Organize, edit, and format complex documents with Microsoft Word; Build tables of contents, captions, indexes, and footnotes that automatically update; Efficiently enter and manage data in Excel workbooks, and format it for easy understand ...
Microsoft Power BI Dashboards Step by Step
Expand your expertise - and teach yourself how to create world-class Power BI business analysis dashboards that bring data to life for better decision-making. If you're an experienced business intelligence professional or manager, you'll get all the guidance, examples, and code you need to succeed - even if you've never used Power BI before.
Successfully design, architect, and implement Power BI in your organization; Take full advantage of any Microsoft Power BI platform, including Power BI Premium; Make upfront decisions that position your Power BI project for success; Build rich, live dashboards to monitor crucial data from across your organization; Aggregate data and data elements from numerous internal and external data sources; Develop dynamic visualizations, including charts, maps, and graphs; Bring data to life with stunning interactive reports; Ensure dashboard security and compliance; Drive user adoption through effective training. ...