RSS
-
Recent Posts
Archives
- May 2013
- March 2013
- February 2013
- January 2013
- December 2012
- November 2012
- October 2012
- September 2012
- August 2012
- June 2012
- May 2012
- April 2012
- March 2012
- February 2012
- January 2012
- December 2011
- November 2011
- October 2011
- September 2011
- August 2011
- July 2011
- June 2011
- May 2011
- April 2011
- March 2011
- February 2011
- January 2011
- December 2010
- November 2010
- October 2010
Categories
- Android
- Application design
- Business models
- Cloud
- ElephantPM
- Excel
- FogBugz and Kiln (Mercurial)
- Frameworks
- HTML5
- Humour
- Infrastructure
- iPhone
- James Bayley
- Keyapt
- Lean startup
- Microsoft SQL Server
- Music
- PRINCE2
- Project Management
- Puzzle
- Railo and ColdFusion
- Science
- Stakeholder engagement
- Uncategorized
- User Experience
- Windows Phone 7
Blogroll
Meta
Author Archives: Dr James Bayley
Netgear WNR1000v3 router port forwarding bug
My router was supplied by Plusnet (firmware V1.0.2.30_53.0.66B1). It has several bugs in the port forwarding function. First the good news: It WILL forward port 80 to port 80 on another server Now the bugs: The User Interface prohibits forwarding … Continue reading
Posted in Application design, Cloud, Infrastructure
Tagged netgear, port forwarding, router
Leave a comment
PyCon tweet proves email is not worst form of communication
I have long thought that email was the worst form of communication; primarily because it involves no real conversation, only the author giving his views to the recipient. But Adria Richards, who in her own words is a “Joan of … Continue reading
Posted in ElephantPM
Tagged developers conference, female equality, joan of arc, python developers, sense of humour
Leave a comment
Create the Union of two tables in Excel
It is very common in Excel to need to create a single table from the two or more other tables. For example, different users may edit different worksheets but you need to aggregate all the data for processing. This can … Continue reading
How to add a row number to an Excel table
Excel tables provide a lot of support for data processing and the use of structured references can improve readability. We want to number rows in an Excel table and we can do it really easily using structured references. =ROW(Table01[@])-ROW(Table01[[#Headers],[RowId]]) We … Continue reading
Posted in Application design, Microsoft SQL Server
Tagged Excel, Microsoft Excel, Row (database), Spreadsheets
Leave a comment
A T-SQL SPLIT function
When taking existing data to put into a data warehouse one hopes that it is nicely formatted. This is seldom the case and recently I was faced with the problem that single field contained a rather dirty list. First I … Continue reading
Posted in Microsoft SQL Server
Tagged Data warehouse, Data Warehousing, Databases, Transact-SQL
Leave a comment
Opera joins Google/Apple in-crowd with shift to WebKit and Chromium
Posted in Uncategorized
Leave a comment
SQL Server Import Wizard cannot import fields containing more than 255 characters
I have been importing data from Excel to SQL Server using the SQL Server Import Wizard. Usually there is no problem but I have found a bug. 1. To reproduce: Try to import a column containing more than 255 characters … Continue reading
Posted in Infrastructure
Tagged bug, Data type, Excel, Microsoft SQL Server, SQL Server
Leave a comment
How the Internet has Changed the Spread of Information
Something new today, a post by a guest blogger John Harris on how the internet has changed the spread of information. Away you go, John, – In the past couple of decades, the Internet has transformed from a classic message … Continue reading
Posted in Uncategorized
Leave a comment
Office 2013 upgrade – red pill or blue pill?
The red pill and its opposite, the blue pill, are pop culture symbols representing the choice between the blissful ignorance of illusion (blue) and embracing the sometimes painful truth of reality (red). Wikipedia about The Matrix movie I have to decide whether to upgrade to Office … Continue reading
Posted in Business models, Cloud, Infrastructure
Tagged Chromebook, libreOffice, Microsoft Excel, Microsoft Office 365, Mint, Red pill and blue pill, windows 8
Leave a comment
A review of JavaScript drawing libraries for flowcharts, Gantt charts and timelines
Overview I manage my projects using my own ElephantPM project management methodology. This is a similar in many ways to PRINCE2 but is greatly simplified so that it is suitable for use by smaller organisations. My needs ElephantPM divides the … Continue reading
