DDL

SQL commands in SQL Server

November 22, 2021 by Daniel Calbimonte

Introduction

If you are here, it means that you want to learn the SQL commands. This article applies to SQL Server especially, but most of the theory is similar to Oracle, MySQL, MariaDB, PostgreSQL, and other databases. The SQL commands are instructions that we send to the database to get information, manipulate the information or create objects, modify them, and handle the access to the information.

DDL triggers in Azure SQL Database

July 28, 2021 by Rajendra Gupta

This article explores database DDL triggers for auditing Data Definition Language (DDL) on Azure SQL Database.

What is a foreign key in SQL Server

February 13, 2020 by Esat Erkec

In this article, we will seek an answer to an important question – “What is a foreign key in SQL Server?”. At the same time, we will give some seconder answers to this question. In this way, we can understand the foreign key concept more clearly.

SQL DDL: Getting started with SQL DDL commands in SQL Server

November 8, 2019 by Ben Richardson

This article explains SQL DDL commands in Microsoft SQL Server using a few simple examples.

Database Level DDL Triggers for Views, Procedures and Functions

October 4, 2019 by Jignesh Raiyani

In this article, we will un-riddle the ways to make use of the data definition language trigger (DDL Trigger), in order to monitor the progressions made to the database programming objects, View, Procedure or Function with a few real-time examples.

Database Level DDL Triggers on Tables

September 23, 2019 by Jignesh Raiyani

This article portrays the different utilization of database DDL Triggers for the Tables with a counting mail alert on schema composition using DDL (Data Definition Language) standard. Using that efficient method we can keep close eyes on monitoring schema changes in any database of SQL Server. We’ll also see how we could monitor these movements and send an alert email to persons responsible to inform about this change.

SQL Server FILESTREAM queries and Filegroups

February 1, 2019 by Rajendra Gupta

In this series of the SQL Server FILESTREAM (see TOC at bottom), We have gone through various aspects of this feature to store large size objects into the file systems.

What is SQL in SQL Server?

December 5, 2018 by Prashanth Jayaram

What is SQL, in the context of SQL Server, is a common question asked by beginners. This article is meant to answer that question, while providing some history, context and an overview of the fundamentals of the language Read more »

How to set up a DDL and DML SQL Server database transactional replication solution

August 22, 2018 by Prashanth Jayaram

In the article How to setup SQL Server database replication for reporting Server we discussed all about setting up a simple SQL Server transactional replication environment. In this article, we’ll simulate a more robust system that replicates faster and includes both DDL and DML statements. We’ll walk-through the steps to setup a dynamic transactional replication.