Adam Machanic

Adam Machanic


Adam Machanic is an independent database software consultant, writer, and speaker based in Boston, Massachusetts. He has implemented SQL Server solutions for a variety of high-availability OLTP and large-scale data warehouse applications, and also specializes in .NET data access layer performance optimization. Machanic has written for SQL Server Professional magazine, serves as SQL Server 2005 Expert for SearchSQLServer.com, and is coauthor of Pro SQL Server 2005 (Apress, 2005). In addition, he regularly speaks at user groups, community events, and conferences on a variety of SQL Server and .NET-related topics. He is a Microsoft Most Valuable Professional (MVP) for SQL Server and a Microsoft Certified IT Professional (MCITP). His latest book, Expert SQL Server 2005 Development (Apress), is due out early in 2007.

Articles Authored

  • SQLCLR Security and Designing for Reuse

    Last updated: Wednesday, February 20, 2019

    Published in: CODE Magazine: 2007 - May/June

    An important principal of software design is that of “least privilege.”Basically, in any given layer of a program, you should only grant minimal access such that the code has rights to only exactly the resources it needs to get its job done-and nothing more. Most SQL Server developers understand this concept: one of the main reasons to use stored procedures is to encapsulate permission to data behind controlled and auditable interfaces, thereby not giving the caller direct access.