by Edward Pollack
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 larg...
Price: $30.40 | Publisher: Apress | Release: 2019
FREE EBOOK - Learning Microsoft SQL Server
by Stack Overflow Community
Microsoft SQL Server is a relational database management system developed by Microsoft. It is an unofficial and free Microsoft SQL Server ebook created for educational purposes. All the content is extracted from Stack Overflow Documentation, which is written by many hardworking individuals at Stack Overflow....
Publisher: Self-publishing | Release: 2019
FREE EBOOK - SQL Server Metadata Succinctly
by Joseph D. Booth
SQL Server is a very complex and powerful product, but it provides tremendous amounts of data about itself. You can use this metadata to improve your database design, increase performance, review security, and more. Joseph D. Booth will show readers sample scripts and queries using information schema views as well as SQL Server-specific views in SQL Server Metadata Succinctly....
Publisher: Syncfusion | Release: 2019
T-SQL Window Functions, 2nd Edition 
by Itzik Ben-Gan
Most T-SQL developers recognize the value of window functions for data analysis calculations. But they can do far more, and recent optimizations make them even more powerful. In T-SQL Window Functions, renowned T-SQL expert Itzik Ben-Gan introduces breakthrough techniques for using them to handle many common T-SQL querying tasks with unprecedented elegance and power. Using extensive code examples, he guides...
Price: $17.27 | Publisher: Microsoft Press | Release: 2019
by Jon Heller
Write SQL statements that are more powerful, simpler, and faster using Oracle SQL and its full range of features. This book provides a clearer way of thinking about SQL by building sets, and provides practical advice for using complex features while avoiding anti-patterns that lead to poor performance and wrong results. Relevant theories, real-world best practices, and style guidelines help you get the most...
Price: $27.10 | Publisher: Apress | Release: 2019
by Philip Seamark, Thomas Martens
Learn the intricate workings of DAX and the mechanics that are necessary to solve advanced Power BI challenges. This book is all about DAX (Data Analysis Expressions), the formula language used in Power BI—Microsoft's leading self-service business intelligence application—and covers other products such as PowerPivot and SQL Server Analysis Services Tabular. You will learn how to leverage the advanc...
Price: $30.08 | Publisher: Apress | Release: 2019
Beginning Database Programming Using ASP.NET Core 3
by Bipin Joshi
Hit the ground running with this book to quickly learn the fundamentals of HTML form processing, user authentication, and database CRUD (Create, Read, Update, and Delete) operations using the ASP.NET Core family of technologies. You will utilize cutting-edge and popular technology options from both the server side and client side to help you achieve your web application goals as quickly as possible.Develope...
Price: $26.90 | Publisher: Apress | Release: 2019
The Definitive Guide to DAX, 2nd Edition
by Marco Russo, Alberto Ferrari
Now expanded and updated with modern best practices, this is the most complete guide to Microsoft's DAX language for business intelligence, data modeling, and analytics. Expert Microsoft BI consultants Marco Russo and Alberto Ferrari help you master everything from table functions through advanced code and model optimization. You'll learn exactly what happens under the hood when you run a DAX expr...
Price: $33.30 | Publisher: Microsoft Press | Release: 2019
by Stack Overflow Community
Data in the world started to grow tremendously after mobile application came in the market. This huge amount of data became almost impossible to handle with traditional relational database - SQL. NoSQL databases are introduced to handle those data where much more flexibility came like variable number of columns for each data. MongoDB is one of the leading NoSQL databases. Each collection contains a number o...
Publisher: Self-publishing | Release: 2019
Hardening Azure Applications, 2nd Edition
by Suren Machiraju, Suraj Gaurav
Build large-scale, mission-critical hardened applications on the Azure cloud platform. This 2nd edition provides information on the newer features in Azure, such as Linux extensions and supporting Azure Services such as HDInsight and SQL Server on Linux. Updated with new applications Hardening Azure Applications also discusses Scale Sets (VMSS), a major upgrade that enables autoscaling and seamlessly makes ...
Price: $29.50 | Publisher: Apress | Release: 2019
