PCWorld’s GlassWire review

Although this product is in beta, it’s first appearance appears to be very promising.  Read PCWorld’s review of Glasswire, an application that can keep an eye on your computer network to see what traffic your devices are receiving and sending.  Read more at PCWorld.

Screenshots from a local VM network

Glass Five GlassWire Four GlassWire Three GlassWire Two

Proxy server error after removing malware

If you have used traditional means to remove malware and suddenly you can’t change the proxy server under Internet Options (Control Panel), you can use RogueKiller to remove the proxy.

Symptoms include any browser failing to navigate the internet, proxy errors and proxies such as 127.0.0.1 port 8800.

After trying the control panel and seeing that the proxy under internet options, connections, lan settings and proxy was ‘locked’ by the Administrator (the end user was the administrator), I used netsh winhttp reset proxy, and tried removing the proxy from the registry.

RogueKiller was the only program that recognized the malicious software and removed the proxy.

After an initial scan, you will have to Agree to Terms and then scan your computer.  Before removing the items, always review each tab and only hit delete on items that are malicious.

Note: Always backup your computer 

RogueKiller

Network Switches – Avoid Daisy-Chains

When you are networking computers, wireless access points, printers and other nodes in multiple rooms, try to avoid daisy-chaining switches or using small 4-8 port switches when you are in a hurry.  Replace any hubs on your network as soon as you can.

With a hub, collisions can be >20% and utilization can stand at >50%.   By replacing a hub alone, you can reduce collisions to 5% on switches in rooms and <1% in the server room.  Switches help to isolate traffic, relieve congestion, separate collision domains (reduce collisions), segment and restart distance/repeater rules.

Daisy Chaining Switches -what not to do

Real world scenarios may require you to temporarily daisy chain switches.  If you do, test the network and run additional backbones or replace core switches to accommodate more nodes as soon as you can. (remember, replace any hubs in your network)

Daisy chaining

One of many solutions is to run independent lines to the core switch

alternative

Basic tips on optimization of your network -

  • Use stackable managed switches
  • Purchase switches that support
    IEEE 802.1D , IEEE 802.1p , IEEE 802.1Q , IEEE 802.1s , IEEE 802.1w , IEEE 802.1x , IEEE 802.3 , IEEE 802.3ab , IEEE 802.3ad (LACP) ,
    IEEE 802.3ae , IEEE 802.3u , IEEE 802.3x , IEEE 802.3z
  • Use a battery backup on the switches

This is the very basics behind network switch infrastructure.  Managing switches and using the IEEE standards above along with optimizing your network and managing the network infrastructure is important.

Excellent articles on Networking Infrastructure

http://www.lantronix.com/resources/net-tutor-switching.html

http://www.techrepublic.com/blog/it-consultant/only-novices-daisy-chain-switches/

Installing Microsoft SQL on Server 2012 R2

Resources:

Windows Server 2012 R2

Microsoft SQL 2012

Can be obtained from TCAT’s DreamSpark -

http://e5.onthehub.com/WebStore/ProductsByMajorVersionList.aspx?ws=5dee02e7-a65d-e111-8056-f04da23e67f6&vsro=8&JSEnabled=1

Note: you can use the trial software on Server and SQL if you do not have a Dreamspark account.

Files to use as demos:

http://msftdbprodsamples.codeplex.com/releases/view/55330

Virtualization needed:

http://www.vmware.com/products/player

Hardware needed:

Dual Core computer with 4 GB of RAM (Minimum)

How to:

Install VMWare Player and commit at least 30GB of HDD space, 1 CPU and 2 GB of ram (minimum).

Install Windows Server 2012 R2

Open Windows Server 2012 R2

Extract the SQL ISO into a folder on the Server

Click on Setup

Click on new SQL Server stand-alone installation

1 SQL

SQL Server 2012 Setup will run a Rule Check to make sure your computer is adequate 2 SQL

You should receive a pass for all items checked (.Net 2.0, .Net 3.5, etc.)3 SQL

Next enter your product key if applicable4 SQL

Click Next and accept the terms5 SQL

SQL Server will begin to install if you have corrected any items that may need correcting.7 SQL

This will check for Setup Support Rules.  Correct any failures if necessary.8 SQL

You will now select SQL Server Feature Installation9 SQL

On the next screen, it is recommended that you select all features if you are learning SQL10 SQL

This will in turn check the installation rules such as .Net Framework and Visual Studeio 2010.11 SQL

Create a default instance of SQL.  You can name the Instance ID or select a hard drive for the installation12 sQL

This will now check your space on the virtual machine (HDD space)13 SQL

It is recommended at the next screen to select the SQL Server agent be placed on automatic in the startup type14

Next select Mixed Mode and provide a complex password.  You will also add the Administrator or your account name as a SQL Server Administrator.15 SQL 16

Below is an example of a simple password.  You must use a complex password.17 SQL 18 SQL 19 20 21 22 23 24

Monitor your task manager and CPU to ensure you have adequate resources.25 26 Host 27

SQL Server manager will now be available for you to use.  While I installed this on my work laptop, you must remember to monitor laptops for heat and resource utilization.

Using one of the resources below, you can substitute what you learn on these pages and try writing queries from data you import from the codeplex database (http://msftdbprodsamples.codeplex.com/releases/view/55330).

A few links to SQL tutorials -

http://www.w3schools.com/sql/

http://www.sqlcourse.com/

http://www.1keydata.com/sql/sql.html

http://sqlzoo.net/wiki/Main_Page

Opening Studio

Opening Studio

Running a basic query

Sample Query

Server Manager – if you want desktop icons on Server, you must open the server manager and add a feature (Desktop Experience).

Features

If you right click on the desktop to use Personalize to add desktop icons, it will not be available.  You must use the above wizard to add features  (Desktop Experience to add icons such as Computer, Network, files and control panel).  Personalize will become available after a reboot.

Features 2Features 3