Category Archives: Development

Cache Money

That's how I makes it rain

That’s how I makes it rain

I was reading the Voice of the DBA and it referred to a post by Brent Ozar about caching at the database level.  After discussing it with my homey, he thought it sounded a lot like memoization (I like to say it with a 3 stooges voice, mem moy Zay Shun).  According to wiki, Memoization is a specific case of optimization, which seems to be what we are doing when we cache the results of a stored procedure.

Continue reading

Workload Simulation With SQL Data Generator

Patients of Dr.Psycho are glad he performs simulated operations

Patients of Dr.Psycho are glad he performs simulated operations

Introduction

In college one of my mentors was a jedi  master of simulations and testing.  The guy could write a simulation for just about anything you can think of, and with anything you can think of.  I’m pretty sure that he once made a neural network for simulating dinosaur procreation rates…using sticks and mud (true story).  Simulating workloads can help you thoroughly test ideas and present data to management that will allow them to make informed decisions.  IRL, your career will be much happier if you can test your ideas BEFORE deploying them to production.  No one is asking you to have good ideas all the time, but the business is depending on you to come up with ideas that will work as intended.  The only way to accomplish this responsibly, is to test.

Continue reading

Virtualize Everything

_

I began dabbling in virtualization somewhere around 2007.  I used VMware sever for creating some virtual labs but nothing too serious.  At that time it was a cool technology and I was happy to have a small group of linux servers running on one single physical server.

Later in 2008 I got a taste of virtualizing windows servers in a production environment using VMware and vSphere.  This was where I fell in love with the technology.  The speed at which I could provision servers was amazing, and having that well designed console that is vSphere…just beautiful, it truly made me feel like a superhero, but it wasn’t until late 2012 that I finally got to try my hand at constructing a fully virtualized infrastructure.

Continue reading