The Multifunctioning DBA

May 1, 2012  10:15 PM

SQL PASS Summit session submitted

Colin Smith Colin Smith Profile: Colin Smith

Last year I got shot down and I thought I might not try again. But after having such a great time presenting at SQL Saturday 131 in Phoenix, I thought I would try again. Since my session had a good turnout, people standing out the door, I thought that a broader audience may enjoy my session. I have some ideas on how to make it better and different then the SQL Saturday session, so I hope I get picked this year. If not then I guess I will try to submit sessions for some of the smaller cons, like DevConnections and SQL Rally. Well if I get picked I will let you know and I hope to see you in my session. I will try and make it fun and try to have some SWAG to hand out.


April 30, 2012  4:00 PM

My SQL Saturday session

Colin Smith Colin Smith Profile: Colin Smith

Since it has been about a year since I have done this I was a little nervous but not too bad. I got set up and people started to get in the room and find seats. before I knew it I was out of seats and people were still walking in. That is a great feeling. By the time I got started I had many people standing and I think that my final count was 39 people. That is the most that I have had in my room to this point.  I asked how many had never done anything with Powershell and I was a bit shocked. Most of the room, I would say at least 80 or more %. So they were in the right place and it was on like Donkey Kong. At this point all the nerves subsided and I did my thing and talked all about the basics and that went well, but I was trying to hurry a bit through that as I really wanted to get to some demo’s and show off the cool things that you can do with Powershell. So about 20 or 25 minutes in we hit the demos for the rest of the session. we got through about 13 of my scripts that I had prepared and I think everyone liked them. I had some good questions and I really like getting that interaction with the crowd. It lets me know that they are paying attention and that they are engaged and enjoying the content.

At the end I had a few people come up and thank me and ask some more questions and that is also really nice. I had a few hand in the speaker evals to me directly and those were all very positive, but I am really looking forward to getting all the session evals back and see what the larger group had to say.

Thanks for coming out to my session and if you were in the session and have some time please go out to Speakerate and let me know what you thought. Thanks again.

April 30, 2012  3:30 PM

SQL Saturday 131 Sessions I attended

Colin Smith Colin Smith Profile: Colin Smith

During SQL Saturday I was able to attend a few sessions before doing my own and I really enjoyed them. First I attended Fun with Reporting Services. This session was a lot of fun. Stacia made a scrabble type game in SSRS and it was truly interactive and required two players. It was amazing to me that you could do that since I can barely get a standard report with a table in it to run the way I want. This is good stuff and if you missed it in Phoenix you should try to catch it at another event if they do it again.

Then I was off to Begin Commit is not enough. This one is about the basics of transactions in SQL Server. Sounds easy enough and I thought I knew this stuff pretty well but boy was I wrong. This session was great and it really made you feel like on idiot but in a good and fun way. Again you should check this one out if you have not.

The last session before lunch was Become Bilingual! Oracle for the SQL Server DBA. This session was good for me since I work in both worlds and I am more of a SQL Server guy. This session talked about the terminology that both environments use but mean different things. This was a good class in helping you, as a SQL or Oracle DBA, communicate with your SQL Server or Oracle counterpart. Randy is a great speaker and I recommend this session to anyone that touches Oracle at all.

After Lunch I attended one more session and then I took the next hour off to get ready for my own. The last one was Best Practices for Monitoring Databases on VMWare. This session was done by a vendor, Confio, whom I really do like (full discloser). But this session was not just a spill for the Ignite product. I was pleasantly surprised by this. A lot of times vendors just take a full hour and harp on why you should use a certain product over another and this was not the case here. Kathy did a great job of explaining how you can do this monitoring without purchasing anything extra then what you get out of the box with ESX and SQL and Windows. Of course she did mention the product but mention really is the right word. I thought it was a great session and a breath of fresh air coming from a vendor.

Then I did my own session and I think it went well. So if you did not make it that is my recap of what I did at a great event. Thanks again to all involved including all the great speakers that I saw and that I did not.

April 30, 2012  2:42 PM

SQL Saturday 131

Colin Smith Colin Smith Profile: Colin Smith

So the event is over and I think it was Great. I think Amy Lewis (twitter) did a fantastic job organizing the event and all the sessions that we had. I attended some great sessions and really enjoyed the content.  in fact I am going to be sharing some of the content with my coworkers so we can all learn something.

Thanks again to everyone for coming out and enjoying SQL Saturday, thanks to Idera and Confio for donating the great swag to me, it went over very nicely, thanks to all the other sponsors, volunteers, and again to Amy for organizing the event. This would not be possible without all of you and your willingness to give back to the community. The SQL Server community is fantastic.

April 27, 2012  6:00 PM

SQL Saturday Presenter Dinner

Colin Smith Colin Smith Profile: Colin Smith

The SQL Saturday 131 Presenter dinner is tonight and I am really hoping that I can make it out and meet all the other speakers and have a good meal. It is a fun event and I really enjoy the networking and hearing what everyone else is doing and catching up with those that I have met at other events. It is a really cool way to meet and get to know others that are interested in SQL Server and a good way to make contacts that may come in handy some day. If you are a speaker I highly recommend going to the dinner and if you are not then submit a session and join us. Speaking is fun and rewarding.

April 27, 2012  4:36 PM

JackandJill Comment

Colin Smith Colin Smith Profile: Colin Smith

JackandJill left me a comment about an issue with one of my scripts and I would like to reach out to you and let you know that I would like to help. I am not sure what the issue really is and I would like to get more information from you so I can help you get it working. My twitter is @smithco32 but I am not on twitter all the time as my work will not allow me to have it up. I check it on my phone when I can so please send me a message and I will help you.


April 27, 2012  3:54 PM

More reporting work

Colin Smith Colin Smith Profile: Colin Smith

I told you about the SQL server jobs repository I was buyilding, and that is done. It works great and I have one report written that gives me an overview of all the jobs in my environment and what succeeded and what failed in the past 24 hours. That is very nice but because of that, I noticed a few jobs that have been failing for a long time and that are somewhat important to us as a DBA team. So I am going to change the way that we do things and I am going to use Powershell to do it. I will be sharing the information with you as I go and I think you will like what I am building here.

April 27, 2012  3:48 PM

SQL Saturday

Colin Smith Colin Smith Profile: Colin Smith

SQL Saturday 131 in Phoenix is coming up very quickly. Tomorrow in fact. I have a session and it looks like we have a day full of great sessions. I hope to see you at the event and in my session. Not sure how it will go since I am at the end of the day but I am really looking forward to the event. I still have a little work to do on my session but it should be a good one and I do have some good SWAG from my good friends at Confio and Idera to hand out. Idera gave me two PowerShell Plus Licenses to give away and you have to be present to win. Good luck and I can not wait to see you at the event.

April 19, 2012  8:00 AM

More SQL Saturday SWAG

Colin Smith Colin Smith Profile: Colin Smith

I have even more SWAG to hand out during my session now. My good fiends over at have giving me a couple of coffee mugs to give away during my session. I am not sure how I will hand them out but I can only imagine that it will be for someone asking or answering a question. Somehow I will give them out and I want to also say what a great product Ignite is. I have been using it for about 4 or 5 months now and it has really helped us. It is fantastic, especially when you get to the office and see an email saying “My job ran slow last night can you take a look?” Well thanks to Ignite I can and I can tell you what the issue was at that time and because I have such visibility into the SQL Server as a whole at that time I can really dig in and find a resolution to the issue. So thanks to Confio for having a great product that really does help me and my team out on a daily basis, and for the additional SWAG. Confio is doing a session at SQL Saturday 131 as well. So, since it is not during my timeslot, I would recommend checking it out. I am not usually a big fan of third party apps and I am not all about eye candy. So when I recommend something, I truly do use it and like it.

Thanks again

April 18, 2012  6:00 PM

SQL Saturday Swag

Colin Smith Colin Smith Profile: Colin Smith


I have just been informed by my good friends at Idera that they will be providing me with two full licenses for there great PowerShell Plus editor. That is right, you attend my session and you might be 1 of 2 lucky winners of a great product, one that I use everyday and I can’t imagine not using. So come on out to SQL Saturday 131 and get all the great free training and as a bonus, come out to my session, Powershell for the DBA, and you might also go home with some awesome software.

Thanks and I hope to see you in my session.

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to: