by Elizabeth Noble
Design and write simple and efficient T-SQL code in SQL Server 2019 and beyond. Writing T-SQL that pulls back correct results can be challenging. This book provides the help you need in writing T-SQL that performs fast and is easy to maintain. You also will learn how to implement version control, testing, and deployment strategies. Hands-on examples show modern T-SQL practices and provide straightforward ex...
Price: $24.62 | Publisher: Apress | Release: 2020
SQL Server Data Automation Through Frameworks
by Andy Leonard, Kent Bradshaw
Learn to automate SQL Server operations using frameworks built from metadata-driven stored procedures and SQL Server Integration Services (SSIS). Bring all the power of Transact-SQL (T-SQL) and Microsoft .NET to bear on your repetitive data, data integration, and ETL processes. Do this for no added cost over what you've already spent on licensing SQL Server. The tools and methods from this book may be ...
Price: $37.99 | Publisher: Apress | Release: 2020
by Anthony Molinaro, Robert de Graaf
You may know SQL basics, but are you taking advantage of its expressive power? This second edition applies a highly practical approach to Structured Query Language (SQL) so you can create and manipulate large stores of data. Based on real-world examples, this updated cookbook provides a framework to help you construct solutions and executable examples in severalflavors of SQL, including Oracle, DB2, SQL Ser...
Price: $44.41 | Publisher: O'Reilly Media | Release: 2020
by Kevin Feasel
Harness the power of PolyBase data virtualization software to make data from a variety of sources easily accessible through SQL queries while using the T-SQL skills you already know and have mastered.PolyBase Revealed shows you how to use the PolyBase feature of SQL Server 2019 to integrate SQL Server with Azure Blob Storage, Apache Hadoop, other SQL Server instances, Oracle, Cosmos DB, Apache Spark, and mo...
Price: $21.73 | Publisher: Apress | Release: 2020
Hands On Google Cloud SQL and Cloud Spanner
by Navin Sabharwal, Shakuntala Gupta Edward
Discover the methodologies and best practices for getting started with Google Cloud Platform relational services - CloudSQL and CloudSpanner.The book begins with the basics of working with the Google Cloud Platform along with an introduction to the database technologies available for developers from Google Cloud. You'll then take an in-depth hands on journey into Google CloudSQL and CloudSpanner, inclu...
Price: $31.60 | Publisher: Apress | Release: 2020
by Kim Berg Hansen
Write powerful queries using as much of the feature-rich Oracle SQL language as possible, progressing beyond the simple queries of basic SQL as standardized in SQL-92.Both standard SQL and Oracle's own extensions to the language have progressed far over the decades in terms of how much you can work with your data in a single, albeit sometimes complex, SQL statement. If you already know the basics of SQ...
Price: $32.87 | Publisher: Apress | Release: 2020
Essential ASP.NET Web Forms Development
by Robert E. Beasley
Go from beginner to pro using one of the most effective and widely used technology stacks, Microsoft ASP.NET. Beginning with the basics, you will learn how to create interactive, professional-grade, database-driven web applications in no time, using ASP.NET, C#, SQL, Ajax, and JavaScript.Essential ASP.NET Web Forms Development is divided into six learning modules and will take you from soup to nuts with ASP...
Price: $31.72 | Publisher: Apress | Release: 2020
The SQL Server DBA's Guide to Docker Containers
by Edwin Sarmiento
Get introduced to the world of Docker containers from a SQL Server DBA's perspective. This book explains container technology and how it can improve the deployment of your SQL Server databases without infrastructure lock-in. You will be equipped with the right technical skills to guide stakeholders in your business as they adopt and adapt to new technologies to improve time-to-market and competitivenes...
Price: $32.99 | Publisher: Apress | Release: 2020
by Benjamin Weissman, Enrico van de Laar
Use this guide to one of SQL Server 2019's most impactful features - Big Data Clusters. You will learn about data virtualization and data lakes for this complete artificial intelligence (AI) and machine learning (ML) platform within the SQL Server database engine. You will know how to use Big Data Clusters to combine large volumes of streaming data for analysis along with data stored in a traditional d...
Price: $33.67 | Publisher: Apress | Release: 2020
SQL Server 2019 AlwaysOn, 3rd Edition
by Peter A. Carter
Get a fast start to using AlwaysOn, the SQL Server solution to high-availability and disaster recovery. This third edition is newly-updated to cover the 2019 editions of both SQL Server and Windows Server and includes strong coverage of implementing AlwaysOn Availability Groups on both Windows and Linux operating systems. The book provides a solid and accurate understanding of how to implement systems requi...
Price: $35.58 | Publisher: Apress | Release: 2020
