To format a short date like MM/DD/YY try the following: select CONVERT(VARCHAR(8), GETDATE(), 1) as MyShortDate For a complete guide to ...

[Read the rest of this article...]

SQL, Date, Convert

Oracle: "Provider=MSDAORA; Data Source=ORACLE8i7;Persist Security Info=False;Integrated Security=yes" Microsoft Access: "Provider=Microsoft.Jet.OLEDB....

[Read the rest of this article...]

Connection Strings, SQL, Oracle, Microsoft Access, MySQL, IBM AS/400

Recently I’ve had need to change the name of a running website in IIS 7. This isn’t something you can do through the GUI, but I have disco...

[Read the rest of this article...]

IIS7, site identifier

So, if you are using DotNetNuke 5.4.1 you already have a cool alternative to default text html editor. Yes i am talking about Telerik RAD Editor. It r...

[Read the rest of this article...]

RFC 1597 provides for a group of Internet Networks that will never be assigned. Furthermore, these addresses will not route through the Internet. This...

[Read the rest of this article...]

Syntax: SELECT field1 [ , field2 ] , ... [ ] INTO newtable FROM source field1 Is a parameter that specifies the list of the fields that are to be r...

[Read the rest of this article...]

Start > run > Type "control userpasswords2" Click Add Put in the username and domain Click Next Select the "other" radio button Select "Adm...

[Read the rest of this article...]

Malware these days can wreak havoc on your registry file associations. Here is a great resource for Windows® XP File Association Fixes from Doug ...

[Read the rest of this article...]

Malware, malicious software

Here's a great sql script to use for the DotNetNuke Reports Module: Select --   AU.Username,    U.FirstName,    U.L...

[Read the rest of this article...]

string emailAddress = "email1@domain.com;address2@another.com;myaccount@somewhere.com"; string[] valuePair = emailAddress.Split(new char[] { ';' }); f...

[Read the rest of this article...]