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


I'm Andy Warren, currently a SQL Server trainer with End to End Training. Over the past few years I've been a developer, DBA, and IT Director. I was one of the original founders of SQLServerCentral.com and helped grow that community from zero to about 300k members before deciding to move on to other ventures.

Archives: 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,361 reads

Posted in SQLAndy 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,330 reads

Posted in SQLAndy on 24 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,313 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,410 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,339 reads

Posted in SQLAndy on 23 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,452 reads

Posted in SQLAndy on 21 September 2007

Notes from PASS 2007 - Part 2

Denver is a great location for a conference. The convention center is two blocks from the 16th street mall - must be 10-12 blocks of shops, restaurants, etc. I stayed at the Courtyard Marriott, small rooms, but directly on 16th St, and nice enough. Only downside is the airport is… Read more

0 comments, 516 reads

Posted in SQLAndy on 19 September 2007

Technical Speaking - Again

One of the points mentioned in the volunteer meeting on Tuesday was that it makes a lot of sense to grow local speakers rather than try to always bring in the 'big name' speakers. I agree with this and there is much you can do to try encourage that first… Read more

0 comments, 533 reads

Posted in SQLAndy on 19 September 2007

Notes from PASS 2007

I attended the morning portion of the volunteer/chapter meeting today and got to put some names with faces for some of the groups we do hosting for (note, if you need to host a sql chapter and you can live with what you see at www.opass.org, email me). Good… Read more

0 comments, 575 reads

Posted in SQLAndy on 18 September 2007

Technical Speaking - Some Misc Thoughts

Last week I taught 'Successful Technical Speaking' for the first time - it's a free four class I put together for End to End Training to help train local speakers for the upcoming SQLSaturday, or maybe just to speak at an oPASS meeting. Getting people to speak for the… Read more

0 comments, 772 reads

Posted in SQLAndy on 17 September 2007

Off to the PASS Summit in Denver

I'm flying out tomorrow for the event and looking forward to it, nice break from the office/work routine, a chance to learn some new stuff, and to see friends that I only get to see once a year. First time I'll be in Denver during decent weather, all my previous… Read more

0 comments, 479 reads

Posted in SQLAndy on 16 September 2007

How Many Good Hours Do Employees Work?

You might call me a bean counter, but it's a fact that every manager needs to manage the distractions that take time away from the real work that needs to be done by their team. At my last job I tried to never let meetings and other interruptions grow beyond… Read more

0 comments, 506 reads

Posted in SQLAndy on 11 September 2007

Dell Selling an iSCSI Box

Saw an plug for it from our sales rep yesterday, MD3000i. Starts at $7300 with just a couple drives, goes up to about $25k maxed out at 18TB. I've always considered the Powervault stuff pretty usable/reliable compared to the complexity of a SAN, but I see in the configuration… Read more

0 comments, 475 reads

Posted in SQLAndy on 11 September 2007

SQLSaturday - Who are the Customers?

For those who might not have browsed previous posts I'm heading up a free one day training event called SQLSaturday as part of my efforts on behalf of oPASS. It's been an interesting experience so far and we received a lot of good initial info from the ONETUG team.… Read more

0 comments, 530 reads

Posted in SQLAndy on 10 September 2007

SQL 2008 CTP4 Available - If you have time!

Makes me yearn for a faster connection, about a 2300 mb download to get all the various pieces and if you download from the main link http://www.microsoft.com/downloads/details.aspx?FamilyID=6A39AFFA-DB6E-48A9-82E4-4EFD6705F4A6&displaylang=en it doesn't launch the MS download manager so that you can pause and resume if needed. I'm torn between downloading to see if…

Read more

0 comments, 1,234 reads

Posted in SQLAndy on 10 September 2007

Background Images in Reporting Services posted on SSC

I wrote this up based on some questions in our recent BI class where we spend almost a full day on the basics of Reporting Services. Not the most exciting topic, but useful at times. I've still got some writing to do to finish explaining the security options for datasources…

Read more

0 comments, 515 reads

Posted in SQLAndy on 6 September 2007

CodePlex, CodeZone, and Connect

You might have visited these already, but it's interesting to see MS diversify a bit from the standard MSDN template. For example, if you look for SQL Server samples on MSDN you get a page that forwards you to http://codeplex.com/SqlServerSamples. CodePlex is seemingly about code but it is listed… Read more

0 comments, 841 reads

Posted in SQLAndy on 6 September 2007