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

Azure Service Logging in the Modern Data Warehouse

By

[read this post on Mr. Fox SQL blog] The “modern data platform” architecture is...

Power Platform Conference – 7/23-24/2019

By

Pragmatic Works is hosting a 2-day Power Platform online conference. If you are unable...

Learning more Kubernetes

By

I’ve been slowly working my way through the 50 days of Kubernetes (K8s). As...

Read the latest Blogs

Forums

The AI Manager

By Steve Jones - SSC Editor

Comments posted to this topic are about the item The AI Manager

SSIS Scale-out Manager don´t show status of any Workers

By Jenda

Why does my SSIS Scale-out manager on my master server not show the status...

Dynamic count of days between start and end in MDX

By TroelsHJ

Hi Guys! Long time reader – first timer poster. Hoping someone can aid me...

Visit the forum

Ask SSC

SQL Server Q&A from the SQLServerCentral community

Get answers