Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Explore new task scheduler triggers in Windows Server 2008
- The task scheduler in Windows Server 2008 is quite different from what is in previous versions of Windows Server. The key elements to a scheduled task are triggers, actions, conditions, and settings. The triggers and actions area in Windows Server 2008 has an increased number of settings...
- Tags: Task, Microsoft Windows Server, Trigger, Figure B, Microsoft Windows, Microsoft Windows Server 2008, Servers, Operating Systems, Software, Hardware, Rick Vanover
- Blog posts 2008-06-10
- Audit data using SQL Server 2005's COLUMNS_UPDATED function
- Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has been modified, it is also useful to track the individual field names that have been modified. This information is great for your auditing department, and it...
- Tags: Function, Audit, Microsoft SQL Server, Auditing, Trigger, Microsoft SQL Server 2005, COLUMNS_UPDATED, COLUMNS_UPDATED Function, System Function, Tim, Databases, Enterprise Software, Software, Data Management, Tim Chapman
- Blog posts 2008-05-13
- 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
- Bulk importing data into SQL Server
- If you work with databases, at some point, you'll deal with inserting data into SQL Server from outside data files. This tutorial shows how to import data using the BULK INSERT command and explains how changing some of its options can make it easier and more efficient to insert data....
- Tags: Microsoft SQL Server, Data, Server, Trigger, BULK INSERT BULK INSERT, SalesHistory, FIELDTERMINATOR, Tim, Databases, Enterprise Software, Storage, Software, Data Management, Hardware, Tim Chapman
- Blog posts 2008-03-24
- Audio Zone Trigger (exe)
- Audio Zone Trigger is a sound detection software. It takes live audio from any input source and enables the computer to react to it in the way you specified. The sound-detection system lets you set any number of Triggers that perform any number of user-defined responses (record sound, run a...
- Tags: Audio, Trigger, Audio Zone Trigger
- Software downloads 2007-11-19
- Implement ASP.NET AJAX with the UpdatePanel control
- The ASP.NET 2.0 AJAX Extensions 1.0 add-on brings AJAX development to ASP.NET developers using existing ASP.NET style coding. This article is a continuation of my look at how to use the ASP.NET AJAX controls with more advanced scenarios. I begin with using multiple UpdatePanel controls on a single page. ...
- Tags: AJAX, Page, Control, Microsoft ASP.NET, Property, Id, Server, UpdatePanel, Label, Button, EventArgs, ID, OnClick, UpdateMode, Postback, ChildrenAsTriggers Property, Trigger, Tony Patton
- Blog posts 2007-09-11
- Comparing SQL Server constraints and DML triggers
- Triggers can also be used to cascade updatesFor example, I can use a trigger to ensure that any changes to a table are reflected in an Audit log. This can be very usefull in situations where a user/programmer/etc might bypass the application and update a table in the database...
- Tags: Databases, Microsoft SQL Server, server, stephen.burns@..., trigger, SaleDate
- Discussion threads 2007-06-05
- Comparing SQL Server constraints and DML triggers
- Over the years, I have witnessed many developers be confused about when to use data-manipulation language DML triggers vs. when to use constraints. I have seen numerous occasions where both objects have been used incorrectly, which has led to problems. This article sheds some light on when to use constraints...
- Tags: Sql Developer, Sql
- Blog posts 2007-06-04
- Audit data using SQL Server 2005's COLUMNS_UPDATED function
- DBA Tim Chapman looks at how the SQL Server 2005 COLUMNS_UPDATED function works and then discusses how to parse out the field names. Auditing data changes in your production environment is very important, especially if you are dealing with confidential information. Besides tracking the data that has...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2005, Tim Chapman, COLUMNS_UPDATED, Databases, Enterprise software, sys.fn_IsBitSetInBitmask, trigger, update statement, audit, SQL Server Newsletter, Function, Auditing, Microsoft SQL Server 2000, Listing B, COLUMNS_UPDATED Function, System Function, Listing C, Software, Data Management
- Technical articles 2007-04-16
- Surround SCM (exe)
- Control and track changes to source files and other digital assets throughout the product development process. Surround SCM with change automation, custom metadata, and virtual branching delivers complete control over the software change process, a clearer view of the state of files, and streamlines parallel development. Cross-platform Surround SCM combines...
- Tags: Trigger, Workflow, SCM, Integration, Supply Chain Management (SCM), E-mail, Process Improvement, Product Development, Enterprise Software, Software, Online Communications, Quality, Business Operations, Research & Development
- Software downloads 2007-04-13
- Using a Single Trigger for Insert and Update
- I have been trying to handle Insert and Update using one trigger. Does anydody know how to detect that a row is being updated in SQL Server 2005? Thanks.William.A couple of ideasif you have common code to run for both transactions put it in a stored proc and the call...
- Tags: wcovuaku@..., programming, trigger
- Discussion threads 2007-02-22
- Questions to ask a SQL Server database developer applicant
- Tim Chapman presents his standard set of baseline technical questions he asks SQL Server database developers during an interview. These questions will help you weed out less-qualified candidates. It is very difficult in today's job market to find well-qualified database developers. As a colleague of mine once said,...
- Tags: Microsoft SQL Server, Tim Chapman, Databases, Enterprise software, database, foreign key, SQL Server Newsletter, Developer, Trigger, Index, Value, Question, Table, NULL, Return Parameter, OUTPUT Parameter, Storage, Software, Data Management, Hardware
- Technical articles 2006-10-16
- Making use of INSTEAD-OF triggers in SQL Server 2005
- Why use Views?Views, especially ones with triggers on them, degrade the performance of the database by a huge amount.You can accomplish the same things by using a select stored procedure or user defined function and an update stored procedure.Don't give your front-end developers access to the tables directly. Just...
- Tags: database, gsquared, Microsoft SQL Server, Microsoft SQL Server 2005, performance, software, sql, trigger, VIEWS
- Discussion threads 2006-09-11
- 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
- Ease database management and automate functions with triggers in MySQL
- In SQL terms, a triggeris "procedural code that is automatically executed in response to certainevents on a particular table in a database" Wikipedia. More simply, it is a stub of code that isautomatically activated when a particular database event, such as an INSERT or DELETE,occurs. Triggers are handy for logging,...
- Tags: Contributor Melonfire, database, database management, MySQL, Query OK, trigger
- Technical articles 2006-08-23
- Ease database management and automate functions with triggers in MySQL
- In database terminology, a trigger is a stub of code that is automatically activated when a particular database event, such as an INSERT or DELETE, occurs. Triggers are handy for logging, to automatically "cascade" changes down from a single table to other linked tables, or to ensure that table relationships...
- Tags: MySQL, Trigger, Database Management, Storage, Databases, Hardware, Enterprise Software, Software, Data Management
- Download resources 2006-08-23
- Auditing changes in all SQL tables
- I have an application that we purchased that accesses it's database in SQL Server 2000. I wanted to know what tables the application accesses when a certain function is performed. I thought that I could add a trigger to each table that would insert a flag into a...
- Tags: SQL Table, sql server, audit, tables, SQL, tool, paulhenriques@..., software, trigger, database, auditing, SQL Profiler
- Discussion threads 2006-07-19
- 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
- Using SQL Server 2005 to document Sarbanes-Oxley compliance: Part 2
- By Tim ChapmanIn Using SQL Server2005 to document Sarbanes-Oxley compliance, I outlined how to create a"home-grown" auditing system to document security changes in SQLServer 2005. In that article, we used DDL triggers to track login activities,which are server-level events. In this article, we'll demonstrate how to useDDL triggers to track...
- Tags: database, DDL, Sarbanes-Oxley Act, Sarbanes-Oxley compliance, trigger
- Technical articles 2006-05-15
- 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
