Wednesday, January 15, 2020

What are the scripting options in SQL Server 2019?

What are the scripting options in SQL Server 2019?
The Scripting options can be accessed from Tools: Options in the SQL Server Management Studio v18.4.



In the Options window drill-down on SQL Server Object Explorer | Scripting as shown.

 Expand the node, General scripting options to display the following:


 Expand the node, Object scripting options to display the following:


 Expand the node, Table and view options to display the following:

 Expand the node, Version options to display the following:

In each version of SSMS, the Options window is slightly different or arranged differently.

Thursday, January 9, 2020

Hands-on Learning Event in Honolulu 1 : Introduction to Structured Query Language

A new session is going to start soon. Sign-up here.


Microsoft SQL Azure Database: SQL Server in Microsoft Cloud
Windows PowerShell for SQL Server


My sincere thanks and best wishes to my students in the previous meets of this course.




Monday, January 6, 2020

What is XEvent Profiler in SQL Server Management Studio (SSMS) 2019 and where do you find it?

XEvent Profier's role in SSMS is for troubleshooting SQL Server Issues such as slow running queries, identify long-running queries, monitor SQL statements, etc. From Version SQL Server 7.0, SQL Profiler was used, but it was not easy to use due to the lack of a GUI.

SQL Profiler was replaced by XEvent Profiler which is easy to use and presents a quick view of Extended Events.
XEvents is a feature of SSMS and not SQL Server and it was available in SSMS V17.3.

It is also available in SSMS V18.4 which is the latest version of SSMS as of now. You can find in the Object Explorer (bottom-most node)  of SSMS as shown here.



Tuesday, December 10, 2019

Is MobX a framework?

Not in the sense of a JavaScript Framework. Frameworks may leverage MobX.
From my answer in Quora:
From MobX site:
MobX is a battle-tested library that makes state management simple and scalable by transparently applying functional reactive programming (TFRP). The philosophy behind MobX is very simple:
Anything that can be derived from the application state, should be derived. Automatically.
which includes the UI, data serialization, server communication, etc.

Wednesday, December 4, 2019

What is the difference between NFC and Bluetooth?


Near Field Communication (NFC) is a standards-based short-range wireless connectivity technology that makes life easier and more convenient for consumers around the world by making it simpler to make transactions, exchange digital content, and connect electronic devices with a touch.

More on their differences here;
http://nearfieldcommunication.org/bluetooth.html

Both use wireless communication.

Bluetooth is short-range with a maximum range of about 30 feet
NFC (Near Field Communication is even shorter with a range of few centimeters (like NFC card to enter your hotel room).

NFC consumes less power compared to Bluetooth.

Because of the range, Bluetooth is more prone to interference with other Bluetooth devices.

Note that the newer Bluetooth known as BLE (low energy type) may use energy comparable to NFC

Sunday, November 17, 2019

What is a Microservice?

A microservice is an architectural design that separates portions of a (usually monolithic) application into small, self-containing services.

Out body is perhaps an analogy of a service 'body' with server microservices like the 'five senses' etc.

"Microservices is an architectural style that develops a single application as a set of small services. Each service runs in its own process. The services communicate with clients, and often each other, using lightweight protocols, often over messaging or HTTP"--
https://stackify.com/what-are-microservices/

You will have to use several frameworks to build a microservice application.
"Spring Boot", "Jersey" and "Swagger" are some of the frameworks for developing in Java.
https://stackify.com/what-are-microservices/

If you are using C++ go here:
http://cppmicroservices.org/

Read this first:
http://docs.cppmicroservices.org/en/stable/README.html#introduction

Wednesday, June 19, 2019

Do you fail to see Windows Sandbox in Windows Features?

If you try to look for Windows Sandbox in the Windows Features box this is what you will find.

WindowsSandbox_02.jpg

But to enable Windows Sandbox you need this in the Windows Features.
You look through the internet and surf away there are various suggestions. But what matters is the Windows Version you have. You would assume, that since you have agreed for automatic updates everything is fine. That is not the case.

I found out that I was running Windows 10 Pro version 1803 and that was the real problem. I tried to update to the needed version 1903 or higher but I was not able to do it from the desktop.

I had to get the Windows 10 Update Assistant to install the higher version.


I finally installed the Windows 10 Update Assistant and ran the program.

It takes a while and the installation would require you to have nothing connected to the USB Ports. If they are connected to anything you will get an error which is easy to correct.

Now with the new version you will see the Windows Sandbox in Windows Features as shown.

That concludes the task of bringing the Windows Sandbox node to the Windows Features.