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


SQL Server 2016 Analysis Services Notes

Checking Analysis Services Deployment Mode for a SQL Server

Goto to OLAP Config folder e.g.

C:\Program Files\Microsoft SQL Server\MSAS13.SQL2016X1\OLAP\Config

In msmdsrv.ini we see

<ConfigurationSettings>

<DeploymentMode>0</DeploymentMode>

0=Multidimensional, 1=SharePoint, 2=Tabular, default=0


Being an Entertaining speaker

A professional fulltime speaker once said to me

“As a speaker the 3 things you need to be are Relevant, Interesting and Entertaining”

I would say after 2 years of speaking I have managed a level of Relevant – know your subject and audience.

I am knocking on Interesting, definitely enthusiastic, keen, exciting, projects voice well, handles a/v issues,designing demos, having a flow to the talk,answers all questions even if it takes me over a year to hunt down Bob Ward in a precon for an answer! Once I even came out from behind the desk and I have 1 joke in my 2016 talk!

The item I have not touched yet is the hard one – entertaining. Being keen is not enough, it is a skill which needs some level of study – having a story, the why not just the how,less words and more visuals.

This is my goal for this year and I will add knowledge/links to this blog post as I learn about this skill.

https://bitquabit.com/post/why-how-is-boring-and-how-why-is-awesome/

Why how is boring and how why is awesome


Comparision of JSON Data Types across Database Products

As per https://www.simple-talk.com/blogs/2016/04/21/json-rise/?utm_content=31572759&utm_medium=social&utm_source=twitter

JSON is on the rise, so here is an initial comparision of JSON data types across data products, more to follow

SQL Server

SQL Server 2016 preview – No native JSON data type, NVARCHAR used instead, no indexing

AZURE SQL DB

https://azure.microsoft.com/en-us/blog/json-functionalities-in-azure-sql-database-public-preview/

Postgres

JSON/JSONB data types

Waiting for 9.4 – Introduce jsonb, a structured format for storing json.

JSONB “Insignificant whitespace is discarded, and the order of object keys is not
preserved. Neither are duplicate object keys kept – the later value for a given
key is the only one stored.”

MongoDB

JSON / BSON data types

Informix

Native JSON/BSON data types, indexing supported, JSON sharding across a cluster of data servers supported.Wire listener supported for Mongo DB applications to talk to Informix via MongoDB community drivers and the REST API.

JSON/BSON data types

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_1770.htm?lang=en

Indexing a BSON field

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_2342.htm?lang=en

BSON processing functions

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.sqls.doc/ids_sqs_2313.htm%23ids_sqs_2313?lang=en

JSON data sharding

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.json.doc/ids_json_011.htm?lang=en

Wire listener which handles Mongo API wire protocol

https://www.ibm.com/support/knowledgecenter/SSGU8G_12.1.0/com.ibm.json.doc/ids_json_007.htm?lang=en