I recently (yesterday, in fact), got to see some amazing recommendations regarding the use of data types. Now I have the chance to provide my personal opinions (guidelines):primary keys: monotonous, ever increasing values - personal choice, but it can introduce unnecessary complexity. So, for the case of small tables, use whatever fits you:as an example, … Continue reading much ado about data types
KISS (Keep it stupid simple) :-)"System.Data.OleDb.OleDbException: [DBNETLIB][ConnectionOpen (PreLoginHandshake()).]General network error. Check your network documentation." - that was the wife having an issue.I told her: okay, do you have SQLNCLI? Obviously, she had it installed.Me: well then, check here:http://blogs.msdn.com/sql_protocols/archive/2005/10/22/483684.aspxhttp://blogs.msdn.com/sql_protocols/archive/2005/10/29/486861.aspxIt turned out that SQL Browser service was not started. Again, KISS or be KISS-ed.
Okay, now I have to admit that this one is not quite cert related, but still:Friend: I tango with a suspect database.Me: suspect database? why?Friend: well, at some point I got an error telling me that it took too much to write something to the database.Me: that would be a premiere... sure it ain't something … Continue reading "Dreadful" i/o errors