Monthly Archives: April 2010

Implementing a custom enumerator for SQL Server TVP

Helpful article by Lenni Lobel. http://lennilobel.wordpress.com/2009/07/29/sql-server-2008-table-valued-parameters-and-c-custom-iterators-a-match-made-in-heaven/

Posted in SQL Server, Table Value Parameter | Leave a comment

How to Size Fill Factor on an Index

Great start and process for determining fill factor by anuchaw. http://blogs.msdn.com/windchillonsql/archive/2010/04/09/more-about-how-to-size-fill-factor-on-an-index.aspx

Posted in SQL Server | Leave a comment

How to Avoid Some Common Developer and DBA Mistakes

Great article by Brad M. McGehee, Director of DBA Education, Red Gate Software Read more: http://www.bradmcgehee.com/2010/04/how-to-avoid-some-common-developer-and-dba-mistakes/#ixzz0lYUIKydM

Posted in SQL Server | Tagged | Leave a comment

VSTS 2008, Assembly Versions and Deployment

Microsoft changed the deployment of  assemblies with Visual Studio 2008. When you created a set up package in VS2005 or lower, the assemblies could have “any” version you wanted. When a user executed the setup package, all previous versions of the … Continue reading

Posted in Visual Studio | Tagged | Leave a comment

Installing Custom Windows Service on Win Server 2008R2

To avoid odd “event log” creation errors or window service installs that seem to go nowhere on a window server 2008 R2 machine (prolly others too), always remember to “run as administrator” with a right mouse click. Spent a good part … Continue reading

Posted in Windows Server 2008, Windows Service | Tagged | Leave a comment

Using SQL Server Timestamp

Well, I googled using timestamp and sql server and while there was some good advice out there, I never saw an example of how to send that value back to sql and compare it.  All the examples showed how to pull … Continue reading

Posted in SQL Server, Timestamp | Tagged , , | 3 Comments