Sponsored White Papers, Webcasts, and Downloads
TechRepublic Resources
- Understanding INSTEAD OF Triggers in Microsoft SQL Server 2000
- During this presentation, we will talk about one of the new features introduced in Microsoft SQL Server 2000, INSTEAD OF triggers. In SQL Server version 7.0 and earlier, triggers are implemented in a before fashion. In other words, any constraint checks are performed after the insert is attempted. The INSTEAD...
- Tags: Microsoft SQL Server, Microsoft SQL Server 2000, Trigger, Microsoft Corp., Databases, Enterprise Software, Software, Data Management
- Webcasts
- Fine-Grained Auditing for Real-World Problems
- Traditional Oracle Database auditing options lets track the actions users perform on objects at the macro level - for example, if one audits for SELECT statements on a table, he or she can track who selected data from the table. However, people don't know what they selected. With data-manipulating statements...
- Tags: Oracle Corp., Statement, Trigger, Databases, Productivity, Enterprise Software, Software, Data Management
- White papers
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- 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
- Branimir Maze (exe)
- In this Maze game you have to collect diamonts and reach the flag to win. There are some monsters that can kill you. If you want to open a door, collect all diamonts or get a trigger.
- Tags: Maze, Trigger, Games, Personal Technology
- Software downloads 2005-10-25
- 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
- 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
- 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
