The Multifunctioning DBA

April 18, 2012  8:00 AM

Jobs Repository

Colin Smith Colin Smith Profile: Colin Smith

I have been working on a task that will populate a database with a ton of information about jobs from all my sql servers and allow me to do reporting on it. Of course I chose powershell to write the script to go get all my data and to populate my tables. I am also using some SPROCS in order to validate my data and get the correct data into the actual tables. I am doing that so that Powershell can just dump the raw data into staging tables and then the SPROCS determine what needs to be inserted, updated, or marked as deleted. Notice I say marked as deleted and not deleted. That is so that I will have some history about when the job was deleted from the SQL Server. I will be posting this here as I go along. My database structure is built so that not just sql server job data can be stored but oracle as well. I am not writing the sripts to gather the job info from the oracle instances since those may be in Oracle and may be in Cron. So over the next few weeks you will start seeing DDL, SPROCS, and Powershell code to get this going. Then perhaps some reports as well.

April 17, 2012  10:13 PM

SQL Saturday 131

Colin Smith Colin Smith Profile: Colin Smith

SQL Saturday is back in Phoenix and it is getting very close. April 28th is the day and man we have a very full lineup and this looks to be a great event. This will be the third SQL Saturday that I have presented at and this looks like it may be the biggest. My session is at the end of the day, not sure if that is good or bad, but I am competing against fewer sessions this year since I am in the 4:00PM time slot. Hope to see you at the event. here is a link to register.

Please go register and show up for a great day of free training, lots of swag, and networking. It really is a fun event and this should be bigger and better than last year.

April 3, 2012  3:33 PM

Powershell Plus Beta

Colin Smith Colin Smith Profile: Colin Smith

I was just notified of a new Beta of Powershell Plus. I love Powershell Plus and I am excited to get this Beta and play with it.  If you would like to play with it and give your feedback to Idera then follow the link and put it to the test and let them know what you think. You might win a Kindle Fire.

March 31, 2012  9:00 PM

Coolest thing I that was a demo during connections

Colin Smith Colin Smith Profile: Colin Smith

So in all the sessions that I attended, that was a lot, I found one demo o be above and beyond the rest and it is something that I would really like to do in my shop. During the pre con session that I attended I was able to see SQL Server 2012 be installed and run on Server 2008 R2 Core. That was awesome. I want to try it so bad now and I would love to get a real load on it and compare it to something that I have running in a standard GUI OS. I have to think that the performance would be better since I do not have anything that is not needed running and competing for CPU. The less the OS is doing means more cycles of CPU that SQL Server can have, also means that the OS might need less memory so that means SQL gets more. Those are BIG WINS in my book. Some might say that the downside is not having a GUI where you can install SSMS or other tools in order to manage the sysstem. Well we really should not be managing the database from local SSMS installations anyway and this will force the hand of your developers to stay off your server.. Sure some management may be a bit more work but you can do it all via Powershell. So do not be afraid, I am not. SQL Server running on a core version of the OS seems like a WIN to me and I can not wait to try it and do some real testing.

March 30, 2012  11:50 PM

Things I did not like about Connections

Colin Smith Colin Smith Profile: Colin Smith

Let me first say that this is not a post of me complaining, well it is but in the nicest way possible. The con was fun, it was relevant, and the sessions that I attended were good. That being said let me talk about some things that I would like to see changed.

  1. Lunch, Overall the food was good and the food is not really my complaint, I am talking about the ice tea that was sitting at the tables. I HATE Ice Tea and I doubt that I am the only one. I understand that having soda or something like that may be too expensive but why not just give us water and the option for Tea. It was a hassle to get water. (small complaint but big too me.)
  2. Schedule, again I think that the content overall l was great and I enjoyed the sessions. The one thing that really stood out to me like a sore thumb was the number of actual sessions on Wednesday. Three sessions, that seemed a bit lite to me but that is just me. And Thursday was much better with a full day of sessions. Thursday was also bad because every hour I had two or three sessions that I wanted to attend. I am OK with having to choose, I appreciate that in fact, but it seems to me that if one or two of those sessions could have been on Wednesday that I would have been able to attend more of the sessions that I was interested in.

