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 assuming that you have correctly followed all Oracle Virtual Box – VHD Creation steps that we did last time. The installation ISO [...]
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 [...]
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 [...]
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