Did a little side job this weekend.
Microsoft SBS has some very nifty features. It sets up quick and the wizard-like interface to configure stuff works amazingly well. Once we get SharePoint running (it's giving us permissions errors everywhere) I'm sure it'll be great.
Read more →
Stupid stupid stupid excel.
It always looks like it imports data right. It tries really hard to guess at how to import data and convert it. And then it runs into data like this:
Read more →
Server: Msg 17, Level 16, State 1, Line 1 SQL Server does not exist or access denied.
OK, let's analyze this on a few levels.
At an existential level, if SQL Server doesn't exist, then what is it that I do again?
Read more →
One of these days, someone will explain to me why when Terminal Server can't configure a printer, it shows up in the Windows Event Log as an error, but SCSI Parity errors on the system disk are just warnings.
Read more →
OK, anybody have any idea why I can't say that certain users are only allowed to log into my server from specific workstations? I'd really love to say that my web login (the logn my web site logs in with) can only log in from my web servers, and if any of my developers tried to use it they'd either get an error message or be electrocuted (preferably at random).
Read more →
Let's talk about hardware for a few minutes.
My previous employer exclusively used Compaq, now HP, server hardware. It was great. It was exceptionally reliable, easy to know what you needed when you want to buy new stuff, the dealers we worked with were knowledgeable and helpful, and really consulted with us to purchase hardware, and had the goods to give us great pricing (we bought a LOT of hardware).
Read more →
If you ever needed more evidence that Microsoft is a big company and often any two given people who should talk to each other don't, here you go. DBCC DBREINDEX and DBCC INDEXDEFRAG do very similar jobs, and should take an identical set of input parameters.
Read more →
Yeah, didn't know if there were or not.
If you're a mac user, and you're on OS X trying to work with Windows servers, RUN don't walk to your nearest Apple reseller and acquire Panther.
Read more →
This is a nasty error. It's an assertion (SQL Server Assertion: File: <recbase.cpp>, line=1378 Failed Assertion = 'm_offBeginVar < m_SizeRec'.). If you do a search on Google, it looks like it's a really odd data corruption problem.
Read more →
LemmingToo and I just had lunch, and discussed some changes we'd like to see in SQL Server.
Correlated Aggregation. If I have a table with a primary key called PK, a Zip Code called Zip, and the number of days associated with that zip code called ServiceDays, I want to be able to pull back an aggregated list of zip codes and the maximum service days for each, and the PK's that include the Zip/Serviceday combination I'm looking for.
Read more →
Here's one you hope you never see. "The Scheduler 0 appears to be hung". On SQL Server 2000, there's no fix, and there's not much you can do about it. My favorite part is that it logs the SPID involved (SPID 63 in my case) but it doesn't log what the SPID was doing.
Read more →
OK, so I got to doing a reinstall on our cursed cluster node. Well, I started with research. Good thing too.
Turns out in order to reinstall a cluster node, you have to uninstall replication.
Read more →
Been messing around with the blogging interface a bit. Hopefully graz'll get around to reporting these. First, when I use my preferred browser, and I hit backspace in one of the forms, the browser crashes.
Read more →
Here's one reason why.
The other reason is that it turns out that one half of our cluster is apparently cursed. I'm not kidding. Seriously. The boxes are identically spec'd and installed (although I didn't do the install, so who knows).
Read more →
I wrote a little welcome message, and put it in the wrong place.
Graz rocks. For now.
Read more →
And if you don't get the reference, you need to go here
Read more →
Greetings and salutations.
I'm RocketScientist. Some of you know me, some of you don't care. I've been doing SQL Server stuff for about 9 years now (started in version 4.21a).
Read more →
I had to mess around a bit with a calculated column today, and I thought I'd share what I found, 'cause it really ticked me off (which, honestly, doesn't take much).
Read more →