I’m decidedly old-school in a few of my habits. My morning routine, barring anything out of the ordinary, is one such example. Typically, I’ll get up between 6:30 to 7:00 am, grab my first cup of coffee, and then chat with my daughters for a few minutes before seeing them… Read more
All good things must come to an end and, after logging almost 1400 miles on the road, the #SQLVacation road trip returns to its home city – Nashville, TN, the “Music City”. Eight SQL Server users groups, eight matching blog posts, two hundred t-shirts, and many hundreds of… Read more
Our long #SQLVacation is nearly at an end because our stop in Evansville, IN is our last roadtrip location for the family and the penultimate (i.e., second to last) technical session of the journey. It’s a bittersweet, fersher.
Evansville is such a beautiful place that it was name La Belle… Read more
The Griswolds had an experience they’ll never forget in St. Louis. And we’ve had ours too, but in a very good way. We’d vacationed in St. Louis two years ago and had a great time. We’ve seen the sights, gotten the pictures, and have the t-Shirts. I still love to… Read more
In the movie, National Lampoon’s Vacation, Clark and Ellen Griswold decide to lead their family, including the kids Rusty and Audrey, on a cross-country expedition from the Chicago area to the Los Angeles amusement park Walley World, touted as “America’s Favorite Family Fun Park.” Ellen sensibly wants to fly, but… Read more
Of the hundreds of cities that I’ve visited around the world, Chicago is one of my favorites. The food. The museums. The architecture. The scenery. It’s all good – except for those outrageously cold winters. So I was really excited when my family agreed that they’d enjoy spending their summer… Read more
I’ve been to Chicagoland many times over the years. During the 1990’s, when I worked for Deloitte, I occasionally traveled to the practice office in downtown Chicago or to the tax practice in Deerfield. In the later 1990’s and early 2000’s (a.k.a. “the aughts”), I frequently traveled to the original… Read more
For some people, Indianapolis means one thing, and one thing only – the Indianapolis Motor Speedway (a.k.a “The Brickyard”) and the Indianapolis 500. In my case, it means several times speaking at IndyPASS, the local SQL Server User Group, over the last 10 years. I first spoke at… Read more
Along the banks of the mighty Ohio River, in sight of the shores of Indiana, lies beautiful Louisville, KY. Louisville is a place with a strong connection for me. (No, not because I drink bourbon, although that’s a pretty good reason to like the place, come to… Read more
ICYMI: Parameter Sniffing, Friends with Partition Benefits, and SELECT INTO Parallelism – SQL Server Performance
Great topics for further reading about tuning SQL Server performance:
If you’ve been reading my blog for a while, you know that I travel and speak quite a lot. A frequent question I’m asked at these events is “I want to start blogging, but don’t know where to start. What do you recommend?” This is a such a common… Read more
ICYMI: Partitioning Advice, Purging Data Bloat, and an example of TVF Misbehavior – SQL Server Performance
Here are some oldies, but goodies that I recommend you read:
Most of us know that partitions are one of the best ways to scale very large databases or very large IO workloads. However, there are risks, two of which are explored in… Read more
ICYMI: Query Optimization Phases, Observer Overhead, and Secrets of SP_Updatestats – SQL Server Performance
Do you do a bit of query tuning? Then check out this treasure trove of performance tuning advice!
Great Articles at SQLPerformance.com
There are so many good articles from SQLPerformance.com this ICYMI article that it’s hard to know which are best to highlight in the limited space.
So, I’ll be arbitrary and simply choose a few of my favorite entries as well look back:
Don’t miss these great articles on SQLPerformance.com from the industry’s top experts:
Update 09-Mar-2015: The original PASS links I provided were behind a firewall. Thanks reader MMcDonald, we have a working link on YouTube.
The SQL Sentry forum for SQL Statement Tuning
Have you ever looked at our community site specifically dedicated to helping users tune their SQL queries, http://answers.SQLPerformance.com?
You can easily upload an execution plan directly from our free Plan Explorer tool or from good ol’ SQL Server Management Studio to… Read more
Troubleshooting full-day workshop in Richmond (March) and Configuration full-day workshop in Huntington Beach (April)
Want to learn more about SQL Server? Now’s a good time to get a full day of inexpensive high-quality training on both the east and west coast, in March and April, respectively.
I hope you’ll join me for a full-day troubleshooting and performance tuning workshop on the Friday preceding the… Read more
Have you read any of the great articles on SQLPerformance.com? The deep-dive technical info about SQL Server performance issues authored by the SQL Server industry’s top experts. Here are a few great articles from the early days of the website, January 2013: