Peter Avila

“My goal in class is to help students get what they came to get by providing them with an experience. When you have an experience, things stick with you, and you have something to draw on.”


SQL Server, Transact-SQL, DTS, Integration Services, Reporting Services, .Net


  • Current consultant using SQL Server and .Net in database design and development and building web and Windows-based applications
  • Former course designer and instructor of database management systems and database applications development at Harvard University; WebTech (SQL, .NET) program at Worcester Polytechnic Institute; database design and computer programing at UC Berkeley Extension
  • Specialized instruction methods and intuitive, productive learning experiences
Peter Avila has taught database design for more than 10 years and has worked as a consultant since 1991, using SQL Server and .NET for database design and applications development.

He is the author of “An Intuitive Approach to Database Design: An Introduction to Data Modeling.”
Peter says he’s an advocate for including an intuitive style with formal instruction in database design and applications development.
“I believe in helping students get familiar with database design using concepts they already understand, as they learn an approach that closely mimics the way databases are designed in the real world,” Peter says. “Only then do we look at the formal approach of normalization to verify our results. Students get the most out of it that way because they rely on their intuitive sense first.”


Object Prefixes: Friend or Foe?

Posted March 24, 2014

Contrary to popular belief, prefixing object names isn’t always a good idea and some professionals have dropped the practice entirely. To see why this is, let’s take a look at database object names as an example. Initially, it might seem … Continue Reading

How to Audit Report Execution in SSRS

Posted February 21, 2014

Do you need to know how often a report runs, who or what processes run the report, how long it takes to run, statistics on report parameters, which reports are not being used, and so on? SQL Server Reporting Services … Continue Reading

How to Make a Cover Page for Your SQL Server SSRS Report

Posted February 17, 2014

A cover page is simply a page that comes before the report data and that usually contains a report title and other identifying information. It can add clarity to your report and give it a clean, professional look. The cover … Continue Reading