Monthly Archives: April 2017

Linkdump: SQL Server security through ActiveDirectory Groups, ConnectionString encryption

I swear I have a post or linkdump on this. Log now, search later! Securing SQL Server using ActiveDirectory: https://www.mssqltips.com/sqlservertip/1831/using-windows-groups-for-sql-server-logins-as-a-best-practice/ https://serverfault.com/questions/457798/why-does-a-d-account-need-sql-server-login https://security.stackexchange.com/questions/98247/ad-user-vs-sql-user-for-sql-server-authentication https://dba.stackexchange.com/questions/12453/login-to-sql-server-using-windows-authentication Connection String encryption: https://msdn.microsoft.com/en-us/library/89211k9b(v=vs.110).aspx https://msdn.microsoft.com/en-us/library/ms254494(v=vs.110).aspx http://stackoverflow.com/questions/11637348/encrypt-connection-string-in-app-config https://msdn.microsoft.com/en-us/library/ff647398.aspx          

Posted in Linkdump, SQL Server, System/DB Administration | Leave a comment

SQL Server linkdump: Create login, Relocate database and best practices, corruption repairs

https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=sql+server2016+create+new+login&* https://docs.microsoft.com/en-us/sql/relational-databases/security/authentication-access/create-a-login http://www.quackit.com/sql_server/sql_server_2014/tutorial/sql_server_user_logins.cfm https://www.supremainc.com/en/node/618   https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=moving+a+database+from+one+drive+to+another+detach+database&* http://dba.stackexchange.com/questions/52007/how-do-i-move-sql-server-database-files https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-user-databases https://docs.microsoft.com/en-us/sql/relational-databases/databases/move-system-databases     https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=ozar+how+to+requisition+drives+for+sql+server&* SQL Server 2005 Setup Checklist Part 2: After The Install https://www.sqlskills.com/blogs/paul/multiple-log-files-and-why-theyre-bad/     When should you put data and logs on the same drive?   SAN Storage Best … Continue reading

Posted in Linkdump, SQL Server | Leave a comment