An SQL Server is a database system developed by Microsoft that is used for managing, ... However, his passion for Windows and everything related became obvious when he became a sys admin in a computer ...

In this example for audit administrative logins on the SQL Server we will audit the login from all members of the “sysadmin” role of the SQL Server. In order to audit the members of the “sysadmin” SQL ...

SQL Server on Windows - all versions that Microsoft supports. For end of support dates, check out the "Support Ends" column at https://sqlserverupdates.com. SQL Server on Linux - yes, fully supported ...

One thing I like to do occasionally, or when “inheriting” a new SQL server, is to check which users have sysadmin privileges. As these users have access to perform any activity in SQL Server it’s ...

Sometimes you become the accidental DBA, or you are the DBA by choice. Either way, you can choose to spend time working in SQL Server Management Studio (SSMS) to look at things such as backups or the ...

In SQL Server 2000, it was difficult to allow users to see the SQL Server Agent jobs on your database server without giving the user sysadmin permissions. SQL Server 2005 makes assigning this ...

So I've searched, and searched, and asked around, but can't find an answer. So of course I come back to where I know the smart folk reside. I'm trying to support one of our devs/support guys. He ...