Month: September 2010

How I Make Coffee and Servers

Last Updated September 15, 2010

I’ve got a disturbing array of coffeemaking gear: My Coffeemakers From left to right: Bialetti Moka – stovetop espresso maker. Great for making powerful hot chocolates in the dead of winter. Burr grinder – the best way to get very consistent grinds. The grinders with spinning blades just randomly slice and dice your beans, but…

How to Use sp_WhoIsActive to Find Slow SQL Server Queries

Last Updated July 28, 2019

Brent Ozar

SQL Server

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…

Register for SQLBits in England – Space Running Out!

Last Updated September 3, 2010

Brent Ozar

If you deal with VMware, Hyper-V, SANs, and SQL Server, come check out my pre-conference session at SQLBits in York, England on Thursday, September 30th. My all-day session is called, “Virtualization, SAN, and SQL Server: The Perfect Storm.” This will be a fun, intimate session – it’s limited to 40 people max, and we’ve got…

How to Buy Your First Mac

Last Updated February 13, 2017

Brent Ozar

Hardware

So you’re tired of craptastic plastic, and you’re noticing more and more Windows people toting around shiny metal computers? Here’s what you need to know. Update October 2013 – updated to include the current Apple laptop lineup. Running Windows On Your Mac If you’re reading this, you probably make a living working with Windows software,…