Currently viewing the category:
"Other"
One of the daily tasks of a database administrator is the granting and the maintaining of access to the fleet of databases under your charge.
It is important to to keep track of all the system administrator accounts and passwords as well as any application ones requested by developers or end users.
[...]
I just finished blog entry one hundred yesterday. It is quite an accomplishment since it takes one to two hours to research, design, and compose an article. I figured it was time to reset my goals for the upcoming year.
In the next thirteen months, I will be focusing on the Microsoft [...]
I am continuing work on PROJECT ALPHA which is chartered to create a test environment for a PERL based Etract Translate and Load (ETL) solution.
If you have correctly followed the previous Oracle Virtual Box articles, a working guest image of Windows 2008 Server now exists with [...]
Today, I am continuing working on PROJECT ALPHA. The project is chartered to create a test environment for developing a PERL based Etract Translate and Load (ETL) solution.
I am assuming that you have correctly followed all Oracle Virtual Box – VHD Creation steps that we did last time. The installation ISO [...]
Today, I am continuing working on PROJECT ALPHA. The project is chartered to create a test environment for developing a PERL based Etract Translate and Load (ETL) solution.
One requirement of the project is to have a FTP server to stage test files. Window 2008 R2 Server comes with Internet Information Services (IIS) [...]
Before today, I have written many articles that were concentrated on one topic in SQL Server or Perl or Visual Basic.
Starting today, I am going to kick off a full blown development exercise named PROJECT ALPHA. The purpose of this project is to create a test environment for developing a PERL based [...]
Many organizations still have servers running Windows 2003. The default number of sessions for Terminal Server, Remote Desktop Protocol (RDP), is two without add more licenses. If an administrators disconnects from the server instead of logs out, there will be open RDP sessions. If you need to login for some DBA task you are [...]
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 [...]
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 [...]
Categories
- Database Admin (39)
- Database Developer (76)
- Integration Services (5)
- Other (11)
- Perl Scripting (7)
- SQL Pass Events (7)
- SQL Tidbits (24)
- Under Construction (1)
- VB Script (10)
Cloud Tags
AFTER 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
