Month: June 2010

Want a better job?

Last Updated June 18, 2010

About two years ago, I made the leap from working as a production DBA to working as a SQL Server expert for Quest Software. When I tell someone what I do for a living, they usually have the same reaction: “Wow, you’ve got a really cool job.” It has its ups and downs, but it…

Another Free Day-Long Training Event

Last Updated June 16, 2010

Brent Ozar

Remember the last day-long virtual training event I did with Kevin Kline (Blog – @KEKline)? The one where I dressed up like Dr. Horrible and played doctor with your DMVs? We’re doing another one! This time it’s Wednesday, July 21st, and we’re adding another great presenter – Buck Woody (Blog – @BuckWoody)! He’s Microsoft’s real…

The Top 10 Developer Mistakes That Won’t Scale

Last Updated January 5, 2019

Brent Ozar

SQL Server

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…

How I Travel

Last Updated June 14, 2010

Brent Ozar

Buck Woody (Blog – @BuckWoody) tagged me in a blog post called How I Travel where he talks about how he packs, how he works on the road, and his journey logistics. Paul Randal responded with the Paul and Kimberly Travel Guide, and those two are definitely hard-core travelers. I think I’m probably the most…

Sargability: Why %string% Is Slow

Last Updated December 29, 2017

Brent Ozar

T-SQL

People love to search. Google has us addicted to fast, easy search functions. Users expect every application to have a built-in blazing-fast search functionality. To pull that off, developers build search queries that let users enter a string, and we ask SQL Server to find matches. For example, say our users need to find some…

SQL Server 2008 R2 Standard Supports Less Memory

Last Updated February 9, 2017

Brent Ozar

Licensing

Pop quiz: how much memory does SQL Server 2008 R2 Standard Edition support? If you’re like me, you’d head to Microsoft’s site and check the SQL Server edition comparison: SQL Server Edition Comparison Looks pretty straightforward, right? Wrong. As it turns out, the marketing material is incorrect – both Books Online and TechNet show that…

Get SQL Server and Oracle Help on Twitter

Last Updated February 13, 2017

Brent Ozar

Oracle

When you’ve got database questions, you can get fast, free, friendly help. Here’s how to do it: Join Twitter. It’s completely free, and you don’t have to post boring stuff. Just use it for questions. Post your question in a tweet with the word #SQLHelp or #OracleHelp. People in the community have searches set up…