Day: March 25, 2019

Last fall, I took and passed the microsoft 70-761 and 70-762 exams to achieve MCSA (Microsoft Certified Solutions Associate) status for sql server 2016.

I’m planning to take the next step this spring, to MCSE. Achieving MCSE certification consists of …

Read More

I’ve been looking into table partitioning as a way to manage large historical tables. The idea is to be able to keep the size of the table reasonably static as new rows are inserted by removing older rows. My goal …

Read More