Bob Walker (Page 3)

Bob Walker

Six Ways to Fail At Local Database Development

A while ago I was assigned to a project to move all of all the business logic from Oracle packages into C# code. Before I could even start moving the code I had to create a suite of tests covering those business rules in the database. The Oracle packages read

How to bring down a Production SQL Server with one line of code

Small releases shouldn't cause major outages. It certainly shouldn't take down a production database server. In the end it was one line of code. That exposed several flaws and brought down the database server. Wednesday night my team and I deployed a release to production. The

Database and Continuous Delivery

Nobody likes getting called at 2 AM. But it happens. More often than not, the reason for that page will have something to do with the database. A SQL job failed, a stored procedure didn’t get deployed, a missing index on a table. That problem doesn’t seem to

Adaption

The project I worked on at West Corporation was moving all the call logging off of the mainframe onto SQL Server. If you don't know, West Corporation is a telemarketing firm, so call logging in kind of a big deal. Like any major project, there was some natural