Demystifying Continuous Integration vs. Continuous Delivery: Part 2

Welcome to part 2 of our Demystifying Continuous Integration vs. Continuous Delivery series.

Execute Stored Procedures in the Microsoft GraphQL API

This tip explores leveraging existing SQL Server stored procedures within the Microsoft GraphQL API.

Deciphering Data Architectures

Data fabric, data lakehouse, and data mesh have recently appeared as viable alternatives to the modern data warehouse. These new architectures have solid benefits, but they're also surrounded by a lot of hyperbole and confusion. This practical book provides a guided tour of these architectures to help data professionals understand the pros and cons of each.

• Printed book:
  • US
• Kindle book:
  • US

T-SQL Fundamentals

Master Transact-SQL's fundamentals, and write correct, robust code for querying and modifying data with modern Microsoft data technologies, including SQL Server 2022, Azure SQL Database, and Azure SQL Managed Instance.

• Printed book:
  • US
• Kindle book:
  • US

Transactions

By now, pretty much everyone has heard the stories about the first computers. They were huge, cost a fortune, required incredible amounts of air conditioning, and perhaps more importantly, ran batch jobs submitted on punched cards and magnetic tape. But even before we had these dinosaurs, there were E.A.M (electric accounting machine) units.

Should That Be One Update Statement or Multiple?

Let’s say we have a couple of update statements we need to run every 15 minutes in the Stack Overflow database, and we’ve built indexes to support them:

Explore Pandas in Python to Analyze and Manipulate Tabular Data

Learn how to use Pandas an open-source library for analyzing and manipulating tabular data in Python along with several examples.

Making Temporal Databases Work, Part 3: Saving Data

In part three of this series, Boris Novikov looks at how data is saved and modified in a temporal database and what kind of integrity constraints are needed for temporal tables. If you haven’t seen parts one and two, don’t worry! Links are provided in the article, and we recommend checking them out first.

Relationships with Microsoft Fabric GraphQL API

Learn how to join tables together when using the GraphQL API with Microsoft Fabric in this step-by-step article.

How Many Indexes Is Too Many?

Let’s start with the Stack Overflow database (any size will work), drop all the indexes on the Users table, and run a delete: