Snipplr - michanne

(Windows PowerShell) Compare TFS Server Paths

Sat, 09 Jul 2011 08:48:16 GMT

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

Thu, 09 Jun 2011 03:46:38 GMT

(SQL) Lots of Table Info

Thu, 09 Jun 2011 03:35:08 GMT

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

(SQL) Function: TruncStrOnDeliminator

Thu, 09 Jun 2011 03:33:33 GMT

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

Thu, 09 Jun 2011 03:09:27 GMT

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

Wed, 11 May 2011 08:27:30 GMT

(SQL) Sample Table Sample

Tue, 10 May 2011 04:18:38 GMT

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) Clean a string

Thu, 05 May 2011 05:08:30 GMT

(SQL) Split a string function

Thu, 05 May 2011 04:55:03 GMT

(SQL) SSRS Report Parmeters and description

Fri, 29 Apr 2011 02:02:05 GMT

(SQL) List of Weeks

Fri, 25 Mar 2011 10:22:50 GMT

(SQL) SQL Server Backup and Restore Snippets

Thu, 24 Mar 2011 03:38:44 GMT

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

Sat, 12 Mar 2011 07:34:14 GMT

(Windows PowerShell) Powershell snips

Thu, 30 Dec 2010 04:55:15 GMT

Short Random lines of code mostly from Powershell.com

(Other) SSIS Log File Name

Thu, 23 Dec 2010 07:36:13 GMT

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

Thu, 16 Dec 2010 08:22:12 GMT

(Windows PowerShell) Get File Version Information for dlls

Mon, 13 Dec 2010 06:52:31 GMT