I'm with Stephen Wynkoop on this one - I'm not sure I'm too hip on Microsoft's emerging direction to divide SQL Server Tools into Developer and Admin Roles. Stephen just posted an editorial based on an interview that he had with Matt Nunn, and points out that Matt confirmed that Microsoft is trying to divide tools along discipline lines - ...

It's almost a rule of thumb to avoid indexing strategies on tables with less than a few thousand rows. The reason, of course, is that SQL Server will frequently just ignore indexes on 'tiny' tables - preferring instead to perform table scans. However, in environments with heavy load, and with borderline memory bottlenecks (i.e. heavy memory ...

I'm no math junkie, but I am a Geek. My hunch is that any geeks reading this won't be able to withstand answering a simple question; one that I thought up a while ago to help explain the 'value' of NULL to a colleague. So, here goes. What's the answer to:NULL + ∞ = In the database world, there's really only one acceptable ...

Camping presents a unique insight into problem management, and can also present a powerful metaphor about how people solve problems. If you've done much real camping, i.e. out in a semi-wilderness area as opposed to being in a groomed state-run/private campground, you've had to figure out how you're going to keep your fire going; and this is ...

Among pilots there's a somber expression: ''All warning labels are written in blood.'' Intellectual respect vs practical respect As a youth this concept was drilled into my head at ground school. It was sufficiently 'drilled' that I even thought I understood it. However, when my first day for actual flight came, it became apparent that while I ...