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:
If you’re an IT manager, the first thing I’d like to tell you is how invested Microsoft is in SQL Server. While earlier incarnations of executive leadership focused in other areas (anyone remember “Developers! Developers! Developers!”?), Microsoft’s new leadership is very bullish on SQL Server. And, why not? After… Read more
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… Read more
I’ve got a question for you. Where did you learn how to listen?
Of all the coaching and consulting clients I have asked that question to, not one has had formal training to become a better listener.
Some have pointed to the works of Stephen Covey and others like him… Read more
Here’s a real-world story: Data collection and analysis is, ironically, for a data management profession, one of the toughest parts of my job. I regularly pull data from our various databases and packaged application reporting systems for CRM, licensing, and user information.
If you’ve ever worked with a packaged product,… Read more
A new abbreviation is beginning to take hold. I first heard of it on Seth Godin’s blog. The abbreviation? tl; dr.
Too long; didn’t read.
I like the new abbreviation. It gives voice to something that has been going on for many years. The elephant in the room now… Read more
Central USA IT Pro Community News – Jan 2015
There are lots of free, in-person and virtual events happening in the central USA over the next few weeks. Don’t miss out on training, ebooks, and other goodies!
- Jan 10
As the manager for enterprise architecture in a very large IT organization, the C-suite executives frequently posed the question, “What database platform is best for this application today and for the future?” Implicit in that question was the idea that some platforms, for the application and for the database, might… Read more
I’m reminded of a demonstration I saw as a kid. San Diego Chargers quarterback, Dan Fouts, had earned a reputation as a prolific passer, breaking record after record.
Once during a practice, Fouts donned a blindfold, took the snap from center, dropped back, and fired a perfect strike into… Read more
A while back, I told you about some of the coolest new features in the recent RTM for SQL Server. The RTM was announced during the “Accelerate your insights” webcast by a boatload of Microsoft’s top executives, including CEO Satya Nadella, COO Kevin Turner, and CVP Quentin Clark. They… Read more
Have you ever been really focused on solving a problem? So focused that you tuned out the rest of the world around you? A monkey clanging cymbals in the cube next to yours wouldn’t bother you, you are so focused. Some IT professionals call this “in the zone.”
Now,… Read more
It’s time to follow up with a discussion of Microsoft’s cloud-centric approach to big data using HDInsight.
MICROSOFT SQL SERVER AND BIG DATA IN THE CLOUD
HDInsight is a 100% Apache Hadoop service, currently at v2.2, available through Microsoft’s Windows Azure cloud offerings. HDInsight makes all of the standard… Read more
A common refrain we hear when presenting at technical conferences and training events is “How can I get promoted into IT management?” We hear this so often that we’ve worked out a sort of mental flowchart for the subsequent dialog. (We are IT people after all). And our exploratory… Read more