Question : I should be ashamed of myself, for asking, I know. Check out this screenshot attached. My server, which […]
Tag: instance
SSMS How do I open a new Query Window using Same Connection Instance of current Window
Question : Coming from Oracle I have discovered that SSMS connects slightly different than Oracle’s SQL Developer. Oracle you click […]
Availability groups multiple instance, multiple listeners [closed]
Question : Closed. This question is off-topic. It is not currently accepting answers. Want to improve this question? Update the […]
How to determine which one is my default instance in MS SQL Server?
Question : I have two instances in my server and I want to know which one of them is the […]
SQL Server Ignoring Instance name when using port number of different instance
Question : I saw a strange case recently and still clueless on what should be the reasoning behind it. On […]
Does SQL Server perform instance recovery after clean shutdown compared to Oracle Database?
Question : If Oracle detects that an instance recovery is needed (like issuing shutdown abort command or crash happens), it […]
TSQL Solution to backup ALL databases on ALL instances of a server?
Question : I’m pretty sure what I’m wanting with my current implementation is impossible, the sys.databases catalog view which is […]
Upstart script in ubuntu for mongodb
Question : I am new to linux and mongodb. I’ve already installed mongodb on ubuntu but I want to run […]
How can MySQL return an empty row matching a given table’s schema, given the table name as an input string?
Question : How can a query or procedure return an empty copy of a new record? Ideally suited for objects […]
How to find out the service accounts for each of my instances in the current server?
Question : I have the following query that gives me one line for each sql server instance installed in the […]