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

Daily Coping 24 Sept 2021

By

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

Using environment variable files for SQL Server in containers

By

There are a whole bunch of environment variables that can be used to configure...

How to Design Backups in SQL Server?

By

The Recovery Point Objective (RPO) and Recovery Time Objective (RTO) are basic concepts related...

Read the latest Blogs

Forums

Starting a career in cloud computing

By WojinRina

Hello, As the title says, might you have any advice to starting a career...

AWS S3 Questions

By lucasPeni

Hi all, Just starting out with AWS and had a few questions.. What are...

Volunteer For Something

By Grant Fritchey

Comments posted to this topic are about the item Volunteer For Something

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers