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 = …

Computers / Programming

Serialization C#

Various serialization functions 123456789101112131415public static string SerializeObject(object obj) {     if (obj == null) { return string.Empty; }     System.Xml.Serialization.XmlSerializer serializer = new System.Xml.Serialization.XmlSerializer(obj.GetType());     string s …

Computers

Create a mysql database

12345$> mysql -u ‘root’ -p mysql> create database atestdatabase; mysql> create user ‘myuser’@’localhost’ identified by ‘secret’; mysql> grant all on atestdatabase.* to ‘myuser’@’localhost’;