Implement DDL Triggers [!INCLUDE SQL Server Azure SQL Database Azure SQL Managed Instance] This topic provides information to help you create DDL triggers, modify DDL triggers, and disable or drop DDL ...

I created a new database here. I applied functions, ddl, dml, orderby, groupby ,joins,user defined function,stored procedure,trigger themes on the database I created.

You want to audit various DDL events and maintain a track of who is creating, altering and dropping various database objects and when. Create a table for maintaining your audit records and insert ...

India are primarily 2000 and 2005, and in a few cases, 2008. The move from Microsoft SQL Server 2000 to 2005 was a big leap with many new functionalities and features introduced. The concept of DDL ...

In this post, I want to cover how you can create a dacpac for SQL Server 2022 databases using sqlpackage. So that you keep the new SQL Server 2022 compatibility level when you deploy new databases.

Learn how to use the Azure Portal to create a cloud-based SQL database with just a few mouse clicks.