Snipplr

(Windows PowerShell) Compare TFS Server Paths - michanne

Sat, 09 Jul 2011 08:48:16 UTC

Compares two TFS paths after $startdate and returns a list of files that are different. First section outputs owner, changeset, servername that are only on the Left side. The second outputs owner, changeset L&R, servername for files that are different. Constrained to files where the Left side change date is after the right side change date.

(Windows PowerShell) Find Empty Folders - michanne

Thu, 09 Jun 2011 03:46:38 UTC

(SQL) Lots of Table Info - michanne

Thu, 09 Jun 2011 03:35:08 UTC

SQL Server - everything you want to know (or not) about a table.

(SQL) Function: TruncStrOnDeliminator - michanne

Thu, 09 Jun 2011 03:33:33 UTC

Function to truncate a string at the last instance of deliminator before exceeding cutoff. Example: select dbo.TruncStrOnDeliminator( 'Aggregates, Asphalt Cleaning, Coating, Cracks, Patching, Repairs, Sealing, Striping',60,default)

(SQL) TFS Database Queries - michanne

Thu, 09 Jun 2011 03:09:27 UTC

Sometimes it is just more convenient to query the db. Returns Pending changes with local path. Have not investigated what lock status translates to.

(Windows PowerShell) SSRS RDL File Command Text - michanne

Wed, 11 May 2011 08:27:30 UTC

(SQL) Sample Table Sample - michanne

Tue, 10 May 2011 04:18:38 UTC

Alternate to tablesample clause. Example from BOL "The expression CAST(CHECKSUM(NEWID(), SalesOrderID) & 0x7fffffff AS float / CAST (0x7fffffff AS int) evaluates to a random float value between 0 and 1"

(SQL) Split a string function - michanne

Thu, 05 May 2011 04:55:03 UTC

(SQL) SSRS Report Parmeters and description - michanne

Fri, 29 Apr 2011 02:02:05 UTC

(SQL) SQL Server Backup and Restore Snippets - michanne

Thu, 24 Mar 2011 03:38:44 UTC

Backup by using Copy_Only. Use to make a copy of the db with or without a new name. Specifies that the backup is a copy-only backup, which does not affect the normal sequence of backups. Copy_only option is 2005 on.

(SQL) SQL Server SP/FN Set Options - michanne

Sat, 12 Mar 2011 07:34:14 UTC

(Windows PowerShell) Powershell snips - michanne

Thu, 30 Dec 2010 04:55:15 UTC

Short Random lines of code mostly from Powershell.com

(Other) SSIS Log File Name - michanne

Thu, 23 Dec 2010 07:36:13 UTC

Basic Datetime format based on Package name. MyPackage_20101222-13_16_34.log.xml

(Windows PowerShell) Searches for a string in file and returns the lines per array - michanne

Thu, 16 Dec 2010 08:22:12 UTC

(Windows PowerShell) Get File Version Information for dlls - michanne

Mon, 13 Dec 2010 06:52:31 UTC