• About

Dr James Bayley

~ Creating successful projects

Dr James Bayley

Category Archives: Microsoft SQL Server

Using Excel 2016 to unpivot data

03/04/2017

Normal people, by which I mean those who don’t process data all day will often create data that is present …

Continue reading →

Create the Union of two tables in Excel revisited

03/04/2017

In 2013 I published a technique to create the union of two tables in Excel. This post is still very …

Continue reading →

Recreate views after changing datatypes in referenced tables

17/10/2014

I recently came across a problem that was difficult to diagnose. After I had changed the datatype in a table …

Continue reading →

Humour: Excel and big data

29/06/2014

As consultants our job is to help the user and unlike the poor second line support person we usually have …

Continue reading →

How to add a row number to an Excel table

14/03/2013

Excel tables provide a lot of support for data processing and the use of structured references can improve readability. We …

Continue reading →

A T-SQL SPLIT function

13/03/2013

When taking existing data to put into a data warehouse one hopes that it is nicely formatted. This is seldom …

Continue reading →

SQL Server Import Wizard cannot import fields containing more than 255 characters

07/02/2013

I have been importing data from Excel to SQL Server using the SQL Server Import Wizard. Usually there is no …

Continue reading →

How to create a calendar table with hourly grain

04/01/2013

Calendar Tables – Why You Need One. <credit: This section was copied from Made2Mentor> What is a Date (Calendar) Table? …

Continue reading →

Enter your email address to receive email notification of new posts

Recent Posts

  • Oyster costs: commuting into London during COVID
  • When was the last time you checked your account recovery information?
  • AI being useful – fixing styles in Word
  • Will Windows become a Linux emulation layer?
  • Buying a laptop to use with Teams

Archives

  • Application design
    • Frameworks
    • HTML5
    • Requirements Management
    • User Experience
  • applications
  • Artificial Intelligence (AI) and Machine Learning (ML)
  • backup
  • Books I like
  • brexit
  • Business models
    • Lean startup
  • Cloud
    • Amazon Web Services (AWS)
    • Bitnami
  • Crypto-currencies
  • cryptocurrencies
  • Cryptostar.money
  • Economics
  • Education
  • ElephantPM
    • PRINCE2
    • Project Management
  • energy
  • Enterprise Architecture
  • Excel
  • FogBugz and Kiln (Mercurial)
  • formidable forms
  • Francesca
  • Game
  • GTD
  • Hardware
  • Humour
  • Infrastructure
  • iot
  • Keyapt
  • Lean Management
  • Management Consulting
  • Marketing
  • Medical
  • Microsoft Teams
  • Mobile Development
    • Android
    • iPhone
    • Windows Phone 7
  • Net Promoter Score
  • office 365
  • Outlook
  • Personal
  • Personal productivity
  • Petition
  • Politics
  • Science
  • security
  • Sharepoint
  • Software
  • Technologies to build applications
    • JavaScript
    • Microsoft SQL Server
    • Railo and ColdFusion
    • Tomcat
    • Wordpress
  • Uncategorized
  • Ventilators
  • virtualisation
  • web design
  • Windows
  • Windows Desktop
    • Excel
    • Windows 10
    • Windows 8.1

RSS

RSS Feed RSS - Posts

RSS Feed RSS - Comments

My Other Sites

CryptoStar - #1 Crypto Directory with User Reviews
Suport My School - #1 For School Fundraising

(C) 2010 – 2014

Blog at WordPress.com.

Cancel
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy