Presenting at Philly.NET Code Camp 2010.1

I will be presenting “The Fine Art of Stored Procedures and User Defined Functions” at Philly.Net's Code Camp 2010.1 on Saturday April 10, 2010 during the 10AM Session.

For Registration and Event Information: http://codecamp.phillydotnet.org/2010-1/default.aspx

SQL Saturday #37 – Philadelphia Presentation Notes

Thanks to all the people who packed the classroom for the presentation, asked good questions, willingly stayed awake and were generally very kind in their appreciation. 

Download the PPT and the Code

http://www.pocketjoshua.com/storage/code-samples/t-sql-for-performance/T-SQL%20Coding%20with%20XML.zip

Check out all the code samples and slides.  There were more demos in the folder then we had time to cover.

Here are a few recommended links for improving your performance skills wit T-SQL:

Simple-talk.com Writing Efficient SQL: Set-Based Speed Phreakery
http://www.simple-talk.com/sql/performance/writing-efficient-sql-set-based-speed-phreakery/

Aaron Bertrand blog series on bad habits
http://www.pocketjoshua.com/sql-journal/bad-habits-to-kick-blog-series-worth-the-time.html

Of course there is also this blog.  Feel free to add the rss feed to your favorite reader.
http://www.pocketjoshua.com/sql-journal/rss.xml
http://www.pocketjoshua.com/sql

Presenting at SQL Saturday #37 in Philadelphia

I will be presenting T-SQL Development Techniques for Performance at SQL Saturday #37 in Philadelphia at 9:30 AM on Saturday March 13, 2010 at St Josephs University as part of the T-SQL Dev Track.

Registration is open until 3/8/2010 or 325 people.  Please make plans to attend and support the Philadelphia area SQL users.  The better the attendance the more love from vendors and sponsors.

The presentation is one I have give before but will be including some new material.

Hope to see you there!

SQL 2008 White Paper - Disk Partition Alignment Best Practices for SQL Server

I have not read this article completely yet.  The purpose of this post is to remind me that I do need to read it and get comments and feedback from others who both care and have a clues as to the subject.

Enjoy:

http://msdn.microsoft.com/en-us/library/dd758814.aspx

Tips for installing SQL Server 2008 on Windows 7

While SQL Server 2008 is compatible with Windows 7 there are a few things to know to help easy some of the installation quirks.

The general gist is that there will be a few warnings that can be bypassed so long as you install SP1 or latest as soon as your are done with the initial installation.  Additionally, there is on error message that may pop up that will go away if you restart your OS.

Invoke or BeginInvoke cannot be called on a control until the window handle
has been created.

This did happen tome and a reboot did cure the problem.  Two articles that I found that were very helpful are linked below:

Is SQL Server 2008 supported on Windows 7 / Windows Server 2008 R2?

By Aaron Bertrand – SQLBlog.com

http://sqlblog.com/blogs/aaron_bertrand/archive/2009/08/14/is-sql-server-2008-supported-on-windows-7-windows-server-2008-r2.aspx

SQL Server 2008 on Windows 7

By John Paul Cook – SQLBlog.com

http://sqlblog.com/blogs/john_paul_cook/archive/2009/08/10/sql-server-2008-on-windows-7.aspx

The articles reference each other.  They were very helpful and quickly got me on track.  Thanks to Aaron & John.