PRElias

/* Drop all non-system stored procs */
DECLARE @name VARCHAR(128)
DECLARE @SQL VARCHAR(254)

SELECT @name = (SELECT TOP 1 [name] FROM sysobjects WHERE [type] = 'P' AND category = 0 ORDER BY [name])

WHILE @name is not null
BEGIN
    SELECT @SQL = 'DROP PROCEDURE [dbo].[' + RTRIM(@name) +']'
    EXEC (@SQL)

PRElias

# Setando a imagem a ser baixada
# https://github.com/jenkinsci/docker
FROM jenkins/jenkins:lts
# Author
LABEL Paulo Roberto Elias "ppuspfc@gmail.com"
# Seta o usuário para ficar administrador
USER root
# Atualiza o S.O.
RUN apt-get update

PRElias

# Setando a imagem a ser baixada
# https://hub.docker.com/r/microsoft/mssql-server-linux/
FROM microsoft/mssql-server-linux:latest
# Author
LABEL Paulo Roberto Elias "ppuspfc@gmail.com"
# Seta o usuário para ficar administrador
USER root
# Atualiza o S.O.
RUN apt-get update

PRElias

/****** Object:  LinkedServer [EXCEL]    Script Date: 09/06/2013 10:02:20 ******/
EXEC master.dbo.sp_addlinkedserver @server = N'EXCEL', @srvproduct=N'Excel files', @provider=N'ADsDSOObject', @datasrc=N'c:\temp\importacoes.xls', @provstr=N'Excel 8.0'
 /* For security reasons the linked server remote logins password is changed with ######## */
EXEC master.dbo.sp_addlinkedsrvlogin @rmtsrvname=N'EXCEL',@useself=N'False',@locallogin=NULL,@rmtuser=NULL,@rmtpassword=NULL

GO

EXEC master.dbo.sp_serveroption @server=N'EXCEL', @optname=N'collation compatible', @optvalue=N'false'
GO

PRElias

Windows Registry Editor Version 5.00

[HKEY_CLASSES_ROOT\Microsoft.PowerShellScript.1\Shell\runas]
"HasLUAShield"=""

[HKEY_CLASSES_ROOT\Microsoft.PowerShellScript.1\Shell\runas\command]
@="powershell.exe \"-Command\" \"if((Get-ExecutionPolicy ) -ne 'AllSigned') { Set-ExecutionPolicy -Scope Process Bypass }; & '%1'\""

PRElias

# Configurando
Set-ExecutionPolicy -ExecutionPolicy Bypass -Force

# Instalando Chocolatey 
Invoke-Expression ((new-object net.webclient).DownloadString('https://chocolatey.org/install.ps1'))

# Recarregando PATH variables
$env:Path = [System.Environment]::GetEnvironmentVariable("Path","Machine") + ";" + [System.Environment]::GetEnvironmentVariable("Path","User") 

# Instalações fundamentais

PRElias

Website pessoal

Template de recursos markdown / Github.

Clone ou baixe o repositório e verifique o arquivo em seu editor de texto preferido para exibir as sintaxes para cada item desejado.

Listas e links para outros documentos no mesmo repositório

• Projetos pessoais

Exibição de GIFs animados de outro repositório (não funciona no GitHub Gist)

PRElias

SELECT 
	value
	,REPLACE(REPLACE(value, CHAR(13), ''), CHAR(10), '') AS OnlyCharacters
FROM STRING_SPLIT(
'paulo
,roberto
,elias
', ',')

PRElias

SELECT deqs.last_execution_time AS [Time], dest.text AS [Query], dest.*
FROM sys.dm_exec_query_stats AS deqs
CROSS APPLY sys.dm_exec_sql_text(deqs.sql_handle) AS dest
ORDER BY deqs.last_execution_time DESC

PRElias

Route::get('/laravellog', function () {
    $file = storage_path() . DIRECTORY_SEPARATOR . 'logs' . DIRECTORY_SEPARATOR . 'laravel.log';
    $data = file($file);
    
    $currentLine = count($data) - 1000;
    if($currentLine < 0){
        $currentLine = 0;
    }
 
    while($currentLine <= count($data) - 1){