Categories
SQL Server SSIS

Tidying up the SSIS Database

If we’re running SQL Server Integration Services (SSIS) then it’s database is the wonderful place where we store our packages ready for execution and the lovely logs we can interrogate when those packages inevitably break (of course not, our code is perfect, right?) This database is all well and good in a fresh environment however […]

Categories
C#

Scraping Data from the Web with C#

Sometimes you need to get data from somewhere and it to be in a usable format. Maybe it’s a set of locations and opening times for a particular service, a price listing from a supplier, or it could be that you need alerting when some data out in the wild changes. Chances are that when […]

Categories
T-SQL Tuesday

T-SQL Tuesday #128 – Learn From Others

The topic for this month’s T-SQL Tuesday is to tell folks about something which went wrong and what it took to fix it. Whilst I’m sure there are plenty of more experienced folks out there who’ll have some interesting articles to read, I thought I’d take it in a slightly different direction. As much value […]

Categories
Personal

Hello World

My name is Andy Brownsword. I write code and tinker with technology. Day to day I’m a DBA working out of the UK and dabbling with various things which come my way or interest me. For years I’ve heard the developer community advocating blogging and having realised how much I depend on the content shared […]