SQL Server DBA / sqlLAB / Uncategorized

Removing Replication

Sticking with the theme of “following my nose“- I set about removing replication from my new ReplicationExample sqlLab. Method 1 While replication is still active, you can remove replication by right clicking Replication and selecting “Disable Publishing and Distribution“. This will remove the subscriptions, publications and also remove the distribution database. Couldn’t be easier. Method … Continue reading

.Net / Data Analysis / Interactive Web Data

Incorporating the EntityFramework & ADO.NET Entity Data Model

The type or namespace name <model_name>¬†could not be found (are you missing a using directive or an assembly reference?) My current project, the Interactive Data Analysis project, is based on a dynamic webpage. The web page will be linked to a SQL Server database via the Entity Framework and a ADO.NET Entity Data Model. The … Continue reading