Listing 1 - 10 of 20 | << page >> |
Sort by
|
Choose an application
Leverage powerful features of the SQL Server and watch your infrastructure transform into a high-performing, reliable network of systems. Key Features Explore more than 20 real-world use cases to understand SQL Server features Get to grips with the SQL Server Always On technology Learn how to choose HA and DR topologies for your system Book Description Professional SQL Server High Availability and Disaster Recovery explains the high availability and disaster recovery technologies available in SQL Server: Replication, AlwaysOn, and Log Shipping. You'll learn what they are, how to monitor them, and how to troubleshoot any related problems. You will be introduced to the availability groups of AlwaysOn and learn how to configure them to extend your database mirroring. Through this book, you will be able to explore the technical implementations of high availability and disaster recovery technologies that you can use when you create a highly available infrastructure, including hybrid topologies. Note that this course does not cover SQL Server Failover Cluster Installation with shared storage. By the end of the book, you'll be equipped with all that you need to know to develop robust and high performance infrastructure. What you will learn Configure and troubleshoot Replication, AlwaysOn, and Log Shipping Study the best practices to implement HA and DR solutions Design HA and DR topologies for the SQL Server and study how to choose a topology for your environment Use T-SQL to configure replication, AlwaysOn, and log shipping Migrate from On-Premise SQL Server to Azure SQL Database Manage and maintain AlwaysOn availability groups for extended database mirroring Who this book is for Professional SQL Server High Availability and Disaster Recovery is for you if you are a database administrator or database developer who wants to improve the performance of your production environment. Prior experience of working with SQL Server will help you get the most out of this book.
Choose an application
Use Microsoft SQL Server 2019 to implement, administer, and secure a robust database solution that is disaster-proof and highly available Key Features Explore new features of SQL Server 2019 to set up, administer, and maintain your database solution successfully Develop a dynamic SQL Server environment and streamline big data pipelines Discover best practices for fixing performance issues, database access management, replication, and security Book Description SQL Server is one of the most popular relational database management systems developed by Microsoft. This second edition of the SQL Server Administrator's Guide will not only teach you how to administer an enterprise database, but also help you become proficient at managing and keeping the database available, secure, and stable. You'll start by learning how to set up your SQL Server and configure new and existing environments for optimal use. The book then takes you through designing aspects and delves into performance tuning by showing you how to use indexes effectively. You'll understand certain choices that need to be made about backups, implement security policy, and discover how to keep your environment healthy. Tools available for monitoring and managing a SQL Server database, including automating health reviews, performance checks, and much more, will also be discussed in detail. As you advance, the book covers essential topics such as migration, upgrading, and consolidation, along with the techniques that will help you when things go wrong. Once you've got to grips with integration with Azure and streamlining big data pipelines, you'll learn best practices from industry experts for maintaining a highly reliable database solution. Whether you are an administrator or are looking to get started with database administration, this SQL Server book will help you develop the skills you need to successfully create, design, and deploy database solutions. What you will learn Discover SQL Server 2019's new features and how to implement them Fix performance issues by optimizing queries and making use of indexes Design and use an optimal database management strategy Combine SQL Server 2019 with Azure and manage your solution using various automation techniques Implement efficient backup and recovery techniques in line with security policies Get to grips with migrating, upgrading, and consolidating with SQL Server Set up an AlwaysOn-enabled stable and fast SQL Server 2019 environment Understand ...
Choose an application
Database management. --- SQL server. --- Linux.
Choose an application
Whether it is learning different techniques to monitor and tune an Azure SQL database or improving performance using in-memory technology, this book will enable you to make the most out of Azure SQL database features and functionality for data management solutions.
Microsoft Azure (Computing platform) --- Database management. --- SQL server.
Choose an application
Over 80 effective recipes to help you solve real-world Microsoft Dynamics 365 for Finance and Operations development problems About This Book Learn all about the enhanced functionalities of Dynamics 365 for Finance and Operations and master development best practices Develop powerful projects using new tools and features Work through easy-to-understand recipes with step-by-step instructions and useful screenshots Who This Book Is For If you are a Dynamics AX developer primarily focused on delivering time-proven applications, then this book is for you. This book is also ideal for people who want to raise their programming skills above the beginner level, and at the same time learn the functional aspects of Dynamics 365 for Finance and Operations. Some X++ coding experience is expected. What You Will Learn Explore data manipulation concepts in Dynamics 365 for Operations Build scripts to assist data migration processes Organize data in Dynamics 365 for Operations forms Make custom lookups using AOT forms and dynamically generate them from X++ code Create a custom electronic payment format and process a vendor payment using it Integrate your application with Microsoft Office Suite and other external systems using various approaches Export and import business data for further distribution or analysis Improve your development efficiency and performance In Detail Microsoft Dynamics 365 for Finance and Operations has a lot to offer developers. It allows them to customize and tailor their implementations to meet their organization's needs. This Development Cookbook will help you manage your company or customer ERP information and operations efficiently. We start off by exploring the concept of data manipulation in Dynamics 365 for Operations. This will also help you build scripts to assist data migration, and show you how to organize data in forms. You will learn how to create custom lookups using Application Object Tree forms and generate them dynamically. We will also show you how you can enhance your application by using advanced form controls, and integrate your system with other external systems. We will help you script and enhance your user interface using UI elements. This book will help you look at application development from a business process perspective, and develop enhanced ERP solutions by learning and implementing the best practices and techniques. Style and approach The book follows a practical recipe-based approach, focusing on real-w...
Business logistics --- Data processing. --- Microsoft Dynamics AX. --- SQL server.
Choose an application
Database professionals will find that this new edition aids in mastering the latest version of Microsoft's SQL Server. Developers and database administrators (DBAs) use SQL on a daily basis in application development and the subsequent problem solving and fine tuning. Answers to SQL issues can be quickly located helping the DBA or developer optimize and tune a database to maximum efficiency.Basic questions are easily located on the topics of filtering, sorting, operators, conditionals, pseudo columns, single row functions, joins, grouping functions, sub queries, composite queries, hier
Client/server computing. --- Relational databases. --- SQL server. --- Relational data bases --- Computing, Client/server --- Microsoft SQL server --- Databases --- Electronic data processing --- Distributed processing --- Information Technology --- General and Others
Choose an application
SQL server is the most widely used database platform in the world, and a large percentage of these databases are not properly secured, exposing sensitive customer and business data to attack. In Securing SQL Server, 2e, readers learn about the potential attack vectors that can be used to break into SQL server databases as well as how to protect databases from these attacks. In this book written by Denny Cherry, a Microsoft SQL MVP and one of the biggest names in SQL server today, readers learn how to properly secure a SQL server database from internal and external threats using best practi
Database security. --- SQL server. --- Client/server computing. --- Computer security. --- Information Technology --- General and Others --- Data base security --- Databases --- Computer security --- Security measures --- Microsoft SQL server
Choose an application
Exchange, SQL and IIS are at the core of most Microsoft enterprise servers. The 2007 releases of these products, along with the release of Windows Vista and Windows 2008 Server, represents the biggest overhaul of Windows enterprise products since Windows 2000. The dramatic changes to security tools and the addition of features that support ""anywhere access"" present IT professionals with a steep learning curve. Making certain that these products are configured to meet regulatory compliance requirements adds additionally complexity to day-to-day management network management.The Best Dam
Choose an application
This book is intended for developers, testers, architects, and project managers who want to explore and make use of the reporting facilities of Team Foundation Server 2013. Although no previous experience of reporting is required, a basic understanding of the Team Foundation Components and project templates would be a plus.
Choose an application
Microsoft Data Mining approaches data mining from the particular perspective of IT professionals using Microsoft data management technologies. The author explains the new data mining capabilities in Microsoft's SQL Server 2000 database, Commerce Server, and other products, details the Microsoft OLE DB for Data Mining standard, and gives readers best practices for using all of them. The book bridges the previously specialized field of data mining with the new technologies and methods that are quickly making it an important mainstream tool for companies of all sizes.Data mining refers t
Data mining. --- OLE (Computer file) --- SQL server. --- Algorithmic knowledge discovery --- Factual data analysis --- KDD (Information retrieval) --- Knowledge discovery in data --- Knowledge discovery in databases --- Mining, Data --- Microsoft SQL server --- Database searching --- Data mining --- E-books
Listing 1 - 10 of 20 | << page >> |
Sort by
|