A gigantic script that gives you a lot information to view and review current databases and SQL Server settings, options and configurations. I see it becoming very favorite of many operational DBA folks. I’d recommend it run it at least once in a month or anytime you want to have very detailed information for any … Continue reading Perform Professional, Comprehensive SQL HealthChecks
Way to go, “Compare ShowPlan” SSMS 2017
Often we wonder and feel a need to compare two execution plans, usually we do it by opening these plans in two separate management studio or tabs on two screens (thanks to my company I always has two monitors). With SSMS 2017 release, a new feature “Compare Plan” will allow developers/tuners to compare execution plans … Continue reading Way to go, “Compare ShowPlan” SSMS 2017
Something anything
Up until now, I had never written a blog and never, if I’m honest, had the desire to put myself out. For me, blogs were time consuming hobby which being a database guy I could never afford due to late night works and always disturbed weekend routines, I although, always felt that I had always … Continue reading Something anything