Posts by Jeremiah Peschka

Coping with Change Control Video

1 Comment
Managing change is part of a DBA’s job. If you aren’t managing database changes effectively, though, disaster can strike. Jeremiah Peschka has worked with good and bad change management practices and even brought some awful ones under control. In this session, he introduces you to tools, tips, and techniques that will help you effectively handle…
Read More

What the Users Want: Ad Hoc Reporting

SQL Server
10 Comments
Eventually we all run into a situation that makes us cringe: the users want to design their own reports. If this were something as simple as giving users a color picker and some visual layout tools, that would be one thing. Most of the time it’s more complex. Business users know their problem domain very…
Read More

Third Normal Form is Snake Oil

13 Comments
Step right up, ladies and gentlemen, and I will sell you the solution to all of your database needs. That’s right, it’s Doctor Codd’s Third Normal Form, guaranteed to cure all ailments of the schemata, pragmata, and performata. Doctor Codd’s Form will make your data performant and compressive. Accept no substitutes or imitators; Doctor Boyce’s…
Read More

DotNetRocks Podcast

2 Comments
What’s a post about the DotNetRocks podcast doing over here? Turns out that I recorded a podcast! You can check it out on September 27th (that’s in just a few days). So what the devil did I talk about? It turns out that there’s some interested in the .NET library for Riak that I’ve been…
Read More

Indexing for Deletes

Indexing, SQL Server
21 Comments
If you’re only indexing to make reads faster, you need to think again. Indexes can make every operation in the database faster, even deletes. The Problem: Deletes are Very Slow I was lazily researching new development techniques one day when I received an email from a client asking why deletes could be slow. I rattled…
Read More

CorrugatedIron v0.1.2 – Now with options!

0
Corrugated Iron, the C# library to working with Riak, isn’t terribly old – OJ and I released the first version two and a half weeks ago. In the mean time, we’ve fixed a few bugs but haven’t pushed out major enhancements. The minor changes that we’ve pushed out, though, have been in direct response to…
Read More

The Stages of Growth

SQL Server
4 Comments
Everyone poops and everyone grows. We all reach that growth stage in our own time, but sooner or later we all encounter it. Once you reach a growth stage you will experience some of these common emotions. I can’t believe it’s not scaling! Denial It’s 8:37AM and your developers just barged into your cubicle yelling, “The…
Read More

Adventures at OSCON

13 Comments
I spent the week of July 25th in the Oregon Convention Center. No, it wasn’t a secret SQL Server event; I was at OSCON. OSCON is the Open Source Convention hosted by O’Reilly (you may know them as the publisher with animals on most of their books). The best part is that I wasn’t just…
Read More

Just One More Thing… Introducing CorrugatedIron

1 Comment
I like to share what I know. That’s why earlier this year, I contributed some code to the Riak function contrib. Since then, I’ve been quietly becoming an independent consultant, starting a business, and working on a big chunk of code. I’m proud to release to the world CorrugatedIron. More NoSQL for .NET If you’ve…
Read More

Upcoming Training

11 Comments
There’s a double dose of free training coming your way on Tuesday, July 19th! Completely Legal Performance Enhancements At 11:30 AM Central I’ll be hitting the intertubes and talking about Completely Legal Performance Enhancements. You’ll want to attend this talk if you know you have a performance problem but don’t know where to start. In…
Read More

Nine Reasons Developers Should Learn SQL

32 Comments
Let’s face it, there are a lot of cool new things you could be learning right now. It seems like there’s a new technology coming out every 12.8 seconds. Why the hell would you want to spend your free time learning a crufty old language like SQL? My reasons, let me show you them. It’s…
Read More

Resolving Conflicts in the Database

Replication
11 Comments
Anyone who has worked with replication has run into problems caused by conflicting data. I’ve lost enough sleep over replication to know that having an effective plan for conflict resolution is important to keeping replication running and healthy. What Causes Conflicts? There are a few ways that conflicts can show up in a database. In…
Read More

Scaling SQL Server: Growing Out

SQL Server
2 Comments
Scaling up is hard, scaling out is even harder. We all know that we can scale reads by adding some kind of replication or read-only copies of databases or using a massive caching layer. What happens when we have to scale writes? Borrowing Brent’s grocery store metaphor, a database that is effectively scaled for reads…
Read More

Which Database Is Right for Me?

Architecture
14 Comments
When you start developing a new application how do you pick the database back end? Most people pick what they know/what’s already installed on their system: the tried and true relational database. Let’s face it: nobody is getting fired for using a relational database. They’re safe, well understood, and there’s probably one running in the…
Read More