SMO + LINQ for Entity Framework Code First Database Modifications
Database Aspects of Code First Using Entity Framework (EF) 4.1 with the Code First approach seems like a good choice for my greenfield Web App – during development I can focus on the Web and C# .Net paradigms, and postpone the bulk of the database work until such time my application and data model has [...]
GOTCHA: SQL Server changes query plan without changing plan_handle
Or how to efficiently get at old query plans Performance Tuning Mission While on a SQL Server 2008 Data Warehouse performance tuning mission, this aspect (or undocumented gotcha as it felt like at the time) of the query plan Dynamic Management Functions caused some head scratching, until I sussed that: A query plan can change [...]
Previously on Kristian Wedberg: Data Warehouse and BI articles
Just to have things nicely gathered in a single place, I’ll kick my new blog off with a few links to my earlier blog & articles, where the content is still relevant: SQL Server Central articles Generating Test Data with Integration Services SSIS – Code Reuse and Complex Control Flows SSIS – Reusable Benchmark Harness [...]
