What OS permissions does SQL Server have?

If you set the service account for the SQL Server services up at installation you are ahead of the game when dealing with securing your SQL Server installation. However there are some environments where the DBA does not do the initial installation of SQL Server. That requires the DBA to go back and configure a custom account [...]

Get those ACLs with PowerShell

If I want to view the access permissions to a particular directory in Windows I can always go to the folder itself and check the security properties on the folder: But that is boring, lets use PowerShell!!! The cmdlet (commandlet) of choice for this is going to be: Get-Acl I will let you dive into this [...]