Skip to content

Instantly share code, notes, and snippets.

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

Kin Shah TheRockStarDBA

🏠
Working from home
View GitHub Profile
@TheRockStarDBA
TheRockStarDBA / Adaptive Statistics Update.sql
Created March 5, 2025 21:37 — forked from FlogDonkey/Adaptive Statistics Update.sql
Finds top N execution plans in cache that took the most time to complete, extracts statistics with low sampling with changed rows (and other filtering), and issues UPDATE STATISTIC commands for each. Meant to be run in high frequency on busy systems. Optionally add NORECOMPUTE to stop SQL Server from auto-updating managed statistics.
/* To persist statistics and disallow engine rebuilding with default sampling, set @WithNoRecompute = 1 */
DECLARE @WithNoRecompute BIT = 1
,@NoRecomputeSQL VARCHAR(50) = '';
IF @WithNoRecompute = 1
BEGIN
SET @NoRecomputeSQL = ',NORECOMPUTE';
END;
DROP TABLE IF EXISTS #Temp;
@TheRockStarDBA
TheRockStarDBA / cursoai.md
Created November 4, 2024 16:22
AI prompt curso AI

Paste in Settings > Rules for AI👇

`DO NOT GIVE ME HIGH LEVEL SHIT, IF I ASK FOR FIX OR EXPLANATION, I WANT ACTUAL CODE OR EXPLANATION!!! I DON'T WANT "Here's how you can blablabla"

  • Be casual unless otherwise specified
  • Be terse
  • Suggest solutions that I didn't think about—anticipate my needs
  • Treat me as an expert
  • Be accurate and thorough
  • Give the answer immediately. Provide detailed explanations and restate my query in your own words if necessary after giving the answer
@TheRockStarDBA
TheRockStarDBA / airflow_metatdata_mining.sql
Created September 26, 2024 21:11
airflow metadata mining
-- ref: https://github.com/jimtodd92/airflow_metadata_mining/blob/main/airflow_metatdata_mining.sql
-- To get Critical user activities like paused and dagrun_clear in past 24 hours.
SELECT event
,DATE (dttm)
,count(*)
FROM PUBLIC.log
WHERE DATE (dttm) BETWEEN (
SELECT max(DATE (dttm)) - 1
FROM PUBLIC.log
)

Behavioral Interviewing

While there are a number of definitions, for our purposes, soft skills are all of the skills that are not technical. Meaning - the you that shows up the interview, as well as your technical ability. Your interview is composed of your technical prowess, as well as your soft-skills and ability to answer non-technical questions around teamwork, leadership, failure (yes), ability to adapt, timeliness, and communication skills.

If you have heard of the airport test - when hiring managers ask themselves would I want to be stuck in an airport with this person? - your non-technical stories will help them answer that question. In short: non-technical questions will ask you to tell a number of stories that supplement your technical mastery.

Interviews are subjective, based off of who’s interviewing you. When you prepare for soft-skill questions, understand the value that you can bring to a company as well as your goals and interests. You will deliver better answers and be more con

Salary Negotiation

For many of you, this will be your first time negotiating. Perhaps some of you have never once considered negotiating, and have always accepted what the employer offered. While negotiation isn’t required, it’s often recommended. You should be compensated fairly for your valuable technical skills.

This section will cover a number of strategies to help you get the best compensation possible. You shouldn’t be out to take the employer for all they’re worth. Instead you should look for compensation that works for everyone involved. Negotiation offers the ability to dramatically increase your earning potential in a very short period of time! Negotiating in a way that is researched, open, and strives to create a win-win result for you and the employer tends to have the best outcome.

Conversation vs. Negotiation

Effective negotiators understand the difference between negotiating and having a conversation. The conversation is everything that happens before the employer makes

{"_id":1,"_type":1,"_typename":"JOBGROUP","_name":"WEEKLY_DASHBOARD","_parentid":100,"_parentname":"\\DASHBOARD","_active":"Y","_effectivecalendarid":10,"_ownerid":1,"_ownername":"DASHBOARD-USER","_timewindowfromtime":null,"_timewindowfromtimeasstring":null,"_timewindowuntiltime":null,"_timewindowuntiltimeasstring":null,"_childrencount":5,"_agentid":null,"_effectiveagentid":10,"_extendedinfo":null,"_agentname":null,"_agenttype":null,"_agentostype":null,"_agentlistname":null,"_agentlistfullname":null,"_allowunscheduled":"Y","_inheritcalendar":"N","_inheritagent":"Y","_inherittimewindow":"Y","_parentactive":"Y","_command":null,"_allowrerun":"Y","_concurrency":1,"_concurrencytype":1,"_fullpath":"\\DASHBOARD\\WEEKLY_DASHBOARD","_parameters":null,"dependencies":{"totaldependencies":0,"dependencies":[]},"successors":{"totalsuccessors":0,"successors":[]}}
{"_id":2,"_type":2,"_typename":"JOB","_name":"DAILY_PROCESS","_parentid":101,"_parentname":"\\DASHBOARD\\WEEKLY_PROCESS","_active":"Y","_effectivecalendarid":11,"_
{
"meta": {
"theme": "elegant"
},
"$schema": "https://raw.githubusercontent.com/jsonresume/resume-schema/v1.0.0/schema.json",
"basics": {
"name": "Kin shah",
"label": "Senior Software Developer / Engineer at Bloomberg LP",
"image": "",
"email": "[email protected]",
@TheRockStarDBA
TheRockStarDBA / fix.md
Created October 14, 2023 23:44
airflow installation of apache-airflow-providers-mysql fails on Katacoda oreilly
pip install apache-airflow-providers-mysql
  error: subprocess-exited-with-error

  × Getting requirements to build wheel did not run successfully.
  │ exit code: 1
  ╰─> [24 lines of output]
      /bin/sh: 1: pkg-config: not found
      /bin/sh: 1: pkg-config: not found
@TheRockStarDBA
TheRockStarDBA / zillowScraper.js
Created September 15, 2023 00:30 — forked from adrianhorning08/zillowScraper.js
Zillow Scraper
async function scrollDown() {
const wrapper = document.querySelector("#search-page-list-container");
await new Promise((resolve, reject) => {
var totalHeight = 0;
var distance = 600;
var timer = setInterval(async () => {
var scrollHeightBefore = wrapper.scrollHeight;
wrapper.scrollBy(0, distance);
totalHeight += distance;