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
- 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
- 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
- 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
- MS Word 2000 toolbars
- I ahve a similar question to a previous questioner. Upon occassion, I don't know the trigger, the "web" toolbar comes up without my requesting it, it is not "checked" in the listing of requested toolbars. In most cases it is undesireable, takes up room from the other toolbars...
- Tags: dhays, Microsoft Corp., Microsoft Word, toolbar, windows
- Q&A 2005-10-26
- Triggers
- Hi therei want to run a script using the jobs in enterprise manager, hopever I want to have a second step which would be to send a mail.I want to send a mail to all the people returnbed from the script and use the email addresses found in that returnded...
- Tags: E-mail
- Discussion threads 2005-10-10
- Call multiple trigger bodies with a single trigger
- Or just use Oracle 8, 9 or 10This article shows how to jump through some hoops to get the effect of multiple triggers of the same type on a table. The restriction of just one trigger of each type was lifted in the Oracle database several versions ago, so...
- Tags: Databases, trigger
- Discussion threads 2005-08-25
- Learn to avoid the mutating table problem in Oracle
- triggertrigger
- Tags: it management, Oracle Corp., sdkjf@..., trigger
- Discussion threads 2005-07-05
Introducing SmartPlanet
-
-
Find thought-provoking progressive ideas on topics that intersect with technology, business and life.
Visit Today
-
-
Technology, perspective, and insights shaping the world
-
Learn innovative and practical skills for your business and your life. SmartPlanet offers 360 degree coverage that you need to feel connected to the information that matters to the world at large.
Go to SmartPlanet
