Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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, 696 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, 538 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, 589 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, 705 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, 582 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, 596 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, 633 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, 582 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, 569 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, 539 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, 552 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, 572 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, 547 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, 587 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, 548 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.

SUNDAY

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, 520 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.

MONDAY

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

Read more

0 comments, 539 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, 600 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, 602 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, 610 reads

Posted in SQLAndy on 21 September 2007

Older posts