Skip to content

Instantly share code, notes, and snippets.

View robsonalves's full-sized avatar
🏠
Working from home

Robson Alves robsonalves

🏠
Working from home
View GitHub Profile
@JCKodel
JCKodel / ProcedureDependencies.sql
Created August 20, 2018 23:12
Obtendo uma lista de dependências de um procedure
SELECT
s.name + '.' + p.name AS procedureName
,(
SELECT DISTINCT
STUFF(REPLACE((SELECT '#!' + LTRIM(RTRIM(q.tableName)) AS 'data()'
FROM
(
SELECT DISTINCT
ts.name + '.' + t.name AS tableName
FROM sys.dm_sql_referenced_entities(s.name + '.' + p.name, 'OBJECT') AS r
@JCKodel
JCKodel / TablesLastUpdates.sql
Created August 20, 2018 23:09
Obtendo a última data de alteração de cada tabela
SELECT
q.tableName
,MAX(q.lastUpdate) AS lastUpdate
FROM
(
SELECT
s.name + '.' + t.name AS tableName
,ISNULL(u.last_user_update, '2000-01-01') AS lastUpdate
FROM sys.tables AS t
INNER JOIN sys.schemas AS s ON s.schema_id = t.schema_id
@shortjared
shortjared / list.txt
Last active April 19, 2024 10:41
List of AWS Service Principals
a4b.amazonaws.com
access-analyzer.amazonaws.com
account.amazonaws.com
acm-pca.amazonaws.com
acm.amazonaws.com
airflow-env.amazonaws.com
airflow.amazonaws.com
alexa-appkit.amazon.com
alexa-connectedhome.amazon.com
amazonmq.amazonaws.com
@danihodovic
danihodovic / main.tf
Created January 8, 2017 20:48
Terraform - static site using S3, Cloudfront and Route53
variable "aws_region" {
default = "eu-west-1"
}
variable "domain" {
default = "my_domain"
}
provider "aws" {
region = "${var.aws_region}"
@tedmiston
tedmiston / nodejs-tcp-example.js
Last active February 19, 2024 21:55
Node.js TCP client and server example
/*
In the node.js intro tutorial (http://nodejs.org/), they show a basic tcp
server, but for some reason omit a client connecting to it. I added an
example at the bottom.
Save the following server in example.js:
*/
var net = require('net');