October 2011 - Posts
Greetings Folks,
Microsoft is excited to bring 19 Sessions to DevTeach from TechDays 2011. The sessions come from 7 focus areas including:
Those of you who would like to avail a $100 discount (and why wouldn't you!), you could use the rebate code T00000NTUG up until the day of the event. Is this a treat or what? :)
TechDays 2011 sessions at DevTeach will address a multitude of topics like Building a Security Skeleton for your ASP.NET Applications, Application Development with HTML5, Migrating to Windows Server 2008 R2, What’s new in SQL Server Code-Named “Denali” and Building Your Own Private Cloud Infrastructure. For a full list of sessions and to see the abstracts, please visit the session listing and schedule.
In order to the most out of your time at DevTeach Ottawa, we suggest you do the following prior to the presentations:
Download or activate free trials of the software that we’ll be covering in the presentations, so you can try it out ahead of time:
Visit the MSDN and TechNet sites to do some pre-reading on the latest news and information on the topics that will be covered.
Looking forward to seeing you November 2nd to 4th in Ottawa!
Obi />
After manually deleting records, truncating the table and then dropping the table one at a time (being an old-fashioned and to some extent anal) I was left with a stack of stored procedures that I had to clean up as well.
I was in no mood to go through dropping them one at a time, so here’s what I found to drop all stored procedures using a cursor:
Method 1.
declare @procName varchar(500)
declare cur cursor
for select [name] from sys.objects where type = 'p'
open cur
fetch next from cur into @procName
while @@fetch_status = 0
begin
exec('drop procedure ' + @procName)
fetch next from cur into @procName
end
close cur
deallocate cur
Method 2 (This method yet simple will give you a better control of the sp’s you want to nuke by creating/viewing a list first)
SELECT 'DROP PROCEDURE ' + p.NAME FROM sys.procedures p
Cheers,
Obi />
I’ve already bought my Tech·Days ticket for this Fall – Don’t Miss your chance to come out to join me and save using my User Group promo code.
Greeting Folks,
I’m excited to let you know that this year, I’ll be attending Tech·Days Toronto this fall. Tech·Days is Microsoft’s premier technical training conference for Developers and IT Professionals. I am passionate about Microsoft technologies and always enjoy meeting and connecting with other Canadian technical professionals.
Tech·Days is a great opportunity for you and your team to enhance your technology skills by getting up to speed on the latest Microsoft technologies, and learning how to maximize your use of the current technologies in your organization.
Check out the three Tech·Days events this year and register today using my special User Group promo Code: TD2011UG and you can get your ticket for only $399.99*. That’s nearly 50% off the regular price of $799.99.
Toronto October 25-26, 2011 Toronto Congress Centre
Vancouver November 15-16, 2011 Vancouver Convention Centre
Montreal November 29-30, 2011 Montreal Palais des congrès
Buy your tickets now >>
This year’s Tech·Days promises to have a great line up of technical sessions and networking opportunities to help you enhance your skills and grow in your career. The first list of 2011 sessions have been posted on the TechDays website. Check them out. This year the team has made a few enhancements to make Tech·Days even better:
-
NEW!Hands-on lab sessions to experience the technology first hand
-
NEW!The Partner Pavilion in each city, providing you with opportunities to network with partners and sponsors
-
NEW!Keynote presentations in each cityfrom awesome technology experts
I look forward to connecting with you this year at Tech·Days 2011!
Sincerely,
Obi Oberoi (Principal Developer Evangelist)