Data Visualisation JavaScript Library

by Joe Hunter 17. May 2012 21:30

If you need to create data visualizations, this JavaScript library called D3.js created by Mike Bostock is very useful.

Some knowledge of HTML5, SVG and CSS is required. There are tutorials available on github to get started.

Tags: data visualisation

Data Visualisation

The Two-Thousand-Year-Old Computer

by Joe Hunter 10. May 2012 22:19

Was bowled over by the technology involved in creating this device 2000 years ago, apparently Archimedes was the inventor.

Tags: qi

QI

Themeroller for jQuery Mobile

by Joe Hunter 7. May 2012 21:17

A handy tool for creating your own customized jQuery mobile theme. Check out the theme Andy Matthews created based on the Twitter Bootstrap framework.

Tags: jquery mobile

jquery mobile

MIT Android App Inventor

by Joe Hunter 1. May 2012 20:41

Build Android Apps without writing any code.

http://beta.appinventor.mit.edu/learn/

Tags: android

Android

What version of SQL Server do I have?

by Joe Hunter 30. April 2012 19:48

Following on from this post on identifying SQL server versions, this blog gives very detailed information on all SQL server versions and service packs

Tags: sql server

SQL Server

SQL formatter

by Joe Hunter 30. April 2012 18:55

This is a useful tool from redgate, formats SQL. An excellent online companion to SQL Fiddle

Tags: sql

SQL

Use Openrowset to select from Excel into SQL Server

by Joe Hunter 29. April 2012 20:18

SELECT *              
FROM OPENROWSET ('Microsoft.Jet.OLEDB.4.0'             
,'Excel 8.0;Database=C:\test.xls'              
,'SELECT * FROM [Sheet1$]')              
              
              Or from CSV: 
             SELECT * FROM                  
OPENROWSET('MSDASQL', 'Driver={Microsoft Text Driver (*.txt; *.csv)};DEFAULTDIR=C:\;Extensions=CSV;','SELECT * FROM my_csv.csv')

Tags: openrowset

T-SQL | SQL Server

Unicode and Character Sets…A crash course

by Joe Hunter 29. April 2012 19:56

One of my bete noirs in SQL server is collation and the problems that can arise from it. Thankfully Joel Spolsky has written a very in-depth guide on collation and character sets that will help everyone to get to grips with this subject.

Tags: unicode, collation

UNICODE

Import Fixed Width Text File into SQL Server

by Joe Hunter 29. April 2012 19:42

Had a torrid time trying to get SSIS working to import a fixed width text file into SQL server. In the end due to lack of flexibility with SSIS packages I opted to revert to using schema files instead. This worked perfectly, but the only downside is that there has to be a unique schema file per text file if the fixed width layout is different.

This article from Datebase Journal is all you need to get started. Also there are some useful functions in this article by Phil Factor

Tags: sql server, t-sql, openrowset

SQL Server | T-SQL

ASP.net and Ajax

by Joe Hunter 23. April 2012 22:37

This article is very useful for looking at ways of “Ajaxifying” (has to be a word? if it isn’t Copyright jhunter 2012) your asp.net web app when retrieving data from backend.
Personal favourite has to be handler (.ashx) pages!

Click here for full article

Tags: jquery, asp.net

.NET

Advertisement

Tag cloud

Page List