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

TheRockStarDBA

function Test-FileHash {
    <#
        .Synopsis
            This is a simple file hash comparison tool that writes to Windows Events when changes are detected

        .Description
            This is a simple file hash comparison tool that writes to Windows Events when changes are detected

        .PARAMETER FilePath
            The path to the file to hash and compare

TheRockStarDBA

"""An example of a cache decorator."""

import json
from functools import wraps
from redis import StrictRedis


redis = StrictRedis()

def cached(func):