Here I am speaking in Dubia. It was a good visit! =^) … [Read more...]

http://kevinekline.com/15088-2/

Mt. Juliet Winter Guard – WGI World Championships – Scholastic A Finals …

The girls went to the World Guard International championships and they got into finals!They ranked 19th in the world when it was all said and done. A flawless performance for many months of hard work and constant practice. I'm so proud of them! … [Read more...]

Predicate Logic, Four Things I Wish I’d Known Sooner, Transact-SQL Bad Habits, Rewriting Queries to Improve Performance

Some of my favorite articles originally appearing at SQLPerformance.com. Why Not Seek Predicate Paul White ( b | t ) proves, once again, why he is the best in the business when it comes to debugging a SQL Server query. In this post, Paul gives you a step-by-step breakdown of a query that goes astray due to implied predicate logic. Got a tough query of your own? Post it atanswers.sqlperformance.com! Four Things I Wish I Knew Sooner as a SQL Server DBA Lori Edwards ( b | t ) tells four things she wished she knew before she started her many year career as a SQL Server database … [Read more...]

Adding Filtered Indexes, Wait Statistics, Comparing Windows Azure Performance

Some of my favorite articles originally appearing at SQLPerformance.com. Dirty Secrets of the CASE Expression Aaron Bertrand ( b | t ) of SQL Sentry takes a look at some unexpected behavior with the CASE expression and some of its derivatives. Did you know that Aaron is both an uber-genius and a curling fanatic? Improbable, I know. An Unexpected Side-Effect of Adding a Filtered Index Paul White’s ( b | t ) deep dive post explains some of the limitations in the special use and usefully special kind of index, the filtered index. When applied in the appropriate scenarios, filtered … [Read more...]

ICYMI – Avoiding Performance Tuning, Wait Statistics, Incremental Statistics

Some of my favorite articles originally appearing at SQLPerformance.com. Avoiding Knee-Jerk Performance Tuning Paul Randal of SQLskills.com starts a new series on knee-jerk troubleshooting, discussing many areas where SQL Server folks jump to conclusions when trying to fix a performance issue. Knee-Jerk Wait Statistics: SOS_SCHEDULER_YIELD Paul Randal continues his series on knee-jerk performance troubleshooting. In this post, he talks about SOS_SCHEDULER_YIELD, and how to determine whether it is a wait to worry about in your scenario. SQL Server 2014 Incremental … [Read more...]

#SQLVacation Follow-up Resources and Contest Details

I've gotten lots of requests for the slide decks, scripts, and the #SQLVacation contest running through July 31st. Plus, other things to follow-up on. In order to make life easier for me, I've put all of the answers in one place on my SQL Sentry blog page. Click the link to get all of the goodies. If enough people participate, I might be able to persuade my boss to let me do this next year. So c'mon and help a brother out!   #SQLVacation, The Experience First came the in-person #SQLVacation roadtrip.   That Kline family won't be nearly as good at this as us Griswolds! Two … [Read more...]

Recommended Intel Processors For SQL ’14, Should Indexes Be In The Key Or Included, Comparing Windows Azure VM Performance

 Some of my favorite articles originally appearing at SQLPerformance.com.   Grouped Concatenation in SQL Server and Grouped Concatenation: Ordering and Removing Duplicates In these two related blog posts, Aaron Bertrand ( b | t ) of SQL Sentry takes on the safest and most efficient ways to perform grouped concatenation in SQL Server. Then he follows up with a closer look at some additional requirements for typical grouped concatenation queries in SQL Server. Recommended Intel Processors for SQL Server 2014 Workloads Glenn Berry ( b | t ) of SQLskills continues his … [Read more...]

SQLVacation Postcard Day 8: Nashville, TN

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 attendees later, it's time to get back home. Only there's one last catch for this Clark Griswold of an everyman. I have one last session to deliver, Top 10 Things Every SQL Developer Needs to Know, here at the Nashville chapter of the Professional Association for SQL Server. Our regular monthly meetings occur on the last … [Read more...]

SQLVacation Postcard Day 7: Evansville, IN

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, but a joy to have the family with me while I work these long days and late nights. Evansville is such a beautiful place that it was name La Belle Riviere ("The Beautiful River") by the early French trappers who were the first Europeans to explore the river valley. Today, the city is the commercial and cultural hub of the "entire tri-state area!". (I can't help but say that in … [Read more...]

SQLVacation Postcard Day 6: St. Louis, MO

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 see the big, iconic Gateway Arch though. In fact, I'm pretty much old news in St. Louis having spoken at their SQL Server user group several times over the years. They've set a grueling pace for me at this meeting, asking for 3 out of my 4 roadtrip presentations along with a vendor presentation to talk about SQL Sentry's tools. … [Read more...]