Tag: SQL302

So I’ve been building an auditing system for my new employer that will help track all the changes to the data.  Right now, some changes could be made, and we wouldn’t be able to tell who made the change, or when the change was made.  I had an “Ah-ha” moment pretty early on. “Let’s use…

One of the things I love most about my current position is the fundamental shift in the types of optimization I’m doing.  Early on in my career I was concentrating on queries that would run once an hour, and cover thousands, sometimes tens of thousands of records per hour.  I think that’s a great place…

I’ve been at my new job for two weeks.  In that time I’ve diagrammed all the databases as they are today.  I’ve suggested recommendations on adding keys to some tables that had none.  I’ve also started diagramming the object data that’s being collected in the system, I’m hoping to find duplication within the system and…