Watch this Video from Expert Exchange where Tim Chapman speaks about writing faster SQL Queries.

Some of the things convered in this Video:

• Look at how to write efficient queries and how not to write effecient queries.
• Learn how to handle dates in the where clause to get more efficient queries.
• Take a look at parameter sniffing.
• Learn to use the executionplan to see how your sql queries are performing.  Then learn ways to improve areas that can speed up the performance of your queries.

Are you using sp_who or sp_who2?  Learn what your SQL Server is doing performance wise using an alterntaive to sp_who or sp_who2.  Who Is Active is a free tool that can help manage your server. 

Get WhoIsActive and try it out today.

I've recently benn introduced to SSIS and have had to quickly get up to speed to solve a problem with an SSIS package.

Check out this Video.  It is a great introduction to see what you need to develop SSIS and also explain what SSIS is and examples that you can use in your projects.

Image Gallery with jQuery Lightbox 1 of 3

Image Gallery with jQuery Lightbox 2 of 3

Image Gallery with jQuery Lightbox 3 of 3

Part 1

Part 2

Part 3

Check out the best tech videos. BestTechVideos

In a previous post, a video about GWT(Google Web Toolkit), talked about how to use Google Web Toolkit in a project. I was hoping that I could use GWT in a future project. The problem is that I work in a .NET Environment and based on my research it doesn't look to be a viable option.

Read More