SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Archives: January 2008

Hot Subtract

 Over the last few weeks I've seen a few posts about the new Hot-Add CPU feature in SQL Server 2008. I think it's pretty cool and I've been wanting something like this for years. I managed a large IBM server at one point with AIX (manager managed, not technical managed)… Read more

0 comments, 723 reads

Posted in The Voice of the DBA on 14 January 2008

E-Readers, Will They Ever Take Off?

I was discussing the Kindle recently with business partner Steve Jones and while we both like the idea of having a portable reader, the $400 price tag - even when you consider the potential savings on books for buying e-version only - just seems too high, and that trumps any… Read more

0 comments, 432 reads

Posted in SQLAndy on 14 January 2008

Evaluating Speakers at Events

Speakers tend to live for the evals. Hopefully it's a validation of work done well after a lot of time preparing, but most speakers would gladly pay for meaningful feedback that would help them improve their game. Event organizers use the evals to see if there is anyone that did… Read more

0 comments, 779 reads

Posted in SQLAndy on 9 January 2008

On the Importance of Documentation...

It seems that I keep inheriting old systems that provide a singular, albeit mission critical, function to their owners. In the majority of these cases, I have encountered numerous small applications that were designed to run in a standalone environment to solve a very narrow problem or set of problems.… Read more

2 comments, 485 reads

Posted in Tim Mitchell on 9 January 2008

Sometimes You Need an Analog Solution, Sorta - Earth Class Mail

Spotted this on the Webware feed, Earth Class Mail is a service that opens and scans your regular mail so you can read it as email! Interesting idea, plus they could make some extra recycling all that paper. Seems like the next logical if evil step would be for mail… Read more

0 comments, 454 reads

Posted in SQLAndy on 9 January 2008

SQL Injection, Again!

Many posts including this one about as many as 70,000 sites being hacked using SQL injection and a vulnerability in MDAC that was patched in Sep 2006. You can see what's still out there by searching google for UC8010 and seeing it listed in the link title with a script… Read more

0 comments, 563 reads

Posted in SQLAndy on 9 January 2008

Partitioning Part 3 Posted on SSC

Part looks at using views for partitioning, still a valid technique even in the SQL 2005 world. I added in some basic performance tuning information as well, looking at the query plan when partitioning is done correctly vs incorrectly. The final installment has been submitted and will cover the SQL… Read more

0 comments, 242 reads

Posted in SQLAndy on 8 January 2008

ACM Queue Article about One Laptop Per Child

If you happen to read ACM Queue there is a great article in the Nov/Dec 2007 issue called 'A Conversation with Mary Lou Jepsen' the CIO of OLPC (sorry, I don't have a URL to it) that talks about some of the technical innovations in the product. They did a ton… Read more

0 comments, 237 reads

Posted in SQLAndy on 7 January 2008

A Lower Level of Noise

I finally got set up to access the MVP newsgroup server today while I was working on some other projects. There are tons of projects in a newsgroup/Usenet type format, mostly for every technology for which there is an MVP. I subscribed to the SQL Server one as well as… Read more

0 comments, 699 reads

Posted in The Voice of the DBA on 6 January 2008

SQL Community - The Site

A friend sent me a link to www.sqlcommunity.com and I think I'd list it. So far doesn't seem impressive, but I know from experience that it takes a while to get things going and flowing. Certainly doesn't compare well to the other community sites so far, but perhaps that will… Read more

2 comments, 469 reads

Posted in SQLAndy on 6 January 2008

SQLSaturday Tampa Call for Speakers

Just a reminder to anyone in the Tampa area, or willing to travel, that the call for speakers for the Feb 2008 SQLSaturday is still open. They want to get a good mix of speakers, topics, and speaker experience level. Doesn't hurt to submit a session and see what happens!… Read more

0 comments, 200 reads

Posted in SQLAndy on 3 January 2008

Why Participating in a Community is Important and Beneficial

Back in 2000 I began writing for swynk.com in hopes of learning more about SQL Server and beginning to make a name for myself in the SQL Server community. That was a little over seven years ago. As SQLServerCentral.com came online, I transitioned to it, writing articles and contributing heavily… Read more

End to End T-SQL!

After a couple of months of discussion, End to End Training has scheduled me to teach a two day beginning T-SQL course for them.  One of the best aspects of End to End Training is that the courseware is written by the trainers. It’s a lot more work to… Read more

2 comments, 418 reads

Posted in Advice from Aunt Kathi on 3 January 2008

Getting Better at Time Management

 One of the things I took from my overall performance last year is I need to get better at time management. While I feel I can get a lot done (and I've been told such by people I trust), I know I waste a lot of time. Too much time.… Read more

Blog Update & Feedburner

Steve finally got the bugs worked out of the recent blog software upgrade and RSS should be available again. Note that the new URL for this blog is http://feeds.feedburner.com/itdepends, and if you subscribe to the SSC aggregate feed, the new URL is http://blogs.sqlservercentral.com/MainFeed.aspx. I also finally got around… Read more

0 comments, 396 reads

Posted in SQLAndy on 3 January 2008

Congratulations to Bayer White - Connected Systems MVP

Just saw that Bayer posted a note confirming that he is a 2008 MVP. I met Bayer a couple years ago via Brian Knight, and Bayer is a mainstay of the local code camps and user groups. Nice guy and I'm sure the MVP status is thoroughly deserved! Read more

0 comments, 172 reads

Posted in SQLAndy on 2 January 2008

Google Bigtable

Google has - and continues - to do some amazing things. It's easy to be awed by their products and their infrastructure, but this one was even more interesting - they designed their own database to host all that information. I'm a product centric professional at this point in my… Read more

0 comments, 390 reads

Posted in SQLAndy on 1 January 2008

Congratulations to Steve Jones on MVP Status

Steve is a 2008 SQL Server MVP. Well deserved, I can think of few people more visible in the community or that have done more for the community. I think it's a shame that MS took so long to recognize him. Not sure if that was because of his occasional… Read more

2 comments, 599 reads

Posted in SQLAndy on 1 January 2008

A New Year's Present

I awoke this morning, rather later than usual after a small get together with some friends, and came down to check email and make sure the site was still working. Sitting down with coffee and breakfast and checking email is a regular event with me, probably close to 350 or… Read more

0 comments, 634 reads

Posted in The Voice of the DBA on 1 January 2008

Newer posts