Responsive Web Design, Mobile Websites and Knowing the Audience

If a website's target audience is mainly mobile based, then the user experience should be designed around them through the use of mobile sites optimized for their genre. But if they're not? Responsive web design techniques provide all users the same HTML capable of responding to the users environment in consistent manner. In the end however, it's all about knowing your customer and their audience needs.

SQL Data Decimation by Date Range and Nth Record

Data decimation (aka Down Sampling) of large SQL datasets allows application to quickly visualize trends in data over large historical periods greatly improving application performance. Combining a custom date range and a SQL Modulo operator, quickly and evenly display long periods of data.