External Article

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.

External Article

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!

Blogs

Ways to land data into Fabric OneLake

By

Microsoft Fabric is rapidly gaining popularity as a unified data platform, leveraging OneLake as...

A Very Cool Benefit in SSMS 21

By

I saw a post from Erin that Preview 2 is available. I’d gotten a...

AI Helping with an API

By

Can an AI help me with some database API work? Let’s see. This is...

Read the latest Blogs

Forums

Copy a large table from one table to another

By shivaji

Hi, I have large table with 75 columns and 1.1 billion rows. Want to...

Topic marked as spam - by mistake?

By Phil Parkin

I received the following notification a few hours ago. It seems legit but has...

Getting blockage on Update Statement

By anshu.shikha

Hi, Need your help. I've a SP that is using Update statement on a...

Visit the forum

Question of the Day

The Hash Join III

In a hash join, if all the build input does not fit in memory, what type of hash join is this?

See possible answers