Image by @isaacmsmith

Query Store allows you to monitor and troubleshoot queries. It also provides stats about runtime such as CPU, IO and Memory.

Enable Query Store with default configuration using below SQL. It is enabled at database level.

SQL Server Enterprise offers scalable memory optimized relational tables. Yes, all data inside table will be loaded in memory. In-Memory tables has two flavors.

• Durable - Offers ACID
• Non-Durable

Ideas Matter Continuous Learning Culture

Adil Najam (Dean, Pardee School of Global Studies, Boston University) gave a talk on topic "Ideas Matter: A reading list for ideas wallahs". He passionately talked about his top 10 books everyone should read, especially folks who are in position of power and ability to influence masses. Focus of his talk was everyone should read books to be the catalyst of real social change & better policy maker.

I would like thank him for bringing immensely valuable topic to the light. My thoughts which are heavily influenced by my recent reading(s) & professionally working as software developer in small to large tech companies in different countries.

Knowledge and problems are two fundamental sources of how human(s) brain emulate idea(s), I guess other species do the same. This raises a fundamental question of how to gain knowledge, since books are an efficient way to store, and communicate knowledge among other modern & innovative ways like audible books, blogs, video and learning from each other etc.

MS Office Interop Automation in C#

Problem Statement: For instance, online training web site asked students to submit their assignments for Microsoft Office Access.  The Project involves performing many tasks in MS Access. and evaluating projects manually will be impossible for site with thousands of concurrent users. So, it will require automation for instant feedback and accurate grading; right?

How to automate: We have to create & release instance of MS Access Application object. However, it can be achieved in two ways:

1. Add reference to Office Interop dll's as shown in below code snippet.
2. Late Bind, use Type.GetTypeFromProgID("Access.Application") to get type, rest of the code stays same.