Month: December 2005

With Microsoft touting Intellisense in just about all of their products, including Visual Studio, one would assume it’d show up in their flagship database product, SQL Server 2005. Unfortunately, the SQL Management Studio still doesn’t offer any prompting as you type in code, even though it’s based roughly on Visual Studio 2005. Enter PromptSQL, an…

My jaw hit the floor on this tech note from Microsoft: with SQL Server 2005 and a SAN, you can have multiple SQL servers hitting the same read-only reporting database. This is really only a solution for reporting loads that require more work from the CPUs than they do from the drive arrays. If the…

Hi. I’m Brent. I’m the owner of the black Jeep. I went out this morning to go to work, and I got nervous when I put the key in the passenger side door and it turned way too easily, meaning it was already unlocked. Then I noticed the pennies you scattered all over the passenger…

Me talking to my developers: “Well, guys, I’ve got good news and bad news. Bad news first: looks like somebody forgot about today’s scheduled outage, and they were trying to load data when the network admins shut down the database server. The ETL database is now trying to recover the messy transactions, and the server…