This category is for Blog articles that are focused on SQL Server.
This is a simple Missing Index Script with no Advertisements to bog you down. A few words of guidance: Don’t blindly add indexes. For example, DO NOT add all the indexes this script returns. Be methodical in determining what indexes would have impact and test them one at a time. Keep track of what indexes …
SQL Server Contained Availability Groups are a new, shiny feature that has great use cases and potential. With that said, you may want to hold off on using them if you haven’t taken the time to understand the impact and limitations. By next version of SQL Server, I see this getting closer to being the …
Another SQL Product End of Support?? We have reached the end of another SQL Server product life cycle from a support standpoint. I remember when SQL Server 2012 came out. It was a very exciting release since we had waited over four years for this release to arrive. Not only that, but we were also …
