Recently there was a question of why a query runs under a second on one environment and another environment runs the same query for 90 seconds and times out the application. It was observed the memory on the second system was running at 94% and so it was put down to that and ‘get more […]
Author: Andy B.
Data Engineer and Nerd
Categories
Cleaning Up with PowerShell
Data has a tendency to grow and every now and again needs some pruning. Flat files can be a big offender, particularly if you’re looking at transactional data or a backup repository for example. If you’re looking to script this process for cleaning up then PowerShell may be a great choice. It’s freely available, quick […]
Categories
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
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 […]
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
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 […]
Andy Brownsword 