jonsagara

class Program
{
    private const string SourceDirectory = @"D:\iPhoneMedia";
    private const string DestDirectory = @"D:\iPhoneMediaSorted";

    static void Main(string[] args)
    {
        var sourceDir = new DirectoryInfo(SourceDirectory);

        // Group by YYYYMM

jonsagara

USE [master]
GO
ALTER DATABASE [tempdb] MODIFY FILE ( NAME = N'tempdev', SIZE = 102400KB , FILEGROWTH = 102400KB )
GO
ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdev2', FILENAME = N'D:\Path\To\Your\DATA\tempdb2.mdf' , SIZE = 102400KB , FILEGROWTH = 102400KB )
GO
ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdev3', FILENAME = N'D:\Path\To\Your\DATA\tempdb3.mdf' , SIZE = 102400KB , FILEGROWTH = 102400KB )
GO
ALTER DATABASE [tempdb] ADD FILE ( NAME = N'tempdev4', FILENAME = N'D:\Path\To\Your\DATA\tempdb4.mdf' , SIZE = 102400KB , FILEGROWTH = 102400KB )
GO

jonsagara

using System;
using System.Linq;
using System.Xml.Linq;

namespace OpmlStats.ConsoleApp
{
    class Program
    {
        private const string OpmlFile = @"C:\Path\To\Your\OpmlFile.opml";

jonsagara

<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets
    xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
    <CodeSnippet Format="1.0.0">
        <Header>
            <Title>AnyKeyQuit</Title>
            <Author>Jon Sagara</Author>
            <Description>Inserts a &quot;Press any key to quit...&quot; prompt</Description>
            <Shortcut>quit</Shortcut>
        </Header>

jonsagara

// Here are some example usages for unimportant jobs we have where crap happens occasionally:

/// <summary>
/// intended for database commands that might deadlock, but are just "nice to haves"; we don't care if they deadlock every now and then 
/// and we DON'T want them to block execution of the rest of /daily or /hourly! this returns -1 if deadlocked, otherwise, returns 
/// the # of rows that the SQL command affected
/// </summary>
private int ExecuteIgnoreDeadlocks(string sql, object param = null, bool logDeadlock = false)
{
    try

jonsagara

public class QuickProfiler : IDisposable
{
    private readonly Stopwatch _sw = Stopwatch.StartNew();
    private readonly string _name;

    public QuickProfiler(string name)
    {
        _name = name;
    }

jonsagara

<?xml version="1.0" encoding="utf-8"?>
<CodeSnippets
    xmlns="http://schemas.microsoft.com/VisualStudio/2005/CodeSnippet">
    <CodeSnippet Format="1.0.0">
        <Header>
            <Title>CreateMediatRClasses</Title>
            <Author>Jon Sagara</Author>
            <Description>Inserts Query, Command, and QueryHandler classes for MediatR</Description>
            <Shortcut>mediator</Shortcut>
        </Header>

jonsagara

void Main()
{
	var startYear = 2000;
	var endYear = DateTime.UtcNow.Year;
	var spookyYears = new List<(int year, int occurrences)>();

	for (var ixYear = startYear; ixYear <= endYear; ixYear++)
	{
		var spookyDaysThisYear = 0;

jonsagara

using System;
using System.Collections.Generic;
using System.Net.Http;
using System.Security.Cryptography;
using System.Text;
using System.Threading.Tasks;

namespace Pwnage
{
    public static class PwnedPasswords

jonsagara

#!/bin/bash

#
# Start elasticsearch in a new Terminal window.
#

echo "Starting elasticsearch in a new Terminal.app window..."

# See: https://stackoverflow.com/a/989357/731
osascript -e 'tell application "Terminal" to do script "~/Downloads/elasticsearch-7.10.2/bin/elasticsearch"'