Tag: table partitioning

Why Performance Optimization Should Be Included In Every High Availability Strategy

A couple of years ago, when my friend SQL Server MVP and Microsoft Certified Master Amit Bansal (Twitter | Facebook) delivered a high availability training in Singapore, I asked if I could take a look at the course outline so I can justify attending. Back then, I was responsible for managing several SQL Server 2000 […]

Helpful Techniques on SQL Server Database Recovery

This video is a compilation of different database recovery techniques that SQL Server DBAs should be familiar and comfortable with. We will look at recovering a database to a specific point in time, isolating critical objects or using table partitioning as an HA/DR option (more commonly called online piecemeal restore) and performing page-level restores. I […]