WebProfIT Consulting
  • Home
  • Cloud
  • SQL
  • Big Data
  • Contact Us
  • RSS

Categories

  • AWS (1)
  • Big Data (1)
  • Cloud (1)
  • SQL (4)
    • Microsoft SQL Server (3)
  • Tips and Tricks (2)
  • Tutorials (1)

Recent Comments

    • Home
    • Tag: INSERT

    Posts tagged INSERT

    Using a DDL trigger to control and automate history of data changes

    2016-09-03 Leave a Comment Written by Pavel Danilov
    Time Capsule - Sony tape recorders

    Summary: DDL trigger does all the magic of automatic support of historical data, all you need is to run the script against your database (once). After that you can turn history on tables on, off, or pause it. It will keep audit of all schema changes in your database and automatically generate DML triggers on […]

    Read More
    Big Data, Microsoft SQL Server, SQL
    backup, COMMIT, DDL, DDL trigger, DML trigger, Excel, IDENTITY column, INDEX, INSERT, management, Microsoft, Microsoft SQL server, primary key, React, replication, SQL, SQL Server, trigger, XML

    Recent Posts

    • How to shrink size of Linux EBS volume in AWS
    • Data Normalization
    • Renaming Primary Keys to Standard
    • INCLUDE Clause in Non-clustered Indexes
    • Using a DDL trigger to control and automate history of data changes

    Archives

    WebProfIT Consulting, Inc. 2016