Skip to content

Instantly share code, notes, and snippets.

View rodolfofadino's full-sized avatar

Rodolfo Fadino Junior rodolfofadino

111 followers · 26 following
View GitHub Profile
@rodolfofadino
rodolfofadino / FindMostExecutedQueries.sql
Created October 9, 2017 18:38
Find Most Executed Queries
SELECT TOP 50
qs.execution_count
,OBJECT_NAME(objectid)
,query_text = SUBSTRING(
qt.text,
qs.statement_start_offset/2,
(CASE WHEN qs.statement_end_offset = -1
THEN len(convert(nvarchar(max), qt.text)) * 2
ELSE qs.statement_end_offset
END
@rodolfofadino
rodolfofadino / pingdom-app.js
Created July 11, 2017 03:11
Example Raspberry PI and Pingdom API
var request = require('request');
var gpio = require('rpi-gpio');
gpio.setup(7, gpio.DIR_OUT,off7);
gpio.setup(11, gpio.DIR_OUT, off11);
var options = {
url: 'https://api.pingdom.com/api/2.0/checks',
headers: {
'User-Agent': 'rasp',
@rodolfofadino
rodolfofadino / .gitconfig
Created February 16, 2017 12:39
.gitconfig
[user]
name = usename
email = email@email.com
[filter "lfs"]
clean = git-lfs clean %f
smudge = git-lfs smudge %f
required = true
[alias]
freebase = pull --rebase
commit = commit -a -v
@rodolfofadino
rodolfofadino / CreateVMFromVhd.ps1
Created September 24, 2016 17:38
Create 10 vms from vhd
Login-AzureRmAccount
Select-AzureRmSubscription -SubscriptionId "xxxx-xxxx-xxx-xxxx-xxx"
$rgName = "resourcegrup"
$location = "brazilsouth"
$storageName="storage"
New-AzureRmResourceGroup -Name $rgName -Location $location
@rodolfofadino
rodolfofadino / createcert.ps1
Created July 8, 2016 18:57
Create AutoSigned Certificate
New-SelfSignedCertificate -certstorelocation cert:\localmachine\my -dnsname *.domain.com
CE0976529B02DE058C9CB2C0E64AD79DAFB18CF4
$pwd = ConvertTo-SecureString -String "Pa$$w0rd" -Force -AsPlainText
Export-PfxCertificate -cert cert:\localMachine\my\CE0976529B02DE058C9CB2C0E64AD79DAFB18CF4 -FilePath e:\temp\cert.pfx -Password $pwd
@rodolfofadino
rodolfofadino / publishNuget.ps1
Created June 21, 2016 17:50
Publish Nuget with PowerShell
$Packages = New-Object System.Collections.ArrayList
$Packages.Add(@{packageName="My.PackageXPTO";filePath="..\..\Projects\MyPackage\bin\Debug\My.PackageXPTO.dll"})
$Packages.Add(@{packageName="My.OtherPackageXPTO";filePath="..\..\Projects\MyOhterPackage\bin\Debug\My.OtherPackageXPTO.dll"})
foreach($Package in $Packages)
{
$packageName = $Package.packageName
$filePath= $Package.filePath
@rodolfofadino
rodolfofadino / SchedulerTasks.bat
Created March 21, 2016 15:06
Scheduler Tasks
##List scheduler tasks
schtasks /Query /FO CSV /V > c:/output.csv
##Change the user scheduler task
schtasks /Change /TN "\Path\Schedulename" /RU "Domain\User" /RP "password"
@rodolfofadino
rodolfofadino / GenericJsonWebHookHandler.cs
Created December 27, 2015 14:58
IntegrateVisualStudioServicesAndSlackWithWebHook
public class GenericJsonWebHookHandler : WebHookHandler
{
public GenericJsonWebHookHandler()
{
this.Receiver = "genericjson";
}
public override Task ExecuteAsync(string generator, WebHookHandlerContext context)
{
usuarios = new List<Usuario>();
@rodolfofadino
rodolfofadino / app_deploy.py
Created September 6, 2015 17:06
webserver in Python to run PowerShell scripts
from flask import Flask
from flask import request
import requests
import subprocess
import json
import time
payload_url = 'https://url-que-notificaremos-quando-o-deploy-terminar/'
app = Flask(__name__)
@rodolfofadino
rodolfofadino / QueryToFindExecutadedQuery.sql
Created August 24, 2015 20:55
QueryToFindExecutadedQuery.sql
SELECT top 2000 execquery.last_execution_time AS [Date Time], execsql.text AS [Script] FROM sys.dm_exec_query_stats AS execquery
CROSS APPLY sys.dm_exec_sql_text(execquery.sql_handle) AS execsql
where execsql.text like '%textoparaprocurar%'
ORDER BY execquery.last_execution_time DESC