Data Control Language (aka Security)

Like ancient Gaul, SQL is divided into three sub- languages. The DDL (Data Declaration Language) declares the data. This is where we find the data types, constraints, references and other structures that have to do with how the data stored . The DML (Data Manipulation Language) uses those declarations to change their contents or to invoke them. It does not change structures and schema objects.

The Data Center that Exploded

A while back, in a Simple-Talk editorial meeting, someone bet Phil Factor that he couldn't come up with a Halloween story. To our surprise he said he could, as long as he didn't have to keep to the strict literal truth. In the end, he came up with a story about a story, and it is true that he first told the story in a data Centre at Halloween!

SQL IS NULL and SQL IS NOT NULL Examples

This article looks at how to use SQL IS NULL and SQL IS NOT NULL operations in SQL Server along with use cases and working with NULL values.

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.