VMWare : How to enable SSH access to ESXi hosts

Posted by Sqltimes
On December 26, 2015
0 Comments

Quick one today A few months ago, in our lab we tried to enable SSH access to our ESXi hosts and these are the steps we followed. First, if you have access to the ESXi console, hit F2 and log in. From the System Customization screen, go to ‘Troubleshooting Options’, and hit <Enter>. In the […]

Posted by Sqltimes
On December 19, 2015
0 Comments

Sql Server allows assigning or GRANTing different applicable permissions to different objects. Since there are so many nuances, sometimes it gets confusing. So this cheat sheet helps reduce the confusion and always come in handy when assigning permissions to securables. Some are listed below: Tables View Type Stored Procedure Functions Synonym User Role Schema Database […]

Posted by Sqltimes
On December 12, 2015
0 Comments

A few months ago, there was an interesting conversation that uncovered this recommendation for maximum & minimum server memory setting for VLDB instances. Memory is a crucial to any database servers; And it becomes more important for VLDBs. So it is important that we achieve optimal memory settings. As with anything else, the correct setting […]

Posted by Sqltimes
On December 5, 2015
0 Comments

Quick one today: A while ago, we had a post on how to set a database in Single User mode to perform some operations. Now, we could look at how to set a database back to multi user mode. 1 2 3 4 5 6 -- -- Set a database in multi user -- ALTER […]

VMWare : How to enable SSH access to ESXi hosts

Sql Server : GRANT or Assign permissions on table, procedure, function, type, etc to user accounts

Sql Server : Optimal Maximum and Minimum Server Memory Settings for VLDB Sql Instances

Sql Server : Set a database in Multi User Mode