Computers

Virtual Box VM Clone Error

When getting the error: 1A hard disk with UUID {55b773b8-cbcb-42ea-9a44-1368b30ed823} or with the same properties (‘D:\VM\VirtualBox\XP SP3\XP SP3.vdi’) is already registered. The error can be resolved by using the utility: …

Computers

Install Wireshark Windows 8 64bit

1. Download wireshark: www.wireshark.org 2. Install wireshark like you normally would. At the end of the installer you will be notified that there was a compatibility problem, ignore this error. …

Computers

Expand VMWare Drive Image

These instructions assume we have a Windows Server called “vm1” that we need to expand the “c” drive. 1). Remove any snapshots from vm1. This method will not work with …

Computers

Datetime variables TSQL

Syntax for a TSQL date time variable 1234567DECLARE @START_DATE DATETIME DECLARE @END_DATE DATETIME SET @START_DATE = ’09/21/2012 00:00:00′ SET @END_DATE = ’09/21/2012 23:59:59′ SELECT * FROM TABLE WHERE POSTINGDATE >= …

Computers

Select Tables with Row Count

TSQL 123456–all tables and rowcount (in descending order by count) select ‘[‘+SCHEMA_NAME(t.[SCHEMA_ID])+’].[‘+t.NAME+’]’ AS [fulltable_name], SCHEMA_NAME(t.[SCHEMA_ID]) as [schema_name],t.NAME as [table_name] ,i.rows from sys.tables t INNER JOIN sysindexes i ON (t.object_id = …