Monthly Archives: October 2016

Linkdump: SQL Server authentication credentials, users, and logins

Google “best practice for sql server logins”: Recommendations and Guidelines on Configuring the Authentication Mode for SQL Server Google “how to set up users and logins sql server”: 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:   Find a Named Range: Home menu / Editing group /  Find & Select. 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

Posted in Uncategorized | Leave a comment