Monthly Archives: December 2008

Back to Seattle

Well I’ve been to Seattle 3 times in 2008 and I’m starting off my first trip in 2009 going back.  I have been appointed to the PASS Board of Directors for 2009.  As most recall I was not elected during the PASS Summit.  There were two open positions from people leaving the board last year and I have been appointed to one of them.  SQLBatman (Thom Larock)  was appointed to the other.

I will be working with the volunteers again this year and I am already working on a new plan to get more of the great volunteers we have involved with PASS.  I am sure I will still have a part in PASS Community Connection as I will continue to help others with setting this up.

I’m happy to once again be on the Board.  It was a learning experience for me last year.  I think this year I can get even more accomplished. 

Advertisements

What was I thinking? Talking about slow weeks

Ok so really I think I forgot to take my common  sense pills on Monday.   What happens when you say your going to have a slow week or this will be an excellent week to get such and such done.  What always happens it get’s busy.  Not just a little busy but terribly busy.  So far I’ve had 2 full days I even had to leave work late on Monday to get things done plus late nights of working.  I’m making  a mental note now to never post something like that again. 

On the learning side how many people out there deal with instances of SQL Server?  If you haven’t do you know how to connect to one?  This might seem simple to most and for many dba’s it should be but I was recently training our Junior DBA and he didn’t know how to connect to the instance instead of just the default.  So I figured I would give a quick run down for those that don’t know or are just learning. 

A default instance is the same name as the computer it’s running on.  So say we have a box named SQL1   to connect in SSMS you simply need to connect to SQL1 and provide credentials.  Now let’s say we install another instance on that same computer named FOO.  In this case in ssms you need to connect to SQL1\FOO  you still use the computer name but now you are telling it which instance you want to connect to.  Let’s have even more fun and add another instance called BAR  now if we want to connect there we would do SQL1\BAR.  Pretty simple eh?  Again this is something that’s simple and easy to remember but hopefully it helps the few out there that have yet to work with instances. 

pat

How do you spend your Slow week?

For many in the computer world this week is usually a production change freeze week or a slower week at the office.  For many DBA’s I know they will have less on their plate this week then they normally do.  So how is it you spend your time on a week like this?  If the week is slow for you.  Some find themselves cramming to get things done before the holiday at the end of the week. 

For me I’m still working on some data gathering designs since it’s not affecting my production systems.  But I will be taking some time to catch up on the last few weeks. I’ve had a very busy last few weeks and need some review time.  Here’s one thing I’ll be reviewing that I haven’t had a chance to get back to. 

This was the first year I would have to say we had 3 good Keynote’s at the PASS Summit.  I did not like the Dell keynote on Thursday before Tom Casey came up to speak but we’ll just not include that as one of the three. 🙂

I plan on re-watching these during my “slower” week this week and figured others might like to know where you can get the keynotes for download. 

http://www.microsoft.com/sqlserver/2008/en/us/events-webcasts.aspx

David Dewitt did an excellent job talking about the scale out capabilities planned for the future of SQL Server.  I hope to be working with this in the future so I’m very excited about it.  If you get a chance I would suggest checking them out. 

SQL Quiz

So I was tagged couple weeks ago by Tjay to take part in a SQL Quiz from Chris Shaw.

The Questions for this quiz…

What are the largest challenges that you have faced in your career and how did you overcome those?

1.  My first challenge I would say it’s not one task but all the task’s.  Balance is what I find is the greatest challenge.  Not only balancing work and family but balancing SQL Servers.  Every Server I have come across is always battling and fighting between querying the data and pulling it out for use.  It’s the most fundamental aspect of a database and usually we find ourselves trying to find ways for those two items to work in harmony more than anything else.  We tune sprocs, queries and design all in hopes of finding that happy balance where everything works. 

2.  My second challenge would be the DW projects I’ve worked on.  My DW projects rarely fit a normal DW project with a team of people and gathering requirements and gathering all the aspects of what are needed and designing a system that works for it.  Usually it’s a smaller project or one that’s expected to do all those things without all the time and effort.  Not to say this is bad it’s just that you have to be very flexible sometimes when it comes to DW projects.  If you can sit down and gather what’s needed and build a team and start the ball rolling right great!  But if not don’t be afraid to jump in head first and get going on your own.  Sometimes once they have seen you can do it then it makes it easier to keep going. 

Those are what I see as my two biggest challenges.  Maybe not specific problems I’ve come across but I rarely get specific problems. 

I’m not going to tag two more people since I’m pretty sure all the people I could tag have already been tagged.  :)  For now I’ll just post my answers. 

pat