aaronolds

SELECT
    r.LAST_ALTERED,
    r.ROUTINE_NAME,
	OBJECT_DEFINITION (OBJECT_ID(CONCAT(r.SPECIFIC_SCHEMA,'.',r.ROUTINE_NAME)))
FROM INFORMATION_SCHEMA.Routines r 

aaronolds

Get-ChildItem "[starting path]" -recurse -Filter [filter] | Select-String -pattern “[pattern in file filtered files]” | group path | select name

aaronolds

When using Breezejs DO NOT USE DTO (Data Transfer Objects).  It is not worth the hell you will go through to make it work.

Look at this post by Ward Bell:
http://neverindoubtnet.blogspot.com/2013/02/the-breeze-server-it-your-way.html
And this post by Julie Lerman
http://msdn.microsoft.com/en-us/magazine/jj883952.aspx

aaronolds

DECLARE @test VARCHAR(2)

print ISNULL(@test, 'test')
print COALESCE(@test, 'test')

aaronolds

public static void SetValue<T>(T obj, string fieldName, object value)
{
	var type = typeof(T);
	
  // Get our property via reflection so that we can invoke methods against property
  var prop = type.GetProperty(fieldName, BindingFlags.Public | BindingFlags.Instance);
  if (prop == null || !prop.CanWrite) return;

  // Gets what the data type is of our property (Foreign Key Property)
  var propertyType = prop.PropertyType;

aaronolds

BitConverter.ToString(md5Hash).Replace("-", string.Empty));

aaronolds

(dir -include *.cs -recurse | select-string .).Count

aaronolds

Keybase proof

I hereby claim:

• I am aaronolds on github.
• I am aaronolds (https://keybase.io/aaronolds) on keybase.
• I have a public key whose fingerprint is 84C5 5C94 D0A8 4B01 ECCD EC4C 3647 12AC 2974 5965

To claim this, I am signing this object:

aaronolds

// http://stackoverflow.com/questions/18794264/visual-studio-how-to-serialize-object-from-debugger
// replace obj with the object you want to serialize
(new System.Xml.Serialization.XmlSerializer(obj.GetType())).Serialize(new System.IO.StreamWriter(@"c:\temp\text.xml"), obj)

aaronolds

Set-ItemProperty -path .\[folder]\ -Name Creationtime -Value '[new date]'