Did you know that the PASS Summit is right around the corner? Well Ok it's in November but The Early bird discount expires on June 30th! Now is the time to register for the Best SQL Server summit around! They have also just announced some of the sessions on the Summit Website I would suggest taking a look at them. In my opinion there's nowhere you can get so much great training on SQL server and networking with more SQL Dba's then the PASS Summit. This also will be our largest Summit ever and the 10th summit in PASS's History!
http://summit2008.sqlpass.org/spotlight-sessions.html
http://summit2008.sqlpass.org/program-sessions.html
I almost forgot the Keynote Speakers are listed also. Typically Keynote's are not the best sessions of the conference for me but with Ted speaking on the future of SQL Server I think that's not going to be one to miss. I also met and spoke with Tom Casey at a Ms event recently and I think that will be a great presentation he's interested in everything about SQL Server and should be an excellent keynote speaker.
http://summit2008.sqlpass.org/keynotes.html
Check it out and Get Registered! I hope to see you there!
Thursday, June 26, 2008
Tuesday, June 24, 2008
SSIS Parameters
I think I'm writing this as much for my sake as for others. Since I continually forget this setting here is how you pass in Parameters into SP's your calling in your Execute SQL tasks's in SSIS. In particular for this one I'm passing date's which is common.
When you have a Execute SQL Task to set the paratemer your passing in as a Variable in SSIS here's the Steps i've been using.
Create the Variable in SSIS, SSIS>Variables>NewIcon> Give it a name and type it should be scoped most likely as the whole package. That does depend on your complexity of the package.
Add your Execute SQL Task> When entering your Stored Procedure use Question marks for the parameters seperated by a comma. Then hit the parameters button and in the parameter name use each variable name from the stored procedure in the same order as you have Them in the stored procedure. Choose the Variable that it corresponds to on the other side. So you might see this.
From here hit Ok and you should have your parameters set to the proper information.
Hope that helps!
When you have a Execute SQL Task to set the paratemer your passing in as a Variable in SSIS here's the Steps i've been using.
Create the Variable in SSIS, SSIS>Variables>NewIcon> Give it a name and type it should be scoped most likely as the whole package. That does depend on your complexity of the package.
Add your Execute SQL Task> When entering your Stored Procedure use Question marks for the parameters seperated by a comma. Then hit the parameters button and in the parameter name use each variable name from the stored procedure in the same order as you have Them in the stored procedure. Choose the Variable that it corresponds to on the other side. So you might see this.
From here hit Ok and you should have your parameters set to the proper information.
Hope that helps!
Friday, May 30, 2008
Vista remote Desktop
So I've been one of the few early adopters of Vista on my desktop machine at work. I know many may have it on their laptop or other machines but for me it's my primary work machine. Its been solid in that respect on this computer except two major issues.
1. I could not RDP into it from my XP laptop. This was a huge problem since I do a great deal of work remotely and I do not like to copy it all down to my laptop machine. I have found the fix for this though! I did a search and found this blog article on the same issue.
http://weblogs.asp.net/astopford/archive/2006/02/28/439240.aspx
For me the last setting on the network sharing option was the lynch pin. It errored when i tried to change the setting but it still took the RDP checkbox inside there so I can now finally RDP into my desktop machine!
2. The second issue is different. For whatever reason one set of systems that I try and hit from my vista machine the network access is 2-3 times slower than hitting it with my laptop. I usually get 20-30ms ping times to this set of Ip's. On my laptop I get maybe 1-2ms to the same set. We still haven't figured this one out but hopefully soon. :)
Point to note I am not as of yet on sp2 I plan to install it but have not had time. :)
1. I could not RDP into it from my XP laptop. This was a huge problem since I do a great deal of work remotely and I do not like to copy it all down to my laptop machine. I have found the fix for this though! I did a search and found this blog article on the same issue.
http://weblogs.asp.net/astopford/archive/2006/02/28/439240.aspx
For me the last setting on the network sharing option was the lynch pin. It errored when i tried to change the setting but it still took the RDP checkbox inside there so I can now finally RDP into my desktop machine!
2. The second issue is different. For whatever reason one set of systems that I try and hit from my vista machine the network access is 2-3 times slower than hitting it with my laptop. I usually get 20-30ms ping times to this set of Ip's. On my laptop I get maybe 1-2ms to the same set. We still haven't figured this one out but hopefully soon. :)
Point to note I am not as of yet on sp2 I plan to install it but have not had time. :)
Thursday, May 29, 2008
Challenge
So I obviously haven't had time to keep up on my blog and i'm sure I don't have a ton of readers but hey I figured I would ask myself this question as much as my readers.
Do Challenges that are presented to you keep you up at night? Personally if someone presents me with a DB problem or a Challenge I usually start rolling it around in my head and don't stop until i come up with several options. I may or may not write answers to it but I still take my mind down the path to the answers. I was presented with a Challenge recently a real big challenge that I'm still thinking about. I know their are other people out there like me I work with several of them. :) I personally think if life isn't challenging it's not worth living. I suggest to everyone to take a challenge every once in a while and see what answers you come up with. :)
Do Challenges that are presented to you keep you up at night? Personally if someone presents me with a DB problem or a Challenge I usually start rolling it around in my head and don't stop until i come up with several options. I may or may not write answers to it but I still take my mind down the path to the answers. I was presented with a Challenge recently a real big challenge that I'm still thinking about. I know their are other people out there like me I work with several of them. :) I personally think if life isn't challenging it's not worth living. I suggest to everyone to take a challenge every once in a while and see what answers you come up with. :)
Tuesday, March 11, 2008
Code Camp Speaker Announcement
Once Again the Code Camp is coming up which means my life is very busy. Here is the official Speaker call. Registration is also open at www.utcodecamp.com
April 26th 2008
Neumont University
Salt Lake City, UT
Code Camp is a one day free training for all developers of any technologies to attend and learn from their peers. We are looking for Speakers to present at this event. All topics are open for discussion and all formats. The sessions would be 45 Minutes long with a 10-15 minute QA time at the end of the session ( total 1 hour). This will be an all day event we plan to go from 9:00-5:00. You don't need to be present the whole day but we would love to have you around for questions from users or to see the other great content of the code camp.
We are looking for 100-150 people to attend the code camp. We will have 3 tracks running all throughout the day (3 sessions going on at once). There might be a chance to do your presentation twice depending on demand.
You must bring your own notebook for your presentation. There will be a room on site for speaker prep during the day of the Code Camp.
Any code samples you show should be made available for download from Code Camp web site. (http://www.utcodecamp.com/)
We are not covering travel or expenses for speakers, but you will receive a great big THANK YOU. A Cool Polo Shirt also!
If you're interested please submit a session title, abstract, and bio Email to pwright@medicity.comPlease put Code Camp Speaker In the subject.
April 26th 2008
Neumont University
Salt Lake City, UT
Code Camp is a one day free training for all developers of any technologies to attend and learn from their peers. We are looking for Speakers to present at this event. All topics are open for discussion and all formats. The sessions would be 45 Minutes long with a 10-15 minute QA time at the end of the session ( total 1 hour). This will be an all day event we plan to go from 9:00-5:00. You don't need to be present the whole day but we would love to have you around for questions from users or to see the other great content of the code camp.
We are looking for 100-150 people to attend the code camp. We will have 3 tracks running all throughout the day (3 sessions going on at once). There might be a chance to do your presentation twice depending on demand.
You must bring your own notebook for your presentation. There will be a room on site for speaker prep during the day of the Code Camp.
Any code samples you show should be made available for download from Code Camp web site. (http://www.utcodecamp.com/)
We are not covering travel or expenses for speakers, but you will receive a great big THANK YOU. A Cool Polo Shirt also!
If you're interested please submit a session title, abstract, and bio Email to pwright@medicity.comPlease put Code Camp Speaker In the subject.
Code Trip Event
Well the Giant bus has come and gone to SLC. We had a great event on March 7th when Tim and his bunch came to town. I would like to thank Tim and all the speakers that are riding around america on the bus. Here's a few pics from the Bus. Come back anytime guys! You can keep track of these guys or find more information at www.thecodetrip.com
Mountains of Snow to greet you on your first stop.
What happens when an MVP gets in front of an MS bus. :)
Thank you Vanna(Craig) For displaying the Bus for us.
Mountains of Snow to greet you on your first stop.
What happens when an MVP gets in front of an MS bus. :)
Thank you Vanna(Craig) For displaying the Bus for us.
Tuesday, February 26, 2008
Upcoming Local Events
I've been behind in my posting's but also in announcements about upcoming events. Even the ones i'm putting on! :) So here's a good summary of upcoming events.
March 7th. Code Trip.
“The Code Trip is a 22-city tour being done by the evangelism team at Microsoft. Salt Lake City is one of our first stops immediately following the MIX08 conference in Las Vegas. Come join the greater Utah user groups for a discussion on some of the newest Microsoft technologies. Learn what is powering some of the Code Trip systems with WPF and Silverlight. We’ll bring stuff to give away and we’ll find some place to have a geek dinner afterwards for those who would like to join us. If you are doing something great with .NET technologies, we want to hear from you as well! We’re video logging the entire trip and want to give developers a chance to share their story. Come join the groups at Franklin Covey on March 7 from 3-5pm." www.codetrip.com for more info
April 24th Community Launch Event for Sql 2008 and Windows 2008.
This event will also be at franklin covey. We will have half the day dedicated to SQL Server 2008 and half the day dedicated to windows 2008. I will be posting a simple schedule and topic list as we get closer to the event. Come and join us to learn about the new products coming out.
April 26th Utah Code Camp Spring 2008
This is the Spring code camp for this year It will be on Saturday from 9:00-5:00. You can register and get all information at www.utcodecamp.com
All the events are free and it's a great chance to network with other It professionals and to learn about lots of various products.
March 7th. Code Trip.
“The Code Trip is a 22-city tour being done by the evangelism team at Microsoft. Salt Lake City is one of our first stops immediately following the MIX08 conference in Las Vegas. Come join the greater Utah user groups for a discussion on some of the newest Microsoft technologies. Learn what is powering some of the Code Trip systems with WPF and Silverlight. We’ll bring stuff to give away and we’ll find some place to have a geek dinner afterwards for those who would like to join us. If you are doing something great with .NET technologies, we want to hear from you as well! We’re video logging the entire trip and want to give developers a chance to share their story. Come join the groups at Franklin Covey on March 7 from 3-5pm." www.codetrip.com for more info
April 24th Community Launch Event for Sql 2008 and Windows 2008.
This event will also be at franklin covey. We will have half the day dedicated to SQL Server 2008 and half the day dedicated to windows 2008. I will be posting a simple schedule and topic list as we get closer to the event. Come and join us to learn about the new products coming out.
April 26th Utah Code Camp Spring 2008
This is the Spring code camp for this year It will be on Saturday from 9:00-5:00. You can register and get all information at www.utcodecamp.com
All the events are free and it's a great chance to network with other It professionals and to learn about lots of various products.
Subscribe to:
Posts (Atom)
