codingawayy

;with Counters as (
	select Id, 
		row_number() over (partition by GroupingColumn order by GroupingColumn asc) as [Counter]
	from RequisitionLine
)
update T
	set T.[Counter] = C.[Counter]
	from MyTable T inner join Counters C on T.Id = C.Id

codingawayy

// This is an auto-generated file.
<#@ template language="C#" hostSpecific="true" debug="True" #>
<#@ output extension="cs" #>
<#@ assembly name="System.Core" #>
<#@ assembly name="EnvDte" #>
<#@ import namespace="System.Linq" #>
<#@ import namespace="System.IO" #>
<#@ import namespace="System.Collections.Generic" #>
<#@ import namespace="System.Text.RegularExpressions" #>
<#@ import namespace="System" #>

codingawayy

.list-csl {
	display: inline;
	list-style: none;
	padding:0;

	li {
		display: inline;
	}

	li:after {

codingawayy

# This script configures IIS application pool and site.
# This script needs to be run once on each machine where the app is deployed.
# Run this file in powershell with admin rights. For example to deploy release config:
#   PS > server-setup.ps1 -Target release

param (
	[Parameter(Mandatory=$true,
	HelpMessage="Name of the build (e.g. - local, debug, release, etc)")]
	[string]$Target
)

codingawayy

# This script configures IIS application pool and app.
# example usage:
# PS> init-server.ps1 -AppName MyApp -TargetComputers computer1,computer2 -PSSessionUser $(PSSessionUser) -PSSessionPassword $(PSSessionPassword) -AppPoolUser $(AppPoolUser) -AppPoolPassword $(AppPoolPassword)

param(
	[Parameter(Mandatory=$true)][string]$AppName,
	[string]$TargetComputers,
	[string]$PSSessionUser,
	[string]$PSSessionPassword,
	[string]$AppPoolUser,

codingawayy

angular.module("paginator", [])
	.service("base64", function() {
		var keyStr = "ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/=";

		function utf8Encode(string) {
			string = string.replace(/\r\n/g, "\n");
			var utftext = "";

			for (var n = 0; n < string.length; n++) {

codingawayy

Private Declare Function URLDownloadToFile Lib "urlmon" Alias _
   "URLDownloadToFileA" (ByVal pCaller As Long, _
   ByVal szURL As String, _
   ByVal szFileName As String, _
   ByVal dwReserved As Long, _
   ByVal lpfnCB As Long) As Long

Public Sub GURoL(url As String, FileName As String)
    Dim lngRetVal As Long
    lngRetVal = URLDownloadToFile(0, url, FileName, 0, 0)

codingawayy

Keybase proof

I hereby claim:

• I am niaher on github.
• I am niaher (https://keybase.io/niaher) on keybase.
• I have a public key ASBktBkUBBhH4rZTMKTq-GQt26QcxCoLnnj4-F9hNkQK5go

To claim this, I am signing this object:

codingawayy

msbuild "MyApp.Database/MyApp.Database.sqlproj" `
  /t:"Build;Publish" `
  /p:SqlPublishProfilePath="MyApp.Database.automated-tests.publish.xml" `
  /p:UpdateDatabase=True `
  /p:PublishScriptFileName="publish-script.sql"

codingawayy

function Test-SqlConnection {
    param(
        [Parameter(Mandatory)]
        [string]$ConnectionString
    )

    $ErrorActionPreference = 'Stop'

    try {
        $sqlConnection = New-Object System.Data.SqlClient.SqlConnection $ConnectionString