About once a month or so, us developers here at Ayoka like to get together over lunch to discuss various software development topics in a series we call Ayoka Lunch n’ Learn. This month our resident SQL Server expert, Steve Chang discussed SQL Server best practices. You can check out the the four part video series below. You can also download the complete PowerPoint presentation here: SQL Server Best Practices – Ayoka Lunch n’ Learn.
You Might Also Like
Top Differences in Code Behind and Reporting Services RDL
- Post published:September 10, 2013
Ok, so I'll try to keep this brief. For one our long-term projects (read: older!), we are using ASP.NET v3.5 WebForms, which is a precursor to the MVC design model…
Setting up Apache, MySQL and PHP for Mac developers
- Post published:January 16, 2009
I've been playing with Mac OS X Leopard for a little while now, and I really like all the development tools it comes with out of the box. For example,…
Introduction to Temporal Tables
- Post published:August 4, 2015
Microsoft has recently released SQL Server 2016 as Community Technology Preview 2 (CTP2) and utilizes temporal tables to simplify the process of auditing records and restoring tables by retrieving its temporal history data. Creating new temporal table schemas and scaling existing database schemas to the new system-versioned architecture prove to optimize processing speeds and add an extra layer of security to tables in the database.