I made myself an early Christmas present: since I had a free exam voucher from Microsoft, I said to myself heck, since I'm not paying for the exam, it's kinda time to upgrade my DBA skills from 2005 to 2008. That is, 70-453.OK, I passed, but I want to tell you some impressions:tough examdifficult examnot … Continue reading SQL 2008 DBA now
Author: Calin OPREA
talking about customer care:-)
I just received (as an MCT I get all kinds of goodies) a free licence of PerfectDisk 11. So far, so good... but: "the official release isn't until tomorow, but I wanted to make sure our MCTs had it in their hands a little early".This is what I call "yes, they care about me".best regards,io
much ado about data types
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
Simple lesson learned
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.
"Dreadful" i/o errors
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
First blog
Well, for whatever reason I decided to run this blog (it's just a first step of many more to come); it will actually contain all the bells and whistles I am hearing during my SQL Server 2005 courses, which I'm currently teaching.First, a bit about me: MCT in SQL Server 2005 - DBA, Windows 2000/2003, … Continue reading First blog
SQL-PLAY 