TechRepublic : A ZDNet Tech Community

2 Resources for

data definition language trigger

  • Subscribe to this listing via:
  • RSS
  • Email

TechRepublic Resources

Document Sarbanes-Oxley compliance with SQL Server 2005
As the DBA for revenue-generating applications, I am frequently invited by my CIO to meetings with Sarbanes-Oxley auditors to discuss the security and integrity of corporate data. In a nutshell, we're expected to answer any number of questions, via appropriate documentation, about who has access to our data, how access...
Tags: Sarbanes-Oxley Compliance, Audit, Event, Sarbanes-Oxley Act, DDL, Microsoft SQL Server, Trigger, Microsoft SQL Server 2005, Data Definition Language Trigger, Data Definition Language Event, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
Blog posts 2008-04-07
Using SQL Server 2005 to document Sarbanes-Oxley compliance
By Tim ChapmanAs the DBA for revenue-generating applications, I amfrequently invited by my CIO to meetings with Sarbanes-Oxley auditors todiscuss the security and integrity of corporate data. In a nutshell, we'reexpected to answer any number of questions, via appropriate documentation,about who has access to our data, how access is granted,...
Tags: audit, audit trail, data definition language trigger, database, DDL, Microsoft SQL Server, Microsoft SQL Server 2005, Sarbanes-Oxley Act, Sarbanes-Oxley compliance, server, trail, trigger
Technical articles 2006-05-09

Additional Resources

Making use of INSTEAD-OF triggers in SQL Server 2005
INSTEAD-OF triggers are powerful objects in SQL Server 2005. Tim Chapman explores some of the useful features of INSTEAD-OF triggers, and discusses how your organization can use them to its advantage. A trigger is a database object similar to a stored procedure that executes in response to certain...
Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, Databases, Storage, INSTEAD-OF INSERT, trigger, INSTEAD-OF trigger, database, SQL Server Newsletter, View, Table, INSTEAD-OF, Enterprise Software, Software, Data Management, Hardware
Technical articles 2006-09-11
Embed event triggers in Oracle databases and push the limits of ERP
At the core of reengineering a company’s business processes for ERP is the combined power of integration and distribution. Oracle, like all ERP platforms, provides efficient and robust mechanisms for tying multiple databases together in a single transaction and triggering downline events from key causal ones. Understanding these relationships is...
Tags: database, DDL, ERP, Oracle Corp., Oracle Database, Scott Robinson, trigger
Technical articles 2003-03-05
Choose the proper Oracle design for auditing
More than ever, companies are demanding complete audit trails for everything that happens within an Oracle database. Managers want to see audits of all aspects of the database, and government regulations are spurring this interest.The most important regulation is HIPAA, the Health Insurance Portability and Accountability Act of 1996. Under...
Tags: Donald Burleson, auditing, Oracle Corp., audit
Technical articles 2003-09-08
Know your DML: The new OUTPUT feature in SQL Server 2005
The ability to immediately access data changes withoutrequiring additional reads from the database can enhance applicationthroughput. When data modification statements are executed in SQL Server 2005,you can capture the data that has been modified and store it for use insubsequent transactions. You can use this technique to prevent the unnecessaryreading...
Tags: database, Deleted, INSERTED, Microsoft SQL Server, Microsoft SQL Server 2005, sales, Tim Chapman, trigger
Technical articles 2006-05-22
MSDN Webcast: New T-SQL Programmability Features in SQL Server 2008 (Level 300)
This webcast on new T-SQL programmability features in Microsoft SQL Server 2008. It covers exciting new features such as new data types (i.e. date/time, filestream, HierarchyID, large UDT, sparse columns), dependency management for database objects, procedure programming (i.e. table value parameter), data warehousing enhancements (i.e. Merge data manipulation language DML...
Tags: Microsoft SQL Server Transact-SQL, Microsoft Developer Network, Microsoft SQL Server 2008, Data Warehouse, Webcast, Microsoft SQL Server, Microsoft Corp., Databases, Business Intelligence, Storage, Enterprise Software, Software, Data Management, Hardware
Webcasts 2007-12-04
Introducing JavaFX: Sun's new family of Java-based products
JavaFX is a new family of products and technologies from Sun Microsystems that you can use to create Rich Internet Applications RIAs. JavaFX currently consists of JavaFX Script and JavaFX Mobile; other JavaFX products are planned for release in the future. JavaFX is anticipated to compete in...
Tags: Application, Operation, Sun Microsystems Inc., Window, Sun NetBeans, Value, JavaFX, JavaFX Script, JavaFX Mobile, FlowPanel, TextField, Button, System.out.println, Class Definition, Programming Languages, Java, Software Development, Software/Web Development, Peter Mikhalenko
Blog posts 2007-10-31
  • << Previous
  • page 1 of 1
  • Next >>


500 Things Every Technology Professional Needs to Know
Did you know Microsoft's RegClean does not work with XP but you can use shareware to clean your registry? Did you know most wireless access points don't have encryption enabled by default? Did you know there are 500 tidbits of information contained in TechRepublic's 500 Things Every Technology Professional Needs to Know that will help you become a successful IT professional.
Buy Now
IT Help Desk Survival Guide, Third Edition
TechRepublic's IT Help Desk Survival Guide, Third Edition provides tools and recommendations to help you better manage help desk services, improve end-user support, troubleshoot frustrating hardware issues, identify quick fixes to vexing Windows problems, and help users make the most of Microsoft Office 2003.
Buy Now

Popular Sanity Saver Videos