Posts by Jeremiah Peschka

Trade Offs: Code Quality

SQL Server
1 Comment
What has two thumbs and is talking about code quality at SQL in the City Seattle? Nearly every day, we’re faced with a decision about quality and time. Do you write quick and dirty code or do you take the time to get it right? Your decision is going to last a lot longer than…
Read More

TL;DR Use A Picture

When you run into problems at work, how do you tell your manager what you did? Typically you would write up the problem, the solution, and a quick summary of the outcome. If you’re like me, this isn’t a lot of fun. And, if your manager is anything like most managers, they don’t want to…
Read More

A Week of Conferences and Travel

SQL Server
0
This week is a double conference extravaganza! That also means that this week is a double travel extravaganza, so you can expect to see a lot of moaning about airports over on twitter. Feel free to heckle me back as I travel across the country from Portland, to San Francisco, to Columbus, and back again.…
Read More

The Trouble with Keys

Architecture
22 Comments
Scaling up is hard: big hardware gets expensive fast. Scaling out is equally difficult; interesting design problems creep in to scale out solutions. One of the more troublesome issues architects face when scaling out is the issue of distributing identity. It’s often advantageous for object identity to be unique and portable across all database instances…
Read More

The Case for Core

SQL Server
18 Comments
SQL Server 2012 was the first version of SQL Server to support being installed on Windows Server Core Edition (Windows without a GUI to the rest of the world). With the impending release of Windows Server 2012 there are a lot of people who are excited about running SQL Server 2012 on Windows Server 2012…
Read More

Potential Problems with Partitioning

Partitioning, SQL Server
Getting started with table partitioning is difficult; there are many decisions to make after you’ve decided to partition data. Correctly configuring partitioning is critical to the long term performance and stability of the database from both a querying and data modification standpoint. There are three key considerations that database architects should devote time to before…
Read More

We’re an Amazon Consulting Partner

SQL Server
9 Comments
I’m really excited to share the news that Brent Ozar Unlimited® is now an Amazon Consulting Partner. The Amazon Consulting Partner program is a way for Amazon Web Services to identify consulting firms specializing in helping customers design, build, and deploy solutions in Amazon Web Services. Cloud computing is some seriously cool stuff and we’re…
Read More

Architecting with AWS – Before You Go

Amazon Web Services (AWS)
0
Architecting with AWS is a three day training session held at the AWS offices in Seattle (classes are available in other locations). Both outsiders and AWS employees come together to learn about building scalable solutions on the AWS platform. This is a practical training program – there’s no certification behind it. The Architecting with AWS…
Read More

A Developer’s Guide to Dangerous Queries (Video)

4 Comments
Want to help us shape our training? Take 30 seconds and answer 5 questions. Are you looking for sample code from the presentation? Download the samples from A Developers Guide to Dangerous Queries. Transact-SQL /************************ * Correlated Subqueries ***********************/ USE ContosoRetailDW; GO SELECT DISTINCT dd.DateDescription , SUM(fs.SalesAmount) AS Sales , SUM(COALESCE(fs.DiscountAmount, 0)) AS Discount FROM…
Read More

SQL Server RDS

Amazon Web Services (AWS) is a platform that offers a ton of services ranging from block storage, operating systems, to mail queues, DNS, and caching. When you say “cloud”, a lot of people think of AWS. AWS hosts a variety of businesses, large and small. Unfortunately, you still have to administer and configure your servers.…
Read More

SQL Server Always On Availability Groups in AWS

Many companies are investigating a move into cloud hosting. With the recent release of SQL Server 2012, these very same companies are also looking at a migration to SQL Server 2012 to take advantage of readable secondaries. Combining Amazon Web Services and SQL Server 2012 seems like a perfect match. Unfortunately, there are some gotchas,…
Read More

Let’s Talk About Joins

0
If you want to learn more about the different join algorithms, consult Wikipedia for an introduction to the basic material and links to additional information: Nested Loop Join Merge Join Hash Join Additional information is also found in the paper Implementation Techniques for Main Memory Databases.
Read More

Understanding Database Choice

Architecture
3 Comments
Everyone needs a distributed database right? Wrong. It’s easy to get so excited about trying out a new technology that you close your eyes to the problem you’re trying to solve. I came across a question on Stack Overflow where the poster was asking what kind of distributed database they needed. Rather than jump right…
Read More
don't be afraid to change everything

Notes on Scalability

15 Comments
We all hope that we’re going to succeed beyond our wildest expectations. Startups long for multi-billion dollar IPOs or scaling to hundreds, or even thousands, of servers. Every hosting provider is touting how their new cloud offering will help us scale up to unheard of heights. I’ve built things up and torn them down a…
Read More

Silent CPU Killers

10 Comments
It’s always important to make sure that SQL Server is running at peak efficiency – nobody wants to waste resources. In the past we’ve concentrated on ways to reduce I/O – either network I/O or disk I/O. The increasing number of cores available in modern CPUs meant that CPU tuning wasn’t as much of a…
Read More