Archives: June 2008
I'm still on the fence here about a Kindle. I pinged someone that bought one and he said they're returning it. Not that they don't like it, but his wife reads too much now, so she's spending more $$ and they'd like to slow down. Also, he doesn't see enough… Read more
Apparently other people like One Note. Microsoft is using it for learning content, and I think that's a cool idea. I might find some issues with that over time, but at first glance I think it's a good idea. Read more
Lately I've been trying out a few new pieces of software to see how well they work. One is Twitter, and if you're really interested, you can follow me there. A few people do, though I'm not sure why. I follow a few people and might cut my list down… Read more
I've been a little surprised lately by some of the questions I've seen in our forums at SQLServerCentral.com with questions that weren't questions. I've seen people post things that make it hard for people to help them. Among those items:
- statements, and never really ask a question.
- An error message…
Randy Dyess of Solid Quality Mentors had a session and since I'd just gotten a copy of Grant Fritchey's book with the same name, I wanted to check it out.
There are 3 types of plans: graphical, text, and XML.
Graphical is cool, looks good, but it doesn't have enough… Read more
I left my laptop at the Red Gate booth, and then managed to wander up to a Data Compression talk from Sunil A. from Microsoft. It was a great presentation, and despite some extensive reading and researching earlier this year, I learned quite a bit about how it works. There… Read more
A program manager asked the question at the start: Who's had a query performance issue where a query "went bad" on the server?
Lots of hands up, and that was one of the things I wanted from this session.
What's reliability? MS sees this as two things
- Quality: Given… Read more
I went to this one, mostly because I don't understand coruption that well and Paul Randal is a great speaker. Worth going to see him if you get the chance.
Run CheckDB. It's important.
You need to know how long checkdb takes to run. Checkdb is optimized to run for… Read more
Andrew Kelley, SQL Server MVP, is a good speaker, so I'd recommend his sessions if you want good technical information.
IO Stats are a snapshot in time since the instance was restarted, so you must have at least two reads to compare the data. Stats are a snapshot. They are… Read more
Talking about heterogenous systems, usually legacy systems. How do you move to a new architecture?
You must start with the old systems, often you cannot throw it away and need to mitigate the risks of migration to newer systems. One way of doing this is to rip out the presentation… Read more
I was going to hit a Powershell lab because the Scripting Guys at TechNet write great columns, but it filled up, so I went to my second choice: Building a Global Database.
What does this mean? If you are building a database that handles all types of languages and… Read more
I still remember hearing an executive in IT at Virginia Power start a sentence like this, and he went on to say it's like a house before chastising the developers for being slow. I was on the ops team and liked the analogy, finding it funny. Course I hadn't done… Read more
Today I ran to the co-location facility for FourDeuce and End to End Training, to upgrade our database server to SQL Server 2005. We've been wanting to do it for awhile, but since most of our SQL code is fairly simple and generic, we haven't needed it. The old SQL… Read more
For SQL Server, it's coming soon. Surprisingly, when I was up in Redmond, quite a few people were asking about this, and wanted to have a new logo. I somewhat agree that the old logo was a little tired and it would be good to see something new.
I saw… Read more
Last month the LCD screen on our treadmill went out. We bought it last Christmas (06) as a present for my wife and I and with all the snow in 07, it was a nice addition to the household, letting us work out with bad weather outside. However the LCD… Read more