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

Don’t be afraid of No

By

How many times have you been afraid to hear “No”? We have all been...

Spark .NET - Spark ML TF-IDF

By

Spark ML in .NET for Apache Spark Spark is awesome, .NET is awesome, machine...

Daily Coping 7 Jul 2020

By

I’ve started to add a daily coping tip to the SQLServerCentral newsletter and to...

Read the latest Blogs

Forums

Adding a Calculated Column in R

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Adding a Calculated Column in...

Better Laptop Life

By Steve Jones - SSC Editor

Comments posted to this topic are about the item Better Laptop Life

First Time using SUBSTRING

By Bron Tamulis

Okay - I have a text field that i need to 'wildcard' search and...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers