MSSQL Turn off Identity and Constraint Check

Posted in MSSQL on July 27th, 2009 by phoenixdigital

When inserting raw data into a Microsoft SQL database you may need to turn off the primary key check and any other constraints just so you can get your data into the system. The following commands will achieve this.

SET IDENTITY_INSERT [TableName] ON;
ALTER TABLE [TableName] NOCHECK CONSTRAINT all;

To restore all checks back to the way they were

SET IDENTITY_INSERT [TableName] OFF;
ALTER TABLE [TableName] CHECK CONSTRAINT all;

Tags: , , ,

Testing a Webserver Directly

Posted in Hacking on July 23rd, 2009 by phoenixdigital

From time to time you might need to see what particular software a webserver is running or the raw data it is actually returning to the web browser. To do this you will need to telnet directly to the server at port 80 and enter the following command.


GET /theUrlYouWantToSee.html HTTP/1.1
Host: the.host.name.com

You can garner alot of information from this such as

  • Server Software
  • Header Details
  • Detailed Error Messages (Sometime hidden by IE)
  • Redirect calls sent to the browser

For Each Loop Code Examples

Posted in C# Programming, iPhone Programming, Multi Language Examples, PHP Programming, VB .Net Programming on July 20th, 2009 by phoenixdigital

This post continues with examples in multiple languages of various coding routines. It’s goal is to assist someone transitioning from one language to another.

In this example we cover the for each loop.
Read more »

If Else Code Examples

Posted in C# Programming, iPhone Programming, Multi Language Examples, PHP Programming, VB .Net Programming on July 19th, 2009 by phoenixdigital

This post continues with examples in multiple languages of various coding routines. It’s goal is to assist someone transitioning from one language to another.

In this example we cover the if else commands.
Read more »

Switch and Case Code Examples

Posted in C# Programming, iPhone Programming, Multi Language Examples, PHP Programming, VB .Net Programming on July 19th, 2009 by phoenixdigital

This post continues with examples in multiple languages of various coding routines. It’s goal is to assist someone transitioning from one language to another.

In this example we cover the switch case conditional statement. This statement is frowned upon by some programmers but can make a cascade of if else statements alot easier to understand.
Read more »

Do Loops Code Examples

Posted in C# Programming, iPhone Programming, Multi Language Examples, PHP Programming, VB .Net Programming on July 19th, 2009 by phoenixdigital

This post continues with examples in multiple languages of various coding routines. It’s goal is to assist someone transitioning from one language to another.

In this example we cover the simple do loop.
Read more »

While Loops Code Examples

Posted in C# Programming, iPhone Programming, Multi Language Examples, PHP Programming, VB .Net Programming on July 19th, 2009 by phoenixdigital

This post continues with examples in multiple languages of various coding routines. It’s goal is to assist someone transitioning from one language to another.

Below is the syntax of the while loop in various languages. Included are examples of the use of continue for skipping a section of code within the while loop and continuing with the loop. Also an example of the use of break to leave to loop regardless of the condition statement.

Read more »

For Loop Code Examples

Posted in C# Programming, iPhone Programming, Multi Language Examples, PHP Programming, VB .Net Programming on July 19th, 2009 by phoenixdigital

This post continues with examples in multiple languages of various coding routines. It’s goal is to assist someone transitioning from one language to another.

In this example we cover the simple for loop.
Read more »

Windows XP as a Media Server for Xbox 360

Posted in Xbox 360 Hacking on July 19th, 2009 by phoenixdigital

This document will show you how to successfully setup a windows XP machine so it can stream videos (notably mp4 and xvid codecs) to your Xbox 360. This guide was written for those who do not have Windows Media Centre Edition.

Read more »

Tags: , , ,

Encoding Videos for iPhone and Xbox 360

Posted in iPhone Hacking, Tivo HD Hacking, TV, Xbox 360 Hacking on July 19th, 2009 by phoenixdigital

The following is a foolproof process for converting video’s from many formats to a format compatible with the iPhone and Xbox 360. I primarily use this method

  • archive recordings from my Tivo HD
  • converting xvid videos to be compatible with my iPhone
  • shinking large format mpeg or mpeg2 to lower size files without losing too much quality.

Read more »

Tags: , , , , , , ,