SQL Server File Locations for Default Instances

Each Instance of SQL Server has its own set of executable files (sqlservr.exe) and data files. The file locations for the default instance are different depending upon the version installed. Essentially, this is to allow multiple versions of SQL Server to happily co-existing on the same server. The table below lists the default file locations …

XAMPP: Using MySQLDump to Backup MySQL on Windows Server 2003 and Windows 7

I couldn’t find anything specific for Backing up the MySQL Databases within XAMPP. There certainly isn’t a pre-configured routine available. In addition, MySQL Workbench (unlike its predecessor MySQL Administrator) does not provide any automated backup facility. So, I decided to explore the use of “MySQLDump”, a command line routine that can be inserted into a …

A Computer Memory Primer

Here is a quick list of the different types of memory found within a typical computer workstation / server. SRAM (Static RAM) DRAM (Dynamic RAM) DRAM DRAM DRAM DRAM DRAM DRAM DRAM - SIMM SIMM DIMM DIMM DIMM DIMM DIMM RIMM - - - SDR SDRAM DDR(1) SDRAM DDR2 SDRAM DDR3 SDRAM DDR4 SDRAM - …

Active Directory: Global Groups; Universal Groups and User Logon

If you are struggling to understand Global Catalog Servers (GCS); Universal Security Groups; and Group Replication, it may help to think about what is actually happening during the user logon process and why. When a User logs onto a Microsoft Domain Network, two things need to happen. The Logon Service has to: Verify the User …

XAMPP 1.7.3 for Windows: Folder Structure

The following is a summary of the contents of each folder within a Windows XAMPP installation. Folder Description Version Notes Anonymous       Apache Web Server Service 2.2.14 Configuration file is: “apache\conf\httpd.conf” cgi-bin       FileZillaFTP FTP Service 0.9.33 Configure using the XAMPP Console. htdocs Web Site Pages     install     …

Sage 50 HR Firewall Ports

Sage 50 HR requires the following Firewall Ports to be open on the Server: TCP 4197 TCP 5150

Configuring Alerts within the Avast ADNM Console

In order to receive an Administrative Email Notification each time a Virus is detected by the Avast Workstation Client, it is necessary to configure the following settings within the “Avast Distributed Network Manager” (ADNM) Console: [1] Basic SMTP Settings   [2] SMTP Settings within the “Computer Catalog” Properties [3] Add an SMTP Alert   The …

XAMPP Control Panel & Event ID 1073

Just lately, I have been unable to “Log Off” from a Remote Session on my Windows 2003 Server (running XAMPP). It would leave a “1073” Event in the System Log (Failed to Restart / Shutdown Computer). A bit odd, since I am not trying to Shutdown the machine. I’m not sure why this has started …