When talking about SQL Performance and Optimization, I always like to point to this excellent post by Benjamin Nevarez where he discusses which sources he used to research and write his Query Optimizer book and which research papers he recommend to learn more about query optimization.
A list of favorite blog posts would not be complete without a trip over to SQL Skills and Paul Randal where he asks,”How many times have you walked up to a SQL Server that has a performance problem and wondered where to start looking?” Well the answer he gives us…
Day two of my favorite posts on SQL Server Query Optimization takes us to Simple Talk and a 2009 blog post from Grant Fritchey and Controlling Execution Plans with Hints. To be honest, while you are there I would check out his book on SQL Server Execution Plans.
Sometimes there are really great posts that explain a topic so well, it is worth sharing. For this next week, I am going to post some of my favorites regarding SQL Server Performance Optimization. Here is a post on Parameter Sniffing where Jes Borland talks about the Elephant and the Mouse problem.
Once again this year, I am signed up for the Microsoft Virtual Academy Challenge. Do you have what it takes to be a rockstar. Do you Know IT and can you Prove IT. Join me and sign up for the 29 day challenge and learn a new skill. Challenge begins…
Starting the year off right by travelling down to Nashville to meet up with the #SQLFamily and spread a little information on Batches, Transactions, and Errors. Added an extra 30 minutes to go over Transaction Isolation Levels.
Ready for one more SQL Saturday event of the year. Final stop will be in Providence, Rhode Island. For those attending, here is the powerpoint presentation from my session. Thank you once again for another amazing Saturday.
Microsoft has also made a commitment to enable choice and support the open source community, allowing customers to leverage the platforms of their choice. To support that, today Microsoft announced the “Microsoft Certified Solutions Associate (MCSA) Linux® on Azure” certification which recognizes the importance of open source-based workloads in the Microsoft…
Microsoft announced the release of the MCSA: Windows 10 certification for IT professionals. This credential demonstrates expertise to configure, manage, and maintain a Windows 10 enterprise system. The new certification incorporates the recently released Exam 697: Configuring Windows Devices, which helps Windows 8 administrators upgrade their skills to Windows 10. The complete…
Finally had a week to finish up some of my College courses. Decided to work on my Technical Writing course and Capstone Project. The Technical Writing course was to submit a proposal and outline the planning phases of my Capstone Project. The purpose of the project was to upgrade an Exchange Server…