In today’s tip I looked at how you can allow users on your system to see the SQL Agent jobs on the database server. However, just because you are able to assign these permissions, doesn’t mean ...

During the last few articles, we have covered the basics of working with SQL server using the Server Management Objects (SMO) and PowerShell. We have covered things such as viewing the state of ...

Configuring VMware Horizon View Event Database Once I'd configured the SQL database, I configured Horizon to use the database to store View Events. To do this, I logged into my View Administrator, ...

Users and developers access SQL Server for completely different reasons. So, be sure you set up access as defined by who they are and why they need access. For many database administrators ...

With SQL, you can give different users various views of the database’s structure and content. SQL has open-source code. MySQL, MariaDB and PostgreSQL offer free SQL databases that large ...

I have worked with SQL Server for many years now, back to Sybase SQL Server days and there has always been confusion over Logins and Users. Even though they typically use the same name they are ...