arkuznetsov

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

arkuznetsov

rem Выполняет коммит от имени указанного автора/коммитера на указанные дату и время
rem Время указывается по московскому часовому поясу (+3 часа)
rem Пример: .\commit.cmd "Artem Kuznetsov" ArKuznetsov@gmail.com "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

@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

@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

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

arkuznetsov

# 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='1c@1c.ru'; fi"

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

arkuznetsov

--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

USE [master]
GO

SET NOCOUNT ON

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

arkuznetsov

USE [master]
GO

SET NOCOUNT ON

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

arkuznetsov

--USE MyDatabase

DBCC UPDATEUSAGE (0)
create table #t(name varchar(255), row varchar(255), reserved varchar(255), data varchar(255), inxex_size varchar(255), unused varchar(255))

insert into #t
exec sp_msforeachtable N'exec sp_spaceused ''?''' 

select * from #t
order by CONVERT(bigint,REPLACE(data,' KB','')) DESC