|
|
|
Get Your Own Blog
If you would like to blog on SQLServerCentral.com then send an email to
webmaster@sqlservercentral.com.
Contact the author
All Blogs
Feeds
Archives
for this blog
Steve Jones is the editor of SQLServerCentral.com and visits a wide variety of data related topics in his daily editorial. Steve has spent years working as a DBA and general purpose Windows administrator, primarily working with SQL Server since it was ported from Sybase in 1990. You can follow Steve on Twitter at twitter.com/way0utwest
Archives: June 2007
I have the best job here at SQLServerCentral.com. I work from home, I get to be creative, writing about what I want to write about and work on my own schedule. I've gotten free admissions to the PASS Summit, TechEd, and the MS BI Conference and been offered others. However… Read more
I wanted to get working on Katmai a little, but not being brave and seeing the release notes that it can't run side by side with SQL Server 2000 (who decided that?), I wanted to put it in a VM. So I fired up Virtual PC, created a new VM,… Read more
My job here at SQLServerCentral.com is mainly as editor. This means that for the most part I edit articles, schedule them for release, work with authors, build questions of the day, correct mistakes in questions of the day, and of course write editorials. Last week I was on vacation, so… Read more
The database manages itself. Not totally, but close to it. It was an
analogy made by Dan Jones with cars. Auto shop isn't really offered in
high school anymore, people don't "tinker" with their cars much anymore.
If this is true, we have more time for data design, data architecture.… Read more
It's a similar theme, off by default if it makes sense, minimize surface area.
Recommendations: for new installs, leave stuff off unless you need it.
Minimize connectivity. for upgrades, turn things off if you do not
truly use them.
SQLSAC - Surface Area tool, launch from command line or setup.… Read more
Last night I went out with Tony Davis of Simple Talk and Alan White, a
longtime author for both here and Simple Talk. After satisfying their
need for microbrewery beer, we ended up at a Southern BBQ. They enjoyed
it, despite having to join me in choking down American beers. Read more
CHECKDB
- needs consistent view of the db. Needs to do this without locking. In
SQL Server 2000 log analysis is used. Almost everything is logged and
once the database is read, the log is read and inside checkdb, recovery
is performed to reconcile the differences. If there was a… Read more
I missed this yesterday, but I saw it on the schedule again, and I knew
I had to make this one. It's titled "Beyond Relational", which I expect
to mean it's focused on enhancements not necessarily related to rows
and columns. But I didn't see the abstract, so I'm not… Read more
Andrew Kelley from Solid Quality Learning did this one, which was good.
I was worried it would be about maintenance plans, but it wasn't.
Instead it was on good real life maintenance for your server and how to
handle it. He did start out talking at the Maintenance Plans abstract… Read more
Everyone wants 5 9's of uptime, 24x7 support, and instant fixes for
issues with their database server. Never mind that I'd argue that most
DBAs don't really need the " Always On" technology, but it's something that sells. So I thought Kim Tripps "Demo Fest" would be a cool… Read more
A good talk on the tools from the guy that's responsible for SSMS,
Configuration Manager, Maintenance plans, Surface Area Configuration
Wizard, and a few more.
Initially I thought this might be a dud, with him showing some of the
basic features of Configuration Manager and Surface Area tools,but then
he… Read more
We're not partners anymore in SQLServerCentral.com, but Andy, Brian,
and myself got together last night for dinner. We haven't seen each
other since the PASS Summit and this was a good time to get together.
We had a nice dinner, reminiscing about the site a bit, them giving me
some… Read more
I ended up driving around Orlando this afternoon to get books. We'd
printed the next version of our Two Minute SQL Server Stumpers and I'd
had it shipped down to a friend's house. He didn't make it down to
TechEd, so I drove up and picked up the books. So… Read more
I dropped into Brian Knight's "Clustering in 60 Minutes" to say hi. If
you've never seen this, it's pretty cool and worth the watch. Brian
makes clustering look pretty easy, and he really sets up a cluster in
the session from scratch, so check it out. It's updated for 2005,… Read more
These will get pretty long as I'm kind of wordy, but these are impressions as things are occurring.
Registration is a little crazy. I'm not sure who desgined this
conference, but it's split among the two sides of the conference center
in Orlando. I've attended 3 or 4 Tech Eds,… Read more
|
Subscribe to this blog
