June 2007 - Blogs - SQLServerCentral

Click here to monitor SSC

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15220&wd=468&ht=60&pair=as" target="_blank"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15220&wd=468&ht=60&pair=as" alt="i" width="468" height="60"/></a>

SQLServerCentral is supported by Red Gate Software Ltd.

Log in :: Register :: Not logged in

<a href="http://g.adspeed.net/ad.php?do=clk&zid=15491&wd=120&ht=300&pair=as" target="_top"><img style="border:0px;" src="http://g.adspeed.net/ad.php?do=img&zid=15491&wd=120&ht=300&pair=as" alt="i" width="120" height="300"/></a>

Archives: June 2007

The War Begins :: Reporting for duty

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

0 comments, 405 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 29 June 2007

SQL Server Error Logs

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

1 comments, 479 reads

Posted in SQL Server Soldier :: News from the frontlines of the database wars on 29 June 2007

Walking the Line

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…

0 comments, 409 reads

Posted in The Voice of the DBA on 28 June 2007

Debugging Stored Procedures in VS 2005

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…

0 comments, 390 reads

Posted in SQLAndy on 27 June 2007

Keep a Spare

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,…

0 comments, 386 reads

Posted in The Voice of the DBA on 20 June 2007

Back to Work (Some days it flows)

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…

0 comments, 428 reads

Posted in The Voice of the DBA on 20 June 2007

Celko Cites Steve Jones

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…

0 comments, 417 reads

Posted in SQLAndy on 20 June 2007

A Motivational Quote

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…

0 comments, 422 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 19 June 2007

GO More than Once?

SSC had a fairly routine article up recently about The GO Command the Semi Colon Terminator which I read, and when I followed along on the associated discussion came across an interesting comment that noted in SSMS you can add an integer param to GO to have it execute the…

3 comments, 432 reads

Posted in SQLAndy on 18 June 2007

Gartner Developer Conference

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…

0 comments, 488 reads

Posted in Tim Mitchell on 13 June 2007

Tampa Code Camp 2007

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…

0 comments, 383 reads

Posted in SQLAndy on 12 June 2007

Mirrored Backups Posted on SSC

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.

0 comments, 409 reads

Posted in SQLAndy on 12 June 2007

June Midlands PASS Meeting Canceled

We are canceling the June Midlands PASS meeting because the speaker (me) is still under the weather. I'll post in a later message about the July meeting.

Technorati Tags: SQL Server | Microsoft SQL Server | SQL Server 2000 | SQL Server 2005 | Professional Association of SQL Server |…

0 comments, 422 reads

Posted in K. Brian Kelley - Databases, Infrastructure, and Security on 7 June 2007

Katmai Manageability

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.…

0 comments, 421 reads

Posted in The Voice of the DBA on 6 June 2007

SQL Server 2005 Security

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.…

0 comments, 424 reads

Posted in The Voice of the DBA on 6 June 2007

Southern BBQ

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.

0 comments, 419 reads

Posted in The Voice of the DBA on 6 June 2007

DBCC Internals

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…

0 comments, 475 reads

Posted in The Voice of the DBA on 5 June 2007

Beyond Relational

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…

0 comments, 457 reads

Posted in The Voice of the DBA on 5 June 2007

Maintenance in SS2K5

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…

0 comments, 437 reads

Posted in The Voice of the DBA on 5 June 2007

SQL Server Always On

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…

0 comments, 531 reads

Posted in The Voice of the DBA on 5 June 2007