Skip to content

Instantly share code, notes, and snippets.

View Albejr's full-sized avatar
:octocat:
I like it!

Albertino Júnior Albejr

:octocat:
I like it!
View GitHub Profile
@Albejr
Albejr / alexa.json
Last active April 12, 2024 19:08
Alexa português pt-br
[
"Alexa, quais são suas habilidades mais populares?",
"Alexa, quais são suas habilidades com jogos?",
"Alexa, quais são suas habilidades domésticas inteligentes?",
"Alexa, que coisas posso experimentar?",
"Alexa, jogar Akinator",
"Alexa, tocar BH FM",
"Alexa, abra frases desmotivacionais",
"Alexa, jogar Perguntados",
"Qual é a previsão para Sagitário",
@Albejr
Albejr / windows-service
Last active August 25, 2020 18:33
Stop Windows Service
/*
https://support.4it.com.au/article/how-to-kill-a-windows-service-which-is-stuck-at-stopping
*/
CMD (administrador)
sc queryex [SERVICENAME]
taskkill /f /pid [PID]
OU
/*
--Object: Table-Valued Function [dbo].[fnSplitString]
--Script Date: 21/02/2019 16:06:34
DECLARE @IDs VARCHAR(100) = '1,2,3,4'
SELECT * FROM [dbo].[fnSplitString](@IDs, ',');
*/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
@Albejr
Albejr / firebase-message
Last active March 7, 2024 19:26
Localize Firebase error messages in PT-BR
catchError(err => {
const errorCode = err.code;
let errorMessage = this.VerifyErroCode(errorCode);
if (errorMessage == null) {
errorMessage = err.message;
}
console.log(errorMessage);
})
@Albejr
Albejr / calendar
Last active August 25, 2020 18:31
Calendar Files
Google Calendar API:
http://www.google.com/calendar/event?
action=TEMPLATE
&text=BANDNAME @ VENUE
&dates=STARTDATE/ENDDATE
&location=VENUE
&details=FULL BAND LIST
&trp=false
&sprop=LINK TO LMS GIG PAGE
@Albejr
Albejr / sql util
Last active August 25, 2020 18:32
Sql Query Util
--============Todas as tabelas que possuem a respectiva coluna============--
DECLARE @ColumnName VARCHAR(20) = 'Column Name'
SELECT T.name AS Tabela, C.name AS Coluna
FROM sys.sysobjects AS T (NOLOCK)
INNER JOIN sys.all_columns AS C (NOLOCK) ON T.id = C.object_id AND T.XTYPE = 'U'
WHERE C.NAME LIKE '%' + @ColumnName + '%'
ORDER BY T.name ASC
--============Ocorrência da palavra em Procedures, Functions ou Views============--