That is really it. I think that is not too bad considering the scale of the con. I think the event organizers did a good job putting on a great event. I would recommend the con to anyone that was interested and I would have just one little bit of advice for you…. Be sure to get some sleep!!

March 30, 2012  9:23 PM

Top Sessions at Connections

Colin Smith Colin Smith Profile: Colin Smith

Now that Connections is over, for me at least (Post Cons are today). Here is what I thought the highlights of the con were.

  1. PowerShell with Allen White Precon was a great class
  2. Waits level 400 session with Paul Randal. Anytime I have seen Paul speak it is a good session filled with great material and better labs.

Those were the top two for me but all were great. I did not attend a single session that I did not find useful and relevant.

Thanks to all the presenters for sharing with the rest of us

March 29, 2012  9:30 PM

Connections in Vegas

Colin Smith Colin Smith Profile: Colin Smith

After a long day in a great powershell session, I was ready to go play some games and have a good time. Well that got a bit out of hand as I stayed out having fun until 5:00AM. My bad and no I did not miss any of the conference, I woke up and suffered and still learned a lot. So on to another day of learning and some great sessions… I went to my room after the sessions and took a nap. Woke up and thought I should go out for a while, I mean this is Vegas after all. Well I did it again, out until 5:00AM. Ouch it made for a long next day. After that I learned my lesson and I was on a better schedule, but it did make it hard to get through all the great sessions. So if you come to a con in Vegas I recommend setting an alarm on your phone for when you want to head up to bed. And listen to that alarm, you set it for a reason.

March 29, 2012  9:00 PM

Connections Pre-Con

Colin Smith Colin Smith Profile: Colin Smith

While here in Vegas at the Dev Connections con, I was able to attend a pre-con that was led by Allen Whit (Blog | Twitter) and it was great. Allen has done some amazingly cool things with powershell to help make him a  better DBA. And now he has shared some of that with me. A lot of what he covered I had read from his blog already but he showed off some things that I had not seen yet and some things that I had not thought of trying. His work on perf counter collection is great. I do not have a huge use for it right now as my company purchased a third party tool for monitoring, but it is still just great work and I can see how a consultant would find it invaluable. I hope to share a thing or two of what I learned in that pre con in my SQL Saturday 131 session. I will not be sharing his work but I have some thoughts on things that I would like to try after attending his session, so I hope that I can get it working and share it with you. One thing that I got out of it was a demo on installing and running SQL Server on Windows Core. This is something that I have been interested since the announcment of the Core edition of Windows Server but as you know it is not supported until SQL 2012.

March 29, 2012  8:33 PM

SQL Saturday 131 Phoenix

Colin Smith Colin Smith Profile: Colin Smith

I have been accepted as a speaker for SQL Saturday 131 in Phoenix again. I am really looking forward to the event and being able to share some of what I have learned while here in Las Vegas at Dev Connections. So go to the website and come get your SQL on with me and everyone else. Last year was a lot of fun and now that this is the second event here in Phoenix, I expect that it will be bigger and better.

hope to see you there.

March 27, 2012  4:58 PM


Colin Smith Colin Smith Profile: Colin Smith

So I arrived here in Vega(Blog | Twitter) about automating and maintaining SQL Server with Powershell. As you all know I love Powershell and I love doing just about everything that I can with it. I do not care if it is managing local computers, workstations, SQL Servers, Severs, VMWare, AD, etc…

That and the fact that Allen White is on the forefront of Powershell with SQL Server make this a great Precon choice for me. I will let you know how it goes and I will post some of the highlights. Not all since I had to pay a premium and I do not want to give his material away for free.

Any way I will be posting about the con as it goes and let you know the sessions that I attend and if the session was good or not. I will also be talking about my trip, it is Vegas afterall, and determine if Vegas is the best place for a con.

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: