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 [...]
The most basic storage unit of any operating system is a file. Files can contain anything from textual data in this article, a bitmap image of your baby daughter, a MS Excel worksheet containing your finances or a Visual Basic program you are currently working on. Therefore it is very important to know how [...]
The invention of a fixed formatted text (flat) file layout started with IBM in the 1960′s. Data sets on the mainframe could be stored in both fixed and variable length records.
A flat file is defined as having one record of data per row that is ended with a new line. Each field [...]
Today, I want to talk about getting in shape to run the Microsoft Exchange, SMTP Relay. It takes years of practice to get in condition for such a grueling race. I am just kidding!
However, the topic of a SMTP relay is an important one that you will come across in your career. A [...]
I would like to chat about one of my favorite programming topics, implementing recursive algorithms.
Recursion in computer science is a method where the solution to a problem depends on solutions to smaller instances of the same problem. A recursive program is a program that calls itself to work on a smaller sub problem. [...]
Most Commercial off-the-self (COTS) systems read and write data to a relational database such as SQL Server, Oracle or DB2. Canned reports and data interfaces included with the COTS system sometimes have limited features that do not fully meet the business requirements. That is where you, the software developer, can come [...]
Business Users like to have data in a spreadsheet format. Since Microsoft Office is installed world-wide, it will be a common request for data in a XLS format.
Let’s make believe that we have the business problem to write information about the first five presidents to an XLS format.
The Cliché, there are [...]
Today I am going to talk about calculating primes.
The Algorithm that I am going to introduce is [...]
The first type of file that every programmer writes to and reads from is an ASCII text file . A text file is a kind of computer file that is structured as a sequence of lines. Each line is terminated with a special character such as a line feed (LF) in UNIX or a [...]
Cloud TagsAFTER ALTER TABLE ALTER TRIGGER CPAN perl modules CREATE DATABASE create function CREATE FUNTION 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 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