Exam Taking Tips for Certification

For many people taking an exam can be really stressful. In this blog post I’d like to see if I can take some of the fear away from taking that exam. This is the final post in my series on How to get certified. Before you take the exam you should complete the first 3…

1

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. So make…

2

Thank You Thank You Sam I Am! I do so like this ALM!

It’s fall and that means back to school for kids, it also means time to start up and really get rolling on new projects, which means it’s a good time to think about the big picture: Application Lifecycle Management (ALM). Developing an application is about much more than just writing code.  You have to collect…

0

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…

0

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…

6

How to Study for a Certification Exam

The most common question I get when talking about certification is what should I study? Well, before you crack open a book, take the time to make sure you are taking the right exam, and figure out what you don’t know so your study time will be spent as effectively as possible. If you want…

0