Download windows sdk
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
Switch to exception context
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
0=Multidimensional, 1=SharePoint, 2=Tabular, default=0
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.
Why how is boring and how why is awesome
JSON is on the rise, so here is an initial comparision of JSON data types across data products, more to follow
SQL Server 2016 preview – No native JSON data type, NVARCHAR used instead, no indexing
AZURE SQL DB
JSON/JSONB data types
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.”
JSON / BSON data types
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
Indexing a BSON field
BSON processing functions
JSON data sharding
Wire listener which handles Mongo API wire protocol