Diversity, Women In Tech

Ada Lovelace Blog: In memory of those who didn’t make it

The Ada Lovelace day is designed to celebrate women’s achievements in science and technology. Amidst all of the celebrations, there should also be pause for those women who didn’t achieve their potential. One woman whom I hugely admire is Sophie Scholl, a 21 year old Biology student, who was murdered by Nazis in February 1943.… Continue reading Ada Lovelace Blog: In memory of those who didn’t make it

Business Intelligence, SQLServerPedia Syndication

Adventures in SQL: SP_MSFOREACHTABLE to find the largest table

When exploring a SQL Server database for the first time, it’s always useful to identify the most populated tables first because they are very likely to be the most important tables. To do this in a situation where there are tight time-scales, it’s possible to use some undocumented SQL Server procedures to quickly produce a… Continue reading Adventures in SQL: SP_MSFOREACHTABLE to find the largest table

Business Intelligence, SQLServerPedia Syndication

Adventures in SQL: Using ASCII to remove carriage returns in user input

A current piece of work involves migrating data from a source system, where there is a lot of user input, into a target system.  The data migration process can always be tricky when user-generated input is involved, since the process involves formalising and sanitising this fluid, informal user input into a formal structure. The informal… Continue reading Adventures in SQL: Using ASCII to remove carriage returns in user input