Accessing SQL Server in AWS Lambda – Part 1

Accessing SQL Server in AWS Lambda – Part 1

AWS Lambda is great, but I had many difficulties finding a way to connect into my RDS SQL Server instance. I started with Python and ODBC (both pyodbc and pypyodbc), but ran into so many issues with missing libraries (LD_LIBRARY_PATH of death). I turned to Java, but I think SQL Server and Java are a bit like oil and water, […]

C# AWS CORS Upload full example

C# AWS CORS Upload full example

AWS CORS allows your users to upload files directly to an AWS bucket securely. There are many benefits to storing files on S3 rather than on your local web server storage, such as life-cycle management, cost and allowing horizontal scaling. If you already upload users files to S3 then CORS removes the need for your website server to be the […]

AWS Sydney Summit

The CTO of Amazon Web Services delivered the keynote speech of the AWS Sydney Summit. I personally thought it was mostly a glorified sales pitch but the parts where representatives from other companies that have migrated to the cloud, like NAB bank, were quite interesting. NAB picked their public facing website, refined their dev-ops process, extensive performance and resilience testing […]

AWS S3 Command Line Bucket File Upload in C#

I generate full-size backups of my database every night, but they just collect dust on my production server taking up space. Not only that, but if I lost the server, the backups would be gone to, so I wanted to investigate some options. I have recently moved my servers and database to Amazon Web Services and really enjoying the value […]

Coding Challenge

I have been thinking about an optimal solution for a real-world problem but just haven’t had any time to have a crack at it. A friend at work suggested I should put it up as a challenge and see who is the ultimate programmer. The Problem A manager has allocated Shifts to their Staff for a given week. Can you […]