Running a 32bit or 64bit CPU?

Posted by Dan | Posted in Systems, Windows | Posted on 09-28-2009

0

Sometimes Windows alone might not be able to tell you what your machine has. To be absolutely sure, if you at least know you have an Intel CPU, try their Processor Identification Utility.

3

You can also save a text file report summary of your machine. Here’s my machine at work:

Intel(R) Processor Identification Utility
Version: 4.21.20091215
Time Stamp: 2010/01/27 19:53:40
Operating System: 6.1-7600-
Number of processors in system: 1
Current processor: #1
Active cores per processor: 2
Disabled cores per processor: 0
Processor Name: Intel(R) Pentium(R) D CPU 830   3.00GHz
Type: 0
Family: F
Model: 4
Stepping: 4
Revision: 6
Maximum CPUID Level: 5
L1 Instruction Cache: 2 x 12 KĀµops
L1 Data Cache: 2 x 16 KB
L2 Cache: 2 x 1 MB
Packaging: LGA775
Platform Compatibility Guide: 05B
Enhanced Intel SpeedStep(R) Technology: Yes
MMX(TM): Yes
Intel(R) SSE: Yes
Intel(R) SSE2: Yes
Intel(R) SSE3: Yes
Intel(R) SSE4: No
Enhanced Halt State: Yes
Execute Disable Bit: Yes
Intel(R) Hyper-Threading Technology: No
Intel(R) 64 Architecture: Yes
Intel(R) Virtualization Technology: No
Expected Processor Frequency: 3.0 GHz
Reported Processor Frequency: 3.0 GHz
Expected System Bus Frequency: 800 MHz
Reported System Bus Frequency: 800 MHz
*************************************************************

FYI, this is from Intel:

Certain advanced Intel(R) processor technologies require system support features be present to be fully enabled. Please see the notifications below for system features required to enable the listed technologies.

Intel(R) Hyper-Threading Technology
Intel(R) Hyper-Threading Technology requires a computer system with a processor supporting Intel(R) HT Technology and an Intel(R) HT Technology-enabled chipset, BIOS and operating system. Performance will vary depending on the specific hardware and software you use. For more information including details on which processors support Intel(R) HT Technology, see http://www.intel.com/info/hyperthreading

To verify your system for Intel(R) Hyper-Threading Technology, download the Intel(R) Hyper-Threading Technology Test Utility from http://downloadfinder.intel.com/scripts-df/Product_Filter.asp?ProductID=1687

Intel(R) 64 Architecture
64-bit computing on Intel architecture requires a computer system with a processor, chipset, BIOS, operating system, device drivers and applications enabled for Intel(R) 64 architecture. Performance will vary depending on your hardware and software configurations. Consult with your system vendor for more information.

Intel(R) Virtualization Technology
Intel(R) Virtualization Technology requires a computer system with a processor, chipset, BIOS, enabling software and/or operating system, device drivers and applications designed for this feature. Performance will vary depending on your configuration. Contact your vendor for more information.

Intel, Intel Atom, Intel Core, Pentium, Xeon, Celeron, OverDrive, SpeedStep and MMX are trademarks of Intel Corporation in the United States and other countries. Copyright(C) 2010, Intel Corporation. All rights reserved.

JavaScript for the Windows Command Console

Posted by Dan | Posted in Automation / Scripting, Databases, JavaScript, Systems | Posted on 09-26-2009

0

JSDB is a great JavaScript interpreter based on Mozilla’s Spidermonkey JavaScript engine. If you like working off the command console, I suggest you give it a go. Of course, not everything is supported, as there is no HTML/DOM context in the console. To compensate for it, the author of this tool has added some great features, like being able to connect to databases, use includes ( easily via the load(“file.js”) function ), and other network facilities, like fetching HTML content from other websites.

TSQL Function to Split JSON Data

Posted by Dan | Posted in Databases, SQL Server | Posted on 09-24-2009

2

SQL Server Central has a great function that converts a JSON string into a table. Worth checking out! (Unfortunately you have to register to see it, but it’s free.)

Function looks like this

1
2
3
-- object example, braces surround the name:value objects 
SELECT id, name, VALUE FROM
dbo.fnSplitJson2('{Apples:20000,Oranges:400,Apricots:507}',NULL)

Which returns a table:

1
2
3
4
id	name	    value
1	Apples	    20000
2	Oranges	    400
3	Apricots    507

Log Parser Lizard

Posted by Dan | Posted in Databases, SQL Server, Systems, Windows | Posted on 09-24-2009

0

Log Parser Lizard is a great free tool if you use Log Parser to parse IIS logs using SQL. It’s a visual tool to query the logs. It also comes with pre-made queries. Let’s take a look at one, “Requests and Full Status by Number of Hits” in IIS logs:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
-- Let's query the IIS W3SVC80086301 Log file c:\temp\logs\ex080918.log
SELECT 	STRCAT(	cs-uri-stem, 
		REPLACE_IF_NOT_NULL(cs-uri-query, STRCAT('?',cs-uri-query))
		) AS Request, 
	STRCAT(	TO_STRING(sc-status), 		
		STRCAT(	'.',
			COALESCE(TO_STRING(sc-substatus), '?' )
			)
		) AS Status, 
	COUNT(*) AS Total 
FROM c:\temp\logs\ex080918.LOG 
WHERE (sc-status >= 400) 
GROUP BY Request, Status 
ORDER BY Total DESC

Which gives you the following result (depending, of course, what’s in your logs):

2

Also, I could’ve queried all the log files put together, such as:

1
SELECT * FROM c:\temp\logs\*LOG

Also, you can create global variables and use them in your queries so that you don’t always have to put the full path to a file. For example:

3

I’m setting the variable IISW3C equal to c:\temp\logs\ex*.log . The queries that come with this tool use these variables (keys) as a shortcut. For your IIS logs dir, you may want to set it up to point to C:\WINDOWS\system32\LogFiles\W3SVC80086301 . Once you’ve done this, you can do (HIT F5 to run query):

1
2
-- Get the top 10 from all IIS logs
SELECT TOP 10 * FROM #IISW3C#

You can also view LogParser graphs from this tool. Let’s try the query to show all extension with total hits:

1
2
3
4
5
6
7
SELECT  TO_UPPERCASE(EXTRACT_EXTENSION( cs-uri-stem )) AS Extension, 
	COUNT(*) AS [Total Hits]
FROM #IISW3C# 
GROUP BY Extension 
-- Ignore .CFM extension
HAVING TO_UPPERCASE(EXTRACT_EXTENSION( cs-uri-stem )) <> 'CFM'
ORDER BY [Total Hits] DESC

4s

Conceptual Web Browser Architectures

Posted by Dan | Posted in Development | Posted on 09-23-2009

0

2

Similar to the Conceptual Firefox Architecture, here's an overview of the other prominent browsers (except IE, because it's proprietary). The document is titled "Architecture and Evolution of the Modern Web Browser" by Alan Grosskurth and Michael W. Godfrey.

LogParser to Query IIS logs using SQL

Posted by Dan | Posted in Automation / Scripting, Databases, SQL Server, Systems | Posted on 09-23-2009

0

LogParser is a great way to query IIS logs (any text log, actually, that is delimited).

Once you have it installed (default install is to C:\Program Files\Log Parser 2.2), let’s try to query log file ex090915.log from directory C:\WINDOWS\system32\LogFiles\W3SVC1942853941 . The way you would do this, is this:

1
LogParser "select date, s-ip, cs-method from C:\WINDOWS\system32\LogFiles\W3SVC1942853941\ex090915.log" -rtp:-1

As you can probably imagine, “date”, “s-ip”, and “cs-method” are the column headers from the log file. The select statement goes in quotes. Also, rather naming a table, you give the path to the log file. What’s the argument -rtp:-1 ? If you don’t include this argument, every 10 results, it will prompt you to “press a key…,” then will show you the next batch of results. In any case, the select state we just ran will spit out the following in the console:

date       s-ip            cs-method 
---------- --------------- ---------
2009-09-15 192.168.157.128 GET
2009-09-15 192.168.157.128 GET
2009-09-15 192.168.157.128 GET
2009-09-15 192.168.157.128 GET
2009-09-15 192.168.157.128 GET
2009-09-15 192.168.157.128 GET
2009-09-15 192.168.157.128 POST
2009-09-15 192.168.157.128 POST
 
 
Statistics:
-----------
Elements processed: 27
Elements output:    27
Execution time:     0.02 seconds

LogParser will even generate graphs (.gif format) of your results.

If you want to use a GUI for your queries, I suggest you try Log Parser Lizard.

Script Out Schema & Data from SQL Server

Posted by Dan | Posted in Databases, SQL Server | Posted on 09-23-2009

0

This is a great way to script out (via the command console) the TSQL for your db schema with data included. The tool is called SQL Server Database Publishing Wizard. Scripting out your data (via insert statements) is optional, as you can script out just the schema. Check out the documentation for help.

Admin Templates

Posted by Dan | Posted in Web Design | Posted on 09-20-2009

0

5

Here’s a list of some great admin templates if you’re developing X project. These are great if you’re developing an admin panel for a CMS, or some other CRM-like application. I prefer using a sexy template when presenting a demo for my software.

jQuery JavaScript Encryption

Posted by Dan | Posted in JavaScript | Posted on 09-20-2009

0

jcryption

This is a neat way to encrypt form fields on the fly when submitting. Good way to add another layer of security. This is a jQuery plugin that uses the public-key algorithm of RSA.

Conceptual Architecture of Firefox

Posted by Dan | Posted in Development, Firefox, Web Browsers | Posted on 09-19-2009

0

Great document outlining the architecture of Firefox from a conceptual level. What components make it up and how it's maintained.


1. It was put together by the University of Victoria. To see information about other browsers, check out the post “Conceptual Web Browser Architectures.”