Sergej Derjabkin derjabkin

derjabkin / gist:5397403

Created April 16, 2013 16:33

Weekly Differential backup of all databases in Microsoft SQL Server

	if not OBJECT_ID('dbo.Proc_BackupDatabaseWeeklyDifferential') is null
	Drop Proc dbo.Proc_BackupDatabaseWeeklyDifferential
	go

	Create Proc dbo.Proc_BackupDatabaseWeeklyDifferential(
	@DbName sysname,
	@TargetPath nvarchar(1000)) as

derjabkin / gist:5311286

Created April 4, 2013 15:16

Disable optimization of local variables in Visual Studio

	set COMPLUS_ZapDisable=1
	rem Disable vshost in the projects options

derjabkin / gist:5236245

Created March 25, 2013 10:30

DevExpress ASP.NET get control instance for an element

ASPxClientControl.GetControlCollection().GetByName(element.id)

derjabkin / gist:5170451

Created March 15, 2013 14:59

Regex Replace with sequential numbers

	string s = @"aasdas %.ls dasdasdasd %.ls asdaasddas %ls";
	int i = 0;
	s = Regex.Replace(s, @"%(\.\*){0,1}ls", (m) => "%" + (++i).ToString());