Linked Servers in a sentence or two: Linked servers in SQL Server are connection definitions from one data source to another (or same instance) so that queries can be written joining tables spanning the multiple data sources. Although Linked Servers can be made to other data sources besides SQL Server (as we saw on how … Continue reading SQL Server: Curse Of Linked Server Security And The Fix – Pass-through Authentication
I am a strong proponent and a believer of using AD groups (not even AD users) to manage your SQL Server permissions end to end. Restated, you would not have any individual AD users as logins in your SQL Server instance, all instance logins with be AD groups. If you are dealing with plain SQL … Continue reading SQL Server – Drop An User In All Databases & Drop The Login Too!
Our Windows security setup is completely (well, mostly 🙂 ) AD groups based. When new employees are hired, we ask for an existing employee after whom the new employees permissions should be mirrored. In other words, if we added the new employee to the same AD groups (that are related to SQL Server of course), … Continue reading Compare AD group membership of two users
I cannot imagine a life without PowerShell now. You would agreee after you find out why. This is what I had to do today. The very real problem: I have a list of about 30 servers. I need to add an AD group name to the local adminstrators group on all 30 servers Create a … Continue reading Using PowerShell – Add user or group to local Administrators group in Windows + Create SQL Server Login