Skip to content

Instantly share code, notes, and snippets.

View Mpdreamz's full-sized avatar
🐱
😹 😼

Martijn Laarman Mpdreamz

🐱
😹 😼
View GitHub Profile
@Mpdreamz
Mpdreamz / gist:4077718
Created November 15, 2012 09:46
Find Locks (SQL SERVER)
SELECT
t1.resource_type,
t1.resource_database_id,
t1.resource_associated_entity_id,
t1.request_mode,
t1.request_session_id,
t2.blocking_session_id,
o1.name 'object name',
o1.type_desc 'object descr',
p1.partition_id 'partition id',
@Mpdreamz
Mpdreamz / max_memory.sql
Created November 28, 2012 14:41
Set maximum memory usage for MSSQL
EXEC sys.sp_configure N'show advanced options', N'1' RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'max server memory (MB)', N'2000'
GO
RECONFIGURE WITH OVERRIDE
GO
EXEC sys.sp_configure N'show advanced options', N'0' RECONFIGURE WITH OVERRIDE
GO
@Mpdreamz
Mpdreamz / gist:5330654
Created April 7, 2013 14:12
Template warmers not returned on get template
--- Request Put Template
PUT http://localhost:9200/_template/put-template-with-warmers?pretty=true HTTP/1.1
Accept: application/json
Content-Type: application/json
Host: localhost:9200
Content-Length: 172
Expect: 100-continue
{
@Mpdreamz
Mpdreamz / es 20.6
Created May 6, 2013 12:36
Different search result since 0.90.0
POST http://local.localghost.io:9200/nest_test_data-9232/elasticsearchprojects/_search?pretty=true HTTP/1.1
Accept: application/json
Content-Type: application/json
Host: local.localghost.io:9200
Content-Length: 444
Expect: 100-continue
{
"from": 0,
"size": 20,
@Mpdreamz
Mpdreamz / Request.json
Created May 27, 2013 13:02
Named Filters missing matched_filters
POST http://127.0.0.1:9200/nest_test_data-6612/elasticsearchprojects/_search?pretty=true HTTP/1.1
Accept: application/json
Content-Type: application/json
Host: 127.0.0.1:9200
Content-Length: 429
Expect: 100-continue
{
"from": 0,
"size": 10,
@Mpdreamz
Mpdreamz / get-endpoints.sh
Created September 15, 2013 16:38
Get all of elasticsearch's REST endpoints, come up with method names for them and dedup them, Used in newer versions of NEST to generate the raw client (if you only need to pass and receive strings from the client. Scroll down for example output
#!/bin/bash
# This scripts scans the elasticsearch source code for all the registered REST endpoints
# It will put the formatted output in $DEFINITIONOUTPUTFILE
# [MethodName] [HttpVerb] [Route]
ESFOLDER="../elasticsearch"
DEFINITIONOUTPUTFILE="src/Generated/rest-actions.txt"
# Find all the lines that registerHandlers
@Mpdreamz
Mpdreamz / gist:6807074
Created October 3, 2013 08:44
default proxy set to fiddler to see web requests initiated by .net application/libraries
<system.net>
<defaultProxy>
<!-- Uncommment this line if you want to see web requests initiated by .NET (think WCF/REST calls)
REMEMBER TO UNDO THIS IF YOU CLOSE FIDDLER!
-->
<!--<proxy bypassonlocal="False" usesystemdefault="True" proxyaddress="http://127.0.0.1:8888" />-->
<proxy bypassonlocal="False" usesystemdefault="True" />
</defaultProxy>
</system.net>
@Mpdreamz
Mpdreamz / gist:8579620
Created January 23, 2014 14:44
Example of exact term boost over fuzzy for Tomas Jansson
PUT http://localhost:9200/prefix_test
{
"settings": {
"blocks.read_only": false
},
"settings": {
"analysis": {
"analyzer": {
"customanalyzer": {
"type": "custom",
@Mpdreamz
Mpdreamz / aggs.metada
Last active August 29, 2015 14:02
Metadata aggregations example
DELETE /countries
PUT /countries
{
"mappings": {
"anthems" : {
"properties": {
"location": {
"type": "geo_point"
}
@Mpdreamz
Mpdreamz / code.cs
Last active August 29, 2015 14:16
Suggested output for the elasticsearch serilog sink 2.0
try
{
try
{
throw new Exception("inner most exception");
}
catch (Exception e)
{
//NastyInnerException does its own ISerializable.GetObjectData() implementation
var innerException = new NastyException("nasty inner exception", e);