Pro SQL Server Internals 2-Ed. D. Korotkevitch

The book is logically separated into eight different parts. Even though all of these parts are relatively independent of each other, I would encourage you to start with Part I, “Tables and Indexes,” anyway. This part explains how SQL Server stores and works with data, which is the key point in understanding SQL Server Internals. The other parts of the book rely on this understanding.

Приветствуем учебный понедельник! 🤟

Pro SQL Server 2012 Relational Database Design and Implementation. L. Davidson

This book is written for professional programmers who have the need to design a relational database using any of the Microsoft SQL Server family of databases. It is intended to be useful for the beginner to advanced programmer, either strictly database programmers or a programmer that has never used a relational database product before to learn why relational databases are designed in the way they are, and get some practical examples and advice for creating databases. Topics covered cater to the uninitiated to the experienced architect to learn techniques for concurrency, data protection, performance tuning, dimensional design, and more.

Вместо 🍻, держите 📚, потому что только среда!

Defensive Database Programming with SQL Server. A. Kuznetsov

This book describes a lot of specific problems, and typical approaches that will lead to more robust code, However, my main goal is more general: it is to demonstrate how to think defensively, and how to proactively identify and eliminate potential vulnerabilities in T-SQL code during development rather than after the event when the problems have already occurred.
The book breaks down into ten chapters, as described below. Eight of these chapters are available in this free eBook version; the final two chapters are included in paid versions only.

🤩А вот теперь можно!

Сразу после сохранения учебника по SQL!

SQL Server 2017 Integration Services Cookbook. Cote C., Lah M., Sarka D.

SQL Server Integration Services is a tool that facilitates data extraction, consolidation, and loading options (ETL), SQL Server coding enhancements, data warehousing, and customizations. With the help of the recipes in this book, you'll gain hands-on experience of SSIS 2017 as well as the new 2016 features, design and development improvements including SCD, tuning, and customizations.

Входим в понедельник очень позитивно🥲🥲🥲

Mastering PostgreSQL in Application Development. Fontaine Dimitri

The book covers the following topics:
✔ write SQL queries to PostgreSQL DBMS;
✔ PostgreSQL tools;
✔ data type;
✔ data management;
✔ parallel control.

Advantages:
➕ relevant material on the topic;
➕ numerous examples.

PostGIS in Action. R. O. Obe, L. S. Hsu

Post GIS (pronounced post-jis) is a spatial database extender for the PostgreSQL open source relational database management system. It’s the most powerful open source spatial database engine. It adds to P ostgre SQL several spatial data types and over 300 functions for working with these spatial types.

УРАААА!!!
*бросает шапку вверх*

ВЫХОДНЫЕЕЕЕ)

NoSQL for Mere Mortals. Dan Sullivan

The purpose of this book is to help someone with an interest in data to use NoSQL databases to help solve problems. The book is built on the assumption that the reader is not a seasoned database professional. If you are comfortable working with Excel, then you are ready for the topics covered in this book.

😸Приветики-пистолетики!

PostgreSQL High Availability Cookbook, 2nd Edition. Shaun Thomas

Welcome to the PostgreSQL 9 High Availability Cookbook! As a database engine, PostgreSQL is settling into its place as a reliable bastion of high-transaction rates and very large data installations. DB-Engines recently listed PostgreSQL as the third most popular database software in the world! With such notoriety comes increasing demand for PostgreSQL to act as a critical piece of infrastructure. System outages in these environments can be spectacularly costly and require a higher caliber of management and tooling.
It is the job of a DBA to ensure that the database is always available for application demands and client needs.