jzabroski

using DemoGrpc.Domain.Entities;
using DemoGrpc.Protobufs;
using Grpc.Core;
using Microsoft.Extensions.DependencyInjection;
using Polly;
using System;
using System.Linq;
using System.Net.Http;
using System.Threading.Tasks;
using static DemoGrpc.Protobufs.CountryService;

jzabroski

#Run this to reverse ignoring of changes to web.config so it gets committed.
git update-index --no-assume-unchanged path_to_file/web.config

jzabroski

using System;
using System.CodeDom.Compiler;
using System.Reflection;
using System.Threading.Tasks;

/*
    To execute, run
    string code = "your code here";
    if (!code.Contains("return")) code = "return " + code;
    code = code.Trim().TrimEnd(';') + ";";

jzabroski

Keybase proof

I hereby claim:

• I am jzabroski on github.
• I am johnzabroski (https://keybase.io/johnzabroski) on keybase.
• I have a public key ASDMWKXdhimJDGdWnb6YFpabkXxft4PBiHEAWI1zDB-GMQo

To claim this, I am signing this object:

jzabroski

-- Originally from: https://mssqlwiki.com/2012/05/04/copy-database-wizard-or-replication-setup-might-fail-due-to-broken-dependency/
--Below script will fix the broken dependencies on all the objects
----------------------------------------------------------------------------
--List of objects for which referenced objects are missing.
--ex: View created on table XYZ and table XYZ is dropped
----------------------------------------------------------------------------
SELECT OBJECT_NAME (referencing_id),referenced_database_name, referenced_schema_name, referenced_entity_name
FROM sys.sql_expression_dependencies
WHERE referenced_entity_name not in (select name from sysobjects)
 

jzabroski

Param (
[Parameter(Mandatory=$true)] [String]$ServiceName
)

<#
From: https://gallery.technet.microsoft.com/PowerShell-Script-for-8243e5d1
This is a PowerShell Script to restart a windows service with its dependent services. The dependent services that were not running when the restart request made, will not be started, so that the system services state will remain same after restart service script run.
#>

[System.Collections.ArrayList]$ServicesToRestart = @()

jzabroski

# Copyright (c) 2016 Microsoft Corporation. All Rights Reserved.
# Licensed under the MIT License (MIT)

function New-RsSubscription {
    <#
        .SYNOPSIS
            This script creates a new reporting subscription.
        
        .DESCRIPTION
            This script creates a new reporting subscription based on the parameters provided. NOTE: A new subscriptionId will be generated.

jzabroski

-- Taken from: http://sqlblog.com/blogs/hugo_kornelis/archive/2014/07/18/database-mail-and-then-the-smtp-server-changed.aspx
DECLARE @NewServer sysname = 'NotTelling.mail', -- New SMTP server
        @OldServer sysname = 'MySecret.mail',   -- Old SMTP server
        @account_id int;

DECLARE Cursor_MailAccounts CURSOR LOCAL FORWARD_ONLY STATIC READ_ONLY
FOR SELECT account_id
    FROM   msdb.dbo.sysmail_server
    WHERE  servername = @OldServer;             -- Add extra logic here

jzabroski

<# .SYNOPSIS
        Export of SSRS reports datasources and images
    .DESCRIPTION
        This PowerShell script exports all (or filtered) reports, data sources and images directly from the ReportServer database
        to a specified folder. For the file name the complete report path is used; for file name invalid characters are replaced with a -.
        Reports are exported with .rdl as extension, data sources with .rds and resources without any additional extension.
        Please change the "Configuration data" below to your enviroment.
        Works with SQL Server 2005 and higher versions in all editions.
        Requires SELECT permission on the ReportServer database.
    .NOTES

jzabroski

# Date:     16/02/14
# Author:   John Sansom
# Description:  PS script to generate all SQL Server Agent jobs on the given instance.
#       The script accepts an input file of server names.
# Version:  1.1
#
# Example Execution: .\Create_SQLAgentJobSripts.ps1 .\ServerNameList.txt
 
param([String]$ServerListPath)