Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 

Archives: July 2008

Tool Review: Hamachi VPN

Maybe I haven't looked at the right products, but two years ago when we needed a VPN solution there wasn't much that was either reasonably low cost or reasonably easy to administer. We needed something that would allow a handful of users remote access to our network. The so called… Read more

0 comments, 555 reads

Posted in SQLAndy on 31 July 2008

Members speaking at User Groups

The Midlands PASS chapter is approaching two years old. We've had some great speakers from the outside like MVPs Brian Knight, John Welch, and Wayne Snyder. We've got another great one coming with Darren Herbold next week. One area we've really struggled is getting users to speak.… Read more

Microsoft Has a New Testing Mechanism - Not a Sim

It looks like Microsoft is working with Prometric to put out a different way of testing for certification. Basically, it's an emulation, there are tasks to complete, and the emulation grades based on how well the tasks are completed when all is said and done. This is different than from… Read more

Reminder - Midlands PASS August Meeting

 

Speaker: Darren Herbold

Midlands PASS Chapter - August 7, 2008 Meeting

The Midlands PASS chapter will hold our normally scheduled meeting on Thursday, August 7, 2008, to host Darren Herbold of Pragmatic Works Consulting and contributing author of the forthcoming Professional Microsoft SQL Server 2008 Integration Services from Wrox (Darren is… Read more

Operation Hands Free

Recently I was driving home and as I made that turn into the sub-division where I live, over the course of the next mile I noticed three of three cars going the other direction were all holding a cell phone to their ear. I hope most of you by now… Read more

0 comments, 552 reads

Posted in SQLAndy on 30 July 2008

Stored Procedures Reconsidered

Quite the debate going on from today's editorial: Stored Procedures Reconsidered. I chimed in late, and going on the "pro-sprocs" group. I think stored procedures are helpful, and a better idea, and most importantly:

Don't take that much more effort

You should be able to auto-gen trivial procs, and… Read more

0 comments, 619 reads

Posted in The Voice of the DBA on 30 July 2008

Panel Interview Part III Posted

As a follow-up to yesterday's post, Part III of the SQL Server panel interview has been posted on-line. A name I left off the original post who was on the panel (which I'll go back and edit):

 A couple of community comments:

Read more

Blogging on SQLServerCentral.com

Recently my friend Steve (managing editor of SSC) posted to his blog about The Bad Karma Project that has to do with the state of blogs here on SSC. Going back to the time when we added blogs to the site I was ambivalent about it at best, thinking dedicated… Read more

0 comments, 579 reads

Posted in SQLAndy on 30 July 2008

Tool Review: Servers Alive

Not all of us work at companies big enough to justify the expense/time it takes to implement something like MS Mom, Altiris, etc. For years I've recommended Servers Alive as a reasonably priced (about $200) solution that lets you do basic fault monitoring. It can alert on low disk space,… Read more

0 comments, 577 reads

Posted in SQLAndy on 29 July 2008

Rebuilding Stats: Twice or Not at All Posted on SSC

Rebuilding Stats was published yesterday on SSC, some nice comments posted to it as well. The main point of the article was that if you're rebuilding indexes with the default options you're automatically getting stats update on those columns as well. Read more

0 comments, 631 reads

Posted in SQLAndy on 29 July 2008

SQL Server Panel Interview

I was asked by Odin Jobs to participate in an email interview on SQL Server. Joining me on the panel were:

Odin Jobs has done this before with PHP. The first couple of posts are here:

Read more

IP6 Addresses Could Break Your DB

I saw this post from Rick Strahl about IP6 Addresses in Vista breaking some code, and it immediately made sense that we're probably going to feel some pain on the db site. While all it may take is altering a column on our side (which increases space usage of course)… Read more

0 comments, 533 reads

Posted in SQLAndy on 28 July 2008

Tool Review: Microsoft Virtual CD-ROM Control Panel

It's downright common these days to download programs as ISO images, but XP doesn't have a native viewer for them. The Virtual CD-ROM Control Panel is an easy way to create a virtual drive letter, point it at the ISO, and then it 'mounts' the drive so that it looks… Read more

1 comments, 640 reads

Posted in SQLAndy on 27 July 2008

Congratulations to Glenn Berry - SQL Server MVP

I just leaned today that Glenn Berry has had his MVP award renewed for another year.  If you have not read his weblog, I'd highly recommend checking it out at http://glennberrysqlperformance.spaces.live.com.  Besides the informative information he blogs about, he is also a very active member in the community and… Read more

0 comments, 557 reads

Posted in Marc Beacom on 27 July 2008

Database Weekly

At least this project is moving forward. We deployed a new design to the site this week, and turned it live this morning. Instead of altering the Dot Net Nuke framework that it was on, we built a new site, mostly because it's a fairly simple type of site and… Read more

0 comments, 576 reads

Posted in The Voice of the DBA on 26 July 2008

A Bad Karma Project

We've had a project underway to upgrade these blogs, moving to a newer version of Community Server, better skinned, etc. The project is scheduled to deploy in a couple weeks.

A couple weeks ago, I heard the project would be ready in a couple weeks. I've heard the same thing… Read more

0 comments, 679 reads

Posted in The Voice of the DBA on 25 July 2008

Blogging Thoughts - Part 2

Earlier I wrote Blogging Thoughts - Part 1 where I discussed the various approaches I've seen in blogs (blogging when you learn something new, blog only technical, etc, etc) as part of the work I'm doing to make recommendations to those asking for advice on building a blog. Note that… Read more

0 comments, 538 reads

Posted in SQLAndy on 24 July 2008

Midlands PASS August Meeting

 

Speaker: Darren Herbold

Midlands PASS Chapter - August 7, 2008 Meeting

The Midlands PASS chapter will hold our normally scheduled meeting on Thursday, August 7, 2008, to host Darren Herbold of Pragmatic Works Consulting and contributing author of the forthcoming Professional Microsoft SQL Server 2008 Integration Services from Wrox (Darren is… Read more

Tool Review: TaskSwitchXP

For longer than I care to count I've used the Alt-Tab Powertoy from MS to get a nicer view of running applications, alt-tab being one of those things that is hard wired into my brain at this point. It works, but occasionally it's flaky, doesn't want to change to a… Read more

0 comments, 541 reads

Posted in SQLAndy on 23 July 2008

Blogging Thoughts - Part 1

One of the things I've been looking at is different blogging styles and trying to figure out which to recommend to beginners, and why. Part 1 will be looking at the styles, and Part 2 will be my thoughts on which to recommend.

  1. When I learn something new. This tends…

Read more

0 comments, 578 reads

Posted in SQLAndy on 22 July 2008

Older posts