I’ve stated before that great database performance starts with great database design. So, if you want a great database design you must find someone with great database experience. But where does a person get such experience? We already know that great judgment comes from great experience, and great experience comes from bad judgment. That means … Read more
Did you know table and index statistics are the most important piece of metadata for your database? The reason for this has to do with how SQL Server (and other database engines) build query execution plans. The query optimizer builds an execution plan based upon the statistical data available at the time. If you have … Read more
Last week I was visiting the SolarWinds home office in Austin and hanging with my fellow Head Geeks. Our conversations often cover a wide range of topics and at times even turn into teaching lessons for each other. I get to learn about networks, storage, virtualization, monitoring, etc. and I get to teach my fellow Head … Read more
I had a question come up last week from someone that wanted to know a few basic facts about their SQL Server backups for audit purposes. The facts they wanted were straightforward: Who took the backup? When was it taken? Where was it written? Simple questions that are answered with a simple script. As usual, here’s … Read more
I wrote a post recently about troubleshooting connectivity for endpoints on Microsoft Azure VMs. The day the post went out I was greeted with this tweet: http://t.co/Ww3MyYjwPu right on time context post for me @SQLRockstar tx sir. Need to see on ports for my #linux vms with #mysql running 🙂 — Shyam Viking (@myluvsql) April 30, … Read more
Last week was the inaugural Microsoft Ignite conference, or as I like to call it: Microsoft TechEd R2. It took place in Chicago and I was fortunate enough to have my company (SolarWinds) send me to work our booth on the exhibit hall floor. I won’t bother you with a review on what Microsoft needs … Read more
