arkuznetsov’s gists

arkuznetsov / SQL_TRIGGER_change_index_data_compression_on_create.sql

Last active October 15, 2024 08:11

SQL create trigger on CREATE TABLE/CREATE INDEX events that changes DATA_COMPRESSION to PAGE

	USE ...
	GO

	DROP TRIGGER IF EXISTS set_table_page_compression
	ON DATABASE
	GO

	CREATE TRIGGER set_table_page_compression
	ON DATABASE
	FOR CREATE_TABLE

arkuznetsov / rename1CFiles.ps1

Created April 4, 2024 08:30

Pwsh.Переименование файлов конфигурации 1С

Get-ChildItem -Path ./src -Filter 'вфт_*' -Recurse | ForEach-Object { if ($_.name -match 'вфт_(.+)_Персонал(.*)') {Rename-Item -Path $_.FullName -NewName $($_.name -replace 'вфт_(.+)_Персонал(.*)', 'вфт_Персонал_$1$2')}}

arkuznetsov / commit.cmd

Created March 23, 2021 07:34

Выполняет коммит от имени указанного автора/коммитера на указанные дату и время

	rem Выполняет коммит от имени указанного автора/коммитера на указанные дату и время
	rem Время указывается по московскому часовому поясу (+3 часа)
	rem Пример: .\commit.cmd "Artem Kuznetsov" [email protected] "2021-03-05 01:30:00" "мой новый коммит от 05.03.2021"

	set AUTHOR=%1
	set AUTHOR=%AUTHOR:"=%
	set EMAIL=%2
	set EMAIL=%EMAIL:"=%
	set GIT_COMMITTER_DATE=%3
	set GIT_COMMITTER_DATE=%GIT_COMMITTER_DATE:"=%.000000000 +0300

arkuznetsov / reg_1cserver.cmd

Last active December 1, 2024 16:59

1C win services registration

	@echo off
	set version=%1
	set regport=%241
	set port=%240
	set range=%260:%291
	set work_dir=C:\Program Files\1cv8\srvinfo%regport%
	set srvc_name="1C:Enterprise 8.3 Server Agent (%regport%)"
	set binpath="C:\Program Files\1cv8\%version%\bin\ragent.exe -srvc -agent -regport %regport% -port %port% -range %range% -debug -http -d \"%work_dir%\""
	set description="1C:Enterprise 8.3 Server Agent (%regport%)"

arkuznetsov / CreateInfoBaseOnServer.bat

Created November 8, 2019 11:50

Create 1C infobase on 1C server

	@echo off
	chcp 1251

	set restoresrv=MyServer
	set sqluser=MySQLUser
	set sqlpassw=%1
	set v8ver=8.3.12.1790

	set restoreddb=MyDataBase
	"%ProgramFiles%\1cv8\%v8ver%\bin\1cv8.exe" createinfobase Srvr=%restoresrv%;Ref=%restoreddb%;SQLSrvr=%restoresrv%;DBMS=MSSQLServer;SQLDB=%restoreddb%;SQLUID=%sqluser%;SQLPwd=%sqlpassw%;SQLYOffs=2000;CrSQLDB=n;DB=%restoreddb% /AddInList %restoreddb%

arkuznetsov / SQL_change_logical_file name.sql

Last active May 28, 2019 11:03

SQL change logical file name

	USE [master]
	ALTER DATABASE [MyDatabase] MODIFY FILE (NAME = N'CurrentLogicalFileName', NEWNAME = N'NewLogicalFileName')
	go

arkuznetsov / git change any commit author.txt

Last active May 4, 2022 05:53

git change any commit author

	# replace commit (GIT_COMMIT) author/e-mail with GIT_AUTHOR_NAME/GIT_AUTHOR_EMAIL
	git filter-branch --env-filter "if [ $GIT_COMMIT = f6f3a903218c4e83f492df637f8341bf1df0b513 ]; then export GIT_AUTHOR_NAME='1c'; export GIT_AUTHOR_EMAIL='[email protected]'; fi"

	#purge backup
	git for-each-ref --format="%(refname)" refs/original/ \| xargs -n 1 git update-ref -d

arkuznetsov / MS_SQL_index_maintenance.sql

Created October 12, 2018 11:58

MS_SQL_index_maintenance.sql - обслуживание индексов (REORGANIZE, REBUILT) с учетом % фрагментации

	--USE ...

	DECLARE
	@PageCount INT = 128
	, @RebuildPercent INT = 30
	, @ReorganizePercent INT = 10
	, @WithRebuild BIT = 1
	, @IsOnlineRebuild BIT = 1
	, @IsVersion2012Plus BIT =
	CASE WHEN CAST(SERVERPROPERTY('productversion') AS CHAR(2)) NOT IN ('8.', '9.', '10')

arkuznetsov / MS_SQL_backup_logs.sql

Created October 12, 2018 11:57

MS_SQL_backup_logs.sql - резервная копия журналов транзакций

	USE [master]
	GO

	SET NOCOUNT ON

	DECLARE
	@db SYSNAME
	, @sql NVARCHAR(MAX)
	, @can_compress BIT
	, @WithValidate BIT = 1

arkuznetsov / MS_SQL_backup_full.sql

Created October 12, 2018 11:56

MS_SQL_backup_full.sql - полная резервная копия баз

	USE [master]
	GO

	SET NOCOUNT ON

	DECLARE
	@db SYSNAME
	, @sql NVARCHAR(MAX)
	, @can_compress BIT
	, @WithValidate BIT = 1

Artem Kuznetsov arkuznetsov