“Switch” Huge Non Partitioned Tables in Seconds

ALTER TABLE [onetable] SWITCH TO [anothertable] There are many challenges with gigantic tables and modifying their schema is one of those that could make many operational DBAs cry. I had to go through a schema change where I have to make data type and identity changes to one of the largest transactional table in the … Continue reading “Switch” Huge Non Partitioned Tables in Seconds

Perform Professional, Comprehensive SQL HealthChecks

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

All about Mongo Backups & Restore

Data is the center of an enterprise and application runs top of this data. It’s crucial being DBA that you protect it and make it available in case of disaster. The basic and finest way to protect your organization's data, implementing database backup and restore plan. Backing up databases, (either in SQL or mongo world) … Continue reading All about Mongo Backups & Restore