Archive for December, 2009

Consultant Tools

Posted: December 30, 2009 in Uncategorized

When I was at lunch today I was thinking about the basic tools in my tool belt. In my tool belt I have SQL Scripts, software and even links to references if I need them. But as I was thinking about the software I know that what I use really comes down to a couple basic tools. The tools that I use make my life easier and well make it so that I can do my job faster and then move on to the next task.

Over the summer I have been onsite with a number of clients and none of them had moved into the direction of purchasing tools for their SQL Server. I however did have my scripts and my references. My tools not so much, the way the majority of the tools that I have used and or seen are licensed by server or instance. Not by the user.

Maybe I am asking too much but each of these tools have a number of different feature sets, I have the tool I like. It would be so nice to go to a client, plug in my key and know that I can get full use of the product as long as I need it. Once I leave I can deactivate the licenses by uninstall or web. This method would allow me to have the tools that I like and know how to use with me at all times. I have my references like web sites; I have my SQL Scripts now I want my tools.

It could be that this is a problem for just me. I do find that I want a lot.



What’s Coming Up

Posted: December 28, 2009 in Uncategorized

I say down last night and I tried to figure out why I am so busy and what I have in the works right now.


Well to say the least there is a lot going on. First and foremost the new item on my list is that I have signed a contract that has be authoring a book. From the looks of it this should take about 18 weeks, maybe a bit longer. During this process there are a number of other events that are happening.

Over the last couple weeks I have had 2 articles published on SSWUG in the Month of January it appears that there will be 4 more.

Then there is also the free SQL Server 2008 Power pivot event that I mentioned last week. If you have not signed up I highly recommend it. This is a free event meaning it will cost you nothing at all, it is hosted by SSUWG on the vConference Platform.


Once those items started to move along the Rocky Mountain Tech Trifecta v2.0 is going to kick off Feb 27th, 2010. I was at last year’s event and it was a kicked. Looks like we are back at Metro State College again. This event is being sponsored by Colorado Technology Consultants. If you want to sign up take a look here.

The Spring SSWUG Conference is just around the corner as well. We are well along in the phase of picking speakers and sessions and look forward to having more information on line soon.

I hope you had a great holiday week and a happy new year.

If I were to look at who would be the best person to give me an overview of Power Pivot or the next release of SQL Server, I without a doubt would pick the man himself Mr. Donald Farmer from Microsoft. However getting the chance to sit down with Donald on a one on one base is very difficult; he is one of the driving forces behind Power Pivot. Not too long ago I had the chance to work out a schedule with Donald that will allow for a FREE event that is going to be hosted by vConferenceOnline in coordination with SSWUG. This Free event is completely free but will require that you sign up. You can find all the information here:

This event looks like it is going to be a 4 hour review with a full list of the sessions on the registration pages. If you work with SQL Server I honestly cannot think of a reason why you would want to miss this event.

Toys for Tots

Posted: December 16, 2009 in Uncategorized

I have a number of event announcements for this week, but on the way into work I heard on the radio that most Toy for Tots programs are well under 50% of what they need to help children have any sort of Christmas this year. Here in the Denver area they were talking about how they had 70,000 requests for a toy for a child yet they had only received 20,000 donations from the community. I know that times are tough for many right now, and I hope that things are picking up but if you are walking around the store this weekend or this week during this crazy Christmas rush I ask that you buy a small gift if you can afford one, maybe even two. Maybe we can help a few more children have a great Christmas.

Sorry to be so off topic, tomorrow I hope to have the ability to announce a couple more events that are just around the corner. Yesterday SSWUG release an article of mine on how to determine if a stored procedure is being used. You may want to check it out.

Did They Lie to Me?

Posted: December 10, 2009 in Uncategorized

How do you get around that sales pitch? I talked to a vendor yesterday that was telling me all about the product that they offered that would help me do backups in a whole new way. I really did like the idea when I first heard about it but when I started to inquire about how it backups with SQL Server the water started to get a little murky.

See this product is for companies to backup everything, not just SQL Server. So they do Exchange and file servers and so on. Now I started to ask question about do they support log shipping or replication because they told me they use VSS and volume shadow copy. This is the link that they sent me.

If you look at the bottom it is very clear that it does not support log backups, that makes me think it does not support log operations at all, so how could they look at replication, t-log shipping or database mirroring. The thing that gets me, when they claim they can backup a SQL Server on the home page you would believe that they could do it without impacting any of the SQL Server features that you are using. What they really mean is we sort of support SQL Server.

I do like the product and there is a way that I can support I just have to think about how much I trust a company that hides what the product can or cannot do… What do you think?




Interview Question Today

Posted: December 2, 2009 in Uncategorized

This entry is really to get you in the mode of answering questions that you would for a job interview. There are always the standard ones but I find that many times people running the interview will ask you a question that you don’t have a canned answer for. May I should have for this one. It was the second time I had been asked. The funny thing is that it relates to a question that I use to ask a lot, but it’s now been changed. My question was or use to be.

Where do you want to be in 5 years?

But now I am being asked.

If you were to define your role would you define it as. What would be the perfect job?

I think all of the questions were fair and I glad I had some time to think about them. I am going to have to send my mind into think mode because I can tell you that I never really thought about it. But I will now.


On a side note hope you had a great turkey day.