Skip to content

Instantly share code, notes, and snippets.

View MateuszNad's full-sized avatar

mnadobnik MateuszNad

2 followers · 2 following
View GitHub Profile
@MateuszNad
MateuszNad / FeedlyApiModule
Last active May 22, 2017 19:23
<#
More about Feedly API - #The feedly Cloud API - https://developer.feedly.com/
What are the differences with a regular access token?
A developer access token has a longer life than a regular access token: it expire after 30 days (instead of one week).
It can be renewed by feedly pro accounts. It is limited to 250 API requests per day
#>
######################### Global variable #######################################
@MateuszNad
MateuszNad / terminating_error
Created June 13, 2017 04:51
try
{
Get-Function
}
catch
{
$_.Exception.Message
}
@MateuszNad
MateuszNad / non-terminating errors
Created June 13, 2017 04:52
try
{
Get-Item E:\File
}
catch
{
$_.Exception.Message
}
@MateuszNad
MateuszNad / terminating_error
Created June 13, 2017 09:16
try
{
Get-ItemFile
}
catch{
Write-Host $_.Exception.Message
}
finally
{
Write-Host "koniec przykładu ..."
@MateuszNad
MateuszNad / powercfg_setacvalueinde.ps1
Last active January 15, 2019 19:57
powercfg /list
<#
Existing Power Schemes (* Active)
-----------------------------------
Power Scheme GUID: 381b4222-f694-41f0-9685-ff5bb260df2e (Zr˘wnowaľony) *
Power Scheme GUID: 64e503f0-b342-49a3-be71-aea540101d3f (Zegary wyˆĄczone (prezentacja))
Power Scheme GUID: 94334198-5f41-42e4-b4b5-6732b7e13386 (Samolotowy)
#>
$PowerSchemeGUID = "381b4222-f694-41f0-9685-ff5bb260df2e"
@MateuszNad
MateuszNad / example-EncodedCommand.ps1
Created February 10, 2019 20:12
powershell -E "cwBhAGwAIABhACAATgBlAHcALQBPAGIAagBlAGMAdAA7AGkAZQB4ACgAYQAgAEkATwAuAFMAdAByAGUAYQBtAFIAZQBhAGQAZQByACgAKABhACAASQBPAC4AQwBvAG0AcAByAGUAcwBzAGkAbwBuAC4ARABlAGYAbABhAHQAZQBTAHQAcgBlAGEAbQAoAFsASQBPAC4ATQBlAG0AbwByAHkAUwB0AHIAZQBhAG0AXQBbAEMAbwBuAHYAZQByAHQAXQA6ADoARgByAG8AbQBCAGEAcwBlADYANABTAHQAcgBpAG4AZwAoACcAVABZAHgAQgBDAHMASQB3AEYAQQBXAHYAOABpAGkAVQBiAE4AcQBOAEgAcQBHAGkAZABDAE4AQwB3AEMANABsAHgASQBkADgAbQBpAGIANAA4ADkAMgBJAGgAOQBlAGkAQwA1AGMAegBNAEgATwBnADkAWQBNAHMAWQA2ADQAVwBjAGkAUQBtAHkAZAB2AE4ANQBhAFEAbABzAGwAYgAwAGUAMABsAEcAUgBYAE0ATQBDADUARgBrAEoAcAB4AHIANgB6ADIAMQB6AGoAVgA0AHcAUgBjADEARABNAHAAZwBVAHYASQB1AEcARgBmAEgAeABHAGoANABMAGMAWgByAGgAegBYAHUATQBCAFcAZABKAGQAOAA4AHoAYwB2AHoAdwAyAGQAUgBlADQAVAAwAGgAZgAvAEgARwB3AD0APQAnACkALABbAEkATwAuAEMAbwBtAHAAcgBlAHMAcwBpAG8AbgAuAEMAbwBtAHAAcgBlAHMAcwBpAG8AbgBNAG8AZABlAF0AOgA6AEQAZQBjAG8AbQBwAHIAZQBzAHMAKQApACwAWwBUAGUAeAB0AC4ARQBuAGMAbwBkAGkAbgBnAF0AOgA6AEEAUwBDAEkASQApACkALgBSAGUAYQBkAFQAbwBFAG4AZAAoACkA"
@MateuszNad
MateuszNad / Convert-ImageToASCII.ps1
Last active February 14, 2019 17:44
<#
.Synopsis
Create-AsciiImage
.DESCRIPTION
This script loads the specified image and outputs an ascii version to the pipe, line by line.
My version the script:
https://gallery.technet.microsoft.com/scriptcenter/bc15444a-9490-4115-aa40-76d898041724
.EXAMPLE
Convert-ImageToASCII -Path C:\Temp\image.jpg -MaxWidth 30
@MateuszNad
MateuszNad / cpu.sql
Last active February 17, 2019 20:28
-- Get CPU Utilization History for last 256 minutes (in one minute intervals) (Query 43) (CPU Utilization History)
DECLARE @ts_now bigint = (SELECT cpu_ticks/(cpu_ticks/ms_ticks) FROM sys.dm_os_sys_info WITH (NOLOCK));
SELECT TOP(256) SQLProcessUtilization AS [SQL Server Process CPU Utilization],
SystemIdle AS [System Idle Process],
100 - SystemIdle - SQLProcessUtilization AS [Other Process CPU Utilization],
DATEADD(ms, -1 * (@ts_now - [timestamp]), GETDATE()) AS [Event Time]
FROM (SELECT record.value('(./Record/@id)[1]', 'int') AS record_id,
record.value('(./Record/SchedulerMonitorEvent/SystemHealth/SystemIdle)[1]', 'int')
AS [SystemIdle],
@MateuszNad
MateuszNad / Test-LastBackups.ps1
Last active February 25, 2019 10:21
<#
.Synopsis
Test-LastBackups
Funkcja korzystająca z poleceń Test-DbaLastBackup, Out-DbaDataTable, Write-DbaDataTable modułu dbatools.
Służy do testowego przywracania kopii zapasowych oraz sprawdzania logicznej i fizycznej integralności obiektów w bazie danych.
Rezultaty zapisywane są do bazy danych określonej w parametrze -OutDatabase i tabeli - OutTable
.EXAMPLE
$paramTestLastBackups = @{
@MateuszNad
MateuszNad / AvailabilityGroups_Restore_StepByStep.sql
Last active February 25, 2019 21:32
-- Włącz SQLCMD Mode
-- 1. Usunięcie bazy danych z Availability Group na instancji Primary
:connect db-test02
ALTER AVAILABILITY GROUP [TestAG] REMOVE DATABASE [NewTestAG];
GO
-- 2. Przywrócenie kopii pełnej, następnie w zależności o polityki kopii zapasowych kopie różnicową i na końcu logi transakcyjne
-- Tutaj wersja uproszczona, tylko full
:connect db-test02
RESTORE DATABASE NewTestAG FROM DISK = N'\\db-test02\SQLBackup\f_bck_NewTestAG_200220192056.bak'