Tuesday, February 11, 2020

MySQL is the DB of year 2019

In the DB-Engines ranking MySQL takes top place, Oracle is 2nd and Microsoft SQL Server is 3.


Read more here for the reasons:
https://db-engines.com/en/blog_post/83

Wednesday, February 05, 2020

Kirk Douglas was a legend and I loved his movies

Kirk Douglas dead at 103.

Kirk Douglas was a great actor, and I am not sure Michael will attain the heights his father reached.

Most of the movies I saw and enjoyed, were released during the 1960s and 1970s. I had fewer opportunities to watch Hollywood movies outside India in the later years.

The movies were riveting largely due to Kirk. I miss him and so does Hollywood. He was a role model for a person in the entertainment industry who was also of high moral caliber. He must have had great genes, healthy habits and discipline to live beyond 100.  I miss him, and so does Hollywood. 

May his soul RIP.

Here are some of the movies I enjoyed:

https://en.wikipedia.org/wiki/There_Was_a_Crooked_Man...--There was a crooked man
https://www.amazon.com/Ace-Hole-Kirk-Douglas/dp/B00170F0MK --Ace in the Hole
https://www.imdb.com/title/tt0054331/ --Spartacus (Stanley Kubrick)
https://www.imdb.com/title/tt0046672/?ref_=nm_flmg_act_74--20,000 leagues under the sea
https://www.imdb.com/title/tt0050468/?ref_=nm_flmg_act_68  --Gunfight at O.K. Corral
https://www.imdb.com/title/tt0047630/?ref_=nm_flmg_act_76  --Ulysses

Tuesday, February 04, 2020

Zebra bands on Windows Desktop

Well, this looks really odd. Where did these bands come from?






I wonder whether it is the problem with the display hardware. If I capture the window and look at it, it has no bands. Also, the display resolution does not have any effect.

Here is a solution from Window Central.

https://hodentekhelp.blogspot.com/2020/02/how-do-you-correct-windows-10-display.html


Friday, January 24, 2020

Query debugger is deprecated in SQL Server Management Studio v18.4

Maybe it will come back if enough people rant!

It looks like it has been deprecated in SSMS 18. I have SSMS v 18.4 installed and the icon is missing. Also missing is the Execute with Debugger drop-down menu in the query pane context.

Debug icon present in 2012 and 2017 SSMS. Missing in v18.4 in the 2019 version.


Missing in the Query drop-down menu. It should have been present below 'Execute'.


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.
DMCA.com Protection Status