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
Invoking Managed Code from SQL Server
- Post published:September 1, 2009
One of the flagship features in SQL Server 2005 is the ability to write stored procedures using any language supported in .NET. This feature provides greater flexibility for developers to…
Read More
Invoking Managed Code from SQL Server
Querying Temporal Tables
- Post published:August 6, 2015
In software performance optimization, real data sources are dynamic since business decisions often rely on the insights that can be retrieved at a moment's notice. SQL Server 2016 has given database administrators the ability to utilize temporal tables to bring database insights to decision-makers in both real-time and from the past. These temporal tables, also known as system-versioned or assertion tables, offer the ability to query its data to be tracked as it changes over time to understand changing business trends, improve the process of auditing data as it changes, maintain slowly changing dimensions (SCD), and ease the process of recovering tables from data corruption or loss.
Read More
Querying Temporal Tables
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…
Read More
Top Differences in Code Behind and Reporting Services RDL
