About the Author. Andrew Brust is Research Director for Big Data and Analytics at Gigaom Research. Andrew is co-author of "Programming Microsoft SQL Server 2012" (Microsoft Press); an advisor to ...

SQL Server security is more robust than the security model Access offers. In addition, SQL Server security is ... Use saved queries as opposed to SQL statements as the data sources for Access objects.

Thanks to Roger Jennings for a great article about the performance implications of various SQL Server access methods ["Optimize SQL Server Data Access," November 2003]. However, I'd like to point ...