Skip to content

Instantly share code, notes, and snippets.

View bbilginn's full-sized avatar
🍺
mythub

~ ~ bbilginn

🍺
mythub
View GitHub Profile
@bbilginn
bbilginn / HttpETagCacheHandler.cs
Created July 23, 2020 06:06
HttpClient ETag based client cache handler.
class HttpETagCacheHandler : HttpClientHandler
{
private static readonly ConcurrentDictionary<string, string> ETags = new ConcurrentDictionary<string, string>();
private static readonly ConcurrentDictionary<string, byte[]> MemoryCache = new ConcurrentDictionary<string, byte[]>();
protected override async Task<HttpResponseMessage> SendAsync(HttpRequestMessage request, CancellationToken cancellationToken)
{
var pathAndQuery = request.RequestUri.PathAndQuery;
if (ETags.TryGetValue(pathAndQuery, out var ifNonMatch))
@bbilginn
bbilginn / docker-compose.yml
Last active August 15, 2022 02:59
docker compose file for sonarqube+postgres+traefik
version: "3"
services:
traefik:
image: "traefik:v2.0"
container_name: "traefik"
command:
# - "--log.level=DEBUG"
- "--api.insecure=true"

Keybase proof

I hereby claim:

  • I am bbilginn on github.
  • I am bilgin (https://keybase.io/bilgin) on keybase.
  • I have a public key whose fingerprint is C123 8855 0E14 0B37 7F6E BEA1 7AB1 9782 6CEF DECE

To claim this, I am signing this object:

@bbilginn
bbilginn / missingindex.sql
Created June 11, 2014 14:40
Missing Index
SELECT TOP 25
dm_mid.database_id AS DatabaseID,
dm_migs.avg_user_impact*(dm_migs.user_seeks+dm_migs.user_scans) Avg_Estimated_Impact,
dm_migs.last_user_seek AS Last_User_Seek,
OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) AS [TableName],
'CREATE INDEX [IX_' + OBJECT_NAME(dm_mid.OBJECT_ID,dm_mid.database_id) + '_'
+ REPLACE(REPLACE(REPLACE(ISNULL(dm_mid.equality_columns,''),', ','_'),'[',''),']','') +
CASE
WHEN dm_mid.equality_columns IS NOT NULL AND dm_mid.inequality_columns IS NOT NULL THEN '_'
ELSE ''
@bbilginn
bbilginn / _BulkCopy.cs
Created April 1, 2014 05:11
BulkCopy mechanism
using FastMember;
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Reflection;
using System.Text;
/**
* Circular Tooltip (SO)
* http://stackoverflow.com/q/13132864/1397351
*/
* { margin: 0; padding: 0; }
body {
overflow: hidden;
background: url(http://theearlcarlson.com/experiments/amTooltip/img/bg.jpg);
}
/* generic styles for button & circular menu */
@bbilginn
bbilginn / Global.asax.vb
Created March 27, 2013 22:28
Nested-Folder-Structure
' Note: For instructions on enabling IIS6 or IIS7 classic mode,
' visit http://go.microsoft.com/?LinkId=9394802
Imports System.Web.Http
Imports System.Web.Optimization
Public Class MvcApplication
Inherits System.Web.HttpApplication
Sub Application_Start()
AreaRegistration.RegisterAllAreas()