Monthly Archives: October 2016

Linkdump: SQL Server authentication credentials, users, and logins

Google “best practice for sql server logins”: https://www.google.com/webhp?sourceid=chrome-instant&ion=1&espv=2&ie=UTF-8#q=best%20practice%20for%20sql%20server%20logins Recommendations and Guidelines on Configuring the Authentication Mode for SQL Server https://support.microsoft.com/en-us/kb/2028697 Google “how to set up users and logins sql server”: https://www.google.com/search?q=how%20to%20set%20up%20users%20and%20logins%20sql%20server Best practice on users/roles on SQL Server for a web application http://stackoverflow.com/questions/1395278/best-practice-on-users-roles-on-sql-server-for-a-web-application   … Continue reading

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

Controlling Excel VBA

Export all VBA code for a spreadsheet: http://www.pretentiousname.com/excel_extractvba   Find a Named Range: Home menu / Editing group /  Find & Select.   http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm auto_open() runs when you sheet starts. Must be present in a code module. Workbook_Open() also runs on … Continue reading

Posted in Excel | Leave a comment

Free(?) Excel video training series

http://excelcentral.com/excel2013/expert/lessons/01110-tables-in-excel.html

Posted in Uncategorized | Leave a comment