Archives: June 2007
No, I'm not going to keep making corny references to war and being a soldier. But in many ways, we dba's are soldiers in a war against poor performance. Often it can be a struggle to get the information and resources you need, but that doesn't lessen the expectation that… Read more
The active SQL Server error log is one of the first places people look when there is a problem. For many people, this is a frustrating exercise. The interfaces for viewing the log in Enterprise Manager and Management Studio are slow and can not be filtered or searched.
There is… Read more
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.
My friend and former co-worker Chris Rock just posted at article over at SQLTeam.com that has a pretty good walk through of how to set up and use the VS debugger on procs. According to an MSDN article he includes it still requires sysadmin permissions to debug though, limiting it…
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,…
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…
I'm at the bookstore today alternating some work with some professional development time and was reading some of Celko's SQL Programming Style and was mildly startled to see him reference a couple of Steve's articles (Coding Standards Part 1
and Coding Standards Part 2
). Worth taking a look…
Normally I don't post this sort of thing to my blog, trying to focus on more technical matters, but this quote struck me the right way because it reminded me that we must be passionate in what we do. "A small group of determined spirits with an unquenchable thirst for…
It's been quite a week at the Gartner Application Development and Integration converence here in Nashville. I've never been to a development-focused event that was so abstract and theoretical; in fact, I don't think I saw a single line of code during the entire converence.
My time here started on…
Web site just went live for this year. Brian & I both presented sessions last year and we're planning to go again this year, along with my sometime sidekick Chris Rock if he can get away from work. Code Camps offer the same kind of variety you'd find at a…
This was fun to run through, nice to see MS adding features even if in my view they didn't quite bake the whole cake. Click here
for the article.
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.…
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.…
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.
- 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…
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…
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…
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…