Browse by Tags

  • Blog Post: New SQL Azure lab available (How to move data to SQL Azure)

    The SQL Azure labs site is a great place to explore and play with SQL Azure! You are probably already using SQL Server and may be working with or wondering about SQL Azure. Often when I want to explore a technology, I find reading a blog post or MSDN article isn’t enough to make me comfortable. I need...
  • 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...
  • Blog Post: SQL Azure Federations (Because you have a lot of data)

    Last week I explained SQL Azure Essentials for the Database Developer where I covered some of the differences between working in SQL Azure instead of an on-premise database from the perspective of a SQL Server database developer. Today I will continue in that vein and explain one of the upcoming features...
  • Blog Post: SQL Azure Essentials for the Database Developer

      I admit it, I am a SQL geek. I really appreciate a well designed database. I believe a good index strategy is a thing of beauty and a well written stored procedure is something to show off to your friends and co-workers. What I, personally, do not enjoy, is all the administrative stuff that goes...
  • Blog Post: Why You Should Never Use DATETIME Again!

    Dates, we store them everywhere, DateOrdered, DateEntered, DateHired, DateShipped, DateUpdated, and on and on it goes. Up until and including SQL Server 2005, you really didn’t have much choice about how you stored your date values. But in SQL Server 2008 and higher you have alternatives to DateTime...
  • Blog Post: Table Valued Parameters Save Code and Traffic

    Do you use Stored Procedures? I hope so, they are great for performance and security. But, on early versions of SQL Server you could only pass one record at a time to a stored procedure. So those of us who nobly followed best practice and used stored procedures for inserting, updating, and deleting records...
Page 1 of 1 (10 items)