Monthly Archives: July 2008

WCF Web Services, HTTPS, Message Security, Transport Security, Certificates

This is more complex than it should be, but we as developers work with what we got.  There are a lot of moving parts, and this is a collection of links and notes to help one navigate the minefield of … Continue reading

Posted in Software Development | Leave a comment

In addition to SQLProfiler

In Management Studio, click on "Include Actual Execution Plan" to get a nifty view of what happend.

Posted in Uncategorized | Leave a comment

ASP.NET Response.Redirect throws an ThreadAbort exception

so handle it and toss it away.   (AI: search this)

Posted in Uncategorized | Leave a comment

Rank Checker

http://tools.seobook.com/firefox/rank-checker/   "Want to know where your website ranks in the search results? Our Firefox Rank Checker extension allows you to easily check your website rankings in Google (US and international), Yahoo, and Microsoft Live search."        

Posted in Uncategorized | Leave a comment

“SET IDENTITY_INSERT” is your friend

Per MSDN Transact-SQL Reference (SQL Server 2000) SET IDENTITY_INSERT Allows explicit values to be inserted into the identity column of a table. Syntax SET IDENTITY_INSERT [ database. [ owner. ] ] { table } { ON | OFF } Arguments … Continue reading

Posted in Uncategorized | Leave a comment

Importing data into Sql Server from Excel

Using the Sql Server Management Studio, right click on the database you would like to import into and select Tasks, and then click Import Data   http://msdn.microsoft.com/en-us/library/ms140052.aspx

Posted in Uncategorized | Leave a comment