weeksdev

WebRequest request = WebRequest.Create("https://splunkserver/services/collector");

request.Method = "POST";

request.Headers.Add("Authorization", "Splunk YOUR_GUID");

ASCIIEncoding encoding = new ASCIIEncoding();
var requestBody = JsonConvert.SerializeObject(new
{
    @event = new

weeksdev

using System;
using System.Net;

class Webby
{
    public string Request(string url, string processName)
    {
        try
        {
            WebClient client = new WebClient();

weeksdev

Creating nuspec file

Go to the path with the .csproj file

Run the following command:

nuget spec

Filling out assembly info

weeksdev

VS Code Setup

1. Install VSCode _ Install C# Extensions _ Install Auto-Using
2. Install dotnet sdk 2.2.402 -> https://dotnet.microsoft.com/download/dotnet-core/thank-you/sdk-2.2.402-windows-x64-installer
3. Install msbuild 2019 -> Build Tools for Visual Studio 2019 (Down on bottom) -> https://visualstudio.microsoft.com/downloads/
4. Install dbeaver to be able to view sqlite dbs or use this for simple option: https://sqlitebrowser.org/blog/portableapp-for-3-11-2-release-now-available/
5. From cli run: dotnet dev-certs https

weeksdev

CREATE LOGIN {{username}} WITH PASSWORD = '{{strong_password}}';
CREATE DATABASE {{database_name}};
ALTER DATABASE {{database_name}} SET RECOVERY SIMPLE;
ALTER AUTHORIZATION ON DATABASE::{{database_name}} TO {{username}};
SELECT suser_sname (owner_sid), * FROM sys.databases ORDER BY name WHERE name = '{{database_name}}';

--FOR WINDOWS LOGIN
create login [<<DOMAIN\USERNAME>>] from windows;

-- For older versions of SQL Server:

weeksdev

Mock<IValidator<Suggestion>> validator = new Mock<IValidator<Suggestion>>();
            validator.Setup(v => v.Validate(It.IsAny<ValidationContext>())).Returns(new FluentValidation.Results.ValidationResult());

weeksdev

SELECT 
    cast(r.total_elapsed_time as decimal(18,2)) / 1000 / 60,
    r.session_id
    ,st.TEXT AS batch_text
    ,SUBSTRING(st.TEXT, statement_start_offset / 2 + 1, (
            (
                CASE 
                    WHEN r.statement_end_offset = - 1
                        THEN (LEN(CONVERT(NVARCHAR(max), st.TEXT)) * 2)
                    ELSE r.statement_end_offset

weeksdev

version: 1.0.{build}
image: Visual Studio 2015
build_script:
- cmd: PowerShell -Version 2.0 .\build.ps1
test: off

weeksdev

alias gofolder='cd "c:/Program Files/Some Folder"'

alias gitlogjira="git log --pretty=oneline | grep -e '[A-Z]\+-[0-9]\+' -o | sort -u"

alias tree='cmd //c tree //a'

alias gitlog="git log --pretty --oneline"

weeksdev

Removing console logs

^.*console\.log\(.*\).*\n