Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Articles with tag DDL Rss

Search for any content tagged ddl

   Items 1 to 6 of 6   
 

Leveraging Constraint Evaluation Sequence in SQL Server

Constraints on a table in SQL Server are evaluated in a specific sequence. Knowing this sequence can help us leverage them to realize various business requirements.  Read more...
By Nakul Vachhrajani 2014/01/27 | Source: SQLServerCentral.com | Category: sql server
Rating: |  Discuss |   Briefcase | 2,608 reads

When Windows don’t provide illumination

Microsoft through its various GUIs tries hard to "protect" users from SQL, but Phil Factor argues that we don't need protection from code. We just need a better way to "document" the syntax.  Read more...
By Phil Factor 2013/06/10 | Source: SQLServerCentral.com | Category: editorial
Rating: |  Discuss |   Briefcase | 129 reads

Auditing DDL Changes in SQL Server databases

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.  Read more...
By Additional Articles 2011/10/20 | Source: SimpleTalk | Category: ddl
Rating: (not yet rated)  Rate this |   Briefcase | 2,259 reads

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

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).  Read more...
By Additional Articles 2011/09/07 | Source: Database Journal | Category: ddl
Rating: (not yet rated)  Rate this |   Briefcase | 1,763 reads

SQL 2008 & 2005 DDL Auditing - Full Server Self Maintaining Solution

DDL triggers enable us to audit DDL changes but there are a few missing events, design decisions and installation complications.  Read more...
By Sean Elliott 2010/08/17 | Source: SQLServerCentral.com | Category: ddl
Rating: |  Discuss |   Briefcase | 7,205 reads

Auditing with SQL Profiler

Complete package to allow tracking of any data that Profiler can capture and storage for auditing purposes, use to satisfy SOX compliance.  Read more...
By Thom Bolin 2009/07/16 | Source: SQLServerCentral.com | Category: auditing
Rating: |  Discuss |   Briefcase | 5,593 reads
   Items 1 to 6 of 6