Another usage of Data Modification Language (DML) triggers is the replicating data for historical tracking or data aggregation. Today, I am going to expand on the AUTOS database that I created in prior articles to demonstrate such usage. The business unit has asked us to track each macro task in the making of an automobile. [...]
Most security administrators are eager beavers when it comes to deploying and running antivirus software on any computer they can get their hands on. This includes Microsoft Windows Servers running your SQL Server Database engine.
Do not let security administrators scan your database files and make your 2012 Dell xeon with eight [...]
A seperation of power between a day-to-day user account and a special occasion adminstrator account can be beneficial for a DBA. By usig a less privledge account for daily activities can avoid costly human mistakes. A mistake will be denied due to not having the correct privledges.
It is standard to use Microsoft Windows Domain [...]
A typical use of Data Modification Language (DML) triggers is to prevent unwanted data modification. AFTER triggers are great at detecting the INSERT, UPDATE or DELETE action and rolling back the changes.
A good security model can prevent these types of changes and should be the first line of defense. However, there are [...]
I am going to wrap up my discussion of LOGON TRIGGERS. We now have a MS ACCESS database that is using a LINKED TABLE pointing to the [WILDLIFE] SQL Server database. Most professional applications set the application name string before connecting via ODBC API to a data source. MS ACCESS does just that at [...]
Today, I am going to build upon the prior ODBC Connection article by showing you how to create a LINKED TABLE in MS ACCESS. I am assuming that you have created a blank MS ACCESS 2007 database named [WILDLIFE.accdb]. I will be using the [WILD LIFE] SQL Server database that was created in [...]
The ODBC standard was developed in the early 1990′s to allow a software developer to use a single interface to access mutltiple data sources. Microsoft Access is a very versatile application since it can import or link to a variety of ODBC data sources.
Today’s article will cover how to define a [...]
I was recently approached by the WINTEL to help rename a Windows 2003 Server that has Symantec Backup Exec 12.5. This backup software uses the Express Version of SQL Server 2005 to manage information about backups, restores, and schedules. Since I have not done this task in a while, I wanted to write down [...]
The number and types of database triggers available to database administrators has increased over the years as the Microsoft SQL Server database engine has matured. There are now triggers for execution after both DDL and DML modifications. These triggers can be classified as AFTER – TSQL code to be executed after an [...]
DATABASE SNAPSHOTS were added to the SQL Server product in the 2005 version. They are great for saving a version of the database before major data changes happen and perfect for rolling back the changes if they are not successful. While books online suggest other uses, I think this one is the best. [...]
Categories
- Database Admin (22)
- Database Developer (27)
- Other (4)
- VB Script (10)
Cloud Tags
@@fetch_status BEGIN close CREATE DATABASE create function create procedure CREATE TABLE create trigger create view cursors database administrator database developer deallocate DECLARE DELETE DROP TRIGGER execute EXISTS EXPORT fetch free code IF IMPORT INSERT ISNULL John F. Miner III open PRINT REPLACE RETURN searching stored SQL SELECT SET sp_helptext SQL Server SUSER_ID SUSER_NAME sys.databases sys.objects sys.schemas TRUNCATE TABLE TSQL UPDATE vb script while
