Have you ever found yourself with the need to copy SQL Server logins from one server to another? It'll come in handy if you're setting up a failover site, building a replacement server, setting up a ...

In a previous article, I talked about getting started with managing SQL server using PowerShell and the Server Management Objects (SMO). While that was mostly spent making the connection and doing ...

My Google-fu is failing me, and BOL is (so far) being unhelpful, so I turn to the wisdom and knowledge of Ars:<BR><BR>I've got floating in the back of my head the vague idea that you can define a ...

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, managing ...