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

Archives: September 2007

The Quickest Podcast in the Business

I almost forgot to record the podcast for tomorrow's editorial. In case you're a glutton for punishment, it's here. I'd spent over an hour polishing off the writing part of this in the am, not having finished it on Friday.

So by fast I mean it took only about…

Read more

0 comments, 1,582 reads

Posted in The Voice of the DBA on 30 September 2007

Clustered Indexes

I work almost exclusively with third party applications. I don't get to do a lot of tuning except for reports and automating stuff. One of the apps at the law firm where I work is our document managment system (DMS). Over the years I have learned that the vendor did…

Read more

0 comments, 1,267 reads

Posted in Advice from Aunt Kathi on 30 September 2007

I Don't Have a Black Eye

Though it kind of looks like that. Here's the first video podcast.

Halo 3

Actually it's probably the 20th, but it's close enough for a test, beta release. Hey, this is a Microsoft site, so we'll release stuff that isn't all the way there. Heck, I don' think it's any…

Read more

0 comments, 1,419 reads

Posted in The Voice of the DBA on 29 September 2007

Monitoring and Alerting

I responded in an interesting thread this morning where someone was looking for advice on what to monitor on their SQL Servers. As expected, I can't find the thread right now and I'm rather busy, but suffice it to say someone was wondering what to monitor on their SQL Servers…

Read more

0 comments, 1,531 reads

Posted in The Voice of the DBA on 28 September 2007

Points or Posts

It's an interesting question that we had come up, and honestly I'm not completely sure what I want. I'll describe it a bit here and then you can send comments to me (sjones at sqlservercentral.com) or post them in the poll I've set up.

Right now we have each…

Read more

0 comments, 1,388 reads

Posted in The Voice of the DBA on 27 September 2007

I Am Not In Charge

That is for sure.

We had a development meeting today with my publishing team (meaning I'm on the team, not leading it) and the developers. We went over some of the bugs and issues we're having. Overall it's not too many bugs, but mostly issues with changes in workslow and…

Read more

0 comments, 1,436 reads

Posted in The Voice of the DBA on 26 September 2007

DTS vs Linked Server

We are trying to move to version 2 of our accounting data warehouse (more likely called a datamart), but it just doesn't have everything the department needs yet. So, we still have version 1 running, a system that gets updated just once each month instead of each night. The warehouses were… Read more

2 comments, 1,542 reads

Posted in Advice from Aunt Kathi on 25 September 2007

Development at High Speed

As with any project, despite being fairly pleased with the final product, there were bugs. In fact, quite a few issues that cropped up,which we hadn't seen in testing. Of course we could have done more testing, but part of that is knowing what to test and part of that…

Read more

0 comments, 1,355 reads

Posted in The Voice of the DBA on 25 September 2007

Flawed URL Validation and Not Eating Your Own Dog Food

MS includes a bunch of reasonably nice validation controls in VS 2005 and one of them includes the ability to validate that a string is a valid (syntactically) a URL. Sort of. If you don't prefix it with 'http://', it says it's invalid. I'd argue that we could just assume… Read more

0 comments, 1,345 reads

Posted in SQLAndy on 25 September 2007

Writing in my sleep

When I first got into IT full time 10 years ago, I noticed that my mind was constantly solving programming problems or thinking of programs I could write. If I had someone else to talk to at the time, I was a normal human, or at least as normal as…

Read more

0 comments, 1,250 reads

Posted in Advice from Aunt Kathi on 25 September 2007

Building a Local User Group

I've had a couple people ask me about ideas for growing (as opposed to starting) a SQL user group. While it's definitely a lot about content, formula, and presentation, it's just like running a business, it all comes back to marketing. That said, here are a few suggestions:

  • Ask PASS…

Read more

0 comments, 1,313 reads

Posted in SQLAndy on 24 September 2007

PASS and new SSC design

I'm rarely a "needy" guy, but I have to admit that I'm feeling a little left out. Due to project commitments and budget constraints, I didn't get to make it to PASS for the second year in a row. The PASS conference is (or at least, has been) my favorite…

Read more

0 comments, 1,423 reads

Posted in Tim Mitchell on 23 September 2007

More & Better News about the PASS Summit from Edgewood

I try not to just post links to other content, but the guys at Edgewood did a pretty good job of capturing what was happening at the conference and I like to promote PASS where I can. Here is what they had to say about Day 1, Day 2 Read more

0 comments, 1,297 reads

Posted in SQLAndy on 23 September 2007

Wayne Synder Elected President of PASS

Congratulations to Wayne on becoming President! I've known him for years and you couldn't ask for a guy with more passion about PASS to lead the organization. He's just a down to earth nice guy that wants to do a good job and takes the responsibility very seriously. Read more

0 comments, 1,394 reads

Posted in SQLAndy on 23 September 2007

SSC Site Upgrade

I see they finally rolled out the new site. Lots of annoying quirks so far, the biggest for me is that the URL's in the notification emails aren't coming across as hyperlinks, forcing me to copy/paste into a browser. Given that I look at a couple dozen a day, this… Read more

0 comments, 1,325 reads

Posted in SQLAndy on 23 September 2007

PASS Report Part 2

This was my 5th year at PASS and every year I enjoy catching up with old friends and meeting many more.


I arrived safely and was in my hotel room by about 2 pm. I am the Program Committee Manager and the board member I report to, Bill Graziano,…

Read more

0 comments, 1,317 reads

Posted in Advice from Aunt Kathi on 23 September 2007

PASS Report

Somehow between the sessions, networking and socializing I never found time to post anything last week. So, I'm going to post two summaries, one for what I learned, one about the social stuff.


I attended Itzik Ben-Gan's all day pre-con session. He covered a lot of material and it…

Read more

0 comments, 1,308 reads

Posted in Advice from Aunt Kathi on 23 September 2007

SQLServerCentral.com - V3!

It's done, it's out, and check it out!!!

I guess if you got here, you've probably noticed :)

This was a fairly painless upgrade. The boys  in the UK got up early, came into the office and converted over the database, moving the website DNS and then letting me know…

Read more

0 comments, 1,374 reads

Posted in The Voice of the DBA on 22 September 2007

Tips for Presenters

I haven't seen a lot of sessions at the 2007 Summit, but I did go through 4 or 5 across the week and I noticed a few things in all of them. There were some first time presenters, and some nervous ones as well, but even the experienced ones could…

Read more

0 comments, 1,371 reads

Posted in The Voice of the DBA on 21 September 2007

Notes from PASS - Part 3

Today was interesting. I headed for breakfast and after a few stops to chat with friends, wound up sitting with some guys from South Korea, one of whom is actually the chapter leader. We talked a little about the challenges of trying to be a PASS chapter outside of the… Read more

0 comments, 1,437 reads

Posted in SQLAndy on 21 September 2007

Older posts