Posts by Jeremiah Peschka

Who Needs an Operating System?

Cloud Computing
3 Comments
In the 1950s, the global economy saw a tremendous change – container ships revolutionized global commerce. Shipping costs got 36 times cheaper with the introduction of containerization. What if you could reduce operational costs and revolutionize application and database deployment in the same way? Containers to the Future In the last few months, the developer world…
Read More

The Network and the Update

SQL Server
17 Comments
We work with SQL Server every day, happily sending and receiving millions of packets of data across the network. Have you stopped to think about what happens when something goes wrong? The Situation It’s a regular Tuesday afternoon. Users are happily submitting orders into the shopping cart. After browsing around the website for a while,…
Read More

IOPS Are A Scam

SQL Server
48 Comments
Storage vendors brag about the IOPS that their hardware can provide. Cloud providers have offered guaranteed IOPS for a while now. It seems that no matter where we turn, we can’t get away from IOPS. What Are You Measuring? When someone says IOPS, what are they referring to? IOPS is an acronym for Input/Output Operations…
Read More

Success in the Cloud

Cloud Computing
5 Comments
Right now, someone in your company is thinking about moving your operations up into the cloud. If your company is like 95% of companies out there, “the cloud” is really a synonym for Amazon Web Services (AWS). Thinking about a move to AWS is happening across many companies, and it’s not something that you need…
Read More

Many Masters, One Truth

As businesses grow, many teams start considering scale out database solutions but they’re cautious – they want to know how to keep data up to date in multiple places. In theory, you can use log shipping, mirroring, or AlwaysOn Availability groups. While this answers the literal question, what people really mean is usually very different.…
Read More

CorrugatedIron 1.4

We’re happy to announce that we’ve released CorrugatedIron 1.4.0. This release contains a large number of bug fixes, new features, and enhancements. That’s right, brand new Riak and .NET straight to you! Get it while it’s hot or keep reading for more details. Riak 1.4 Support CorrugatedIron 1.4.0 brings Riak 1.4.0 feature support including: Index…
Read More

Mix and Match Databases: Dealing with Data Types

SQL Server
3 Comments
Moving between databases is hard enough, try using multiple databases in the same application and you might start thinking you’ve gone insane. Different application demands for accessibility, redundancy, backwards compatibility, or interoperability make this a possibility in the modern data center. One of the biggest challenges of running a heterogeneous database environment is dealing with…
Read More

Database Quick Fire Challenge

SQL Server
0
Celebrity cooking shows are popular around Brent Ozar Unlimited®. We watch Top Chef for the creative cooking as much as the human drama. Contestants on Top Chef face huge challenges – they’re working alone, have a limited set of tools, have a fixed set of ingredients, and operate under ridiculously strict time guidelines. What makes…
Read More

Monitoring SSD Performance

SQL Server, Storage
2 Comments
Everyone wants to make sure they’re getting the best performance out of their solid state storage. If you’re like a lot of people, you want to make sure you’re getting what you paid for, but how do you know for sure that the drive is performing well? Watch that Average The first way to monitor…
Read More

The Basics of Database Sharding

SQL Server
5 Comments
There are many ways to scale out your database; many of these techniques require advanced management and expensive add-ons or editions. Database sharding is a flexible way of scaling out a database. In this presentation, Jeremiah Peschka explains how to scale out using database sharding, covers basic techniques, and shares some of the pitfalls. This…
Read More

How Much Cache Do You Have?

SQL Server
1 Comment
Without looking in your wallet, do you know how much cash you have? Most of us know within a few dollars. Now, without looking in your SQL Server, do you know much data is cached in memory? You probably don’t and that’s okay; you shouldn’t know how much data SQL Server is caching in memory.…
Read More

Saving Session State (video)

Architecture
8 Comments
Session state frequently ends up on a busy SQL Server. What seemed like a good idea in development turns into a problem in production. While there are valid business reasons for persisting session state to permanent storage; there are equally valid reasons to avoid using SQL Server as the permanent storage. We’ll investigate why session…
Read More

Rolling Averages in SQL Server

Aggregate functions are convenient – they solve a business need and they make development easy. Unfortunately, not all business requirements are so easy to solve. Let’s look at one example: rolling averages. The Rolling Average A rolling average is a simple concept; an average is computed over a fixed subset of data. Rolling average calculations…
Read More

Hive Data Warehouse: Lessons Learned (video)

SQL Server
3 Comments
Your company is considering a data warehouse and you’re unsure where to start; with so many tools on the market, it can be difficult to pick a solution. Jeremiah Peschka has designed and deployed several data warehouses using Hive to scale flexibly with data volume and query complexity. Learn what Jeremiah has found in real-life…
Read More

When a Query Isn’t Quite a Query

SQL Server
2 Comments
Databases exist to store data and answer questions about that data. The way we ask questions has to change based on the database itself – SQL changes between different RDBMS vendors. Things get even stranger when you venture outside the RDBMS world and start storing your data in Hive. Even though Hive Query Language (HiveQL)…
Read More
Menu