Browse by Tags

  • Blog Post: SQL Server Roadmap to Denali Webcast Series

    SQL Server Denali, so many great features for reporting, high availability, business intelligence, and more . If you haven’t had time to sit down and start learning about what’s new in the latest release of SQL Server, join Microsoft Canada for a weekly webcast series to help discover and understand...
  • Blog Post: Great Content in the Nations Capital!

    TechDays is going to rock Toronto, Montreal, and Vancouver. But we haven’t forgotten the rest of the country! TechDays is sponsoring a number of events across Canada so even if you can’t make it to TechDays this year, you don’t have to miss out! In Ottawa, Microsoft is a proud sponsor and is even providing...
  • Blog Post: Quick SQL Tips – Indexed Views

    Although not a new feature, Indexed views can still be a useful tool for increasing query performance . Of course you have to be careful of the trade-offs. Just like indexing a table, indexing a view may speed up a query, but will increase your storage requirements and slow down insert and update operations...
  • Blog Post: Come Learn SQL Azure in Ottawa

    Come join me as I will be presenting this Friday in Ottawa on SQL Azure at CTE Solutions . I grew up on SQL Server, but it really isn’t that hard to get up to speed on SQL Azure. A lot of features are the same, but there are a few key differences you need to know. In this session I will be talking about...
  • Blog Post: How to Move Data from One Table to Another

    I recently saw a post on Stack Overflow asking how do you copy specific table data from one database to another in SQL Server. It struck me I should share the solution to this with others because it is such a handy trick. Often I set up test data and want to quickly copy it to another table, or a co...
Page 1 of 1 (5 items)