SQL Server Management Studio 18 won’t open

SQL Server Management Studio 18 won’t open

Yes, no Oracle today.  A very short blogpost about opening SQL Server Management Studio. It didn’t open, only a splash screen pops up.

Found the solution at DBA Stack Exchange, but thought it would be nice to summarize this in a blog-post.

Logging gave no clue:

  • Running ssms.exe with logging (C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\Ssms.exe” -log C:\drop\log.txt)
  • C:\Users(user)\AppData\Roaming\Microsoft\AppEnv\15.0\ActivityLog.xml .

Solutions mentioned (first one worked for me):

  • “I just overlaid the Microsoft.VisualStudio.Shell.Interop.8.0.dll in C:\Program Files (x86)\Microsoft SQL Server Management Studio 18\Common7\IDE\PublicAssemblies with the copy from ..\PrivateAssemblies\Interop and the IDE opens”
  • Another solution:  “For me there was an additional Microsoft.VisualStudio.Shell.Interop.8.0

This is known issue and there is new official workaround which published by the SSMS developers team.

You can view the open ticket at the Microsoft feedback system .

Resources:

DBA stack exchange: https://dba.stackexchange.com/questions/237086/sql-server-management-studio-18-wont-open-only-splash-screen-pops-up

Microsoft feedback system: https://feedback.azure.com/forums/908035-sql-server/suggestions/37502512-ssms2018-installed-but-will-not-run  

Oracle Enterprise Manager 13c and Always On Monitoring

Oracle Enterprise Manager 13c and Always On Monitoring

In this cloud-era it’s almost weird to explore stuff on-premises, but I did….  In this case a slightly Higher Availibility configuration of Oracle Enterprise Manager (OEM) that doesn’t  cost anything, is not disruptive to the existing configuration and gives a tiny bit more confidence during patching of OEM : Always On Monitoring (AOM).  Maybe a bit underrated functionality – within Oracle .

When Oracle Management Server (OMS) is down for patching, AOM is capable of mailing you when a critical target is down. It’s a limited functionality, but can be quite useful in some cases. Some details has changed since the start in 2016, when DBIservices wrote about it. At the end of the blogpost my findings. (more…)

SQLDeveloper user preferences in a Citrix environment

SQLDeveloper user preferences in a Citrix environment

Installing software in a Citrix-environment is sometimes a hassle. You have to handover the software, installation- and test-documentation to the scripters and hope for the best. In this case I handed over SQLDeveloper 19.4 as a pretty default installation, very simple and scripting for Citrix is is not that hard too. Scripter tested it, I tested it, and it was all fine during the day. But… it turned out that the saved connections and other preferences were gone the next morning. A very short post to overcome this annoyance.

(more…)

Of Motorcycles, Databases and the Cloud

Of Motorcycles, Databases and the Cloud



What has Oracle to do with motorcycles? At first sight: nothing at all! Except I’m a motor rider myself and I’m doing something with databases. But, inspired by a motorcycle-vlogger I made a mental connection between those area’s, where motorcycles can be replaced by cars or any other luxury goods we are using. Just a small reflection about overlooking the hidden costs or savings.

(and by the way, the photo of Itchy Boots I used, has her permission).

Motorcycles

To explain the relation, and relevant for this short blogpost, I first need to tell you what bike I own at the moment.

My motorcycle is a Yamaha XT1200Z Super Tenere Worldcrosser with 112 BHP, 1200cc, an impressive machine with massive power, especially designed for people like me, a wannabee world-traveller with little or no experience in off-road riding. The motor has been equipped with all kind of fancy electronics avoiding me falling off, be involved in an accident or get lost. But… you don’t see a lot of dirt-road travellers choose this bike for their adventures. (more…)

Multitenancy: is a Proxy PDB part of the 3 free PDBs at 19c

Multitenancy: is a Proxy PDB part of the 3 free PDBs at 19c

As most of us know, Oracle Database 19c now supports up to 3 pluggable databases (PDBs) per container database (CDB) without requiring additional multitenant license—applicable for both Standard Edition (SE2) and Enterprise Edition (EE). This documentation clearly states: “For all offerings, if you are not licensed for Oracle Multitenant, then you may have up to 3 user-created PDBs in a given container database at any time.” Meaning it’s about user-created PDBS.

But is a Proxy PDB (in fact a kind of symbolic link in Linux terms) considered user-created, or are you allowed to have 4 PDBs in theory? Once, I attended a presentation of Carajandb (Johannes Ahrends) in Germany, who stated that a Proxy PDB is free to use, based on the 18c documentation.

(more…)

X