Foreword Advanced computing technologies have allowed businesses, governments, academia, and other organizations to greatly improve and expand their use of information to enhance the ability to achieve their goals. However, with expanded use of data comes an expansion of data processing...
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...
Leverage the features of Azure SQL database and become an expert in data management Key Features * Explore ways to create shards and elastic pools to scale Azure SQL databases * Automate common management tasks with PowerShell * Implement over 40 practical activities and...
Learn how to combine SQL Server's analytics with Azure's flexibility and hybrid connectivity to achieve industry-leading performance and manageability for your cloud database. Key Features * Understand platform availability for SQL Server in Azure * Explore the benefits...
Leverage the power of SQL Server 2017 Integration Services to build data integration solutions with ease Key Features * Work with temporal tables to access information stored in a table at any time * Get familiar with the latest features in SQL Server 2017 Integration...
Bring the performance and security of SQL Server to Linux About This Book • Design and administer your SQL Server solution on the open source Linux platform • Install, configure, and fine-tune your database application for maximum performance • An easy-to-follow...
Explore the impressive storage and analytic tools available with the in-cloud and on-premises versions of Microsoft SQL Server 2019. Key Features * Gain insights into what's new in SQL Server 2019 * Understand use cases and customer scenarios that can be implemented with...
"Implement and administer successful database solution with SQL Server 2017 About This Book • Master the required skills to successfully set up, administer, and maintain your SQL Server 2017 database solution • Design and configure, manage, and secure a...
Build smarter and efficient database application systems for your organization with SQL Server 2017 About This Book • Build database applications by using the development features of SQL Server 2017 • Work with temporal tables to get information stored in a...
Troubleshoot query performance issues, identify anti-patterns in code, and write efficient T-SQL queries Key Features * Discover T-SQL functionalities and services that help you interact with relational databases * Understand the roles, tasks and responsibilities of a...
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...
Get up to speed with the new features added to Microsoft SQL Server 2019 Analysis Services and create models to support your businessKey Features* Explore tips and tricks to design, develop, and optimize end-to-end data analytics solutions using Microsoft's technologies* Learn tabular...
It is a major challenge to migrate very large databases from one system, say for example, to transfer critical data from Oracle to SQL Server. One has to consider several issues such as loss of data being transferred, the security of the data, the cost and effort, technical...
The latest on SQL databases SQL All -In-One For Dummies, 3rd Edition, is a one-stop shop for everything you need to know about SQL and SQL-based relational databases. Everyone from database administrators to application programmers and the people who...
Each recipe comprises step-by-step instructions followed by an analysis of what was done in each task and other useful information. The book is designed so that you can read it chapter by chapter, or look at the list of recipes and refer to them in no particular order. Each example comes with its...
This book is an easy-to-follow, comprehensive guide that is full of hands-on examples, which you can follow to successfully design, build, and deploy mission-critical database applications with SQL Server 2014. If you are a database developer, architect, or administrator...
This part of International Standard ISO/IEC 9075 specifies the syntax and semantics of a database language for declaring and maintaining persistent database language routines in SQL-server modules. The database language for s and <SQL-invoked routine>s...
Get unique insights from your data by combining the power of SQL Server, R and Python Key Features *Use the features of SQL Server 2017 to implement the data science project life cycle *Leverage the power of R and Python to design and develop efficient data models *find...
Narrow Your Results