Archive for October, 2009

A Few Days After The Conference

Posted: October 27, 2009 in Uncategorized

Well last week was an exciting week, in the SSWUG conference we did a few things that we had never done before. Any time you try something new there is a bit of the nerves that set in but you keep your head down and continue to press through them. Here is a short list of the firsts:

  • We did a SKYPE Video Call with one of the speakers. The video was shown live to the conference attendees.
  • We did a SKYPE Audio Call with an attendee in London. It was awesome to talk to someone so far away about a conference we were doing live.
  • We had a whole room that was dedicated to all live sessions all day. Speakers in this room were delivering sessions without the safety of a recording. This gave attendees from around the world the chance to ask questions in the middle of a session.

All of this along with a number of other sessions and activities really lead to an awesome event.

If you attended this event make sure you fill out your survey. We look for these to help us plan for the next conference from the dates to the event to the subject.

Speaking of awesome events there has been a number of Saturday events around the country over the last few years. One of these a friend of mine is a coordinator and is really excited to be involved with this.

They plan on having various tracks, such as development, architecture, administration, and end users with 4 hands on lab sessions for SharePoint 2010. All the breakout sessions will be a mix between 2007 and 2010 topics. Our registration page is located at http://www.sharepointsaturday.org/kc. This year we are lucky to have Joel Oleson, former MS SharePoint Product Team Member and SharePoint Evangelist for Quest Software, keynoting our event.

If you have any interest in Share Point and will be around KC Dec 12th, 2009 you may want to check out this Share Point Saturday. This is a free event and I know there will be a number of National Speakers there.

Day 1 in the Books

Posted: October 21, 2009 in Uncategorized

Day 1 for the conference is in the book. It was a great event with SQL Rockstar otherwise known as Thomas La Rock. We were getting a lot of questions and there was some great talk about if you as a DBA want to be Mr. Right or Mr. Right Now. I can’t go through and type his whole session, but here is the break down…

Mr. Right – This is the guy who is right all the time. He is known for being right and may not be known for the best customer service. You may have met this guy in the past. See the thing about Mr. Right is that he plans there may not be a lot of quick fixes. Mr. Right is confidant and does things the right way.

Mr. Right Now – Always has a phone to his ear and is spending most of his time working manual workaround issues. Mr. Right Now is very well like and is everyone’s best friend. He would be a big hit at all the parties, however he is working to make sure that everyone else’s mistakes have been corrected or should we say band-aided.

Maybe the descriptions are a bit drastic. But really is the mindset of proactive or reactive. Awesome discussion Mr. Rockstar, what a way to start our first all live all day all room confernce. It was a pleasure to meet you. I hope to work with you in the future.

In the morning we have Ted Malone, I am sure he is going to have some great information to pass along as well.

Late this week

Posted: October 16, 2009 in Uncategorized

I have a lot going on this week. 3 big presentations that are keeping my attention plus knowing I will be in Tucson next week for the conference. If you haven’t had a chance to look at it yet you should check out the lineup. I hope that I have more time next week to post some more information.

Only a couple of days left to register!
Want to Stay Up To Speed with SQL Server?
Oct 21, 22, 23 – SSWUG.ORG Virtual Conference [Register Here]
75+ sessions, expert speakers, time is running out to register.

Oct 26, 27, 28 – Smart Database Design Class with Paul Nielson
In-person, hands-on class about best practices, approaches and more.  Seats VERY limited.  (West Coast – Tucson, AZ)
[More information here] [Register Here]

I have about 100 e-mail address like I am sure that everyone else does as well now a days. Many of them I never check, but today I got an e-mail from a friend that I use to work with. I met this friend about 10 years ago when we worked at the same company. I am sure that his first memory was of me taking all the admin access away from about 15 developers (Not a great day in my career). Back then I was very adamant that all code must be done in stored procedures, he wanted to know how I felt about it today. Today I know that I am not always going to be so lucky, however that does not mean that I cannot share my opinion on a professional level.

 

So I took 5 min to write down what first came to my mind on the Pro’s and Con’s of using stored procs:

 

Pro’s

 
 

  • There is a lot of flexibility in using dynamic SQL statement.

 

  • Developers have more control over how data is returned.

 
 

Con’s

  • When code is embedded in web pages the risk of SQL Injection is very high.  Over the last few years we have seen actual examples from clients who have not changed over to Proc’s  What use to be a matter of just sanitizing your inputs is now a matter of being able to catch the hack at all.  Many of the hack are coming across as Hex so there is no way to sanitize.  I have actual code examples of this.

 

  • There is always the fact that SQL Server has no idea what is coming at it, so it has to continue to compile the procs and look at Stats to see what is the best index to use. 

 

  • When the code is not in procs the performance tuning is left up to the developer of the application or it put a major load on the DBA trying to find the bad code using 3rd party procs and or trace files and performance monitors

     

  • Security is a concern when direct table access is allowed. Even in a Select statement. There have been many times when I have seen a Select statements hurt the performance of a production server.

     

I am sure I missed a bunch of Pro’s and Con’s. If you make a note on here I would be more than happy to add them.

 
 

The Attitude

Posted: October 5, 2009 in Uncategorized

I was thinking today about the many things that you can do with SQL Server. Things that go beyond what database servers are really designed to do. As I was thinking about the subject it reminded me of a discussion I had one time with a boss of mine right after I got out of the Marine Corp. This boss of mine was named Bill and Bill played a huge role in getting me back into thinking like a civilian and understanding what you need to do to succeed. Anyhow, we had this employee that worked for me and whenever we had an idea on how we can make something better or a new benefit to being a client of ours this employee would always come up with reasons not to do it. This guy’s name was John and John was 100% sure that the product we offered at that time could not get any better.

If you think about John he may be bringing valid points to a subject. There may have been many finer more specific points of a suggestion that he would just fight us on. If Microsoft handled business this way we would not have many of the cool neat new features that we do. To take it one step beyond that, another company may have produced something that had been tabled causing us to lose that money.

OK, I am done rambling. I am just saying when new subjects come across your desk maybe we should take a look at how it can be done, not always why it cannot be done. There is always the question on if you should do something that needs to be addressed. In my opinion it’s all in the attitude.