SQL Server File Locations for Default Instances

Each Instance of SQL Server has its own set of Executables (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 (as … Continue reading SQL Server File Locations for Default Instances

Advertisements

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 … Continue reading XAMPP: Using MySQLDump to Backup MySQL on Windows Server 2003 and Windows 7

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 … Continue reading Active Directory: Global Groups; Universal Groups and User Logon

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     … Continue reading XAMPP 1.7.3 for Windows: Folder Structure

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 … Continue reading Configuring Alerts within the Avast ADNM Console