Skip to content

Instantly share code, notes, and snippets.

Mikhail mikerodionov

Block or report user

Report or block mikerodionov

Hide content and notifications from this user.

Learn more about blocking users

Contact Support about this user’s behavior.

Learn more about reporting abuse

Report abuse
View GitHub Profile
View Check_SQL_backup_version.sql
#This script retrieves SQL Server version from BAK file and allows you to compare with your SQL Server version
#If your SQL Server version is lower that one which was used to create backup you won't be able to restore BAK file
$BakFile= Read-Host "Provide full path to SQL BAK file (including file name with extension)"
$VerDetectQuery="RESTORE HEADERONLY FROM DISK='$BakFile'"
$BakMajorVer=Invoke-Sqlcmd -Query $VerDetectQuery | Select-Object -ExpandProperty SoftwareVersionMajor
$BakMinorVer=Invoke-Sqlcmd -Query $VerDetectQuery | Select-Object -ExpandProperty SoftwareVersionMinor
$BakBuildVer=Invoke-Sqlcmd -Query $VerDetectQuery | Select-Object -ExpandProperty SoftwareVersionBuild
$BakVer= "$BakMajorVer.$BakMinorVer.$BakBuildVer.0"
$ServerSQLVer=Invoke-Sqlcmd -Query "SELECT SERVERPROPERTY('productversion')" | Select-Object -ExpandProperty Column1
View Take_process_dump.ps1
# Specify process name
$ProcName = "K2HostServer"
$procid=get-process $ProcName |select -expand id
# Create target folder if not exist:
$DumpPath="C:\dumps"
If (!(Test-Path $DumpPath))
{
Write-Host 'Creating folder'
(New-Item $DumpPath -ItemType Directory | out-null)
}
View AD_DS_Enable_GC.ps1
Set-ADObject "CN=NTDS Settings,CN=DOMAINCONTROLLER-NAME,CN=Servers,CN=Default-First-Site-Name,CN=Sites,CN=Configuration,DC=DOMAIN,DC=COM" -Replace @{options='1'}
View AD_DS_Check_GC_role.ps1
#Open PS session to one of your domain controllers if necessary:
Enter-PSSession -ComputerName cndrm-dc01 -Credential DOMAIN\administrator
#Select IsGlobalCatalog propery for your DCs:
Get-ADDomainController -Filter * | Select-Object -Property Name,IsGlobalCatalog | Format-Table -AutoSize
@mikerodionov
mikerodionov / Get_SQL_version_and_navigate_to_setup_folder.ps1
Last active Apr 21, 2019
Get installed SQL Server version (for all instances on server) and navigate to the relevant setup folder
View Get_SQL_version_and_navigate_to_setup_folder.ps1
# This scripts detecs installed SQL instances through registry and returns version information
$inst = (get-itemproperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server').InstalledInstances
foreach ($i in $inst)
{
$p=(Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL').$i
(Get-ItemProperty 'HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\Instance Names\SQL').$i
(Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$p\Setup").Edition
(Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$p\Setup").Version
$ver = (Get-ItemProperty "HKLM:\SOFTWARE\Microsoft\Microsoft SQL Server\$p\Setup").Version
switch ($ver) {
View Check table size in Oracle database.sql
SELECT segment_name, segment_type, bytes/1024/1024 MB
FROM user_segments
WHERE segment_type='TABLE' AND segment_name='YOUR_TABLE_NAME'
@mikerodionov
mikerodionov / Check object owner in Oracle DB.sql
Created Apr 11, 2019
Check object owner in Oracle DB.sql
View Check object owner in Oracle DB.sql
select owner, object_name, object_type
from ALL_OBJECTS
where object_name = 'YOUR_OBJECT_NAME'
View Simplistic_SQL_cycle_example.sql
DECLARE @count int
SET @count = 1
WHILE @count <= 200
BEGIN
INSERT INTO [K2].[dbo].[StringSmO] values ('Subservice To Be Selected in Drop Down Long Name!')
SET @count = @count + 1
END
View Insert_data_into_FILESTREAM_table.sql
USE [TEST_DB]
--Example 1- Insert JPG file into FileStream column:
INSERT TestTable(DocumentNumber, DocumentBody)
VALUES
(1, (SELECT * FROM OPENROWSET (BULK 'C:\Images\Sample_Image.jpg', SINGLE_BLOB) document));
--Example 2 - Convert text into binary format:
INSERT INTO TestTable(DocumentNumber, DocumentBody)
VALUES (2, CONVERT(VARBINARY(MAX), 'Hello World'))
View Start_specified_Number_of_instances.ps1
# Code sample for this can be found in K2 Developer Reference
# 4.7:
# https://help.k2.com/onlinehelp/k2blackpearl/devref/4.7/default.htm#using_the_windows_powershell_to_start_a_k2_process.html
# 5.2:
# https://help.k2.com/onlinehelp/k2five/devref/5.2/default.htm#runtime/wf-client/ps-startprocess.html
$i = 0
$NumberOfInstancesToStart = 100000
$ProjectName = 'K2Project'
$WorkflowName = 'Process'
You can’t perform that action at this time.