TheRockStarDBA

/*
This script is used to shrink a database file in
increments until it reaches a target free space limit.

Run this script in the database with the file to be shrunk.
1. Set @DBFileName to the name of database file to shrink.
2. Set @TargetFreeMB to the desired file free space in MB after shrink.
3. Set @ShrinkIncrementMB to the increment to shrink file by in MB
4. Run the script

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

/************************************************************************************************************************************************************************************************************************************
************************************************************************************************************************************************************************************************************************************
Author		: 	Kin Shah
 
Purpose		:	Gives you the disk latency for READ / WRITE operations on DATA and LOG files.
				if Data read/write > 20 ms and Log Read / write > 15 ms then its something to look out for.

				This script generates recommendations as well ..

				This is part of my project that I am working for SQL Server health checker ..... 

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

<#
    .SYNOPSIS
    Performs a series of asynchronous pings against the target hosts.

    .PARAMETER HostName
    A string array of target hosts to ping.

    .PARAMETER PingCount
    The number of pings to send against each host.
#>

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