TheRockStarDBA

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

TheRockStarDBA

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

TheRockStarDBA

{"_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,"_

TheRockStarDBA

{
 "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": "kin.msdba@gmail.com",

TheRockStarDBA

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

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;

TheRockStarDBA

WITH ntiles AS (
    SELECT 
        id,
        height,
        weight,
        gender,
        country,
        favorite_color,
        disease, 
        NTILE(5) OVER (PARTITION BY gender, country, favorite_color ORDER BY height) as height_ntile

TheRockStarDBA

Falsehoods programmers believe about time

This is a compiled list of falsehoods programmers tend to believe about working with time.

Don't re-invent a date time library yourself. If you think you understand everything about time, you're probably doing it wrong.

Falsehoods

• There are always 24 hours in a day.
• February is always 28 days long.
• Any 24-hour period will always begin and end in the same day (or week, or month).

TheRockStarDBA

Python

This is my recommended Python setup, as of Fall 2022. The Python landscape can be a confusing mess of overlapping tools that sometimes don't work well together. This is an effort to standardize our approach and environments.

Tools and helpful links:

• Python docs: https://docs.python.org/3/
• Python Standard Library: https://docs.python.org/3/library/index.html - Start here when you're trying to solve a specific problem
• pip: https://pip.pypa.io/en/stable/ - Python's standard package installer, included with the language itself
• pipx: https://pipxproject.github.io/pipx/ - Global script installer, built on top of pip

TheRockStarDBA

#!/usr/bin/env python3


import argparse
import sys
import mmap
import logging

from collections import defaultdict