Year: 2010

Free-Con 2010 at the Hugo House

My Latest Experiment: #SQLPASS Free-Con

#SQLPass
18 Comments
At big conferences like the Professional Association for SQL Server Summit in Seattle, attendees can pay extra to attend a pre-conference or post-conference session.  Select speakers talk all day on just one topic, so the attendees get really deep coverage on it.  Competition among speakers is tough for these slots because there’s money involved –…
Read More

Conferences and WiFi Security

8 Comments
Just a few quick notes about security before anyone shows up at the PASS Summit. First, set up lock codes on your phones, iPads, and laptops.  Those of us who are security-conscious tend to play pranks on those of us who aren’t.  (Ask Tom LaRock about the year he found a shirtless fireman on his…
Read More
Geekbench Results After CPU Tweaks

Proof that CPU Power Matters

0
At least one person was paying attention when I recently blogged about the problems running SQL Server on power-saving processors.  One of my clients, the Northwestern Medical Data Warehouse, decided to check out the settings on their brand-new IBM x3850.  Sure enough, they were set to save power by default, so they tweaked that and…
Read More
Before Coffee

SQL Server on Power-Saving CPUs? Not So Fast.

42 Comments
StackOverflow went through a few infrastructure upgrades this week.  Jeff Atwood blogged about the changes, and Kyle Brandt goes into more detail. Here’s a short recap of some of the SQL Server changes: Changed physical server models (from IBM/Lenovo to Dells) Went from two quad-core Xeons to two six-core Xeons Enabled hyperthreading (so it looked…
Read More

My PASS Lightning Talk Preview Video

#SQLPass
10 Comments
At this year’s PASS Summit, we’re adding a series of sessions called Lightning Talks.  In a normal one-hour time slot, you can sit and watch several presenters give rapid-fire, 5-minute micro-sessions on various topics. My Lightning Talk is “Storage Area Networks Simplified” – I’m covering the two most important things you need to know about…
Read More

Watch the PASS Summit Keynote Live Online

#SQLPass
2 Comments
For the first time this year, the Professional Association for SQL Server will be broadcasting the PASS Summit keynote live on the web! Each day of the Summit, Microsoft staff will open up the day with their keynote speeches: Tuesday – Ted Kummert will be talking about Microsoft’s commitment to mission critical applications and easier…
Read More

I’m Sending My Clients To Your Blog

4 Comments
When I deliver my performance tuning recommendations to my clients, I want them to be able to go back to my findings again and again over time, learning more each time they read.  One of my favorite tools to help their journey is a list of recommended reading material. I rarely give out links to…
Read More
Crossing the Chicago Mac Sailboat Race off my bucket list

My Bucket List

16 Comments
Bob Pusateri (Blog – @SQLBob) just posted his Bucket List – the list of things he wants to do before he kicks the bucket.  Aaron Bertrand followed up with his. If you haven’t seen the movie The Bucket List starring Morgan Freeman and Jack Nicholson, I’d highly recommend it.  Immediately after seeing that movie, I…
Read More
Standard Deviation

Telling Clients They’re Unusual

Professional Development
9 Comments
Consultants need to get around. One of the key differences between consultants and contractors is that contractors tend to stay at the same company for weeks or months, while consultants jump around very quickly from project to project.  Most of my engagements are just 3-4 days long: I parachute in, put out the burning fires,…
Read More
File Upload Example

Sharing Big Files Easily with Amazon S3

13 Comments
Email servers restrict how big your file attachments can be.  I frequently ask my clients to send me trace files and diagnostic logs that are hundreds of megabytes (even compressed), and doing this over email just doesn’t work.  In the old days, we set up FTP servers to move files around, but FTP uploads aren’t…
Read More
Do you know me? That's why I carry this.

The Microsoft MVP Program

6 Comments
I just got my MVP prize package in the mail.  The package is artificially big – it’s 95% cardboard, 5% content – but that’s because the really good stuff doesn’t come in boxes. Do you know me? That's why I carry this. MVP awardees get a lot of free software licensing from not just Microsoft,…
Read More
My Coffeemakers

How I Make Coffee and Servers

16 Comments
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…
Read More

How to Use sp_WhoIsActive to Find Slow SQL Server Queries

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…
Read More

Register for SQLBits in England – Space Running Out!

6 Comments
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…
Read More
The stickers are optional.

How to Buy Your First Mac

Hardware
53 Comments
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,…
Read More
Phoenix and Question Mark

Underemployed Developers: Meet Project Phoenix

3 Comments
A few months back, Microsoft gave MVPs a few MSDN Ultimate subscriptions to pass on to community members, no strings attached.  I quietly gave mine to a few deserving folks who I thought could be future MVPs, but Arnie Rowland (Blog – @ArnieRowland) had a better idea. Arnie’s Project Phoenix encourages developers to propose a…
Read More