Finally I got 8 GB of RAM on my laptop. That's a great thing, especially that I have free licenses to pretty much whatever Microsoft has as x64, except that I'm married and this is not quite my laptop, but my wife's. If you ask anyone on the planet, you are to find out that … Continue reading To 32 or not to 32 on Windows 7
Category: Uncategorized
SQL Server installation tips… NOT
I have to admit that I shamelessly "steal" any info available on the net when it comes to SQL Server. Just to give you a quick example: Brent Ozar and Jonathan Kehayas both have some neat articles about installing SQL Server. Of course, I use the Next > Next > Finish feature, just as anybody … Continue reading SQL Server installation tips… NOT
Strange error in SQL Server 2005… when aplying SP3
Before going any further, let's get this straight: I'm not sure whether it's a bug or not, whether can be reproduced or not, but I care to have this documented.A machine was re-installed (Win 2003, SQL 2005), having 3 named instances (no default, just named instances). SP3 was applied... and nothing was like before:-). You … Continue reading Strange error in SQL Server 2005… when aplying SP3
SQL 2008 DBA now
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
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
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