Building a WebSite Via The Command Line and MSBuild

| 0 comments

As a software developer, I am always looking for ways to generate a build with the additional cost and overhead of commercial products and this is where the command line and msbuild can save the day. If you have never worked with the executable aspnet_compiler.exe or msbuild.exeit is not as difficult as you may thing once you begun to understand the various switches. In fact I prefer the direct interface when performing a build because there are many times I can catch errors in code that for one reason or another are masked when performing a build within the Visual Studio .NET IDE and to be honest I have no idea why the IDE reports a successful build when the command line results in a failure. Before I continue any further I want to provide credit to Steve Smith of ASPAlliance who was gracious enough to answer questions that I had when I begun traveling down this road. ASP.NET Compilation Tool (Aspnet_compiler.exe) The ASP.NET Compilation tool (Aspnet_compiler.exe) enables you to compile an ASP.NET Web application, either in place or for deployment to a target location such as a production server. In-place compilation helps application performance because end users do not …

Continue reading

June 2010 SQL Script Collection

| 0 comments

Structured Query Language Pronounced “S-Q-L” or “see-quill,” a language used to interrogate and process data in a relational database. Originally developed by IBM for its mainframes, all database systems designed for client/server environments support SQL. SQL commands can be used to interactively work with a database or can be embedded within a programming language to interface to a database. Programming extensions to SQL have turned it into a full-blown database programming language, and all major database management systems (DBMSs) support the language. Each month I intend on posting a collection of scripts that I have found beneficial for myself as well as something that you may be able to put to use. Military Time Format DECLARE @d DATETIME = GETDATE() –ddHHmmMMMyy.toUpper (military format). –That is two digit day, two digit hour, two digit minute, three letter month, two digit year, and month is uppercase. SELECT RIGHT(’00’ + CAST(DATEPART(DAY,@d) AS VARCHAR(2)),2) + RIGHT(’00’ + CAST(DATEPART(HOUR,@d) AS VARCHAR(2)),2) + RIGHT(’00’ + CAST(DATEPART(MINUTE,@d) AS VARCHAR(2)),2) + UPPER(LEFT(DATENAME(MONTH,@d),3)) + RIGHT(CAST(DATEPART(YEAR,@d) AS VARCHAR(4)),2) Retrieve all Primary and Foreign Keys SELECT t.table_schema AS PrimarySchemaName , t.TABLE_NAME AS PrimaryKeyTable, tc.CONSTRAINT_NAME AS PrimaryKey, COALESCE(tc2.constraint_schema,’N/A’) AS ForeignSchemaName, COALESCE(rc1.CONSTRAINT_NAME,’N/A’) AS ForeignKey , COALESCE(tc2.TABLE_NAME,’N/A’) AS ForeignKeyTable FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS tc INNER JOIN …

Continue reading

Web Hosting Gone Wrong: Webhost4life

| 13 Comments

As you may have noticed last Friday evening my website was extremely slow and when it loaded it resulted in error after error. As soon as I saw the problem I begun to investigate the root cause in order to determine the best approach to resolve the issue. To my surprise WebHost4Life whom I am now calling WebHostNot4Life had migrated my site and database to a new server. Typically a move to newer hardware represents a positive aspect but in this case WebHost4Life completely failed at the task, in fact a quick search of Google yielded a number of customers experiencing similar problems as myself and in some cases a complete loss of data. It makes one wonder if this company no longer cares about quality or is simply unqualified to perform the job. Turning to Twitter I noticed a number of others in the exact same boat as myself. As I mentioned earlier last Friday around 6:00 PM I noticed the problems with my site. After a few hours trying to resolve the problem I contacted technical support to let them know that I learned that my site had been migrated to the new platform and the database was …

Continue reading

Fire Your Cable Provider And Save Your Money With PlayOn

| 1 Comment

If you’re looking for a way to cut the cord from your cable television provider and you have a broadband internet connection then keep reading. In the past I have tried a number of ways to get steaming media from Hulu, ABC, CBS, and other web based solutions on my main television sets and while I was successful it just did not work out in the long run for me. I continued to try to figure out how best to stream my favorite shows to the living and bedrooms without having to purchase additional hardware or run cables across the house I stumbled upon a product called PlayOn that works extremely well. First let me state that my teenager has a Wii console and to my amazement PlayOn supports this console as well as a number of other devices to include PlayStation 3, Xbox 360, Moxi HD DVR , and the NetGear EVA2000. Since I have a Wii, I thought it would be worth the time to try PlayOn and determine just how well it works. The first step is to download PlayOn and install the software on your primary computer should you have more than one. It is important …

Continue reading

Software Engineering Reference Posters

| 0 comments

I’m not sure what side of the fence you may fall on when it comes to reference posters, but while I don’t have my work space walls plastered with them they are none the less very informative and useful. More often than not if you’re looking for a quick answer many of these reference posters do exactly that. Oh and it doesn’t hurt that these posters and let you true geek shine thru and you may become the envy around your fellow geeks. Just remember to hang them in a location where you will not have the team looking over your shoulder all the time. In fact, why not point them to this post and tell them to print their own copies! So take down that silly office photo and hang up something that provides value. Microsoft Visual Studio Visual Basic 2005 Keyboard Shortcut Reference Poster Visual C# 2005 Keyboard Shortcut Reference Poster Visual C# 2008 Keybinding Reference Poster Visual Basic 2008 Keybinding Reference Poster Visual Studio 2010 Quick Reference Guidance Visual Studio 2010 Keybinding Cards .NET Framework 3.5 Common Namespaces and Types Poster BizTalk BizTalk ESB Architecture Poster BizTalk Server 2009 Capabilities Poster BizTalk Server 2009 Runtime Architecture Poster …

Continue reading