For the .NET programmer, Visual Basic programmer or PHP programmer, if you are accessing a SQL Server database there are some things you should know to performance tune your queries. Learn how to improve query performance with Indexes, how to properly use parameterized queries, using the query analyzer, and avoiding common SQL Server performance pitfalls. This presentation is a lot …

SQL Server Performance for Developers Read more »

The two sessions I will be presenting at DevTeach in Vancouver BC will be the following: Using FILESTREAM and FILETABLES in SQL Server – Configuring and Using FILESTREAM and FILETABLES in SQL Server Developers love to use SQL Server to store files, but this causes headaches for the DBA, finally a reasonable solution for file storage in SQL Server FILETABLES …

Working on my sessions for DevTeach in Vancouver in December. Read more »

Today I learned that two of the sessions that I proposed for Vancouver DevTeach were accepted. This event taking place on December 2nd to 4th 2013 at the Vancouver Sheraton Wall Center Hotel. It will have 3 full days of main conference (Dec. 2-4). Don’t miss this Vancouver DevCon! The first session: Using FILESTREAM and FILETABLES in SQL Server Steve Stedman …

Sessions Accepted for DevTeach Vancouver BC Read more »

Tonight I had the opportunity to present to the Bellingham .NET users group.  About 30 people showed up for the presentation.   SQL Server Performance Tuning and Advanced Query Tuning: This presentation will include SQL Server performance tuning tips and recommendations for both the developer and the database administrator. Topics covered will include index usage details, query tuning, understanding the …

SQL Server Performance Tuning for the Bellingham .NET users group Read more »