DDL

External Article

Auditing DDL Changes in SQL Server databases

  • Article

Even where Source Control isn't being used by developers, it is still possible to automate the process of tracking the changes being made to a database and put those into Source Control, in order to track what changed and when. You can even get an email alert when it happens. With suitable scripting, you can even do it if you don't have direct access to the live database. Grant shows how easy this is with SQL Compare.

2011-10-20

2,823 reads

External Article

SQL Server 2008 and 2008 R2 Integration Services - Analysis Services Execute DDL Task

  • Article

The term DDL designates Data Definition Language, which implies an action involving creating data structures. In the context of Analysis Services Execute DDL Task, this is a bit of a misnomer because its capabilities are much more diverse, extending to such areas as backups, restores, deletions, modifications, or processing. This is accomplished by employing Analysis Services Scripting Language (ASSL).

2011-09-07

2,257 reads

Blogs

Speaking at the NYC Lunch and Learn DevOps Devour Hour

By

This Friday is the NYC DevOps Devour hour, which is actually 3 hours. Plus...

What’s new in SQL Server 2025 CTP 2.0

By

Three years ago, when the first public preview of SQL Server 2022 (CTP 2.0)...

Monday Monitor Tips: Beyond SQL Server

By

Redgate Monitor works with more than SQL Server. Some big changes were announced recently,...

Read the latest Blogs

Forums

SQL 2022 upgrade issues

By Lapchien

We're about to upgrade our SQL 2017 Standard to 2022 standard.  We have 1...

Script-Drop Orphan users from SQL Server Database

By Srinivas Merugu

Comments posted to this topic are about the item Script-Drop Orphan users from SQL...

The Hidden Cost of Ignoring Software Bugs

By danishtariq1

Every expert knows you can't make perfect software that never crashes or has bugs....

Visit the forum

Question of the Day

The Minimal Linked Server

What is the minimal number of parameters to add a linked server with sp_addlinkedserver?

See possible answers