TwilightMoms City Movie Festival

If you had the opportunity to to see the Twilight Movie screening a few days ago it was a great date with the wife or significant other.
TwilightMoms.com put on a huge city movie festival and the outcome was extraordinary. The committee wanted capture the energy and excitement in Salt Lake City, Utah. There were tons [...]

Twilight Movie Screening

Or should I say, Twilight Screaming. I was of course one of the few men in the theater to see the movie and I KNOW that the others were, the radio station manager, a movie reviewer from ScreenRant.com and the other supportive husbands of the committee members at TwilightMoms.com. I was caught up in the [...]

SQL Recompiles

Here are some articles that describes the need to reference the owner (schema) of SQL Server stored procedure when called by applications. Also, making sure that the calls are sensitive to the case of the schema.ProcName.
 

http://support.microsoft.com/kb/263889 (Reducing blocking by compile locks)
http://support.microsoft.com/kb/243586/ (Reducing Stored Procedure recompiles)
http://support.microsoft.com/kb/195565/EN-US/ (algorithm for Auto-Update stats and recompile determination)

Following these suggestion can [...]

SMO SQL Server Error Reading Stored Procedures Collection

The following error is appearing while running Visual Studio 2005 and developing an application with SMO capabilities. It appears when trying perform a foreach( on ActiveDB.StoredProcedures).
Could not load file or assembly ‘Microsoft.SqlServer.BatchParser, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91′ or one of its dependencies. An attempt was made to load a program with an incorrect format.
I found an MSDN [...]