DDL

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

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

SQL Server Quick Tips

By

Earlier this year I made a series of videos that were played before the...

The 2019 State of DevOps Report–Webinar

By

Tomorrow I get to chat with another giant in the world of DevOps: Jez...

An Effective Solution to Resolve SQL Database Corruption

By

I am a SQL Administrator and today I will share my experience about an...

Read the latest Blogs

Forums

Is Data the Future of the Vibrant Web?

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Is Data the Future of...

Solve HASH MATCH in query plan

By Mauricio_

Hi, This is SQL Server 2016, by the way. I'm trying to optimize a...

Dynamic - Row Level Masking.

By koti.raavi

Hi, I have looked into Dynamic Data Masking and Row Level Security, Is there...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers