• Get Out Of Dodge–Migration Resources

    { This article also appears on The Regular IT Guy } As part of the TechEd Session I did at TechEd NorthAmerica with all of its video Switcher issues AND to keep the resources flowing on this topic - I have put together this resource blog post including embedded video screencasts of each of the demos. The original presentation pace was fast (too fast) - so here you can grab a Pint / Coffee...
  • Register Now for TechDays 2011!!

    It’s here! It’s live! You can now register for TechDays 2011 in Toronto, Montreal, and Vancouver!! We are really excited about the great sessions you will be able to attend grouped into the following content areas: Communications & Collaboration featuring sessions on SharePoint 2010, Office 365, Exchange 2010, and Microsoft Lync Server 2010! Cloud Computing & Online...
  • “The SQL Guy” Post #5: SYNONYMously Reference SQL Server Objects

    Continuing on a topic that includes some more content aimed at DBAs and developers, this week we’ll look at how SYNONYMs can make your life easier.   What would you do when an object that is referenced in several places and in several databases (Stored Procedures, Functions, etc.) is being moved to a different database or is being renamed due to a new object naming policy? Think of how much work...
  • Just how far will we go to get awesome TechDays 2011 content?

    Oh - about 32,990 kms – based on the exact flight paths for a round trip from Ottawa – Vancouver - Auckland/New Zealand – Gold Coast/Australia – Sydney/Australia – Vancouver – Ottawa. Based on my sessions I’ve presented at TechEd North America, contacts at the Australian and New Zealand editions reached out to see if I’d be interested in presenting...
  • TechDays 2011 Session Submissions Now Open!

    Are you passionate about technology? Do you have a desire to share your knowledge with your developer and IT Pro peers? Is there a story that you feel you need to share with the rest of Canada? If you answered YES to any or all of the above questions, you’re in luck!! TechDays Canada 2011 is looking for individuals who have a story to share and want to deliver a session in one or all of the...
  • “The SQL Guy” Post #4: SQL SERVER NOW SUPPORTS COMPOUND OPERATORS

    Saleem Hakani switches gears a bit to talk about how to make code more efficient with compound operators in SQL Server 2008.  Enjoy! Do you miss the ability to use the compound operators the way you would use them in other languages? Wouldn’t it be nice to provide a shorter syntax for assigning the result of an arithmetic operator? SQL Server 2008 introduces Compound Operators that allows you...
  • Security Bulletins for the Regular IT Guy #33, August 2011

    Over pints Pierre Roman, Bruce Cowper and Rick Claus decided they would put together a concise and timely podcast each “Update Tuesday”. The object is to keep it simple by letting you know in plain non technical language what the updates are, what they resolve and why you should care. As always - if you have suggestions on making it better - please pass on your comments. Mail Rick directly...
  • “The SQL Guy” Post #3: THE POWER OF SQL SERVER 2008 CENTRAL MANAGEMENT SERVER

    Here is another great article from Saleem Hakani of the SQL Server product team at Microsoft.  Enjoy! Imagine this: Your manager has asked you to find out the available disk space for all the drives from SQL Servers in the production environment and you have 6800 SQL Servers that are spread in North America, Europe, Asia and Australia. After an hour, your manager comes back and asks you to get...
  • “The SQL Guy” Post # 2: USING THE MIRROR DATABASE FOR REPORTING/QUERYING PURPOSE

    Before I get to the meat of this blog post, I have to acknowledge the fact that the technical content of “the SQL guy” blog posts is the work of Saleem Hakani from the SQL Server product team at Microsoft.  Saleem is a wealth of information and I find his posts of great value that I want to share them with you.  Thanks Saleem!! Now, onto the topic at hand… How many times have you thought...