SQL Server Archives - Page 39 of 41 - Brent Ozar Unlimited®

The Stages of Growth

August 9, 2011

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.

Denial
It's 8:37AM and your developers just barged into your cubicle yelling, "The database can't handle the load!" What's your first reaction? If you're like me, you probably threw a stapler at them. If you're a bit more level-headed, you most likely said something like, "That's unpossible!"

T-SQL & Development

Windowing Function Examples for SQL Server

July 14, 2011

Aggregations and grouping can be a pain in the rear for the novice SQL developer. Way back in 2003, the ANSI/ISO standards people figured this out and added windows and ranking functions to the standard. In 2005, Microsoft added a few of these functions (ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE()) as well as the OVER() clause…

SQL Server 2012 CTP3 is Here! Five Things to Know About the Next Version of SQL Server

July 12, 2011

SQL Server Denali CTP3 is here, and today I'm excited to be able to talk about this new public preview of the next version of SQL Server. CTP1 came out back in November 2010, and CTP2 wasn't released to the public, so this is your first chance in several months to see progress. Here's what you want to know:

Scaling SQL Server: Growing Out

June 8, 2011

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…

Performance Tuning

SQL Server Locking and You!

June 1, 2011

Did you know that SQL Server's locking has a name? It's called two-phase locking. If we're really getting specific about it, SQL Server uses what's called strong strict two-phase locking or SS2PL. We'll get there in a few minutes, right now we're going to take a look at what makes up two-phase locking.

But First, Some History

Production DBA

DBA Nightmare: SQL Server Down, No Plans

May 3, 2011

Managing data is about managing risk, but no matter how we good we are at managing risks, they're still risks.

We've seen several high-profile data failures recently:

Announcing Our New Weekly Community Recap Email

May 2, 2011

You're overworked. You don't have the time to sit around reading blogs, keeping up on the latest industry news, and reading web comics.

That's where we come in. To stay on top of our game, we have to spend a couple days per week honing our skills. We've started a weekly email recapping the best stuff we've found in the community this week.

Five Favorite Free SQL Server Downloads

February 21, 2011

So you're lazy and you're company's broke - what to do? Here's my favorite free downloads to help manage SQL Server: Understand execution plans with SQL Sentry Plan Explorer - I dunno about you, but viewing execution plans in SQL Server Management Studio is a pain in my rear. The scrolling sucks, the cost numbers…

Scaling up or scaling out?

February 16, 2011

When you need SQL Server to handle more load, there's two big-picture ways to do it:

Scale up - use a more powerful SQL Server
Scale out - use more SQL Servers

Microsoft Atlanta: Cloud-Based SQL Server Monitoring

November 9, 2010

Microsoft Atlanta is a new cloud-based SQL Server monitoring tool. Companies can deploy an agent on their SQL Server 2008 and 2008 R2 instances, and the agent will communicate up to Microsoft's servers in the cloud (through a secure gateway also installed inside the company's network.) Microsoft aggregates the data, analyzes it looking for problems, and displays it back to IT users like database administrators through a web-based dashboard.

How to Use sp_WhoIsActive to Find Slow SQL Server Queries

September 9, 2010

SQL Server database administrators need to be able to quickly find out what queries and stored procedures are running slow. Microsoft includes sp_who and sp_who2 in SQL Server 2005 and 2008, but there's a much better tool, and it's completely free.

In this five minute tutorial video, I explain how to use sp_WhoIsActive from Adam Machanic (Blog - @AdamMachanic):

The Top 10 Developer Mistakes That Won’t Scale

June 15, 2010

Microsoft records TechEd sessions, and you can watch the recording of mine. Here's the abstract:

You’ve heard it before: “It worked fine on my machine, but the users say it’s too slow.” Don’t blame the developers: they’re using SQL Server features that look great on paper, but in reality, they won’t scale up to production loads. Learn to recognize these common mistakes before they go into production and be armed with alternatives.

SQL Server 2008 R2 Release Date: April 21 2010

April 15, 2010

The SQL Server 2008 R2 release date was April 21, 2010. You can download SQL Server free as an evaluation version.

I've written a lot about the new features:

2 Features of SQL Server You Should Avoid

March 3, 2010

Crystal meth helps you lose weight and feel better about yourself. It's true. Wikipedia says so. Sure, the side effects of methamphetamine are more than just anorexia and euphoria, but if you're looking to be an upbeat, skinny person, meth gets the job done. SQL Server has a couple of similar features that might make…

Book Week: The Economics of Writing a Book

January 18, 2010

This week I'm focusing on books and the book business. Today I'll be covering the money thing for authors, and tomorrow I'll be reviewing a book I like for both the content and the business. Enjoy!

Now that I'm holding a physical copy of our book in my hand, the pain of the experience has started to fade, and I can write about it with an open mind.

You may ask yourself, How did I get here?

January 17, 2010

Paul Randal (Blog - @PaulRandal) tagged me in a post about the three events that brought him here. I had to think about this one for a while, and I even talked it over with Erika. Discovering BBSes Long before the public got access to the Internet, I was logging onto Bulletin Board Systems (BBSes)…

How to Use the #SQLHelp Hash Tag on Twitter or Slack

December 18, 2009

You've got questions, we've got answers.

No, not Radio Shack - Twitter and the SQLcommunity Slack. Right now, no matter when you're reading this, there are people on Twitter who can answer quick questions for you. Thanks to an excellent idea by Aaron Nelson (@SQLVariant), it's even easier now. In this post, I'll show how to ask questions and how to answer them.
How to Ask #SQLHelp Questions in Slack

Christian Bolton on SQL Server memory

November 20, 2009

At #SQLBits, I was quite excited to attend this session because of the presenter. Christian Bolton of COEO (Twitter) was the head author on our upcoming book SQL Server 2008 Internals and Troubleshooting, and he's one of the only 8 Microsoft Certified Masters on SQL Server that work outside of Microsoft. Physical vs Virtual Memory…

SQL Server 2008 R2: Into the Clouds

August 12, 2009

R2's new Data-Tier Application (DAC) capabilities give the DBA to manage databases as if they were more like virtual servers. Today I'm going to talk about what that means short-term and long-term.
Short-Term: Nothing To See Here, Move Along
I don't think most DBAs will see a .dacpack file in the wild for years:

Category: SQL Server