.NET Runtime Optimization Service

To run .NET Runtime Optimization Service:

Wondering why mscorsvw.exe has high CPU usage? You can speed it up.

c:\Windows\Microsoft.NET\Framework64\v4.0.30319\ngen.exe executeQueuedItems
schTasks /run /Tn “\Microsoft\Windows\.NET Framework\.NET Framework NGEN v4.0.30319 64”


Using vim as a man pager

https://zameermanji.com/blog/2012/12/30/using-vim-as-manpager/

export MANPAGER=”col -b | vim -c ‘set ft=man ts=8 nomod nolist nonu’ -c ‘nnoremap i <nop>’ -”

export MANPAGER=”col -b | vim -c ‘set ft=man ts=8 nomod nolist nonu noma’ -”

For gnu man:

export MANPAGER=”/bin/sh -c \”col -b | vim -c ‘set ft=man ts=8 nomod nolist nonu noma’ -\””

 


Linux kernel networking – monitoring and tuning

http://blog.packagecloud.io/eng/2016/06/22/monitoring-tuning-linux-networking-stack-receiving-data/

Monitoring and Tuning the Linux Networking Stack: Receiving Data


Oracle APPROX_COUNT_DISTINCT Function

Some notes on the Oracle APPROX_COUNT_DISTINCT Function

The APPROX_COUNT_DISTINCT Function – A Test Case

Testing

http://externaltable.blogspot.co.uk/2014/08/scaling-up-cardinality-estimates-in.html

Scaling up Cardinality Estimates in 12.1.0.2

http://afatkulin.blogspot.co.uk/2013/11/hyperloglog-in-oracle.html

HyperLogLog in Oracle

Sketch of the Day: HyperLogLog — Cornerstone of a Big Data Infrastructure

HyperLogLog — Cornerstone of a Big Data Infrastructure

 


SQL Server SSMS and SSDT now GA

SQL Server

SSMS now generally available

https://msdn.microsoft.com/en-us/library/mt238290.aspx

SQL Server Data Tools (SSDT) for Visual Studio 2015 is now generally available.

https://msdn.microsoft.com/en-us/library/mt204009.aspx

 


SQL Server 2016 RTM available, critical dependency!

SQL Server 2016 now available!

Visual Studio Benefit – Developer Edition

https://myprodscussu1.app.vssubscriptions.visualstudio.com/Benefits

OR

Technet Evaluation Centre

https://www.microsoft.com/en-us/evalcenter/evaluate-sql-server-2016?i=1

Important Note:

SQL Server 2016 has a critical pre-requisite for updated Visual Studio VC++ 2013 Runtime Libraries.These do NOT come via Windows Update, they are a seperate download.

https://support.microsoft.com/en-us/kb/3138367

 


Debugging SQL Server crashes with windbg

Download windows sdk

https://developer.microsoft.com/en-us/windows/hardware/windows-driver-kit

Install just debugging tools for windows

Check for updates

All Apps -> Windows Kits -> Windbb (X64)

File->Open Crash dump->

C:\Program Files\Microsoft SQL Server\<instance>\Log\SQLDump0001.mdmmp

Point to Symbols

.sympath srv*c:\Websymbols*http://msdl.microsoft.com/download/symbols;

Load symbols

.reload /f

Switch to exception context

.ecxr

Dump stack

kC 1000


Follow

Get every new post delivered to your Inbox.