Michael Haren’s Wassupy Blog

Archive of posts in database

1. Make way for a unique key constraint by renaming/updating duplicate rows in SQL Server Jul 8, 2014
2. Automatically Connect to the Replica Set Primary with Mongo Shell Feb 19, 2013
3. SQL Server 2012: “Saving changes is not permitted…” Nov 14, 2012
4. Catching Unique Key Constraint Violations with Entity Framework and SQL Server Oct 30, 2012
5. How To Restore a Database With Active Connections Apr 13, 2012
6. Reseeding *All* Identity Values in a Database Jul 19, 2011
7. Renaming a SQL Server Database Apr 11, 2011
8. Truncating the log of a previously replicated database Mar 16, 2011
9. “Host is not allowed to connect to this mysql server” (Solved) Feb 14, 2011
10. Recovering from SQL Server Error: “Syntax Error in TextHeader” Feb 11, 2011
11. Project Noodle: Initial Database Design Oct 25, 2010