From the monthly archives: May 2012
A new version of SQL Server is released every few years. This year was no different with the launch of SQL Server 2012 in March. It is important to migrate older, unsupported databases to a current version. I am going to examine 3 different techniques to upgrade the [PUBS] sample database from SQL Server [...]
Another usage of Database Triggers is track Data Definition Language (DDL) changes that occur in a database. Today, I am going to enhance the AUTOS database script to add such auditing. This auditing is a very good practice when multiple people have syadmin rights to make such changes.
First, I am going [...]
During the installation of SQL Server, you are prompted to select an authentication mode.
Regardless of the choice, a [sa] account will be created. If you are using Windows Authentication, the account will be be left in a disabled state. On the other hand, if you are using Mixed Mode Authentication, you are [...]
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 [...]
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 [...]
Categories
- Database Admin (39)
- Database Developer (72)
- Integration Services (5)
- Other (12)
- Perl Scripting (7)
- SQL Pass Events (8)
- SQL Tidbits (38)
- Under Construction (1)
- VB Script (10)
Archives
Cloud Tags
AFTER ALTER TABLE ALTER TRIGGER CPAN perl modules CREATE DATABASE create function create procedure CREATE TABLE create trigger create view database administrator database developer DATA TYPES DDL DECLARE DELETE DROP DATABASE DROP TRIGGER DROP VIEW execute EXISTS FORMAT free code INSERT ISNULL John F. Miner III PASS perl script REPLACE SELECT sp_help sp_helptext SQL Server SQL Server Management Studio SSMS. string function sys.databases sys.objects sys.schemas TRIGGERS TRUNCATE TABLE TSQL UPDATE USER DEFINED VIEW vb script
